← All guidesCompliance🇩🇪 Germany

DATEV export for invoices: create the CSV for your tax advisor

How to create a DATEV Buchungsstapel file from your Billino invoices and expenses: what is in it, which accounts it uses (SKR04), and what your tax advisor should know before importing.

10 November 2026·6 min read
🇩🇪 Auf Deutsch lesen

Your tax advisor asked for “the DATEV file”, also called the Buchungsstapel. This guide shows how to create it in Billino, what is inside, and the few things your tax advisor should know before importing it. If you are not sure what DATEV is, start with What is DATEV?.

Create the file

  1. Open Exports → Tax in the web dashboard. The DATEV option appears when your business profile is German, and it is already selected.
  2. Choose the period: this month, last month, or a custom range. The page starts on the current quarter.
  3. Click the export button. It shows how many invoices are in the period, for example “Export 12 invoices”. You get one CSV file named after your company and the period, ending in “DATEV.csv”.

The mobile app has the same export on its Compliance Export screen. It is free on every plan.

What is in the file

  • Invoices and expenses together. One file is one journal for the period, so it always holds both. Issued, partly paid, paid and cancelled invoices are included; drafts are not.
  • The DATEV Buchungsstapel format (EXTF): semicolon-separated, with a decimal comma. Amounts are always positive, and a reversal is expressed with the debit/credit flag.
  • SKR04. All accounts are four-digit SKR04 accounts.
  • Nothing is locked. The file is not marked as committed (festgeschrieben), so your tax advisor can review the postings before booking them.

Sources: DATEV: Formatbeschreibung.

How a sale is booked

Every invoice becomes a posting from the customer’s account (debit) to a revenue account. The customer account is 10000 plus the customer number. Billino gives every customer a number automatically, starting at 1 and never changing, so your first customer is account 10001. An invoice without any recipient goes to the collective account 10000.

The revenue account depends on the case:

Case Revenue account (SKR04) Amount in the file
Domestic sale at 19% 4400 Gross
Domestic sale at 7% 4300 Gross
Kleinunternehmer (§ 19 UStG) 4185 Invoice total
Other tax-exempt domestic sale 4100 Invoice total
EU business customer, services (reverse charge) 4336 Net
EU business customer, goods 4125 Net
Customer outside the EU, services 4338 Net
Customer outside the EU, goods 4120 Net

DATEV treats 4400 and 4300 as automatic accounts: they work the VAT out of the gross amount themselves. That is why those lines carry the gross amount and no tax key.

An invoice with several VAT rates becomes one line per rate. An EU or non-EU invoice that contains any goods item is booked entirely on the goods account.

Cancellations

A cancelled invoice and its Storno appear as two postings. The Storno is booked as a credit with a positive amount, so the pair cancels out in the journal.

Sales to private customers in other EU countries (OSS)

If you are above the EU-wide €10,000 threshold and Billino applies the VAT of the customer’s country (the One-Stop-Shop scheme, OSS), those invoices are booked the way DATEV describes for OSS. The file carries the gross amount, DATEV’s standard tax key 250 for services or 240 for goods, and the customer’s country and its VAT rate in DATEV’s EU columns. The revenue account is the plain account 4200 “Erlöse”. If your tax advisor has set up an individual OSS revenue account, they map 4200 to it.

Sources: DATEV: Formatbeschreibung, Your Europe: Cross-border VAT.

Expenses

Expenses are in the same file. Each expense line is booked on the SKR04 account of its category, or on 6300 “Sonstige betriebliche Aufwendungen” if the line has no category code, against the collective creditor account 70000. Lines with 19% or 7% VAT carry DATEV’s input-tax key (9 or 8) on the gross amount. Other rates are booked net, without a key.

What your tax advisor should know

  • The chart is SKR04. The accounts are four digits long.
  • The personal accounts are 10000 plus the customer number, and 70000 for all expenses. In DATEV, they should exist in the client file, or your tax advisor maps them once.
  • The header has no Berater or Mandant number. Billino does not know them, so those fields are empty.
  • The invoice number is cleaned. It goes into the document field, which DATEV limits to 36 characters and to letters, digits and $ & % * + - /. Spaces, dots, umlauts and other characters are removed.

Before your first real hand-over, send your tax advisor a small test period, for example one month. That shows quickly whether their DATEV setup takes the file as it is.

What the export does not do

  • It is a file, not a live connection to DATEV.
  • It uses SKR04 only. If your tax advisor works in SKR03, get in touch.
  • It has no account per supplier: all expenses go to one creditor account. It writes no cash discounts (Skonto).
  • It follows DATEV’s published format description. How your tax advisor’s DATEV takes the file depends on their own setup, which is why the test period is worth it.

In Billino

The DATEV export is free on every plan, next to the CSV journal and the invoice PDFs, under Exports → Tax. Customer numbers are assigned automatically, so your regular customers keep the same DATEV account from one export to the next.

Common questions

Which chart of accounts does the DATEV export use?

SKR04, with four-digit accounts. If your tax advisor works in SKR03, get in touch and tell us.

Is the DATEV export free?

Yes. Exports are free on every plan, together with the CSV journal and the invoice PDFs.

Can I export only my invoices, without expenses?

No. The DATEV file is one journal for the period, so it always contains your invoices and your expenses together.

Does Billino connect to DATEV directly?

No. The export is a file that you create for a period and hand to your tax advisor. There is no live connection.

What if my tax advisor's DATEV reports an unknown account on import?

The file uses personal accounts for customers (10000 plus the customer number) and one collective account for expenses (70000). Your tax advisor creates the missing accounts once in the client file, or maps them to their own.

Send your first invoice today.

No credit card. Just sign up and send your first invoice.

Get it onGoogle PlayComing soonDownload on theApp Store

Works in your browser too · iOS available now, Android coming soon

Fair use policy applies. →