Statement of account template
Copy a statement of account template to reconcile customer invoices, payments and credits. See a worked example and show what is overdue.
By Lars Holdgaard, Founder & CEO of Debitura

A statement of account summarizes what one customer owes as of a specific date. Use this template to show the opening balance, new invoices, applied payments and credits, and the closing balance. List overdue amounts separately so the customer can see what needs attention.
Copy the statement of account template
Select the rows below and paste them into a spreadsheet. Replace the fictional entities and references. Keep one currency per statement and list each invoice, payment and credit on its own row.
| Statement date | Period start | Period end | Supplier | Customer | Currency | Transaction date | Type | Reference | Applied to invoice | Invoice due date | Entry amount | Running balance |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-11-19 | 2026-11-01 | 2026-11-19 | Copper Quay Components Ltd | North Weir Parts BV | EUR | 2026-11-01 | Opening balance | OPEN-NOV | NW-101 | 2026-10-23 | 1500 | |
| 2026-11-19 | 2026-11-01 | 2026-11-19 | Copper Quay Components Ltd | North Weir Parts BV | EUR | 2026-11-02 | Invoice | NW-114 | 2026-11-16 | 2800 | 4300 | |
| 2026-11-19 | 2026-11-01 | 2026-11-19 | Copper Quay Components Ltd | North Weir Parts BV | EUR | 2026-11-08 | Payment | PMT-448 | NW-114 | -1200 | 3100 | |
| 2026-11-19 | 2026-11-01 | 2026-11-19 | Copper Quay Components Ltd | North Weir Parts BV | EUR | 2026-11-12 | Credit | CN-039 | NW-114 | -300 | 2800 | |
| 2026-11-19 | 2026-11-01 | 2026-11-19 | Copper Quay Components Ltd | North Weir Parts BV | EUR | 2026-11-16 | Invoice | NW-126 | 2026-12-16 | 900 | 3700 |
Worked example with invoices, a payment and a credit
Fictional example. Copper Quay Components Ltd sends this EUR statement to North Weir Parts BV for 1 to 19 November 2026. A prior-period invoice, NW-101, accounts for the EUR 1,500 opening balance.
| Date and reference | Ledger entry | Change in EUR | Running balance in EUR |
|---|---|---|---|
| 1 Nov 2026 · opening | Prior-period invoice NW-101, due 23 Oct | None | 1,500 |
| 2 Nov 2026 · NW-114 | New invoice, due 16 Nov | +2,800 | 4,300 |
| 8 Nov 2026 · PMT-448 | Payment applied to NW-114 | -1,200 | 3,100 |
| 12 Nov 2026 · CN-039 | Credit note applied to NW-114 | -300 | 2,800 |
| 16 Nov 2026 · NW-126 | New invoice, due 16 Dec | +900 | 3,700 |
Closing balance = EUR 1,500 + EUR 2,800 - EUR 1,200 - EUR 300 + EUR 900 = EUR 3,700.
Overdue on 19 November: EUR 2,800. NW-101 is overdue by EUR 1,500. NW-114 has EUR 1,300 overdue after the payment and credit. Not yet due: EUR 900 for NW-126, due 16 December.
Reconcile the statement before sending it
- Check the customer’s legal name, account reference, period and currency. Start from the opening balance for that account and currency.
- Use your ledgers and remittance records to match payments and credit notes to the right invoices. Show an unallocated receipt separately and flag its status if you cannot match it.
- Check that the closing balance agrees with the account ledger. Show the due dates and remaining balances for open invoices. An open amount becomes overdue after its due date.
- Share the statement with your accounts payable contact, include the relevant invoice references and ask them to identify any differences. Use the original invoices for the underlying charges and payment terms.
When you have reconciled an overdue B2B balance
Keep the statement, original invoices and the records supporting any payments or credits. Start a collection case with Debitura.
Reference
-min.webp)
Sign up to our newsletter
Get updated on best practices, tips and tricks about international debt collection and accounts receivable management.

.webp)