DATEV export
  1. Home
  2. For tax advisors

For tax advisors What arrives at the tax firm.

Which files a run hands over, in which format, with which number ranges and accounts, and in which order they are read into DATEV. The same details are in the handout the shop creates per tenant.

The handover

The files of one run.

The files belong to exactly one export run. For every run the shop keeps a list of all files with their SHA-256 checksum and a fingerprint across the booking and master data files; documents without an image are named individually in the run instead of going missing silently.

your-shop.com/admin

Orders › DATEV export › History

Export of 01.09.2026

Back

FinishedSuccessfulMuster Handels GmbH01.08.2026 - 31.08.2026ScheduleInterface v700

OverviewReportReconciliationProtocolEmail

Orders1,204

Bookings1,311

Booking volume (debit+credit)€642,180.50

Errors and findings0

File

EXTF_Buchungsstapel_55001_20260801-20260831.csvSHA-256 a3f1 9c2e …Download

EXTF_Div-Adressen_55001_20260801-20260831.csvSHA-256 7b0d 41aa …Download

DATEV_Belege_55001_20260801-20260831.zipSHA-256 e58c 0f13 …Download

All files of this run go to the tax firm together - every booking points at exactly one document image through its Beleglink.

Re-export lock & audit chain

Documents locked
Yes
Locked at
01.09.2026 06:02
Run fingerprint
9c41 e07a …
Fingerprint of previous run
52d8 a1f3 …

Locked documents are not booked again when the same period is exported twice. The run's fingerprint covers ALL files of this run and chains to its predecessor's, proving that no file was changed or removed afterwards. This is not the DATEV Festschreibung, which lives in the file header and is set on the tenant.

  • EXTF_Buchungsstapel_*.csv

    The bookings of the period. Above 99,996 booking lines several files are created ("_01von03", "_02von03" …), each a complete batch with its own header and its own totals.

    Format
    EXTF 700, category 21, format version 13
  • EXTF_DebKred_Stamm_*.csv

    Names and addresses for the personal accounts when every customer gets a debtor of their own. Read in first.

    Format
    category 16, version 5
  • EXTF_Div-Adressen_*.csv

    The addresses for the collective debtor with diverse addresses. Read in first.

    Format
    category 48, version 2
  • DATEV_Belege_*.zip

    The document images as PDFs with a document.xml following the DATEV document schema. It contains exactly what the batch points to through its document links; at most 4,999 documents and 450 MB per package.

    Format
    ZIP for the document transfer

Header and character set

Header
advisor number, client number, start of the fiscal year, account length, period and label
Chart of accounts
SKR03 or SKR04, accounts with 4 to 8 digits
Interface
version 700, booking batch in format version 13
Character set
Windows-1252, CRLF line endings, semicolon separator
Freeze flag
set per tenant, off by default; written into every booking line (field 114)
Test export
labelled "Testexport" instead of "Export" in the header

Booking logic

Booking
debit debtor, credit revenue
Basis
documents (invoice, credit note, cancellation), not the order status
Taxation
accrual on the invoice date or cash basis on the payment date; OSS and EU business customers on the invoice date even under cash basis
Debtors
collective debtor, per payment method, with diverse addresses or one debtor per customer
Aggregation
one booking per document or collective bookings per day, account and tax key, then without document number and link
Cancellation
general reversal (field 118) or side switch
Cost centres
KOST1 and KOST2 (fields 37 and 38) according to stored rules
Document numbers

The number ranges in the document field.

TransactionWhat the document field holds
Invoices, credit notes, cancellationsthe document number from the shop in document field 1, cleaned to the characters DATEV accepts, at most 36
Incoming payments, with the payment exportthe invoice number of the settled invoice for open-item matching; without an invoice "Z-" before the order number
Refunds, with the payment exportthe number of the credit note or cancellation document, dated on the refund date
Document field 2stays empty on purpose, because it has a fixed meaning for open-item clients
Document link (field 20)the reference to the document image in the document ZIP
Import

Importing the booking batch into DATEV.

  1. Do not open or save the CSV files with Excel: Excel changes the character set and the number format, after which the file can no longer be imported.
  2. If debtor master data or diverse addresses are included, read them in first; without them the numbers in the batch are unknown.
  3. Read the booking batch into DATEV Rechnungswesen through the DATEV format import, with several files each one on its own.
  4. Read the document packages in through the document transfer, in any order; the document link connects booking and image.
The preview of the booking lines in the admin: document date, account, contra account, debit or credit, amount, tax key, document field 1 and posting text
For looking at the bookings there is the preview in the admin; the CSV file stays unchanged.

What the export does not contain

  • payment provider fees and their collective payouts to the bank account
  • cash discounts, partial payments and payment differences
  • dunning and an open-item list
  • revenue from marketplaces or other systems outside the shop

These transactions belong in the bookkeeping and are recorded there.

Assumptions to agree on

  • The OSS threshold monitoring counts every taxable EU B2C sale; for a pure service shop it warns rather too early, never too late.
  • The statutory threshold of €10,000 is fixed; the setting can only bring the warning forward.
  • Great Britain counts as outside the EU; deliveries with the state Northern Ireland are named separately in the check report, the country code XI stops.
  • Revenue belongs to the tenant through its sales channels; agree on a later reassignment beforehand.
The handout

All of it as a PDF, per tenant.

The shop creates the handout, in German, with one click on the Export page, with the real values of the tenant: advisor number, accounts in use, OSS method, number ranges. Ten sections, from the file header to the import into DATEV.

The DATEV export handout with master data, file format and booking logic
Questions from tax firms

What tax firms ask before the first import.

Can the file be tested before switching over?

Yes. The test export writes a real, complete file whose header says "Testexport" instead of "Export". It locks nothing and can be repeated as often as needed: the right way for a trial import and a reconciliation.

Are the batches frozen on import?

Only if you want that. The freeze flag is set per tenant and is off by default; it is written into every booking line (field 114), so that DATEV does not freeze the batch on its own. By default the tax firm therefore imports the batch without a freeze and can still edit it in DATEV.

What happens above 99,996 bookings?

The export writes several complete files, ending in _01von03, _02von03 and so on, each with its own header and its own reconciliation totals. Each file is imported on its own; together they make up the period.

How do the document images reach the booking?

Through the document packages: one ZIP per package with a document.xml following the DATEV document schema and the PDFs. Imported through the document transfer, the document link in field 20 connects booking and image automatically.

Which charts of accounts and account lengths are possible?

SKR03 and SKR04, with general ledger accounts of four to eight digits. A new tenant starts with SKR03 and four digits.

Does the export write a performance date?

On request, in field 115: the dispatch date, meaning the day the delivery was set to "shipped" in Shopware, or the order date. If an order has no dispatch recorded, the order date stands there. It is off by default. DATEV only processes it once the tax firm activates the performance date in the DATEV client.

Does the batch come as single or collective bookings?

By default as single bookings, one line per document with document number and document link: that way the open items can be matched in DATEV, and the document images attach on import. Collective bookings combine per day and account, then without document numbers and links; the individual lines stay traceable in the shop's history. Which booking method applies is set on the tenant, as the tax firm specifies.

Who answers questions about accounts and keys?

The shop owner: every point in the handout can be set in the shop. The protocol of each run shows for every document which tax case applied, which date and which account were used, and why a document was skipped.