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 |
Amount (without debit/credit indicator) | Amount of the journal entry |
Debit/Credit indicator | Describes whether the entry is a debit or credit posting |
Currency indicator (amount) | Currency indicator (e.g. EUR) |
Exchange rate | Conversion rate |
Base amount | we currently don't import any data into this field |
Currency indicator (base amount) | we currently don't import any data into this field |
Account | Account number |
Contra account (without posting key) | Number of the contra account of the entry |
Posting key | Posting key |
Document date | Date of the document (usually the invoice) (format: DDMM) |
Document field 1 | Number of the document (usually the invoice number) or order number |
Document field 2 | Due date of the payment |
Cash discount | we currently don't import any data into this field |
Posting text | Order number and customer number, or, for example, the selected comment for manual cash-in and cash-out transactions at the till |
Item lock | we currently don't import any data into this field |
Miscellaneous address number | we currently don't import any data into this field |
Business partner bank | we currently don't import any data into this field |
Matter | we currently don't import any data into this field |
Interest lock | we currently don't import any data into this field |
Document link | Document ID from export documents (if export documents is enabled) |
Document info - Type 1 / Content 1 | Transaction reference of the order |
(...) | we currently don't import any data into this field |
Document info - Type 8 / Content 8 | we currently don't import any data into this field |
KOST1 - Cost center | Cost center of the sub-shop or cost center of the product |
KOST2 - Cost center | Cost center of the product or cost center of the sub-shop |
Cost quantity | we currently don't import any data into this field |
EU country and VAT ID | ISO code for the EU country |
EU tax rate | Tax rate for the EU country |
Deviating type of taxation | we currently don't import any data into this field |
Matter L+L | we currently don't import any data into this field |
Function addition L+L | we currently don't import any data into this field |
BU 49 main function type | we currently don't import any data into this field |
BU 49 main function number | we currently don't import any data into this field |
BU 49 function addition | we currently don't import any data into this field |
Additional information - Type 1 / Content 1 | Customer group |
Additional information - Type 2 / Content 2 | Billing address |
(...) | Billing address |
Additional information Type 9 / Content 9 | Billing address |
Additional information - Type 10 / Content 10 | Shipping address |
(...) | Shipping address |
Additional information Type 17 / Content 17 | Shipping address |
Additional information - Type 18 / Content 18 | Voucher code * |
Additional information - Type 19 / Content 19 | Bank reference ** |
Additional information - Type 20 / Content 20 | Name IBAN BIC ** |
Pieces | we currently don't import any data into this field |
Weight | we currently don't import any data into this field |
Payment method | we currently don't import any data into this field |
Type of receivable | we currently don't import any data into this field |
Assessment year | we currently don't import any data into this field |
Assigned due date | we currently don't import any data into this field |
Cash discount type | we currently don't import any data into this field |
Order number | Order number (optional) |
Posting type | we currently don't import any data into this field |
VAT key (down payments) | we currently don't import any data into this field |
EU country (down payments) | we currently don't import any data into this field |
Matter L+L (down payments) | we currently don't import any data into this field |
EU tax rate L+L (down payments) | we currently don't import any data into this field |
Revenue accounts (down payments) | we currently don't import any data into this field |
Origin indicator | we currently don't import any data into this field |
Empty field | we currently don't import any data into this field |
KOST date | we currently don't import any data into this field |
Mandate reference | we currently don't import any data into this field |
Cash discount lock | we currently don't import any data into this field |
Shareholder name | we currently don't import any data into this field |
Participant number | we currently don't import any data into this field |
Identification number | we currently don't import any data into this field |
Subscriber number | we currently don't import any data into this field |
Item lock until | we currently don't import any data into this field |
Designation SoBil matter | we currently don't import any data into this field |
SoBil posting indicator | we currently don't import any data into this field |
Fixation | empty = will be fixed automatically |
Delivery date | we currently don't import any data into this field |
Date assignment tax period | we currently don't import any data into this field |
*) only in combination with our voucher plugin
**) only in combination with our plugin for automatic bank reconciliation
Description of typical journal entries and accounts
The plugin frequently uses the following three types of accounts:
Revenue accounts:
A revenue account can be described as a subaccount 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 a customer completes an order, a receivable arises against the company, which is represented by a debtor account. Debtor accounts can be maintained as individual or collective debtor accounts. For collective debtor accounts, the accounts are maintained and named depending on the payment method. For individual debtor accounts, the accounts are named depending on the customer and receive the same numbers as the customers (account number = customer number)
Clearing accounts:
Clearing accounts are accounts that neither serve as a settlement point for a balance sheet item nor are described as revenue accounts. They are used to represent the payment process and are booked against the debtor account (receivables).
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 maps for the respective business processes.
Business processes:
1.) Creating an invoice for €50
2.) A payment transaction of €50
3.) A cancellation invoice for €50
4.) A refund of €50
Corresponding journal entries:
1.) Debtor account €50 to revenue account €50
2.) Clearing account €50 to debtor account €50
3.) Revenue account €50 to debtor account €50
4.) Debtor account €50 to clearing account €50
Account representation for the business processes:
Debtor account | Debtor account |
1.) €50 | 2.) €50 |
4.) €50 | 3.) €50 |
Revenue account | Revenue account |
3.) €50 | 1.) €50 |
Clearing account | Clearing account |
2.) €50 | 4.) €50 |