Statement of account template for Excel, South Africa
Short answer: a statement of account lists what a client was invoiced, paid and credited, with a running balance and the amount due now. This free Excel template does the sums and works out how overdue the unpaid part is, in current, 1 to 30, 31 to 60, 61 to 90 and over 90 day groups. Type the transactions in date order, save as PDF and send it.
Download
| File | What is in it | Download |
|---|---|---|
| Statement of account template (.xlsx) | One client per sheet. Room for 40 transactions, a running balance, ageing by group, a balance due, and a check line. Prints on one A4 page, landscape. Sample rows and a How to use sheet. | Download Excel |
How to use it
- Type your business details, your banking details, the statement date and the client's details.
- List every transaction, oldest first. Choose the type: Invoice, Payment, Credit note, or Opening balance for a balance brought forward.
- Type each amount as a positive number. For an invoice, also type its due date.
- Read the summary at the top. It shows the balance due and how much is current or overdue. A check line tells you if an invoice is missing its due date.
- Save as PDF and send it with a short message.
What the sample shows
| Line | Amount |
|---|---|
| Invoiced (INV-0101, INV-0102, INV-0107) | R10,120.00 |
| Payment received, 15 October | R3,277.50 |
| Credit note CN-0003, goodwill discount | R200.00 |
| Balance due | R6,642.50 |
| Of which current (INV-0107, due 17 November) | R1,840.00 |
| Of which 1 to 30 days overdue (INV-0102, due 24 October) | R4,802.50 |
The payment cleared INV-0101 in full, and the credit note took R200 off INV-0102. That is how the ageing works: payments and credit notes are applied to the oldest invoice first. If a client paid a specific newer invoice and left an older one open, say so in your message, because the statement will show the older one as paid first.
What a statement should show
- Your name, address and VAT number if you are registered, and the client's name and account reference.
- The statement date, and every invoice, payment and credit note since the last statement, in date order.
- A running balance and the total due.
- How much is overdue and for how long.
- Your banking details, and the reference to use.
A statement is a summary of the account, not a tax invoice. It does not replace the invoices, so send a copy of any invoice the client asks for. See how to send a client statement for when to send one and what to say.
When the statement does not work
A statement is the step after a reminder and before a demand. If the client still does not pay, send a letter of demand. To see all your clients at once rather than one, use the aged debtors template.
Have the statement built for you
In Zuvo, a client's statement with ageing is built from their invoices, payments and credit notes, on every plan. On Starter and above you can email it to the client from the app.
Try Zuvo free for 14 days, no cardQuestions people ask
What is a statement of account?
A statement of account is a summary of what a client owes you over a period. It lists the invoices you issued, the payments you received and any credit notes, with a running balance and the amount now due, and usually shows how overdue each part is.
What is the difference between a statement and an invoice?
An invoice asks for payment for one supply and, if you are VAT-registered, is the document the client uses to claim VAT. A statement summarises the whole account. It is a reminder and a reconciliation, not a tax invoice, and it does not replace the invoices.
How often should I send a statement?
Monthly is common for clients who buy regularly, sent a few days after month end. Send one sooner when an account is overdue, because it shows the client the full picture in one page.
Does a statement include VAT?
It shows the amounts the client owes, which normally include VAT, because that is what they must pay. The VAT detail stays on the invoices.
How does the template work out the ageing?
It applies payments and credit notes to the oldest invoice first, then ages each unpaid invoice from its due date to the statement date you type. The check line warns you if an unpaid invoice has no due date, because it cannot be aged without one.
A spreadsheet template and general guidance, not accounting advice. A statement is not a tax invoice.