Skip to content
v26.3

DATEV Export

DiKAS exports your POS data in DATEV format (EXTF v13) — directly importable into DATEV Unternehmen Online or by your tax advisor. No manual retyping, no errors, encrypted and sendable by email.


Part 1: For Users

What Is DATEV?

DATEV is the standard software for tax advisors in Germany. Over 400,000 firms use DATEV. The DATEV export transfers your POS data in a structured format to your accounting — you save time and avoid typing errors.

Setting Up the Export (Initial Setup)

Admin → DATEV → Tab "Configuration"

DATEV Configuration

You will need the following information from your tax advisor:

Setting What is it? Where do I get it?
Advisor Number Your tax advisor's number at DATEV Ask your tax advisor
Client Number Your number at the tax advisor Ask your tax advisor
Account Length 4 or 5 digits Ask your tax advisor
Chart of Accounts SKR03 or SKR04 Ask your tax advisor

Tip: Ask your tax advisor once for these four details. The setup is then done in 2 minutes.

Configuring Accounts

💡 Quick start: Under Chart of Accounts Template click "Apply SKR03" or "Apply SKR04" — all account fields are filled with the standard values for your chart of accounts. Then only adjust the accounts that your tax advisor specifies differently and save.

The default accounts work for most businesses. Only adjust them if your tax advisor specifies different accounts:

Account Default (SKR03) Default (SKR04) Meaning
Revenue Account 19 % 8400 4400 Revenue with 19 % VAT (drinks, etc.)
Revenue Account 7 % 8300 4300 Revenue with 7 % VAT (takeaway food)
Revenue Account 0 % 8200 4200 Genuine tax-exempt revenue (NOT vouchers/deposits)
Cash Register 1000 1600 Cash balance (cash payment)
Money in Transit (Card) 1360 1360 Transit account for card payments
Expense Account 6300 6300 Business expenses
Deposit Account 1590 1590 Deposits (pass-through item, 0 % VAT)
Customer Credit Account 1701 3301 Liability from customer credit top-ups
Voucher Account 1702 3302 Liability from issued vouchers

⚠️ Important for tax advisors: Customer credit and voucher top-ups/sales are not revenue — they are liabilities (prepayments received). They are NOT posted to the 0 % revenue account but to the two liability accounts. The default values (1701/1702 or 3301/3302) are placeholders from the "other liabilities" range — please adjust to your chart of accounts. Set an account to 0 to force the old behavior (posting as tax-exempt revenue).

Performing an Export

Admin → DATEV → Tab "Export"

  1. Select time period — enter from-to date
  2. Select mode — usually "End-of-day report" (default)
  3. Optional: enable "Include expenses"
  4. Click "Create export"
  5. The progress bar shows the status
  6. Click "Download" → save ZIP file

Quick-select buttons for common time periods:

Button Time Period
Today Today only
Yesterday Yesterday only
Last Week Mon–Sun of the previous week
Last Month Entire previous month
Last Quarter Last calendar quarter
Last Year Entire previous year

Which Mode to Choose?

Mode When to use? For whom?
End-of-Day Report For most businesses Small/medium restaurants
Per Receipt When the tax advisor wants to see every receipt Audit-relevant businesses
Per Business Day For nighttime operations (bar, club) Businesses open past midnight
By Article Group When food and drinks are booked separately Restaurants with differentiated accounting
Article Group Detailed Article groups + days combined Larger businesses
By Invoice For B2B invoices (corporate customers) Catering, event hospitality
Expenses Only Only cash withdrawals and business expenses Separate expense reporting

Tip: Start with "End-of-Day Report". If your tax advisor needs more detail, switch to "Per Receipt" or "By Article Group".

Sending to the Tax Advisor

Instead of manually emailing the file, DiKAS can send the export directly to your tax advisor:

Admin → DATEV → Tab "Tax Advisor"

  1. Enter name and email of the tax advisor
  2. Optional: set ZIP password (the file is AES-256 encrypted)
  3. Communicate the password to the tax advisor by phone or in person (one-time only)
  4. During export: click "Send to tax advisor"

