Skip to content
HALOWERK

Formatwerk

accounting csv unify

DATEV 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 exports are parsed with csv-parse after detecting the delimiter (; , tab |), the header row, decimal comma or point (also 1.234,56, trailing minus and parentheses), the date format (DD.MM.YYYY, YYYY-MM-DD, DD/MM vs MM/DD by value range, YYYYMMDD) and the columns.

POST https://format.halowerk.com/v1/accounting-csv-unify

Inputs

Fields of the published input schema
FieldTypeRequiredDescription
csvstringYesCSV export as text.
delimiterstringNoForce a delimiter (otherwise detected).
mappingobjectNoColumn names to use for the unified fields.
outputstringNoReturn rows as JSON, unified CSV or both.
Show full input schema
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "csv"
  ],
  "properties": {
    "csv": {
      "type": "string",
      "minLength": 1,
      "maxLength": 20000000,
      "description": "CSV export as text."
    },
    "delimiter": {
      "type": "string",
      "enum": [
        ";",
        ",",
        "\t",
        "|"
      ],
      "description": "Force a delimiter (otherwise detected)."
    },
    "mapping": {
      "type": "object",
      "additionalProperties": false,
      "description": "Column names to use for the unified fields.",
      "properties": {
        "date": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for date."
        },
        "value_date": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for value_date."
        },
        "document_number": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for document_number."
        },
        "text": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for text."
        },
        "amount": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for amount."
        },
        "debit_amount": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for debit_amount."
        },
        "credit_amount": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for credit_amount."
        },
        "side": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for side."
        },
        "account": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for account."
        },
        "contra_account": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for contra_account."
        },
        "debit_account": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for debit_account."
        },
        "credit_account": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for credit_account."
        },
        "tax_key": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for tax_key."
        },
        "tax_rate": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for tax_rate."
        },
        "net_amount": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for net_amount."
        },
        "tax_amount": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for tax_amount."
        },
        "currency": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for currency."
        },
        "cost_center": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for cost_center."
        },
        "counterparty": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100,
          "description": "Column for counterparty."
        }
      }
    },
    "output": {
      "type": "string",
      "enum": [
        "json",
        "csv",
        "both"
      ],
      "default": "json",
      "description": "Return rows as JSON, unified CSV or both."
    }
  }
}

Open original schema

Published input example

{
  "csv": "Datum;Belegnr.;Buchungstext;Betrag;Soll;Haben\n05.10.2026;RE-1;Erlös Beratung;1.190,00;1200;8400"
}

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 →