DATEV
German cooperative providing accounting software (such as DATEV Kanzlei-Rechnungswesen) that is widely used by German tax advisors. The DATEV CSV format (Buchungsstapel) is the standard import format for monthly bookkeeping data.
DATEV eG is a German cooperative founded in 1966 in Nürnberg. Its software is widely used by German tax advisors (Steuerberater) for client bookkeeping and tax filing. For watch dealers, DATEV's relevance is one specific thing: the format your tax advisor expects when you hand over monthly transaction data.
DATEV CSV (Buchungsstapel-Format)
The standard import format is the Buchungsstapel CSV, a semicolon-separated values file with a fixed column layout. Each row is a single bookkeeping entry (Buchung):
- Umsatz (amount)
- Soll/Haben-Kennzeichen (debit/credit indicator)
- Konto (account number from the chart of accounts in use, for example SKR03 or SKR04)
- Gegenkonto (counter-account)
- Buchungstext (description)
- Belegdatum (document date)
- Belegnummer (document number)
- and several optional columns
The format has specific requirements, for example the character encoding, the date format (day and month), the comma as decimal separator and a fixed header structure. A wrongly formatted file will fail to import. DATEV publishes the current format specification.
DATEV products
The two main DATEV products that import Buchungsstapel CSVs are:
- DATEV Kanzlei-Rechnungswesen: used by tax advisors for their clients' books.
- DATEV Mittelstand: used by mid-sized companies for in-house accounting.
Smaller related products (DATEV Unternehmen Online) provide a web interface for clients to upload documents directly to their tax advisor.
Account number conventions
Most German businesses use the standard charts of accounts SKR03 (structured by business process) or SKR04 (structured like the annual accounts). The dealer's tax advisor decides which chart is in use.
Practical note
Ask your tax advisor which handover they prefer. Many advisors also book from documents and lists: in ChronoDesk, the handover is the Bestandsliste export (Excel, CSV, PDF), the monthly period-close package with the period's accounting documents and a gap report, and scheduled reports by email. If an advisor imports any file into DATEV, have them test one month first to confirm format and account mapping.
Related: steuerberater, zugferd, differenzbesteuerung, ankaufsrechnung, kleinunternehmer.