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-unifyInputs
| Field | Type | Required | Description |
|---|---|---|---|
| csv | string | Yes | CSV export as text. |
| delimiter | string | No | Force a delimiter (otherwise detected). |
| mapping | object | No | Column names to use for the unified fields. |
| output | string | No | Return 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."
}
}
}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
- 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
- Formatwerk0.005 USDC
bates number
POSThttps://format.halowerk.com/v1/bates-numberStamps every page of the documents, in order, with a Bates label such as ACME000001 (pdf-lib, Helvetica) at a corner or edge of the visible page (CropBox; rotated pages get an upright label), optionally on a white box and with a legend such