A customer statement, or statement of account, is a summary you send a customer showing all their invoices and payments over a period and the total they still owe. It is one of the simplest and most effective accounts receivable tools: a clear statement often prompts payment on its own.
This free template has a header for your business and the customer, a table of charges and payments in date order with an automatic running balance, and a total amount due. It works in Excel or Google Sheets. Send one per customer, usually monthly.
Sending statements on a regular cycle keeps customers aware of what they owe and surfaces any disputes early, before invoices age.
What is in the statement
A header (your business, the customer, statement date and account number), then a running table of charges (invoices) and payments with a balance, ending in the total amount due. The running balance and total calculate automatically as you add lines.
What is a statement of account?
It is a document you send a customer listing every invoice and payment over a period and the balance they still owe. Unlike an invoice, which bills for one sale, a statement summarises the whole account.What should a customer statement include?
Your business details and the customer's, the statement date, each invoice and payment in date order with a running balance, the total amount due, and remittance instructions. The template includes all of these.How often should I send statements?
Monthly is the norm, often at the start of the month for the previous month's activity. Regular statements keep balances visible and prompt timely payment.What is the difference between a statement and an invoice?
An invoice requests payment for a specific sale; a statement summarises all outstanding invoices and payments for a customer and shows the total owed. You send invoices per sale and statements per period.Does it work in Google Sheets?
Yes. Import the Excel file into Google Sheets; the running balance and total formulas work the same.Last updated August 27, 2026. This guide is general information, not accounting, tax, or financial advice.