DATEV Format

DATEV Format

A registered cooperative of the tax, accounting, and legal professions is the German DATEV eG. Data can be imported into DATEV Accounting via the DATEV format, which is a CSV-based file interface. The DATEV developer portal has the interface documentation available:

• DATEV format v7.0.

Prerequisites

These must initially be produced in order to use the DATEV Export:

• DATEV Settings

Filters You can select the firm whose GL Entries you want to export in the filtering section. The timeframe for the export is another option. This is typically the last month.

Menu You can access the DATEV Settings or download the export file from the menu. The export file is a ZIP archive that includes both master data and the transaction data from the preview (Customers, Suppliers, Accounts).

Exported Data GL Entries can now be exported in the format that ERPNext generates them in. Booking a sales invoice, for instance, will generate three GL entries:

ERPNext's right side is not always an account, though. A customer, supplier, or several accounts are other possibilities. Because of this, we employ a temporary against account that is configurable in DATEV Settings. This account serves as the basis for all GL entries. The rows in the DATEV Export will like the following:

To determine if and how you can utilize this information, please consult a tax professional.