A clear statement of account that reconciles every charge and payment
When a client has several open invoices, a statement of account is the cleanest way to remind them of the total owing. This builder turns a list of charges and payments into a running ledger, carries the balance forward line by line, and produces a tidy statement you can email or attach for your monthly dispatch.
How it works
The statement starts from the opening balance brought forward. The builder processes each transaction in order: it adds any charge and subtracts any payment, then carries the new running balance to the next line — so every row shows exactly what was owed at that point. At the end it sums all charges and all payments and computes the closing balance owing, which equals the opening balance plus total charges minus total payments. Amounts are formatted in your chosen currency with the matching symbol, and the output is an aligned, copy-ready statement with a polite settlement note.
Worked example
A client has an unpaid balance of £500 from last month. This month you raised two invoices and received a partial payment:
| Date | Reference | Charge | Payment | Balance |
|---|---|---|---|---|
| 01 Jun | B/F | — | — | £500.00 |
| 03 Jun | INV-0041 | £850.00 | — | £1,350.00 |
| 10 Jun | INV-0042 | £640.00 | — | £1,990.00 |
| 15 Jun | PAY-2891 | — | £500.00 | £1,490.00 |
The closing balance owing is £1,490. The client now has a single document showing exactly how that figure was reached, with references they can match to their own purchase ledger.
When to send a statement of account
Statements are typically sent monthly, but there are specific triggers that make them especially useful:
End of month. Routine monthly statements prevent balances from becoming stale and remind clients what is open without a confrontational phone call.
Before chasing overdue invoices. Sending a statement first gives the client an opportunity to spot a mismatched reference or a payment already made. Many payment disputes stem from reconciliation errors, not bad faith, and a statement resolves them quickly.
At financial year-end. Clients often request a statement to reconcile their own accounts payable before closing their books. Having one ready builds goodwill and speeds your own receipt of payment.
When a client queries their balance. A statement is the quickest way to answer “what do we owe you?” with evidence rather than a verbal summary.
Making statements effective
Use consistent references. Invoice numbers on charge lines and payment receipt references on payment lines let the client cross-check each line against their own records without asking you to clarify.
Carry forward promptly. The opening balance should exactly match the prior month’s closing balance. Discrepancies here are the most common source of client disputes.
Include payment terms. Add a note below the closing balance stating your standard terms — for example “Payment due within 30 days of invoice date.” A statement is a soft reminder; including terms reinforces the timeline without making it feel like a demand.
Send the same day each month. Predictable statements get paid faster than ad-hoc reminders because clients can process them as part of their routine payment run.