DATEV format export

The DATEV format export allows companies operating in Germany to securely exchange financial and accounting data between different software applications. The export files are DATEV compliant and ready for import, making it easier for tax consultants and accountants to prepare tax filings and financial statements for your company.

Who typically uses this report

DATEV file format is a widely accepted file format used in Germany by accountants, tax consultants, and related businesses. It is an extract of master data (chart of accounts, customers, and vendors) as well as General Ledger transactional data formatted to adhere to specific technical and formatting requirements.

What’s in this report

The DATEV data export consists of chart of account data, merged customer and supplier data, and transactional data for a user-defined period within a fiscal year.

Multinational companies operating in Germany can create a separate chart of accounts for their German entities and use the reporting account filter to run the DATEV export.

The resulting zipped folder can be downloaded and includes the following files:

  • EXTF_Sachkontobeschriftungen.csv: DATEV-compliant CSV file for chart of accounts.

  • EXTF_DebKred_Stamm.csv: DATEV-compliant CSV file with merged supplier and customer information.

  • EXTF_Buchungsstapel.csv: DATEV-compliant CSV file with transactional data of entries posting to the General Ledger. This includes incoming and outgoing AR sales invoices, credit notes and AR sales invoice corrections, and direct journal entries.

    The record quantity for the transactional data posting batch is 99,999 postings. If the number of records exceeds this limit, you will need to do multiple extractions using shorter periods.

Supplier and Customer DATEV ID

You can add DATEV ID information to your supplier and customer records to display dimension information in the DATEV export.

  1. Go to Accounts Payable > All > Suppliers.

    or

    Go to Accounts Receivable > All > Customers.

  2. Do one of the following:

    • To add a new customer or supplier, select Create.
    • To edit an existing customer or supplier record, select Edit at the end of the row.

  3. In the Details section of the Additional Information tab, enter the DATEV ID.

  4. Select Save.

  1. Go to Accounts Payable > All > Suppliers.

    or

    Go to Accounts Receivable > All > Customers.

  2. Do one of the following:

    • To add a new customer or supplier, select Add
    • To edit an existing customer or supplier record, select Edit on that row

  3. In the Details section of the Additional Information tab, enter the DATEV ID.

  4. Select Save.

The supplier and customer CSV templates now include the DATEV ID field so you can import multiple records at one time.

When you run the DATEV export, the DATEV ID displays for suppliers and customers in the following ways:

  • In the EXTF_Sachkontobeschriftungen General Ledger transactions export, the DATEV ID from the supplier and customer records is displayed for offset accounts. Expense accounts still display the expense account number.

  • In the EXTF_DebKred_Stamm merged supplier and customer export, the DATEV ID displays for suppliers and customers. If the supplier or customer record does not have an associated DATEV ID, the field does not display any value.

  • There's no impact for the EXTF_Buchungsstapel chart of accounts export.

Additional information or limitations

You must have the Deutsche Umsatzsteuer standard tax solution installed and configured at the company or entity level.

Users need the appropriate permissions to run the DATEV data export. You can grant those permissions under Subscriptions > General Ledger > Reports > DATEV data export > Run.

To access this compliance report, go to General Ledger > All > Reports > DATEV data export.

You can run the export at the entity level, or at the top level you can select the entity for the export. The period selected for export cannot span fiscal years.

The Intermediary account facilitates the transfer of balances in the General Ledger entries CSV file and makes it easier for you to organize your financial data before running the DATEV export. The extracted amounts are not reflected in the chart of accounts and not used in Sage Intacct for accounting purposes.

Due to the requirements set by DATEV, you cannot customize or change the formatting of this export.