DATEV Interface for E-Commerce: Automating Accounting

Manual posting of e-commerce transactions is one of the biggest time drains in accounting. For a B2B shop with 500 orders per month, at least as many sales invoices are generated, plus credit notes, reversal entries, and payment allocations. According to a Bitkom survey, an accountant needs an average of 4.8 minutes for manual entry of a journal posting (Bitkom, 2024). With 500 postings, that amounts to over 40 hours per month, a full work week just for transferring shop data to accounting.

Additionally, there is the error-proneness of manual entries. Transposed digits in amounts, incorrect account assignments, or forgotten tax amounts lead to discrepancies that must be painstakingly corrected at the latest during the annual close. An automated DATEV interface virtually eliminates these error sources. The investment pays for itself within a few months for most B2B shops.

DATEV offers various import formats and interfaces that differ in scope and automation level. The choice of the right format depends on the DATEV version in use, the tax advisor's requirements, and the desired degree of automation.

For most B2B shops, the classic DATEV format (also called DATEV journal stack or ASCII format) is the pragmatic entry point. It is supported by all DATEV versions and can be reliably generated from the shop system. The file contains one journal entry per line with all relevant fields: amount, debit and credit account, document date, posting text, tax code, and cost center. The tax advisor imports the file into DATEV and can immediately begin the review.

For advanced automation, DATEV Connect online offers a REST-based API enabling bidirectional data exchange in real time. Posting data is transferred directly from the B2B shop to DATEV without needing to export and import a file. This solution, however, requires DATEV activation by the tax advisor and registration as a DATEV interface partner.

The correct assignment of shop transactions to DATEV accounts is the heart of any DATEV integration. Incorrect account assignments lead to erroneous balance sheets and require extensive corrections. In B2B e-commerce, various business transactions must be correctly posted to the appropriate general ledger accounts.

A common problem with account mapping involves international business transactions. Deliveries within the EU (intra-community supply) and to third countries are subject to different tax regulations that must be posted to different general ledger accounts. The interface must automatically select the correct tax code and revenue account based on the delivery address and the customer's VAT ID. Errors at this point can lead to significant tax consequences and should therefore be coordinated with the tax advisor.

Correct VAT treatment is the most complex aspect of a DATEV integration in e-commerce. In the B2B sector, various special cases must be reliably mapped by the interface in addition to the standard tax rate.

The DATEV interface must automatically determine the correct tax code for each business transaction. This requires the following information from the shop: the customer's country, the VAT ID (for B2B verification), the delivery address, the product group, and the type of service (goods or services). Validation of the VAT ID via the EU Commission's VIES database should already occur during customer registration in the B2B portal, not only during posting creation.

Implementing a DATEV interface follows a structured process that should be closely coordinated with the tax advisor. It is crucial that the chart of accounts and posting logic are clarified in advance so the interface delivers correct data from the start.

A critical success factor is the test phase. The interface should run in parallel with manual bookkeeping for at least one full month. The automatically generated journal entries are compared with manually created ones, and deviations are analyzed and corrected. Only when consistency is established is the switch to automated operation made. This parallel approach costs more time in the short term but avoids costly errors in production. Professional implementation by an experienced partner significantly reduces project risk.

Beyond posting data, the tax advisor also expects the associated documents. In e-commerce, these are primarily the invoice PDFs that the shop automatically generates. DATEV document linking enables connecting these PDFs directly with the respective journal entry, allowing the tax advisor to navigate from the posting directly to the document.

The technical implementation occurs via DATEV Document Link or DATEV Unternehmen online. The shop generates a PDF for each invoice, names it according to a defined scheme (e.g., invoice number as filename), and provides it together with the posting data. With the DATEV XML interface, documents can be directly embedded or referenced as separate files.

For B2B shops with high document volumes, the automatic upload function to DATEV Unternehmen online is recommended. Invoice PDFs are uploaded directly to the document archive via API and automatically linked with the corresponding journal entries. This eliminates manual effort for document filing and ensures that digital document archiving meets GoBD requirements.

A DATEV interface must handle errors robustly. Not every business transaction can be automatically assigned correctly. New tax scenarios, special cases like triangular transactions, or incomplete customer data can result in an invalid journal entry.

A particularly critical aspect is ensuring completeness. No business transaction may be lost during transfer. A reconciliation of the count and total of exported journal entries against shop transactions ensures all transactions have been captured. Regular reconciliations between shop revenue and DATEV postings are an essential part of internal controls and interface quality assurance.

The GoBD (Principles for the proper keeping and storage of books, records, and documents in electronic form) establishes specific requirements for digital bookkeeping. A DATEV interface must consider these requirements so that automated bookkeeping complies with legal requirements.

Process documentation is an often underestimated aspect. It must describe in detail how the interface works, which data is transferred in which format, how account assignment occurs, and how errors are handled. In the event of a tax audit, this documentation must be available for the auditor. A professional B2B portal with DATEV connectivity delivers this documentation as part of the implementation.