Formatwerk
datev extf generate
Writes the 31-field header (EXTF, 700, category 21, Buchungsstapel, format version 13, timestamp, consultant and client number, fiscal year start, account length, period, label, dictation code, booking type 1, purpose 0, lock flag, currency, chart identifier), the 125 documented column headings and one line per booking: amount with decimal comma, S/H flag, account and contra account, tax key, document date TTMM, Belegfeld 1/2, cash discount, posting text, cost centres, EU VAT id, foreign.
POST https://format.halowerk.com/v1/datev-extf-generateInputs
| Field | Type | Required | Description |
|---|---|---|---|
| header | object | Yes | Batch header. |
| bookings | array | Yes | Bookings (at most 20,000 per call; DATEV accepts up to 99,999 per file). |
| encoding | string | No | File encoding. |
Show full input schema
{
"type": "object",
"additionalProperties": false,
"required": [
"header",
"bookings"
],
"properties": {
"header": {
"type": "object",
"additionalProperties": false,
"required": [
"consultant_number",
"client_number",
"fiscal_year_start",
"period_from",
"period_to"
],
"description": "Batch header.",
"properties": {
"consultant_number": {
"type": "integer",
"minimum": 1001,
"maximum": 9999999,
"description": "Beraternummer."
},
"client_number": {
"type": "integer",
"minimum": 1,
"maximum": 99999,
"description": "Mandantennummer."
},
"fiscal_year_start": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "First day of the fiscal year."
},
"account_length": {
"type": "integer",
"minimum": 4,
"maximum": 8,
"default": 4,
"description": "General ledger account length (must match the DATEV client)."
},
"period_from": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "First day of the batch period."
},
"period_to": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Last day of the batch period."
},
"label": {
"type": "string",
"maxLength": 30,
"pattern": "^[A-Za-z0-9_./ -]*$",
"description": "Batch label (letters, digits, blank, . - /)."
},
"dictation_code": {
"type": "string",
"pattern": "^([A-Z]{2}){0,2}$",
"description": "Dictation code, e.g. MM."
},
"currency": {
"type": "string",
"pattern": "^[A-Z]{3}$",
"default": "EUR",
"description": "Batch currency."
},
"locked": {
"type": "boolean",
"default": false,
"description": "Festschreibung (lock bookings after import)."
},
"chart_of_accounts": {
"type": "string",
"pattern": "^(\\d{2}){0,2}$",
"description": "Chart identifier as used in the header field Sachkontenrahmen, e.g. 03 or 04."
},
"origin": {
"type": "string",
"pattern": "^\\w{0,2}$",
"description": "Origin code (Herkunft), up to 2 characters."
},
"exported_by": {
"type": "string",
"pattern": "^\\w{0,25}$",
"description": "Exporting user."
},
"application_info": {
"type": "string",
"maxLength": 16,
"description": "Application information."
},
"created_at": {
"type": "string",
"format": "date-time",
"description": "Creation time; default now (written in Europe/Berlin time)."
}
}
},
"bookings": {
"type": "array",
"minItems": 1,
"maxItems": 20000,
"description": "Bookings (at most 20,000 per call; DATEV accepts up to 99,999 per file).",
"items": {
"type": "object",
"additionalProperties": false,
"required": [
"amount",
"debit_credit",
"account",
"contra_account",
"date"
],
"properties": {
"amount": {
"type": [
"number",
"string"
],
"description": "Positive amount, e.g. \"1190.00\"."
},
"debit_credit": {
"type": "string",
"enum": [
"S",
"H"
],
"description": "S = debit, H = credit, relative to account."
},
"account": {
"type": [
"string",
"integer"
],
"description": "Account (Konto)."
},
"contra_account": {
"type": [
"string",
"integer"
],
"description": "Contra account (Gegenkonto)."
},
"tax_key": {
"type": "string",
"pattern": "^\\d{1,4}$",
"description": "BU key as agreed with the tax adviser (the documentation shows four digits)."
},
"date": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Document date."
},
"document_number": {
"type": "string",
"maxLength": 36,
"description": "Belegfeld 1 (invoice number): letters, digits, $ & % * + - /."
},
"document_field_2": {
"type": "string",
"maxLength": 36,
"description": "Belegfeld 2."
},
"discount": {
"type": [
"number",
"string"
],
"description": "Cash discount amount (payments only)."
},
"text": {
"type": "string",
"maxLength": 60,
"description": "Posting text."
},
"currency": {
"type": "string",
"pattern": "^[A-Z]{3}$",
"description": "Currency of the amount."
},
"exchange_rate": {
"type": "string",
"pattern": "^[1-9]\\d{0,3}[.,]\\d{2,6}$",
"description": "Exchange rate (currency of the amount : base currency), e.g. 1.0825; the documented expression requires a value of at least 1 with 2 to 6 decimals."
},
"base_amount": {
"type": [
"number",
"string"
],
"description": "Amount in the base currency."
},
"base_currency": {
"type": "string",
"pattern": "^[A-Z]{3}$",
"description": "Base currency."
},
"cost_center_1": {
"type": "string",
"pattern": "^[\\w ]{1,36}$",
"description": "KOST1."
},
"cost_center_2": {
"type": "string",
"pattern": "^[\\w ]{1,36}$",
"description": "KOST2."
},
"eu_vat_id": {
"type": "string",
"maxLength": 15,
"description": "EU VAT id of the destination country."
},
"eu_tax_rate": {
"type": "number",
"minimum": 0,
"maximum": 99.99,
"description": "EU tax rate of the destination country."
},
"document_link": {
"type": "string",
"maxLength": 210,
"description": "Beleglink."
},
"order_number": {
"type": "string",
"maxLength": 30,
"description": "Auftragsnummer."
},
"partner_bank": {
"type": "integer",
"minimum": 1,
"maximum": 999,
"description": "Geschäftspartnerbank (requires sepa_mandate_reference)."
},
"sepa_mandate_reference": {
"type": "string",
"maxLength": 35,
"description": "SEPA mandate reference (requires partner_bank)."
},
"service_date": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Leistungsdatum (requires tax_period_date)."
},
"tax_period_date": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Datum Zuordnung Steuerperiode."
},
"due_date": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Fälligkeit."
},
"tax_rate": {
"type": "number",
"minimum": 0,
"maximum": 99.99,
"description": "Tax rate for keys with rate choice."
},
"country": {
"type": "string",
"pattern": "^[A-Z]{2}$",
"description": "Country for the tax rate."
},
"document_info": {
"type": "array",
"maxItems": 8,
"items": {
"type": "object",
"additionalProperties": false,
"required": [
"type",
"content"
],
"properties": {
"type": {
"type": "string",
"maxLength": 20
},
"content": {
"type": "string",
"maxLength": 210
}
}
},
"description": "Beleginfo pairs."
},
"additional_info": {
"type": "array",
"maxItems": 20,
"items": {
"type": "object",
"additionalProperties": false,
"required": [
"type",
"content"
],
"properties": {
"type": {
"type": "string",
"maxLength": 20
},
"content": {
"type": "string",
"maxLength": 210
}
}
},
"description": "Zusatzinformation pairs."
}
}
}
},
"encoding": {
"type": "string",
"enum": [
"windows-1252",
"utf-8-bom"
],
"default": "windows-1252",
"description": "File encoding."
}
}
}Published input example
{
"header": {
"consultant_number": 1001,
"client_number": 1,
"fiscal_year_start": "2026-01-01",
"period_from": "2026-10-01",
"period_to": "2026-10-31"
},
"bookings": [
{
"amount": "1190.00",
"debit_credit": "S",
"account": "1200",
"contra_account": "8400",
"date": "2026-10-05",
"document_number": "RE2026-042",
"text": "Erlös Beratung"
}
]
}Result & documentation
Machine-readable documentation of this hub
Source of this page: the published HALOWERK catalog. Updated: 2026-11-17 UTC.
More endpoints in this hub
- Formatwerk0.004 USDC
accounting csv unify
POSThttps://format.halowerk.com/v1/accounting-csv-unifyDATEV booking batch files (EXTF/DTVF, category 21) are read by their documented field positions: amount and S/H become a signed amount relative to the account, Belegdatum TTMM is resolved within the fiscal year from the header. Other export
- Formatwerk0.005 USDC
avv checklist
POSThttps://format.halowerk.com/v1/avv-checklistChecklist after Art. 28 GDPR (Regulation (EU) 2016/679 Art. 28 (GDPR), https://eur-lex.europa.eu/eli/reg/2016/679/oj, German and English text retrieved from the EU Publications Office 2026-11-01): Art. 28(3) sentence 1 (subject-matter, dura
- Formatwerk0.004 USDC
bagit package
POSThttps://format.halowerk.com/v1/bagit-packageCreate: files go to data/, manifest-<alg>.txt and tagmanifest-<alg>.txt are written for SHA-256 (default), SHA-512 or legacy SHA-1/MD5, bag-info.txt gets your metadata plus Bagging-Date, Bag-Size and Payload-Oxum; paths are checked (no abso