Statement of account template
The document that answers "what do I owe you?" without an argument. Four numbers that add up, for one period, for one customer.
The template as it comes, with {{placeholders}} where the text changes.
Free, no signup, no email. Edit it in Word, PowerPoint or Excel like any other file.
The fields in this template
Each {{placeholder}} matches a column name in the sample list, so the two line up on their own.
| Placeholder | What goes in it |
|---|---|
{{Customer Name}} | The account holder. |
{{Statement Period}} | "1–31 July 2026". Be explicit about both ends. |
{{Opening Balance}} | What was outstanding at the start. |
{{New Charges}} | Invoiced during the period. |
{{Payments Received}} | Paid during the period. |
{{Closing Balance}} | Opening + charges − payments. It must actually add up. |
{{Account Manager}} | Who to call about it. |
{{Statement Date}} | When it was issued. |
The arithmetic has to be visible
A statement that shows only "you owe $4,820" invites a phone call. A statement that shows opening, charges, payments and closing lets the customer reconcile it against their own books without talking to anyone — which is the entire point.
Make sure the four numbers really do add up. Export them from your accounting system rather than typing them; a statement with arithmetic that does not work destroys trust in every other number you send.
It is a collections tool, not just a record
Most overdue payments are not refusals — they are invoices that fell through a gap. A monthly statement catches those quietly, before anyone has to make an awkward call.
Send it on the same day every month. Predictable statements get processed; irregular ones get filed.
Same day, every customer
Month-end means the same document for every account, with different numbers. Export the ledger to a spreadsheet, one row per customer, and generate the whole run at once — each file named after the customer so they can be attached to emails without opening them.
Need forty of them?
Upload this template with your own list and every row comes back as its own file, named from a column you choose. Word, PowerPoint or Excel in; Word or PDF out.
Send your Excel →Free to run and inspect every file. Downloading a batch is a one-time US$9.90 — no subscription, no account.