This guide describes how the accounting data must be exported from DATEV as a trial balance (“SuSa”) so that they can be imported into Finokapi as a basis for your financial planning & analysis.
Please note that a SuSa file always relates to an entire fiscal year. We recommend that you take into account at least 2 previous years when exporting for the first time and create a new export every month for the current fiscal year.
Step 1: Open ASCII-Export in DATEV
Please complete the following steps to create the SuSa files in the appropriate format for Finokapi:
In DATEV Arbeitsplatz, open a fiscal year of the desired accounting client.
Now, in the menu on the upper left, click "Bestand" -> "Exportieren" -> "ASCII-Daten".
Step 2: Configure Finokapi format
In the new window, click on “Formatverwaltung” -> “Format einspielen” and select the Finokapi SuSa template. (This step only needs to be carried out once before the first export.)
Now select the new format “Finokapi SuSa” in the format selection below "Summen und Salden".
Step 3: Save SuSa file on your device
Please specify the storage location and a file name with the extension “.csv” and make sure that the accounts included are set from 1 to 99999 and that the two checkmarks are checked.
At the bottom right, click Export -> Export and Close. The SuSa file can now be found in the previously selected storage location.
.png){kind=small}
