Export DATEV balances

Export the balances from the totals and balances list to a CSV file.

Data is saved as comma-separated values in CSV format. This format is particularly easy to import and export and can be processed by almost any software.

The export is used in particular to provide the tax consultant with balances so that they can prepare the tax return without having full access to the accounting.

A list of totals and balances with the following fields is exported:

Account number
Account name
EB value debit/credit (+/-)
Debit annual transaction figure
Credit annual transaction figure

In the DATEV software, the CSV can be imported under the path DATEV > Accounting > Open client > Balance > Import > ASCII import.

The required contra accounts are set in the Datev import mask and the key date of the totals and balances list is entered. Please note that all blocked accounts must be released once for posting by the tax consultant before the import (in the SKR03 1400, 1600 chart of accounts). If the release is forgotten, however, the DATEV import reports and indicates that the accounts must be released under Master data chart of accounts before the import.

Create CSV file

Select OpenScope > Import & Export > Manage DATEV imports/exports > Export DATEV balances.

1st header line: Select whether the CSV file should contain a header line with the column headings Account number, Account name, Balance carried forward, Debit_accumulated, Credit_accumulated, Balance.

2. coding: Select the coding in which the CSV file is to be exported. We recommend the default setting.

3. balances by date: Select the key date on which the balances are to be exported.

4. export: Click on Open file to display the CSV file or on Export to save the file on your computer.