DATEV export for catering businesses in Germany: what your tax adviser really needs
Last updated: · Catering Cat editorial team
What helps your German tax adviser most is a DATEV posting batch in DATEV format (EXTF): a CSV file with a header line that can be imported straight into DATEV accounting. For it you need the adviser number, client number, chart of accounts (SKR03 or SKR04), account length and start of the financial year from your accounting firm. Revenue is posted separately by VAT rate – typically accounts 8300/8400 in SKR03 and 4300/4400 in SKR04 for 7 % and 19 %. Voucher images such as invoice PDFs are usually transferred separately, for example via DATEV Unternehmen online.
Why the export matters
Most catering businesses in Germany have their bookkeeping done by a tax accountancy firm, and that firm almost always works with DATEV. Every invoice you write has to arrive there as a posting: receivable from the customer, revenue and VAT.
If the firm types these postings in by hand, it costs time and money and invites errors – especially with mixed invoices at 7 % for food and 19 % for drinks. A clean export saves both sides work and follow-up questions.
Before setting up an export, have a short conversation with your accountancy firm: which data do they want in which form, how often, and who posts incoming payments?
Posting batch (EXTF) or plain CSV?
The posting batch is the format DATEV itself documents for imports from third-party software. The first line is a header with metadata, the second line holds the column names, and each further line is one posting. A plain CSV is still useful as an outgoing-invoice journal for checking or for your own overview.
| Aspect | DATEV posting batch (EXTF) | Plain CSV / outgoing-invoice journal |
|---|---|---|
| Structure | CSV with a DATEV header line (identifier “EXTF”, format name “Buchungsstapel”) and defined columns | any columns, e.g. date, number, customer, net, VAT, gross |
| Import into DATEV | imported directly as a batch, posting proposals are created automatically | has to be mapped or typed in by the firm |
| Accounts | contains revenue and debtor accounts | usually contains no accounts |
| Suited for | ongoing bookkeeping via the firm | your own analysis, checks, hand-over to other programs |
The details you need from your accountancy firm
A posting batch always belongs to one financial year. So never export a period spanning the year end – with a calendar financial year, for example January to March, not December to February.
- Adviser number (Beraternummer): the DATEV number of the tax firm.
- Client number (Mandantennummer): your number within the firm.
- Chart of accounts: SKR03 or SKR04 (sometimes an industry-specific chart).
- Account length: usually 4 digits; the length of debtor accounts depends on it.
- Start of the financial year: normally 1 January, or another date if your financial year differs.
- Revenue accounts for 7 %, 19 % and, if relevant, exempt sales if the firm uses accounts other than the defaults.
- Debtor logic: one collective debtor for all customers or a separate debtor account per customer.
Revenue accounts in SKR03 and SKR04
Since 1 January 2026, restaurant and catering services in Germany are again taxed at 7 % VAT, while drinks remain at 19 %. For caterers this means almost every invoice contains two VAT rates and therefore at least two revenue postings.
| Revenue type | SKR03 (default) | SKR04 (default) |
|---|---|---|
| Revenue at 7 % VAT, e.g. food, buffet, catering | 8300 | 4300 |
| Revenue at 19 % VAT, e.g. drinks, separately agreed extra services | 8400 | 4400 |
| Trade receivables (collective account) | 1400 | 1200 |
- Accounts 8300/8400 and 4300/4400 are set up in DATEV as automatic accounts: VAT is calculated out automatically when posting.
- Many firms use their own sub-accounts, for instance separating catering, party service and canteen. Ask before using the default accounts.
- Discounts on the invoice total must be split proportionally across the VAT rates, otherwise the revenue per account will be wrong.
Debtors: collective account or one per customer?
In DATEV, customers are kept on personal accounts called debtors. With 4-digit general ledger accounts, personal accounts have 5 digits; debtors are usually in the range 10000 to 69999, creditors from 70000.
With a collective debtor (e.g. 10000), all invoices land on one account. That is simple but makes open items per customer hard to follow. With a separate debtor per regular customer, the firm sees immediately who owes what and can match payments cleanly. For one-off customers such as wedding couples, a collective debtor is often enough.
What matters is that the debtor number in your invoicing software matches the one at the firm. Create new debtors following an agreed scheme.
What belongs in each posting line
An invoice with food and drinks produces two lines with the same invoice number: one against the 7 % revenue account and one against the 19 % revenue account. Cancellation invoices are exported as reverse postings so that original and cancellation offset each other in the account.
| Field | Content in a catering example |
|---|---|
| Amount and debit/credit indicator | €1,284.00, debit (credit for cancellations) |
| Account | debtor, e.g. 10023 (Example AG) |
| Contra account | revenue account, e.g. 8300 for the 7 % share |
| Voucher date | invoice date |
| Voucher field 1 | invoice number, e.g. 26-047 |
| Posting text | customer and occasion, e.g. “Example AG summer party” |
Voucher images, payments and common pitfalls
- Voucher images: the posting batch contains booking data only. Invoice PDFs or e-invoices are usually transferred separately, e.g. by uploading to DATEV Unternehmen online; your firm decides how.
- Incoming payments: these normally come via bank data in DATEV and are matched to open items there. Voucher field 1 with the invoice number makes matching easier.
- Duplicate imports: export each period only once, or agree how late additions are handled.
- Character set: DATEV files are traditionally encoded in Windows-1252. Umlauts in customer names should look right after import.
- Finalised postings: once postings are locked (festgeschrieben), the firm can no longer change them – corrections then go via cancellations.
- Down payments and small-business rules: these are special cases; discuss them with your tax adviser.
How Catering Cat helps with the DATEV export
On the Starter plan and above, Catering Cat creates a DATEV posting batch in EXTF format for SKR03 or SKR04 from your issued invoices and cancellations. In the invoice settings you enter adviser and client number, chart of accounts, account length, revenue accounts and a default debtor; regular customers can get their own debtor number.
Each invoice is posted separately at 7 % and 19 %, discounts are already split proportionally across the VAT rates, and the invoice number is in the voucher field. There is also a CSV outgoing-invoice journal for checks, plus ZUGFeRD/Factur-X PDFs and XRechnung XML as vouchers.
Catering Cat is not an accounting program: bank postings, incoming invoices and annual accounts remain with your firm. Agree the chart of accounts and accounts with them before the first export.
Frequently asked questions
What is a DATEV posting batch?
A CSV file in DATEV format with a header line (“EXTF”) and defined columns. The accountancy firm can import it directly into DATEV instead of typing postings in.
Where do I get the adviser and client number?
From your tax accountancy firm. The adviser number identifies the firm at DATEV, the client number identifies your business within the firm.
Which revenue accounts do I use for 7 % and 19 %?
By default 8300 and 8400 in SKR03, or 4300 and 4400 in SKR04. Many firms use their own sub-accounts – ask first.
SKR03 or SKR04 – which is better?
Your firm decides. SKR03 follows the flow of business processes, SKR04 the structure of the annual accounts. What matters is that your export uses the same chart.
Is an Excel list of my invoices enough?
As an overview yes, for bookkeeping usually not: the firm then has to map or retype the data. A posting batch saves that step.
Guides
Less paperwork. More time for cooking.
Set up your business in two minutes, import your menu and print your first buffet cards today – for free.
Start for freeCatering Cat supports the management of allergen information and does not replace a legal review.