Cash · Guides
Conciliation file
The format of the Cash reconciliation file.
The reconciliation file lists completed cash-in and cash-out movements for a period.
File structure
- Field delimiter: the pipe character
|. - Order: exactly one header row first, zero or more body rows, then exactly one footer row last.
- Each row is a single text line. Fields must not contain the delimiter unless an escaping rule is agreed separately. By default, there are no pipe characters inside fields.
| Row marker | Role |
|---|---|
h |
Header. Identifies the start of the file. |
b |
Body. One completed payment or movement. |
f |
Footer. Aggregate totals for validation. |
Header row
Text
hThe line is the single lowercase character h, with no other fields.
Body row
Each body row is one reconciled transaction.
Text
b|<payment_id>|<type>|<amount>|<reference>|<operation_date>|<currency>| Position | Field | Description | Format |
|---|---|---|---|
| 1 | Row marker | Literal b (lowercase) |
Fixed |
| 2 | payment_id |
Unique identifier of the payment or transaction | UUID, lowercase hex with hyphens, e.g. 42dd06f4-c53d-4951-95ba-0ce5e8c35f30 |
| 3 | type |
Operation kind | CASH_IN for cash-in, CASH_OUT for cash-out |
| 4 | amount |
Transaction amount | Decimal with a dot separator. Two fractional digits recommended, e.g. 2495.00 |
| 5 | reference |
Reference or destination account for the movement | String, e.g. a 20-digit reference. No spaces unless part of the agreed reference format. |
| 6 | operation_date |
Operation date | ddmmyyyy. 25 March 2026 is 25032026. |
| 7 | currency |
Transaction currency | ISO 4217 alphabetic code, e.g. MXN |
Body rows
b|42dd06f4-c53d-4951-95ba-0ce5e8c35f30|CASH_OUT|2495.00|20511446630069045555|25032026|MXN
b|49154917-b77e-4af0-8155-eec9b45df262|CASH_OUT|123.00|20511446636424426786|25032026|MXN
b|104ca5a9-277e-4d6b-b5f8-31a68a9a5270|CASH_OUT|948.00|20511446637894288912|25032026|MXNFooter row
Text
f|<total_payments>|<total_amount>| Position | Field | Description | Format |
|---|---|---|---|
| 1 | Row marker | Literal f (lowercase) |
Fixed |
| 2 | total_payments |
Count of body rows in the file | Non-negative integer, e.g. 3 |
| 3 | total_amount |
Sum of all body row amounts | Decimal, same rules as amount, e.g. 3566.00. Must equal the sum of the amount fields of all b rows, to the agreed rounding rule. |
Cash-in and cash-out
- Cash-in and cash-out share the same layout, delimiter and columns.
- The
typefield tells you whether a row is cash-in or cash-out. - A file can contain both kinds of rows when it covers a calendar period or settlement window.
File name
Recommended pattern. Replace PREFIX with your integration client name.
Text
{PREFIX}_CASH_{ddmmyyyy}.txt| Part | Meaning |
|---|---|
PREFIX |
Client name prefix, such as your client short code |
CASH |
Fixed segment for cash reconciliation |
ddmmyyyy |
Business or settlement date, aligned with the reconciliation period |
Example: ACME_CASH_25032026.txt
Some pipelines use the .csv extension for the same content. The format is still pipe-separated text, not comma-separated. Use the extension agreed with operations.
Full example
ACME_CASH_25032026.txt
h
b|42dd06f4-c53d-4951-95ba-0ce5e8c35f30|OUT|2495.00|20511446630069045555|25032026|MXN
b|49154917-b77e-4af0-8155-eec9b45df262|OUT|123.00|20511446636424426786|25032026|MXN
b|104ca5a9-277e-4d6b-b5f8-31a68a9a5270|OUT|948.00|20511446637894288912|25032026|MXN
f|3|3566.00Checks: total_payments is 3, and total_amount is 2495.00 + 123.00 + 948.00 = 3566.00.