Booking batch
EXTF_
7 bookings, format version 13, 5.5 KB
- Home
- Sample files
Sample files Two files, just as the plugin writes them.
A test export from our test system, with made-up customers: the booking batch and the diverse addresses that go with it, byte for byte as the plugin wrote them. Character set Windows-1252, separator semicolon - any text editor opens them.
Diverse addresses
EXTF_
5 addresses, format category 48, 4.8 KB
The customers are made up, the numbers those of a test client. The tax firm imports the addresses before the booking batch.
The first line tells DATEV where the batch belongs.
31 fields, of which the filled ones are shown here. The second line carries the headings of the 125 columns.
| Field | Value | Meaning |
|---|---|---|
| 1 | EXTF | Marker of the DATEV format |
| 2 | 700 | Interface version number |
| 3 | 21 | Format category: 21 is the booking batch |
| 4 | Buchungsstapel | Format name |
| 5 | 13 | Format version |
| 6 | 20260916171236000 | Created on: date and time; the last three digits (milliseconds) are 000 |
| 9 | DvsnDatev | Exported by: the program that wrote the file |
| 11 | 12345 | Advisor number |
| 12 | 1234 | Client number |
| 13 | 20260101 | Start of the fiscal year |
| 14 | 4 | Account length |
| 15 | 20260901 | Period from |
| 16 | 20260930 | Period to |
| 17 | Testexport 2026/09 | Label; a binding export is called "Export 2026/09" |
| 19 | 1 | Booking type: 1 stands for financial accounting |
| 20 | 0 | Accounting purpose |
| 21 | 0 | Freeze: 0 means DATEV does not freeze after the import |
| 22 | EUR | Currency |
| 27 | 03 | Chart of accounts: 03 stands for SKR03 |
Seven lines: one invoice, one credit note, five cancellations.
All of them carry the collective debtor 10000 as the account and the revenue account as the contra account; S or H gives the direction. The address number in field 16 tells the customers apart - SJST287 has none, because its order carries no usable customer number, so it sits on the collective debtor alone.
| Document field 1 | Amount (S = debit, H = credit) | Contra account | Field 16 | Tax key (BU) | Field 40 / 41 | Reversal (GU) | What it is |
|---|---|---|---|---|---|---|---|
SJST29 | 161,54 S | 8320 | 20018 | 0240 | FR / 20,00 % | 1 | Cancellation of an OSS sale to France, as a general reversal |
SJCN168 | 35,82 H | 8400 | 20033 | Credit note to a domestic customer: debit revenue, credit debtor, marked H | |||
SJST225 | 426,47 S | 8125 | 20015 | ATU12345675 | 1 | Cancellation of an intra-community supply to Austria, VAT ID in field 40 | |
SJST287 | 23,55 S | 8400 | 1 | Cancellation of a domestic sale at 19% | |||
SJST312 | 95,89 S | 8320 | 20018 | 0240 | FR / 20,00 % | 1 | Cancellation of an OSS sale to France, as a general reversal |
SJST389 | 146,51 S | 8400 | 20004 | 1 | Cancellation of a domestic sale to a company at 19% | ||
41299 | 182,99 S | 8320 | 20001 | 0240 | FR / 20,00 % | Invoice of an OSS sale delivered to France - the address file holds the billing address: collective account 8320, key 240, country and rate in fields 40 and 41 |
Document date and link
Field 10 carries the document date as DDMM, here 0309. Field 20 points to the document image in the document package with "BEDI" and a GUID.
General reversal
The cancellations stand with the same accounts on the same side as their invoice; the 1 in field 118 makes DATEV deduct them there.
What else goes along
The order number in field 95, the freeze flag of the header in field 114 of every line and, for sales abroad, the country in field 120.
The address for every address number.
Format category 48, version 2. The address number connects the address with the booking; the account is the collective debtor.
| Address number | Account | Name | Address |
|---|---|---|---|
20001 | 10000 | Anna Müller | Hauptstraße 12, 10115 Berlin, DE |
20004 | 10000 | Weiß & Söhne GmbH | Industriestr. 7, 50667 Köln, DE |
20015 | 10000 | Gruber Alpin GmbH | Mariahilfer Str. 100, 1070 Wien, AT |
20018 | 10000 | Camille Lefèvre | Rue de Rivoli 5, 75001 Paris, FR |
20033 | 10000 | Nora Schmidt | Waldstraße 33, 24103 Kiel, DE |
What gets asked about the files.
Can I import the files into DATEV?
Not into your own records: the header carries the numbers of a test client (advisor number 12345, client number 1234), and DATEV only accepts files whose numbers match its records. To look at them a text editor is enough. For a trial import with your own data, the plugin's test export writes the same file with your tax firm's numbers.
Why does the document date have no year?
That is how the format wants it: the document date is DDMM, and the year follows from the period in the header. That is why a batch always stays within one fiscal year.
Why are there no document images?
A test export builds no document packages; they come with the binding export. The document links in field 20 are already in this file - they point to the PDFs the package then brings along.
More in the manual
Tenant and assistant
What a tenant is, the five-step assistant and when you need several.
Accounts and debtors
Revenue, cash, shipping and voucher accounts, the four ways to the debtor and the cost centres.
Export and history
Period, preview, test export and export, the running run and the history.
Check report and findings
Errors that stop and notices that do not - and the way to fix each one.
All settings
Every setting on the tenant and the global switches, with default and effect.
Glossary
Booking batch, general reversal, freeze and the other words from DATEV and Shopware.