Track time. Get paid.
Client statement of account template
Show your client how their balance adds up across several invoices. Download the workbook and start with one client and one currency.
Free, without signup. Your details stay in your downloaded file. Excel calculates; Word and PDF amounts are manual.
Build a statement your client can check
- Gather the records. Bring issued invoices, recorded payments and issued credit notes. Find the previous closing balance in your accounting records or last reconciled statement.
- Set the period. Open the Statement tab. Enter your business, contact and client. Choose a three-letter currency code and enter the period dates as YYYY-MM-DD. The period end is the statement date.
- Carry forward the opening balance. Enter the confirmed balance just before your start date, including zero or a negative client credit. Do not list those earlier invoices again.
- Add this period’s transactions. Use date order and a unique reference per row. Enter a positive amount in either Invoice or Payment / credit. Leave the other amount cell blank. Describe each payment’s invoice allocation; use a new receipt reference for each part payment.
- Review before sharing. Resolve every Review row or Review inputs message. Ready to review checks the entries, not your source records. Match those records yourself, add agreed payment instructions, and export only Statement to PDF. Remove the Example tab before sending an editable workbook.
The workbook holds eight transactions, with amounts up to 9,999,999.99 and at most two decimal places. For longer statements, use your accounting software.
Use each invoice’s issued total, including any tax. Do not calculate tax again. The statement summarises your account; it does not replace the original invoices.
Example: explain USD 1,050 still recorded
North Studio prepares Harbour Studio’s statement for 1–30 November 2026. The Example tab starts with a confirmed USD 400 opening balance.
| Date | Reference | Invoice | Payment / credit | Balance |
|---|---|---|---|---|
| 2 Nov 2026 | INV-201 | 800.00 | 1,200.00 | |
| 6 Nov 2026 | PAY-01 | 300.00 | 900.00 | |
| 11 Nov 2026 | CR-01 | 50.00 | 850.00 | |
| 16 Nov 2026 | INV-202 | 200.00 | 1,050.00 |
Closing balance = 400 + 800 − 300 − 50 + 200 = USD 1,050. Compare each reference with your records before sharing.
Complication: USD 100 is disputed
The client questions USD 100 of INV-202. No credit has been issued, so keep the USD 1,050 recorded balance and add this review note:
USD 100 of INV-202 disputed; no credit issued. Contact client before requesting that portion.
If you later issue a USD 100 credit within this period, add its unique reference with 100 in Payment / credit. The balance becomes USD 950. A later-period credit belongs on the next statement.
What does the balance mean?
A positive balance is recorded as owed to you. A negative balance is client credit. Zero means the account balances. Check each invoice’s due date before calling any amount overdue.
Keep currencies separate. Confirm uncertain payments before sharing, and remove private notes. This template cannot verify bank activity or allocate payments for you.
Need to reconcile individual invoices first? Use the invoice payment tracker. For a courteous message after checking the balance, use the payment reminder pack.
Background: MYOB’s statement of account guide. The examples here are fictional.
Want your hours ready for the next invoice? See how TimeLodge turns tracked hours into invoices.