The tax advisor receives an email with: - Professional greeting - Client and advisor number - Export mode and time period - The ZIP file as attachment

Article Group Account Mapping

For differentiated accounting, you can assign a separate revenue account to each article group:

Admin → DATEV → Tab "Configuration" → Article Group Mapping

Article Group Account Counter Account
Non-alcoholic drinks 8400 1000
Beer 8400 1000
Wine 8400 1000
Food 8300 1000
Desserts 8300 1000

Article groups without a mapping automatically use the default revenue account (based on the VAT rate).

Payment Method Account Mapping

By default, cash payments are booked to the cash register account and card payments to the money-in-transit account. For special payment methods, you can define custom accounts:

Payment Method Account Counter Account
Cash 8400 1000
Debit card 8400 1360
Customer credit 8400 1590
House tab 8400 1400

Expenses in DATEV Export

If "Include expenses" is enabled, your recorded business expenses are included in the export:

  • Expenses with 19 % (e.g., office supplies): Input tax BU 9
  • Expenses with 7 % (e.g., food items): Input tax BU 8
  • Tax-exempt expenses: BU 40

Note: Expenses of type "Transfer" (DeferredPayment) are not included in the DATEV export, as they have no cash register effect.

Deposits in DATEV Export

Deposit amounts are automatically booked to the configured deposit account — separate from the revenue accounts. Deposits are a pass-through item (0 % VAT).

Exporting Receipt Images (Document Link)

Incoming receipts (invoices/receipts attached as a photo or PDF under Expenses) can be exported together with the posting as a document image. This way the tax advisor can see the original document directly for each expense.

Enable: Admin → DATEV → Configuration → option "Include receipts" (together with "Include expenses" or mode "Expenses only").

During export: - Each expense with an attached document receives a document link (BEDI "<GUID>", DATEV field 20) in the posting. - The document images (PDF/image) are placed in the same ZIP, named by GUID. - DATEV assigns the documents automatically to the respective posting on import (DATEV Unternehmen Online / document link).

ℹ️ Prerequisite: expenses must also be exported ("Include expenses" or mode 6). Coordinate the first import with receipts briefly with your tax advisor.


Part 2: For Tax Advisors — Technical Reference

EXTF Format v13

DiKAS exports in the DATEV EXTF format version 13 (Extended Transfer Format). The export file is a semicolon-separated CSV file with UTF-8 encoding.

Header Line

The first line contains the EXTF header with 21 fields:

"EXTF";700;21;"Buchungsstapel";13;{Timestamp};;"DK";"DiKAS";;{BeraterId};{Mandantennummer};{WjBeginn};{SachkontenLaenge};{DatumVon};{DatumBis};"DiKAS";;1;0;"EUR"
Position Field Description
1 "EXTF" Format identifier
2 700 Format variant
3 21 Number of header fields
4 "Buchungsstapel" Document type
5 13 EXTF version
6 Timestamp Creation timestamp (yyyyMMddHHmmssfff)
7 Reserved
8 "DK" Country code
9 "DiKAS" Software name
10 Reserved
11 BeraterId Tax advisor number
12 Mandantennummer Client number
13 WjBeginn Fiscal year start (yyyyMMdd)
14 SachkontenLaenge Account length (4 or 5)
15 DatumVon Export start (yyyyMMdd)
16 DatumBis Export end (yyyyMMdd)
17 "DiKAS" Software name
18 Reserved
19 1 Batch count
20 0 Currency decimal places
21 "EUR" Currency

Column Header

The second line defines the posting columns:

Umsatz (ohne Soll/Haben-Kz);Soll/Haben-Kennzeichen;WKZ Umsatz;Kurs;Basis-Umsatz;WKZ Basis-Umsatz;Konto;Gegenkonto (ohne BU-Schluessel);BU-Schluessel;Belegdatum;Belegfeld 1;Belegfeld 2;Skonto;Buchungstext

Posting Lines

From line 3, the postings follow:

