Here you'll find descriptions of the individual fields of the DATEV export as well as a description of typical journal entries and accounts.
Description of the fields of a DATEV export
Field name | Description |
Umsatz (ohne Soll/Haben-Kz) | Amount of the payment (for POS Sales Channels: cash deposit/withdrawal) |
Soll/Haben-Kennzeichen | S for payments or cash deposits, H for refunds or cash withdrawals |
WKZ Umsatz | We currently don't import any data into this field. |
Kurs | We currently don't import any data into this field. |
Basis-Umsatz | We currently don't import any data into this field. |
WKZ Basis-Umsatz | We currently don't import any data into this field. |
Konto | Clearing account of the payment method or, for cash deposits and withdrawals, according to the configuration |
Gegenkonto (ohne BU-Schlüssel) | Collective debtor account of the payment method or, for cash deposits and withdrawals, according to configuration |
BU-Schlüssel | We currently don't import any data into this field. |
Belegdatum | Date of the payment or cash deposit/withdrawal (format: DDMM) |
Belegfeld 1 | If set accordingly in the configuration, the order number is exported here; otherwise this field remains empty. |
Belegfeld 2 | We currently don't import any data into this field. |
Skonto | We currently don't import any data into this field. |
Buchungstext | Order number, customer number |
Postensperre | We currently don't import any data into this field. |
Diverse Adressnummer | We currently don't import any data into this field. |
Geschäftspartnerbank | We currently don't import any data into this field. |
Sachverhalt | We currently don't import any data into this field. |
Zinssperre | We currently don't import any data into this field. |
Beleglink | The document link is used to link journal entries with document images. |
Beleginfo - Art 1 / Inhalt 1 | Sales Channel / Name of the (POS) Sales Channel in which the order was placed |
Beleginfo - Art 2 / Inhalt 2 | Export comment / The export comment for the payment stored in the order details |
Beleginfo - Art 3 / Inhalt 3 | Store / Name of the respective POS store. These fields are used for all journal entries created as a result of a DATEV export for a POS Sales Channel (receivables, refund claims, payments, refunds and cash deposits/withdrawals). Pickware POS must be installed and activated for this. |
Beleginfo - Art 4 / Inhalt 4 | Transaction reference, if available |
Beleginfo - Art 4-8 / Inhalt 4-8 | We currently don't import any data into this field. |
KOST1 - Kostenstelle | Depending on the configuration, either the cost center of the Sales Channel or (if available) the cost center of the product is imported here. |
KOST2 - Kostenstelle | Depending on the configuration, either the cost center of the Sales Channel or (if available) the cost center of the product is imported here. |
Kost-Menge | We currently don't import any data into this field. |
EU-Land u. UStID (Bestimmung) | Country and VAT ID of the recipient. This field is only exported for line items with a delivery country in Europe (including Germany). |
EU-Steuersatz (Bestimmung) | Tax rate of the journal entry. This field is only exported for line items with a delivery country in Europe (not Germany). |
Abw. Versteuerungsart | We currently don't import any data into this field. |
Sachverhalt L+L | We currently don't import any data into this field. |
Funktionsergänzung L+L | We currently don't import any data into this field. |
BU 49 Hauptfunktionstyp | We currently don't import any data into this field. |
BU 49 Hauptfunktionsnummer | We currently don't import any data into this field. |
BU 49 Funktionsergänzung | We currently don't import any data into this field. |
Zusatzinformation - Art 1 / Inhalt 1 | Company |
Zusatzinformation - Art 2 / Inhalt 2 | Title |
Zusatzinformation - Art 3 / Inhalt 3 | First name |
Zusatzinformation - Art 4 / Inhalt 4 | Last name |
Zusatzinformation - Art 5-20 / Inhalt 5-20 | We currently don't import any data into this field. |
Stück | We currently don't import any data into this field. |
Gewicht | We currently don't import any data into this field. |
Zahlweise | We currently don't import any data into this field. |
Forderungsart | We currently don't import any data into this field. |
Veranlagungsjahr | We currently don't import any data into this field. |
Zugeordnete Fälligkeit | We currently don't import any data into this field. |
Skontotyp | We currently don't import any data into this field. |
Auftragsnummer | Order number/external order number |
Buchungstyp (Anzahlungen) | We currently don't import any data into this field. |
Ust-Schlüssel (Anzahlungen) | We currently don't import any data into this field. |
EU-Land (Anzahlungen) | We currently don't import any data into this field. |
Sachverhalt L+L (Anzahlungen) | We currently don't import any data into this field. |
EU-Steuersatz (Anzahlungen) | We currently don't import any data into this field. |
Erlöskonto (Anzahlungen) | We currently don't import any data into this field. |
Herkunft-Kz | We currently don't import any data into this field. |
Buchungs GUID | We currently don't import any data into this field. |
KOST-Datum | We currently don't import any data into this field. |
SEPA-Mandatsreferenz | We currently don't import any data into this field. |
Skontosperre | We currently don't import any data into this field. |
Gesellschaftername | We currently don't import any data into this field. |
Beteiligtennummer | We currently don't import any data into this field. |
Identifikationsnummer | We currently don't import any data into this field. |
Zeichnernummer | We currently don't import any data into this field. |
Postensperre bis | We currently don't import any data into this field. |
Bezeichnung SoBil-Sachverhalt | We currently don't import any data into this field. |
Kennzeichen SoBil-Buchung | We currently don't import any data into this field. |
Festschreibung | 0 – The journal entries are not finalized after being imported into DATEV. Finalization is carried out by your tax advisor. |
Leistungsdatum | We currently don't import any data into this field. |
Datum Zuord.Steuerperiode | We currently don't import any data into this field. |
Fälligkeit | We currently don't import any data into this field. |
Generalumkehr (GU) | We currently don't import any data into this field. |
Steuersatz | We currently don't import any data into this field. |
Land | We currently don't import any data into this field. |
Abrechnungsreferenz | We currently don't import any data into this field. |
BVV-Position | We currently don't import any data into this field. |
EU-Land u. UStID (Ursprung) | We currently don't import any data into this field. |
EU-Steuersatz (Ursprung) | We currently don't import any data into this field. |
Configuring the "Auftragsnummer" field
The order number is an additional field on the order which by default contains the order number. Depending on the configuration in Pickware, one of the following values can be exported here, for example if you want to store transaction references or marketplace order numbers:
Order number
External order number
External order number, order number if empty
Under Settings → Extensions → DATEV → Journal entry section, you can use the Order number option to specify which value is exported into this field for receivables and payments.
DATEV allows a maximum of 30 characters for the order number. If the value is longer, an error is output per line in the export and the order number is used instead.
Description of typical journal entries and accounts
The extension frequently uses the following two types of accounts:
Revenue accounts:
A revenue account can be described as a sub-account of equity and is used to determine profit. For example, when goods are sold, the incoming payment represents sales revenue, which is booked via the revenue account and closed via the profit and loss account.
Debtor accounts:
Debtor accounts record receivables, credit notes and open items from a company's deliveries and services. This means that as soon as an order is completed by the customer, a receivable arises against the company, which is represented by a debtor account. For collective debtor accounts, the accounts are maintained and named depending on the payment method.
The DATEV export contains individual journal entries in DATEV format. Each journal entry represents either a receivable or a payment. The following examples show which journal entries the plugin creates for the respective business processes.
Business processes:
1.) A payment transaction of €50
2.) A refund of €50
Corresponding journal entries:
1.) Clearing account €50 to debtor account €50
2.) Debtor account €50 to clearing account €50
Account representation of the business processes:
Debtor account | Debtor account |
2.) €50 | 1.) €50 |
Clearing account | Clearing account |
1.) €50 | 2.) €50 |