Accountant

The posting batch your accountant can actually import

Pick a month, download the file, pass it on. GastroSystem produces a DATEV posting batch in EXTF format: one set of postings per cash close, with account and contra account, tax key and document date. Your accountant reads it into Rechnungswesen instead of retyping your Z-reports — and you map the accounts once, to SKR03 or SKR04.

One posting set per cash close, not per receipt

Your accountant books the day, not the individual pizza. So the batch condenses each cash close into a set of postings: revenue separated by VAT rate, cash, cashless payments, tips and cash differences. The document date is the day of the close and the document field carries the Z-report number, so every posting can be traced back to the report it came from. A day nobody closed has no Z-report and therefore no postings — and the export says so rather than passing over it silently.

Every posting has two sides — the batch balances

Each line carries an account, a contra account and an amount, so it is a complete double entry. That makes the batch balanced by construction: the cash account moves by exactly what the drawer moved by — cash revenue plus tips, plus pay-ins, minus pay-outs, plus the booked cash differences. Anything the provider split cannot account for lands visibly on a catch-all account with a warning rather than leaving the batch out of balance.

SKR03 or SKR04 — and accounts we refuse to invent

Where the answer is not in doubt, accounts are pre-filled: revenue at 19 % and 7 %, cash, cashless payments, transit accounts. Where it depends on your chart of accounts — tips, cash differences, receivables, the clearing accounts of your payment providers — the field stays empty. If one of those is missing from an export you need, the export refuses and names the account rather than inventing a number your accountant would have to hunt down later.

The format DATEV really expects

The file is CP-1252 encoded rather than UTF-8, fields are separated by semicolons, text is quoted, decimals use a comma and lines end with CRLF; the document date is day and month, because the financial year sits in the file header. Each of these details decides whether the import runs through or whether €12.40 arrives as twelve hundred and forty euros.

What this saves in the practice

EXTF

Directly importable

A posting batch in DATEV format for Rechnungswesen — no retyping of Z-reports.

SKR03/04

Both charts of accounts

Proposals where the answer is settled, free mapping wherever it depends on the practice.

= 0

A balanced batch

Every posting carries account and contra account — the cash account moves by exactly what the drawer did.

How you set the export up

1

Enter the chart of accounts and account length

SKR03 or SKR04 and the length of the general ledger accounts as your practice keeps them. Both are on any statement they send you.

2

Agree the open accounts with your accountant

Tips, cash differences, receivables and the clearing accounts of your payment providers depend on your chart of accounts. Agreed once and entered, the mapping applies to every future export.

3

Pick a month and pass the file on

The batch covers the cash closes in the period. If the month contains a day without a close, the export points it out so you can catch up before the file goes to the practice.

Frequently asked questions about the DATEV export

What format does the file come in?

A posting batch in DATEV's EXTF format — the CSV structure Rechnungswesen expects on import, with a header carrying the financial year, chart of accounts and account length. The file is CP-1252 encoded, semicolon separated and uses the comma as the decimal separator, because that is how DATEV reads it.

How granular are the postings?

One set of postings per cash close, not per receipt. Revenue is separated by VAT rate, alongside cash, cashless payments, tips and cash differences. The document date is the day of the close and the document field carries the Z-report number, so each posting can be traced back to the report it came from.

Which accounts do I have to set myself?

The ones that depend on your chart of accounts: tips, cash differences, receivables and the clearing accounts of your payment providers. Revenue at 19 % and 7 %, cash and cashless payments are pre-filled for SKR03 and SKR04. If an account an export would need is missing, the export is refused with the name of that account — a made-up number would be worse than a clear error.

Does the DATEV export replace the DSFinV-K export?

No. The posting batch is the summary for bookkeeping and goes to your accountant. The DSFinV-K is the complete till dataset with every receipt and every line and goes to the tax administration. A cash audit needs the DSFinV-K; the posting batch is no help there.

Ready for your own system?

Start for free and see for yourself — 0% commission, full control.