DATEV configuration and settings

This page explains the settings needed to export DATEV-compliant financial data to a CSV or Excel file. You can export data using the DATEV export page.

Access rights

Open: Administration > Roles

To ensure users can access this page and the DATEV export page, you need to confirm settings for your users.

1. On the Roles page, select Administrator from the main list.
2. Expand Finance and make sure that the activity for DATEV export is switched ON.
3. Select the Read and Manage checkboxes.
4. Expand Finance setup and make sure the activity for DATEV configuration is switched ON.
5. Select the Read and Manage checkboxes.
6. Save your changes.

DATEV configuration

This record is delivered with default settings, but you can modify.

What would they modify and why?

The customer and supplier ID ranges display according to the DATEV rules as follows:

GL account number	Customer ID	Supplier ID
4 digits (0001 to 9999)	10000 to 69999	70000 to 99999
5 digits (00001 to 99999)	100000 to 699999	700000 to 999999
6 digits (000001 to 99999)	1000000 to 6999999	7000000 to 9999999
7 digits (0000001 to 999999)	10000000 to 69999999	70000000 to 99999999
8 digits (00000001 to 9999999)	100000000 to 699999999	700000000 to 999999999

 

Master data updates

To ensure that exported data meets DATEV standards and requirements, you need to add the respective DATEV IDs to the following records:

Company: Enter the DATEV consultant and your DATEV ID number provided by DATEV.

Customers: Enter DATEV customer IDs for all customer data to be exported.

Suppliers: Enter DATEV supplier IDs for all supplier data to be exported.

Financial data updates

DATEV standards need to be applied for taxes and accounts for German companies.

Accounts: On the DATEV tab, enter the DATEV ID and switch Automatic account to ON, and add the tax reference.

Tax: For German accounts, enter the Posting key.