In this article you will learn about: The structure of your DATEV export file
The DATEV export file always follows the same structure and is always provided in the same file format.
File format & Character set
The export is provided as a CSV file using the Windows-1252 character set (also known as CP-1252).
Columns
Revenue
Gross amount of the relevant transactions.
Debit/Credit indicator
The Debit/Credit indicator shows the direction of the transaction. PerfectGym Next always records transactions in the system "Debit to Credit," which is why this column always displays "D."
Account
Account number on the debit side of the relevant transactions.
Counter-account
Account number on the credit side of the relevant transactions.
Date
Date of the DATEV export file.
KOST1
Value stored under Settings / Studio / Master data / Internal studio number.
KOST2
Value stored under Settings / Studio / Master data / Internal studio number (see KOST1).
BU-key
DATEV tax key:
-
0% VAT = 1
-
7% VAT = 2
-
19% VAT = 3
EU tax rate
The tax rate corresponding to the transactions. Control field for the BU-key.
Transaction text
The corresponding transaction entry is output as the transaction text. Example: "Receivables to Sales revenue 19%."