Skip to content
HALOWERK

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-generate

Inputs

Fields of the published input schema
FieldTypeRequiredDescription
headerobjectYesBatch header.
bookingsarrayYesBookings (at most 20,000 per call; DATEV accepts up to 99,999 per file).
encodingstringNoFile 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."
    }
  }
}

Open original schema

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

All endpoints in this hub →