Billpay · Guides
Daily conciliation file
The format of the daily Billpay payments file delivered over SFTP.
Every day there is a file with the payments made that operational date. Use it to reconcile against your own records.
Delivery
The file is sent by SFTP. Monato gives you SFTP access once your integration is certified.
File name
Text
CLIENTNAME_PAYTYPE_OPERATIONALDATE.csvExample: FINCH_BILL_01012025.csv
Header row
| Name | Example | Description |
|---|---|---|
| Letter | h |
Letter to identify a header row. |
| Total Payments | 10 |
Total payments that were made. |
| Total Amount | 1000000 |
Total payments amount in cents. For example, 10000 pesos is 1000000. |
Body rows
One row per payment.
| Name | Example | Description |
|---|---|---|
| Letter | b |
Letter to identify a body row. |
| Payment_ID | XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX |
Payment ID. |
| Payee_ID | XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX |
Payee ID. |
| Amount | 10000 |
Payment amount in cents. For example, 100 pesos is 10000. |
| Payer Account | XXXXXXXXXX |
The reference that was paid. |
| Operational Date | 01012024 |
The date the payment was made, as ddmmyyyy. |
| Idempotency Key | XXXXXXXXXX |
Your ID for the payment. |
| Currency | MXN |
Currency of the payment. |
Note:
Amounts in this file are in cents.