Skip to main content

DATEV Configuration – Export for Accounting

Activate the EXTF header, DATEV master data, repository structure, DATEV cloud upload and all DATEV-specific export options.

Written by Christian Schad

With the DATEV format, additional options become available that make the batches DATEV-compliant, store your tax advisor's DATEV master data, define the repository structure for DATEV receipt transfer and optionally activate the direct upload into the DATEV cloud. All options are located in the General tab of the basic settings.

Note: This article describes the DATEV configuration inside the accounting export. For the separate payroll interface, all details are in the article DATEV LODAS and Lohn und Gehalt.

Activating the Datev XML interface with receipts

With the Datev XML interface with receipts checkbox, ZEP creates booking batches in DATEV EXTF format. The EXTF package is an extended CSV batch with an additional header record that DATEV Unternehmen online and DATEV Rechnungswesen software can import directly. With the Datev XML interface with receipts active, additional required fields appear that are necessary for a DATEV-compliant batch.

Storing DATEV master data

As soon as the Datev XML interface with receipts is active, the DATEV master data fields of your tax advisor or in-house accounting appear.

Consultant number and client

Under Consultant number enter the DATEV consultant number of your tax advisor. Under Client enter the assigned client number. You receive both values from your tax advisor or accounting department.

Chart of accounts (SKR)

Under SKR store the DATEV chart of accounts (e.g. 03 for SKR 03 or 04 for SKR 04). The default is 03. The chart of accounts determines which account numbers are valid in your accounting system.

Business year start

Under Business year start choose the month in which the business year begins (default January). DATEV uses this date to assign bookings to the correct business year.

Account number length

Under Account number length enter the number of digits used for your accounts in DATEV (default 4). ZEP aligns the length of the exported accounts to this value.

Repository structure for receipts

With the Datev XML interface with receipts active, you define under Repository structure the folder hierarchy in which ZEP organizes invoice and receipt files in the DATEV repository. Three levels are available per data type:

  • Repository Invoices Level 1–3: Hierarchy for the invoice PDFs (default: ZEP / Belege / %YYYY%/%MM%).

  • Repository Cost reports Level 1–3: Hierarchy for the receipt files from cost accounting reports (same defaults).

Variables like %YYYY% (year) and %MM% (month) are replaced at runtime with the date of the respective booking. This produces dedicated folders per month and year in the DATEV repository.

Connecting DATEV Online

With the DATEV Online checkbox you link your ZEP account with your DATEV Unternehmen online account. The prerequisite is an active DATEV Online license, which is automatically included in ZEP Professional.

  • Click Connect. ZEP redirects you to the DATEV OAuth page where you sign in with your DATEV account and grant ZEP the permission for the booking-data upload.

  • After a successful sign-in, ZEP displays the status DATEV connected.

  • On the next invoice or cost export, the Upload to DATEV option appears, which uploads the batch directly into DATEV Unternehmen online.

Note: Before going productive, test the connection via the Test mode checkbox in the filter form of Invoices or Checked Cost Accounting Reports. ZEP then transfers the batch to the DATEV cloud but does not mark the bookings as exported.

Viewing DATEV uploads

Under Export for Accounting > DATEV uploads you see an overview of all previous uploads to the DATEV cloud. Per upload, ZEP shows the timestamp, type (invoices / cost reports / master data), the number of contained bookings and the result (successful, failed, test mode). This way you can trace what has been transferred to DATEV.

DATEV-specific export options

In the General tab of the basic settings, three additional DATEV checkboxes are available once the DATEV format is selected:

Invoice export with performance date

With the Invoice export with performance date checkbox active, ZEP additionally exports the performance date alongside the invoice date, which is relevant for VAT. In the filter form of Exporting Invoices, the Invoice or performance date selection then appears, allowing you to choose which date drives the period filter.

DATEV export with finalization

With the DATEV export with finalization checkbox active, the exported bookings go directly into the DATEV finalization (default active). DATEV then prevents later changes to the bookings, which secures GoBD compliance. Switch off finalization only if your accounting team explicitly needs to be able to change bookings in DATEV.

With the DATEV export with receipt link checkbox active (only without the Datev XML interface with receipts), ZEP writes the receipt number into field 20 of each booking so that DATEV can link the associated receipt file. The prerequisite is that the receipt files are uploaded separately via the DATEV Online connection or shipped with the ZIP option.

DATEV LODAS and Lohn & Gehalt

Note: The DATEV payroll interfaces LODAS and Lohn & Gehalt are automatically part of this module in ZEP Professional. The detailed guide – activating the interface, configuring the payroll code and the hour ratios as well as the export workflow – is in the article DATEV LODAS and Lohn & Gehalt.

Did this answer your question?