--- type: Template title: Customer Statement Template (Free Excel) description: A free customer statement of account template for Excel. List invoices and payments with a running balance and total due. Send to customers each month. resource: https://accounting.events/resources/accounts-receivable-statement-template/ tags: [accounts receivable statement template, customer statement template, statement of account template, statement of account excel] timestamp: 2026-09-28 author: Harry P. Smart fact_checked_by: Julie Turnbridge fact_checked: 2026-10-26 --- Statement Template # Customer statement template A free statement-of-account template for Excel: list each customer's invoices and payments with a running balance and total amount due. By Harry P. Smart, CPA and Lead Reviewer. Fact-checked by Julie Turnbridge on October 26, 2026. Published June 9, 2026. Updated September 28, 2026. 5 min read. Quick answer **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, a date-ordered table of charges and payments with a running balance, and a total due. It works in Excel or Google Sheets. If your invoices are in Xero or QuickBooks Online, Paidnice sends customer statements like this one automatically, per customer group, on the schedule you set. Preview Xaccounts-receivable-statement-template.xlsxStatement of AccountTo: Harbor Logistics LtdStatement date: 31 May 2026DateReferenceDescriptionChargesPaymentsBalance2026-05-01Opening balance02026-05-02INV-1003Invoice3,2003,2002026-05-18RCT-502Payment received1,0002,2002026-05-28INV-1019Invoice1,5003,700Total amount due3,700Send one statement per customer each month. Running balance and total due calculate automatically. Free customer statement template Excel (.xlsx) with an automatic running balance and total due. No sign-up. [Download Excel](https://accounting.events/resources/accounts-receivable-statement-template/accounts-receivable-statement-template.xlsx) ## Key facts - Balance due equals the opening balance plus charges minus payments. - The IRS says to keep records generally [3 years, or 7 years](https://www.irs.gov/businesses/small-businesses-self-employed/how-long-should-i-keep-records) if you claim a bad debt deduction. - A bad debt deduction needs [reasonable steps to collect](https://www.irs.gov/taxtopics/tc453), which dated statements help you show. ## What is a statement of account? A statement of account summarises a customer's opening balance, invoices, payments, and total amount due over a period. ## 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. ## How often should I send statements? Monthly is the norm, often at the start of the month for the previous month's activity. ## 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. ## Does it work in Google Sheets? Yes. Import the Excel file into Google Sheets; the running balance and total formulas work the same. ## What mistakes should you avoid with this template? 1. **Leaving out a payment.** Skipping RCT-502 shows 4,700 due instead of 3,700, overstating by 1,000 (27%). Post payments when received. 2. **Mixing up date order.** Listing RCT-502 before INV-1003 shows a balance of minus 1,000 on that line. Sort lines by date. 3. **Using the wrong opening balance.** An opening balance 500 too low shows 3,200 due instead of 3,700. Copy last month's closing balance. ## Frequently asked questions ### How do I calculate the running balance? In the preview, 0 plus 3,200 is 3,200, minus 1,000 is 2,200, plus 1,500 is 3,700. ### How long should I keep customer statements? The IRS generally says [3 years, or 7 years](https://www.irs.gov/businesses/small-businesses-self-employed/how-long-should-i-keep-records) if you claim a bad debt deduction. ### Can I email the statement? Yes. Export the sheet as a PDF and email it, so the customer cannot change the figures. ## Bottom line Bottom line: This template suits a business with a handful of customers that bills monthly. Move to software when you send more than a few statements a month, since manual updates then cause the errors above. ## Related reading Independent software reviews and guides from Accounting.Events. [Template ### AR aging report template Group unpaid invoices into aging buckets automatically. Read more →](https://accounting.events/resources/accounts-receivable-aging-report-template/)[Template ### AR ledger template The full customer ledger behind each statement. Read more →](https://accounting.events/resources/accounts-receivable-ledger-template/)[All resources ### Resources, templates and calculators Every free AR guide, template and calculator we publish. Read more →](https://accounting.events/resources/) **About the author: Harry P. Smart, CPA and Lead Reviewer.** Harry P. Smart is a CPA based between London and New York City. Harry writes and leads the review of the software guides on Accounting.Events. **Fact-checked by Julie Turnbridge, Freelance writer and bookkeeper**, on October 26, 2026. Checked prices, review counts, awards, integrations and dates against each primary source. Last updated September 28, 2026. This guide is general information, not accounting, tax, or financial advice. ## Sources Sources checked by Julie Turnbridge on October 26, 2026: 1. [3 years, or 7 years](https://www.irs.gov/businesses/small-businesses-self-employed/how-long-should-i-keep-records) (irs.gov/businesses/small-businesses-self-employed/how-lon...) 2. [reasonable steps to collect](https://www.irs.gov/taxtopics/tc453) (irs.gov/taxtopics/tc453)