Column Format Description
Umsatz 1.234,56 (de-DE) Gross amount
Soll/Haben S or H S=Debit (revenue), H=Credit
WKZ Umsatz empty Not used
Kurs empty Not used
Basis-Umsatz empty Not used
WKZ Basis empty Not used
Konto 4-5 digits Revenue account (e.g., 8400)
Gegenkonto 4-5 digits Source account (e.g., 1000 cash register)
BU-Schlüssel 2-40 Automatic tax code
Belegdatum ddMM Day+month (e.g., 1503 = March 15)
Belegfeld 1 Text Document number (Z-no., receipt no., invoice no.)
Belegfeld 2 empty Not used
Skonto empty Not used
Buchungstext Text Posting description

Example Posting (End-of-Day Report)

"EXTF";700;21;"Buchungsstapel";13;20260312120000000;;"DK";"DiKAS";;12345;67890;20260101;4;20260301;20260331;"DiKAS";;1;0;"EUR"
Umsatz (ohne Soll/Haben-Kz);Soll/Haben-Kennzeichen;WKZ Umsatz;Kurs;Basis-Umsatz;WKZ Basis-Umsatz;Konto;Gegenkonto (ohne BU-Schluessel);BU-Schluessel;Belegdatum;Belegfeld 1;Belegfeld 2;Skonto;Buchungstext
1.234,56;S;;;;"";8400;1000;3;0103;Z-1;;;"Tagesabschluss 1 MwSt 19,00%"
567,89;S;;;;"";8300;1000;2;0103;Z-1;;;"Tagesabschluss 1 MwSt 7,00%"
50,00;S;;;;"";8200;1000;40;0103;Z-1;;;"Tagesabschluss 1 MwSt 0,00%"

BU Codes (Automatic)

DiKAS sets the BU code automatically based on the tax rate:

VAT (Revenue, modes 0–5):

BU Tax Rate Meaning
3 ≥ 19 % VAT standard rate
2 ≥ 7 % VAT reduced rate
40 0 % Tax-exempt

Input Tax (Expenses, mode 6):

BU Tax Rate Meaning
9 ≥ 19 % Input tax standard rate
8 ≥ 7 % Input tax reduced rate
40 0 % Tax-exempt

The 7 Export Modes in Detail

Mode 0: End-of-Day Report

Property Value
Data Source DayClose documents (Z-reports)
Grouping 1 posting per end-of-day report per tax rate
Account Revenue account by tax rate
Counter Account Cash register account (SrcKonto)
Document Field 1 Z-{Number} (e.g., "Z-1")
Posting Text Tagesabschluss {No} MwSt {Rate}%

Recommended for: Small businesses with 1 POS and daily closing.

Mode 1: Per Receipt

Property Value
Data Source All POS receipts
Grouping 1 posting per receipt per tax rate
Account Revenue account by tax rate
Counter Account By payment method: Cash→Cash register, Card→Money in transit
Document Field 1 Receipt number (e.g., "42")
Posting Text Bon {No} MwSt {Rate}%

Split payment: If a receipt is settled with multiple payment methods (e.g., 10 € cash + 20 € card), the revenue is distributed proportionally per payment method to the respective counter account — 10 € to the cash register, 20 € to money in transit. This keeps the cash register and money-in-transit balances accurate. (The rounding difference is borne by the last payment method so the total remains exact.)

Recommended for: Detailed accounting, audit-relevant businesses, tax audits.

Mode 2: Per Business Day

Property Value
Data Source POS receipts, grouped by receipt date
Grouping 1 posting per day per tax rate
Account Revenue account by tax rate
Counter Account Cash register account (SrcKonto)
Document Field 1 Date (e.g., "15.03.2026")
Posting Text Umsatz {Date} MwSt {Rate}%

Recommended for: Businesses with nighttime operations (bar, club), where a business day extends past midnight.

Mode 3: By Article Group (WGR)

Property Value
Data Source Receipt line items, grouped by article group
Grouping 1 posting per article group per tax rate
Account WGR mapping account or default revenue account
Counter Account WGR mapping counter account or cash register account
Document Field 1
Posting Text WGR {Group Name} MwSt {Rate}%

