Accounting Export DATEV-Format

Your Dolibarr bookkeeping in DATEV format for your German tax advisor - no rework

Dolibarr offers complete double-entry bookkeeping; most tax advisors in Germany work with DATEV, the accounting software of the German tax profession. This module connects the two: you export a period from the general ledger and get a package your advisor imports straight into DATEV - the posting batch in DATEV format (EXTF) with tax keys ("BU-Schlüssel") set automatically, the receipts for the postings, linked for DATEV, and on request the master data of your customers and suppliers.

Why this module?

• Tax keys set automatically: the module recognises customer and supplier invoices, credit notes, payments and manual entries and sets the tax key for each VAT rate. Payments carry the invoice number, so DATEV clears the open items. Gross, net and VAT lines of a manual entry become one gross posting with a tax key, as DATEV expects.
• DATEV automatic accounts respected: on accounts with a VAT rate attached in DATEV (such as 8400 revenue 19 %), the module leaves out the key or sets key 40 exactly where it belongs - no double VAT and no rejection on import. The list comes filled for the German charts of accounts SKR03 and SKR04 and takes your advisor's own accounts.
• A receipt on every posting: invoice PDFs, uploaded supplier invoices and documents attached to payments and bank lines are included, together with the document.xml for DATEV's receipt transfer. In DATEV, each posting then carries its receipt.
• Personal accounts instead of control accounts: the contra account is the customer or supplier account, so open items in DATEV are right. The master data file creates new personal accounts with address and VAT ID.
• VAT special cases: reverse charge under section 13b of the German VAT Act for EU and non-EU suppliers, intra-community supplies with VAT ID, the EU One-Stop-Shop (OSS) for sales to consumers in other member states with the rates of the destination country, and the date of supply for the right VAT period.
• Cost centres and opening balances: with our module ControllingHub the postings carry cost centres (KOST1/KOST2); at year end, opening balances go along as postings against account 9000. If an export spans several months, each month gets a batch of its own so DATEV assigns it correctly.
• A check report with every export: control totals, a per-document total check and notes with the posting number, before the file goes to your advisor. Every export stays available with its report and a note.
• Trial exports without risk: export as often as you need to reconcile with your advisor. Only the final export marks the postings as exported.
• With a comprehensive handbook: the handbook (PDF, in German, 26 pages) explains the monthly routine, every setting and its effect, the import into DATEV for the advisor and all special cases - with a one-page cheat sheet.

How it works

1. Set up: choose DATEV export as the accounting export format, enter the advisor and client numbers.
2. Export: in the accounting export, pick the month and export. The package is downloaded.
3. Check: the check report shows control totals and notes; the list of DATEV exports keeps every export.
4. Hand over: your advisor imports master data, receipts and the posting batch into DATEV; the instructions are in the package.

What the module does not do

The module translates what is booked in Dolibarr; whether an account or VAT rate is right is for your tax advisor to judge. It creates a file in the DATEV exchange format and needs no online interface and no additional DATEV subscription; you choose how the file reaches your advisor. Postings made by the advisor do not come back to Dolibarr, and it is not an interface to DATEV payroll.

User interface languages: German, English
Output: DATEV format (EXTF) posting batch and customer/supplier master data, receipts with document.xml for DATEV receipt transfer

Requirements

Tested with Dolibarr 20 to 24 and PHP 7.4 to 8.5.

• The Accounting module (double-entry) with personal accounts for customers and suppliers
• The German chart of accounts SKR03 or SKR04 for the prefilled automatic accounts (other charts with a list of your own)
• Optional: our module ossaddon 1.2 or later for the One-Stop-Shop, our module ControllingHub for cost centres

Included

With your purchase you get:

• A ZIP file to download and install yourself
• The handbook (PDF, German)
• Updates for one year after purchase (downloadable from the Dolistore)

Please note, NOT included are:

• Installation and setup in your system
• Training and answers to general user questions
• Custom changes and extensions

If you are interested, we are happy to make you an offer. Support: dolistore@bloxera.com

Documentation & demo

A description of the module and its setup: https://www.dolicenter.com/accounting-export-datev.php

Try the module before you buy in our demo instance: https://demodatev.portal.dolicenter.com (user: demo, password: demo).