Formatwerk
receivables aging
Days overdue = reference date minus due date (or invoice date plus payment terms, or invoice date as basis). Items are assigned to "not due", 1-30, 31-60, 61-90 and over 90 days (bucket limits configurable). Per currency: gross open amount, credit notes (negative items, kept separate), net open amount, overdue amount and share, amount-weighted average days overdue and amount, count and share per bucket; per customer: amounts per bucket and the oldest overdue item; plus the 20 oldest overdue.
POST https://format.halowerk.com/v1/receivables-agingInputs
| Field | Type | Required | Description |
|---|---|---|---|
| items | array | Yes | Open items. |
| reference_date | string | No | Reference date, default today (UTC). |
| buckets | array | No | Upper limits of the overdue buckets in days. |
| basis | string | No | Age by due date or by invoice date. |
| payment_terms_days | integer | No | Used when due_date is missing: due = invoice_date + terms. |
Show full input schema
{
"type": "object",
"additionalProperties": false,
"required": [
"items"
],
"properties": {
"items": {
"type": "array",
"minItems": 1,
"maxItems": 100000,
"description": "Open items.",
"items": {
"type": "object",
"additionalProperties": false,
"required": [
"amount"
],
"properties": {
"id": {
"type": "string",
"maxLength": 64,
"description": "Item id."
},
"customer": {
"type": "string",
"maxLength": 140,
"description": "Customer or supplier."
},
"amount": {
"type": [
"number",
"string"
],
"description": "Open amount; negative = credit note."
},
"due_date": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Due date."
},
"invoice_date": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Invoice date."
},
"currency": {
"type": "string",
"pattern": "^[A-Z]{3}$",
"default": "EUR",
"description": "Currency."
}
}
}
},
"reference_date": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Reference date, default today (UTC)."
},
"buckets": {
"type": "array",
"minItems": 1,
"maxItems": 8,
"items": {
"type": "integer",
"minimum": 1,
"maximum": 3650
},
"default": [
30,
60,
90
],
"description": "Upper limits of the overdue buckets in days."
},
"basis": {
"type": "string",
"enum": [
"due_date",
"invoice_date"
],
"default": "due_date",
"description": "Age by due date or by invoice date."
},
"payment_terms_days": {
"type": "integer",
"minimum": 0,
"maximum": 365,
"default": 0,
"description": "Used when due_date is missing: due = invoice_date + terms."
}
}
}Published input example
{
"reference_date": "2026-11-01",
"items": [
{
"id": "A1",
"customer": "Alpha GmbH",
"amount": "1000.00",
"due_date": "2026-11-15"
},
{
"id": "A2",
"customer": "Alpha GmbH",
"amount": "500.00",
"due_date": "2026-10-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
- 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