Special items: Deposit, customer credit, and voucher line items are NOT assigned to an article group but are automatically posted to their respective balance sheet account (deposit/customer credit/voucher account).

Recommended for: Differentiated revenue analysis (e.g., drinks vs. food separately).

Mode 4: Article Group Detailed

Property Value
Data Source Receipt line items, grouped by article group + date
Grouping 1 posting per article group per day per tax rate
Account/Counter Account Same as mode 3
Document Field 1 Date (e.g., "15.03.2026")
Posting Text WGR {Group Name} {Date} MwSt {Rate}%

Recommended for: Larger businesses with daily article group analysis.

Mode 5: By Invoice

Property Value
Data Source Customer invoices (status ≥ "Open")
Grouping 1 posting per invoice per tax rate
Account Revenue account by tax rate (special items to balance sheet account)
Counter Account Cash register account
Document Field 1 Invoice number (e.g., "RE-2026-001")
Posting Text RE {Invoice Number}

Recommended for: B2B businesses with customer invoices (catering, events, corporate customers).

Mode 6: Expenses Only

Property Value
Data Source Spending documents (business expenses)
Grouping 1 posting per expense per tax rate category
Breakdown AmountNormal (19 %), AmountReduced (7 %), AmountTaxFree (0 %)
Account Expense account (SpendingKonto, e.g., 6300)
Counter Account Cash register account
BU Code Input tax: 9 (19 %), 8 (7 %), 40 (0 %)
Posting Text Ausgabe {Comment} {Rate}%

Filtering: Expenses of type "Transfer" (DeferredPayment, AccountMode 4) are skipped — they have no cash register effect.

Recommended for: Separate expense exports when expenses are not integrated into the revenue export.

Void Postings

Void receipts are included in the export as negative counter-postings (void reversal) — both the original receipt and the void appear, so the revenue nets out and the audit trail (GoBD/DSFinV-K) is complete:

  • Modes 1–4 (receipt/line-based): The void receipt is exported with a negative amount (debit↔credit swapped), which neutralizes the original.
  • Mode 0 (end-of-day report): The Z-report contains the original voided gross; DiKAS appends a void-reversal line for the voided receipts of the period (posting text "Storno-Reversal …") that brings the day's revenue to net — incl. reversal of any deposit/credit/voucher portions to their balance sheet account.

Expenses in Revenue Modes (0–4)

If "Include expenses" (IncludeSpendings) is enabled, expenses are output in addition to revenues in the same export. The BU codes automatically switch to input tax (9/8/40).

Account Length (Sachkontenlänge)

Setting Revenue Account Example Account Length
4 digits 8400 SKR03 standard
5 digits 84000 SKR03 with subdivision

The account length in DiKAS must be identical to the DATEV configuration. If there is a mismatch, the postings will be rejected by DATEV.

Accounting Logic & Special Cases (for Tax Advisors)

This section answers common questions about the accounting treatment of each transaction type. Basic principle: revenues are posted gross per tax rate to the respective revenue account against the payment/cash account; pass-through items and liabilities are extracted from the respective tax line first and posted to their balance sheet account.

Transaction Account (Debit/Credit) Counter Account BU Note
Revenue 19 % Revenue 19 % Payment account 3 Standard rate
Revenue 7 % Revenue 7 % Payment account 2 Reduced (takeaway food, etc.)
Genuine tax-exempt revenue 0 % Revenue 0 % Payment account 40 Only genuine 0 % — NOT voucher/deposit
Cash payment Revenue Cash register (1000/1600) Countable
Card payment Revenue Money in transit (1360) Pass-through until bank receipt
Split payment (cash+card) Revenue proportional per payment method Proportionally distributed (see Mode 1)
Customer credit top-up Customer Credit Account Payment account 40 Liability, not revenue
Payment with customer credit Revenue (goods taxed) Customer Credit Account 3/2 Reduces the liability
Voucher sale (multi-purpose) Voucher Account Payment account 40 Liability, not revenue
Voucher redemption Revenue (goods taxed) + Voucher Account (reduction) Payment account/Voucher Account 3/2 VAT arises only now
Deposit (out/return) Deposit Account Payment account 40 Pass-through; net of issue minus return
Discount (already netted in revenue) 3/2 Revenue is posted net after discount
Void Revenue credit (reversal) Payment account 3/2 Negative counter-posting, full audit trail
Expense/business expenditure Expense account Cash register 9/8/40 Only mode 6 or "Include expenses"

