Skip to content
HALOWERK

Datenwerk

bank csv unify

No bank-specific layouts are assumed: the header row (preamble lines before it are skipped) is matched against a documented list of German and English column terms (Buchungstag, Valuta/Wertstellung, Betrag/Umsatz, Soll/Haben, Auftraggeber/Empfänger, IBAN, BIC, Verwendungszweck, Buchungstext, Gläubiger-ID, Mandatsreferenz, Kundenreferenz (End-to-End), Saldo, Date, Amount, Payee .) or mapped explicitly by the caller. Delimiter, decimal comma/point and date format are detected (ambiguous.

POST https://daten.halowerk.com/v1/bank-csv-unify

Inputs

Fields of the published input schema
FieldTypeRequiredDescription
csvstringYesCSV text as exported by the bank (decode the file to text first).
delimiterstringNo
decimalstringNo
date_formatstringNo
mappingobjectNoExplicit header names per target field; overrides detection.
debit_indicatorsarrayNoValues of the sign column meaning debit (default S, Soll, D, DR, DBIT, Debit, -).
default_currencystringNo
outputstringNo
Show full input schema
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "csv"
  ],
  "properties": {
    "csv": {
      "type": "string",
      "minLength": 20,
      "maxLength": 5000000,
      "description": "CSV text as exported by the bank (decode the file to text first)."
    },
    "delimiter": {
      "type": "string",
      "enum": [
        "auto",
        ";",
        ",",
        "\t",
        "|"
      ],
      "default": "auto"
    },
    "decimal": {
      "type": "string",
      "enum": [
        "auto",
        "comma",
        "point"
      ],
      "default": "auto"
    },
    "date_format": {
      "type": "string",
      "enum": [
        "auto",
        "DD.MM.YYYY",
        "DD.MM.YY",
        "YYYY-MM-DD",
        "DD/MM/YYYY",
        "MM/DD/YYYY"
      ],
      "default": "auto"
    },
    "mapping": {
      "type": "object",
      "additionalProperties": false,
      "description": "Explicit header names per target field; overrides detection.",
      "properties": {
        "booking_date": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "value_date": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "amount": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "debit": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "credit": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "sign": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "currency": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "counterparty_name": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "counterparty_iban": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "counterparty_bic": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "remittance_info": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "booking_text": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "creditor_id": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "mandate_reference": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "end_to_end_id": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "balance": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        },
        "account_iban": {
          "type": "string",
          "minLength": 1,
          "maxLength": 100
        }
      }
    },
    "debit_indicators": {
      "type": "array",
      "maxItems": 10,
      "items": {
        "type": "string",
        "maxLength": 10
      },
      "description": "Values of the sign column meaning debit (default S, Soll, D, DR, DBIT, Debit, -)."
    },
    "default_currency": {
      "type": "string",
      "pattern": "^[A-Z]{3}$",
      "default": "EUR"
    },
    "output": {
      "type": "string",
      "enum": [
        "json",
        "csv",
        "both"
      ],
      "default": "both"
    }
  }
}

Open original schema

Published input example

{
  "csv": "Date,Payee,Account number,Transaction type,Payment reference,Amount (EUR)\n2026-11-02,\"Warehouse equipment Ltd\",DE79000000001234567890,Credit Transfer,\"Invoice 42, thanks\",250.00\n2026-11-03,Coffee Shop,,Card Payment,-,-4.20"
}

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 →