Migration of accounting data for balance sheet and tax AG
Process optimization through technology: Excel tool for booking processes
Bilanz und Steuer AG has been supporting national and international companies of all legal forms for around 40 years. The range of services includes tax consulting, auditing, accounting, management consulting and business consulting. In addition, foreign clients are advised on their activities in Germany.
Since 2018, eWorks has been supporting Bilanz und Steuer AG in programming macros in Excel in order to import accounting transactions from an input format, assign them using tax keys and transfer them to a target format that can be imported by DATEV.
The application developed consists of a Microsoft Excel workbook with an individually created Excel ribbon, which can be used to call up all functions such as reading in the necessary input files and creating the output files in CSV format. For this purpose, functions were developed in close cooperation with the clients that read in and process the data in accordance with German accounting rules and write it back for further use.
eWorks provided Bilanz und Steuer AG with comprehensive support in the professional implementation of the Excel tool: Starting with consulting and software conception, through the Excel programming of the VBA macros, to the handover and commissioning of the developed Microsoft Excel solution. Following the installation, eWorks was reliably available to Bilanz und Steuer AG for operating questions, any error reports (under warranty) and expansion requests. The Excel solution developed is used monthly by selected clients to carry out the necessary data transformations in a time-saving manner.