Introduction

General

The DATEV format is a CSV file with a fixed file name prefix (EXTF_....CSV) and a fixed record structure for different formats. The file structure is as follows:


Technical structure

All data fields must be separated by a semicolon. A CR/LF must be placed at the end of each line. All text data fields must be enclosed in quotation marks (e.g. "my text"). If a text data field contains quotation marks, these must be doubled. Control characters within text data fields are not permitted (e.g. line breaks). The separator for numbers of type double is a comma (e.g. 99.99). Thousands for numbers are generally not to be marked separately (exception: individual data fields from the master data for customers/vendors).

Example

Here is an example of a sample file in posting batch format.

Filename: EXTF_Buchungsstapel.csv

"EXTF";700;21;"Buchungsstapel";13;20240130140440439;;"RE";"";"";29098;55003;20240101;4;20240101;20240831;"Buchungsstapel";"WD";1;0;0;"EUR";;"";;;"03";;;"";""
Turnover (without debit/credit indicator);Debit/credit indicator;WKZ turnover;Rate;Basic turnover;WKZ basic turnover;Account;Offsetting account (without BU key);BU key;Document date;Document field 1;Document field 2;Cash discount;Posting text;Item block;Miscellaneous address number;Business partner bank;Facts;Interest block;Document link;Document info - type 1;Document info - content 1; Document info - type 2;Document info - content 2;Document info - type 3;Document info - content 3;Document info - type 4;Document info - content 4;Document info - type 5;Document info - content 5;Document info - type 6;Document info - content 6;Document info - type 7;Document info - content 7;Document info - type 8;Document info - content 8;KOST1 - cost center;KOST2 - cost center;Cost quantity;EU country a. VAT ID (determination);EU tax rate (determination);Dev. Taxation type;Facts L+L;Function supplement L+L;BU 49 main function type;BU 49 main function number;BU 49 function supplement;Additional information - type 1;Additional information - content 1;Additional information - type 2;Additional information - content 2;Additional information - type 3;Additional information - content 3;Additional information - type 4;Additional information - content 4;Additional information - type 5;Additional information - content 5;Additional information - type 6; Additional information - Content 6;Additional information - Type 7;Additional information - Content 7;Additional information - Type 8;Additional information - Content 8;Additional information - Type 9;Additional information - Content 9;Additional information - Type 10;Additional information - Content 10;Additional information - Type 11;Additional information - Content 11;Additional information - Type 12;Additional information - Content 12;Additional information - Type 13;Additional information - Content 13;Additional information - Type 14; Additional information - content 14;Additional information - type 15;Additional information - content 15;Additional information - type 16;Additional information - content 16;Additional information - type 17;Additional information - content 17;Additional information - type 18;Additional information - content 18;Additional information - type 19;Additional information - content 19;Additional information - type 20;Additional information - content 20;Unit;Weight;Payment method;Receivable type;Assessment year;Assigned due date; Cash discount type;Order number;Posting type;VAT code (down payments);EU country (down payments);Facts L+L (down payments);EU tax rate (down payments);Revenue account (down payments);Origin code;Posting GUID;KOST date; SEPA mandate reference;Cash discount block;Shareholder name;Participant number;Identification number;Subscriber number;Item block until;Description SoBil fact;SoBil posting indicator;Fixed entry;Service date;Date Assign. Tax period;Due date;General reversal (GU);Tax rate;Country;Settlement reference;BVV item;EU country and VAT ID (origin);EU tax rate (origin);Dev. discount account
100,18;"S";"";;;"";48400;8401;"";3101;"";"";;"Test Anzahlung";;"";1;;"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"50";"";;"";;"";;"";;;;"";"";"";"";"";"";"";"";"";"";""; "";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";;;;"";2012;;1;"Projekt 4711";"AG";3;"";;;8070;"WK";"";;"";;"";;"";"";;"";;0;;;;"";;"";"";;"";;
10,00;"S";"";;;"";48220;8400;"";3103;"";"";;" "Normalabschr. immater. VermG" ";;"";;;;"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"90";"";;"";;"";;;;;;"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";""; "";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";;;;"";;;;"";"";;"";;;;"WK";"";;"";;"";;"";"";;"";;0;;;;"";;"";"";;"";;
64083;"S";"";;;"";4400;85;"";3101;"";"";;"Normalabschreibung Gebäude";;"";;;;"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"50";"";;"";;"";;;;;;"";"";"";"";"";"";""; "";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";;;;"";;;;"";"";;"";;;;"WK";"";;"";;"";;"";"";;"";;0;;;;"";;"";"";;"";;
531,16;"S";"";;;"";4832;320;"";3101;"";"";;"Normalabschreibung Kfz";;"";;;;"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"20";"";;"";;"";;;;;;"";"";"";"";"";"";""; "";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";;;;"";;;;"";"";;"";;;;"WK";"";;"";;"";;"";"";;"";;0;;;;"";;"";"";;"";;
4979,65;"H";"";;;"";8400;30200;"";0902;"201802010";"";;"";;"";;;;"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"202";"";;"";;"";;;;;;"";"";"";"";"";"";"";"";""; "";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";;;;"";;;;"";"";;"";;;;"WK";"";;"";;"";;"";"";;"";;0;;;;"";;"";"";;"";;
11687,62;"H";"";;;"";8120;40000;"";0902;"201802011";"";;"";;"";;;;"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"299";"";;"";;"";;;;;;"";"";"";"";"";"";"";""; "";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";;;;"";;;;"";"";;"";;;;"WK";"";;"";;"";;"";"";;"";;0;;;;"";;"";"";;"";;
13968,83;"H";"";;;"";8125;40100;"";1602;"201802023";"";;"";;"";;;;"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"299";"889";5;"DE133546770";;"";;;;;;"";"";"";"";"";""; "";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";;;;"";;;;"";"";;"";;;;"WK";"";;"";;"";;"";"";;"";;0;;;;"";;"";"";;"";;
11807,63;"H";"";;;"";8125;40100;"";1702;"201802024";"";;"";;"";;;;"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"299";"";;"DE133546770";;"";;;;;;"";"";"";"";"";"";""; "";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";;;;"";;;;"";"";;"";;;;"WK";"";;"";;"";;"";"";;"";;0;;;;"";;"";"";;"";;