Docs · File formats
Late Payment & Retainage CSV format
Header names are matched automatically, in any order and any case. Extra columns are ignored.
| Column | Required | Also accepted as | Example |
|---|---|---|---|
| Customer | Yes | customer, customer name, client, client name, bill to, debtor | Northgate Builders Ltd |
| Invoice number | Yes | invoice number, invoice no, invoice no., invoice #, invoice, inv no | INV-1042 |
| Invoice amount | Yes | amount, invoice amount, invoice total, total, gross amount, original amount | 2,400.00 |
| Invoice date | invoice date, date, issue date, txn date, transaction date, document date | 2026-03-02 | |
| Due date | due date, due, payment due, date due, due on | 2026-04-01 | |
| Payment terms | terms, payment terms, credit terms | Net 30 | |
| Date paid | paid date, date paid, payment date, paid on, settled date, date settled | 2026-05-18 | |
| Amount paid | amount paid, paid, payments, paid amount, payment amount | 2,400.00 | |
| Open balance | open balance, balance, balance due, amount due, outstanding, outstanding balance | 0.00 | |
| Currency | currency, currency code, ccy | GBP | |
| Customer type | customer type, type, b2b b2c, segment | business | |
| Disputed | disputed, in dispute, dispute, on hold | ||
| Agreed interest rate | interest rate, agreed interest rate, late interest, late interest rate, late payment interest, contract interest | ||
| Retainage held | retainage, retainage held, retention, retention held, retention money, retainage amount | ||
| Retainage release date | retainage due, retainage release date, retention due, retention release date, release date, retainage due date | ||
| Retainage paid date | retainage paid, retainage released, retention paid, retention released, retainage paid date | ||
| Project | project, job, job name, project name, contract | ||
| Project state | project state, job state, site state, state, work state |