Customer Credit (Prepaid Balance)

  • Top-up = customer pays in advance → prepayment received / liability, no VAT. Posted to the Customer Credit Account.
  • Redemption (paying with credit) → the goods are posted as revenue with their regular tax rate; counter account is the Customer Credit Account (liability decreases).
  • Payout of credit (art_payout) likewise reduces the liability.
  • Disco card top-ups (art_discoaufladung) are treated identically.

Vouchers — Multi-Purpose vs. Single-Purpose (§ 3 para. 13–15 German VAT Act)

DiKAS treats vouchers by default as multi-purpose vouchers: the sale is not taxable (liability on the Voucher Account), VAT only arises upon redemption (with the tax rate of the actually supplied service). This is the standard case for hospitality vouchers, since they can be redeemed for both 7 % food and 19 % drinks.

⚠️ Special case — single-purpose voucher: If the place of supply and the tax rate are already determined at the time of issue (e.g., a voucher exclusively for a specific 19 % service), VAT is already due on sale (single-purpose voucher, § 3 para. 14 German VAT Act). DiKAS does not distinguish this automatically — record such vouchers as regular revenue (a separate article with the applicable tax rate) or have the tax advisor periodically rebook the Voucher Account balances accordingly.

Deposits

Deposit is a pass-through item (0 % VAT). Issue (sale of deposit-bearing goods) and return (deposit refund, negative position) are posted net to the Deposit Account — separate from revenue. This ensures that deposit neither inflates revenue nor the tax base.

Voids & GoBD/DSFinV-K

A void creates its own void receipt with negative amounts (the original remains unchanged — immutability per GoBD). Both receipts appear in the export so the revenue nets out and the audit trail is seamless. In aggregated modes (0/2) the void reduces the daily/period total; in end-of-day mode this is done via a dedicated void-reversal line.

Money in Transit (Card Payments)

Card revenues are posted to the Money in Transit account (1360), not directly to the bank — the payment service provider pays out collectively (often net of fees) to the bank account. The clearing of the money-in-transit account against the actual bank receipt is handled in financial accounting (not by DiKAS).

Tips

Tips to employees are exempt from VAT and not revenue of the business; they are not part of the revenue posting lines. (Shown informally in the hospitality receipt/Z-report.)

Full Chart of Accounts (SKR03 / SKR04)

All accounts configurable in DiKAS with their common default values. The chart of accounts provided by your tax advisor always takes precedence — adjust these values accordingly.

DiKAS Setting SKR03 SKR04 Type Meaning
Revenue Account 19 % 8400 4400 Revenue Sales revenue 19 % VAT
Revenue Account 7 % 8300 4300 Revenue Sales revenue 7 % VAT
Revenue Account 0 % 8200 4200 Revenue Tax-exempt revenue
Cash Register (Source Cash) 1000 1600 Asset Cash balance
Money in Transit (Card) 1360 1360 Asset Card payment pass-through
Expense/Cost Account 6300 6300 Expense Business expenses (adjust per type)
Deposit Account 1590 1590 Pass-through Deposit (0 % VAT)
Customer Credit Account 1701* 3301* Liability Prepayments received (credit)
Voucher Account 1702* 3302* Liability Prepayments received (vouchers)

* Placeholders from the "other liabilities/prepayments received" range — replace with the account specified by your tax advisor. 0 = disable (old posting as 0 % revenue).

Additionally: per article group (modes 3/4) and per payment method own account/counter-account mappings are possible (see above).

