Skip to content

DATEV export (EN)

Claude edited this page Nov 20, 2026 · 2 revisions

DATEV export (Buchungsstapel, EXTF)

Deutsch: DATEV-Export

The DATEV export plugin (datev.jar) writes a DATEV-Format Buchungsstapel file (EXTF, header version 700, format category 21, format version 13, CSV) from the Journal for direct import into DATEV Kanzlei-Rechnungswesen or DATEV Unternehmen online.

Installation

  1. Import datev.jar from the plugins/ folder of the OpenYaBS distribution (or openyabs-plugins-<version>.zip) via Settings › Plugins › Import plugin.
  2. Import a chart of accounts (if not done yet) via Settings › Accounts › Import using the updated files in ext/:
    • ext/accounts-german-skr03.xml – SKR03 (updated: removed/cleaned up outdated 16 % accounts and updated German UStVA field numbers, e.g. 81 instead of 51),
    • ext/accounts-german-skr04.xml – SKR04 (newly added).

Settings

Under Settings › Plugins › DATEV-Export (stored per database):

  • Consultant number (Beraternummer) (1001–9999999) and client number (Mandantennummer) (1–99999).
  • Fiscal year start (Wirtschaftsjahresbeginn) (YYYYMMDD), account length (Sachkontenlänge) (4–8, usually 4), chart of accounts (03 = SKR03, 04 = SKR04, auto-detected from imported accounts).
  • Batch label (Bezeichnung) (max 30 chars), optional initials (Diktatkürzel) (2 uppercase letters), lock on import (Festschreibung) (off by default).
  • Document date mode: Payment date (cash basis / EÜR, default) or Document date.
  • Money accounts: income and expense money accounts (default 1200 for SKR03, 1800 for SKR04), plus optional cash account (e.g. 1000 / 1600) for cash register (POS) sales.
  • Accounts & BU tax keys per tax rate: fallback revenue and expense accounts when the document's account does not match the line's tax rate, plus the Use automatic accounts toggle (omits the BU key when the account's tax rate matches; otherwise defaults to 3/2 for 19 %/7 % income and 9/8 for 19 %/7 % expenses).
  • Accounts for 0 % sales by VAT category (see VAT categories): the category comes from the tax rate of the positions (the customer's rate, the product's, else one with the value).
    • 0 % EU delivery account (category K, intra-community supply): 8125 (SKR03) or 4125 (SKR04).
    • EU services, reverse charge (category AE, customer with a VAT ID of another EU country, § 3a Abs. 2 UStG): 8336 or 4336 – UStVA line 21, not 41.
    • § 13b UStG domestic (category AE without an EU VAT ID): 8337 or 4337.
    • Exports outside the EU (category G): 8120 or 4120.
    • Without a category (0 % = "E") a 0 % sale to an EU business is booked as a delivery (8125/4125) as before; the check dialog points this out so services are not booked wrong.

Export and validation

  • Choosing Journal › Export › DATEV-Buchungsstapel (CSV) opens a check dialog listing missing settings, documents without an account, accounts without a number, missing rate accounts, long document numbers, or multi-year periods (Write anyway / Cancel).
  • File name: EXTF_Buchungsstapel_<YYYYMMDD>_<YYYYMMDD>.csv (Windows-1252, CRLF, semicolon-separated, decimal comma, quoted text).
  • Tax-adviser ZIP package: while the plugin is active, the DATEV CSV is automatically added to the tax-adviser ZIP under datev/EXTF_Buchungsstapel_….csv.
  • Booking rules: only counted (paid) entries are exported – never cancelled or unpaid records. Multi-rate invoices (with discounts) and partial payments are split exact to the cent per tax rate; credit notes reverse the debit/credit flag (H); 0 % EU deliveries and services populate column 40 (EU-Land u. UStID) from the contact's VAT ID (for the EC sales list).

Importing into DATEV

Do not open and re-save the CSV in Excel (Excel alters the header and number formatting). In DATEV Kanzlei-Rechnungswesen, import via Bestand › Importieren › Stapelverarbeitung.

See also

Clone this wiki locally