Docs · File formats

Late Payment & Retainage CSV format

Header names are matched automatically, in any order and any case. Extra columns are ignored.
ColumnRequiredAlso accepted asExample
CustomerYescustomer, customer name, client, client name, bill to, debtorNorthgate Builders Ltd
Invoice numberYesinvoice number, invoice no, invoice no., invoice #, invoice, inv noINV-1042
Invoice amountYesamount, invoice amount, invoice total, total, gross amount, original amount2,400.00
Invoice dateinvoice date, date, issue date, txn date, transaction date, document date2026-03-02
Due datedue date, due, payment due, date due, due on2026-04-01
Payment termsterms, payment terms, credit termsNet 30
Date paidpaid date, date paid, payment date, paid on, settled date, date settled2026-05-18
Amount paidamount paid, paid, payments, paid amount, payment amount2,400.00
Open balanceopen balance, balance, balance due, amount due, outstanding, outstanding balance0.00
Currencycurrency, currency code, ccyGBP
Customer typecustomer type, type, b2b b2c, segmentbusiness
Disputeddisputed, in dispute, dispute, on hold
Agreed interest rateinterest rate, agreed interest rate, late interest, late interest rate, late payment interest, contract interest
Retainage heldretainage, retainage held, retention, retention held, retention money, retainage amount
Retainage release dateretainage due, retainage release date, retention due, retention release date, release date, retainage due date
Retainage paid dateretainage paid, retainage released, retention paid, retention released, retainage paid date
Projectproject, job, job name, project name, contract
Project stateproject state, job state, site state, state, work state