Encryption

If a ZIP password is configured:

Property Value
Encryption AES-256
Library SharpZipLib
Filename DATEV_Export_{From}_{To}.zip
Content EXTF_Buchungsstapel.csv

The password must be communicated to the tax advisor once via a secure channel (by phone, in person). It is not transmitted in the email.

Email to Tax Advisor

The automatically generated email contains:

Subject: DATEV Export 01.03.2026 - 31.03.2026

Dear Dr. Steuer,

please find attached the DATEV export for the period 01.03.2026 - 31.03.2026.

  Client number: 67890
  Advisor number: 12345
  Export mode:    End-of-day report

The ZIP file is password-protected. The password has been
communicated to you separately.

Best regards,
Your DiKAS System

[Attachment: DATEV_Export_20260301_20260331.zip]

Importing into DATEV

DATEV Unternehmen Online: 1. Log in → Documents → Import posting batch 2. Upload ZIP file (enter password if applicable) 3. Verify: advisor number and client number must match 4. Account length must be identical 5. Review and post the entries

DATEV Kanzlei-Rechnungswesen: 1. File → Import → EXTF 2. Select CSV file from ZIP 3. Posting batch is created 4. Review and finalize

API Endpoints

Method Endpoint Description
GET /api/v1/datev/config Load configuration
PUT /api/v1/datev/config Save configuration
POST /api/v1/datev/export Start export (async)
GET /api/v1/datev/export/{sessionId}/status Query export status
GET /api/v1/datev/export/{sessionId}/download Download ZIP
POST /api/v1/datev/send Export + email to tax advisor

Practical Example: Restaurant "Zur Linde"

Initial Setup

Tax advisor Dr. Müller provides the following data: - Advisor number: 12345 - Client number: 67890 - Chart of accounts: SKR03, 4-digit - Revenue drinks: 8400 (19 %) - Revenue food: 8300 (7 %) - Cash register: 1000 - Money in transit: 1360

Monthly Process

  1. Perform end-of-day report daily (Z-report)
  2. At month-end: Admin → DATEV → Export
  3. Time period: "Last month"
  4. Mode: "End-of-day report"
  5. "Include expenses": Yes
  6. Click "Send to tax advisor"
  7. Dr. Müller receives the encrypted ZIP file by email
  8. Dr. Müller imports the data into DATEV and posts them

Result in DATEV

For March 2026 (31 end-of-day reports), the export file contains: - Approx. 62 posting lines (2 per day: 19 % and 7 %) - Plus expense postings (if enabled) - Plus deposit postings (if applicable)


Frequently Asked Questions

Which mode should I choose? Ask your tax advisor. Typically, "End-of-day report" (mode 0) is sufficient. For tax audits, "Per Receipt" (mode 1) is recommended.

Do I need to use different accounts for food and drinks? Not necessarily. If your tax advisor requests it, enable the article group account mapping. Otherwise, DiKAS automatically books by tax rate.

What happens with voucher sales in the DATEV export? The sale of a (multi-purpose) voucher is not revenue but a liability (prepayment received) — it is posted to the Voucher Account. VAT only arises upon redemption (the purchased goods are then taxed at their respective rate and the liability is reduced). Details and the single-purpose special case: see section "Accounting Logic & Special Cases".

What happens with customer credit top-ups? Same as vouchers: the top-up is a liability (posted to the Customer Credit Account, not revenue). When paying with credit, the liability is reduced and the goods are taxed.

Can house tabs (on account) be exported? House tabs have no cash register effect and therefore do not appear in modes 0–4. Use mode 5 "By Invoice" for customer invoices.

What if my tax advisor doesn't use DATEV? The EXTF format is a standard CSV and can also be imported into other accounting software (e.g., Lexware, sevDesk, ADDISON). The column structure is identical.

Can I automate the export? Via the REST API (POST /api/v1/datev/export and POST /api/v1/datev/send), you can trigger the export programmatically — e.g., via a cron job at month-end.


Next Step

Customer Invoices — Create and send invoices