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
Please click on the following button to download the Finokapi stylesheet first.
In the new window, click on “Format Management” -> “Import Format” and select the Finokapi-SUSA stylesheet. (This step only needs to be carried out once before the first export.)
Now select the new format “Finokapi SuSa” in the “Format Selection” under “Totals and Balances”.
Step 3: Save SUSA file
Please specify the storage location and a file name with the extension “.csv” and make sure that the account size is 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}
