Free statement of account template for Google Docs
A period summary of a customer's invoices, credits and payments with a running balance, generated one per account from your ledger data.
Free to copy, no sign-up: the file opens in your own Google Drive. Updated November 13, 2026.
What’s in the statement of account template
Every block has a placeholder showing where your details go. Type over them by hand, or bind each one to a field in your data and let it fill itself.
- Header with your logo and the statement period {{period.from}} – {{period.to}}
- Account block and account number {{customer.name}} · {{customer.account}}
- Opening balance brought forward {{balance.opening}}
- Activity table: invoices, credits and payments in date order loop: {{entries}}
- Closing balance and ageing buckets {{balance.closing}} · {{ageing.over90}}
- Remittance details and how to query a line {{remittance.details}}
How to use this statement of account template in Google Docs
- 01
Copy the template to your Google Drive
Press "Copy to my Google Docs". Google asks to make a copy, and the copy is yours to edit; the original is never changed. All you need is a free Google account.
- 02
Replace the placeholders with your details
Text in double braces, like {{period.from}} – {{period.to}}, marks where your own values go. Work down the page: header with your logo and the statement period; account block and account number; opening balance brought forward, and so on.
- 03
Make it match your brand
Swap the logo, colours and fonts in Google Docs as you would in any document. The layout is built to hold when the text changes.
- 04
Download it as a PDF, or share the link
File, then Download, then PDF Document gives you a file to send or print. Download as Word (.docx) works too if someone needs it.
- 05
Making these regularly? Fill it from your data
Connect Airtable, Google Sheets or a CSV to SourceToDocs and it fills a copy of this template for every row, so you stop retyping.
A statement of account answers a different question from an invoice. Rather than billing for one job, it shows a customer everything that moved on their account over a period — invoices raised, credits applied, payments received — and where the balance stands at the end of it. The number of entries is unpredictable, so pages have to break on their own; that is the case for Google Docs.
What to include in a statement of account
| Section | What to write | Example |
|---|---|---|
| Statement period | From and to dates | 1–31 October 2026 |
| Customer and account number | Who the statement is for | Acme Co · A-10432 |
| Opening balance | What was owed at the start of the period | $2,150.00 |
| Activity | Each invoice, credit and payment in date order, with reference | 12 Oct · INV-0871 · $940.00 |
| Running balance | The balance after each line | $3,090.00 |
| Closing balance | What is owed at the end of the period | $1,840.00 |
| Ageing | How much is current, 30, 60 and 90+ days overdue | 90+ days: $0.00 |
| How to pay | Bank details or payment link, and who to contact | accounts@… |
How to prepare a statement of account
- Set the period first and bring the previous closing balance forward as the opening balance.
- List every transaction in date order, invoices and credits as well as payments.
- Show a running balance, so a customer can find the line where their records differ from yours.
- Add ageing if anything is overdue; it turns a statement into a polite reminder.
- Send it as a PDF at the same time each month.
Statement of account or invoice?
An invoice asks for payment for one sale. A statement summarises the whole account over a period and asks for nothing new: it shows what has been invoiced, what has been paid and what remains. Send invoices as work is billed, and a statement monthly to customers with an open balance.
Google Docs will not calculate the running balance. Keep the ledger in Google Sheets, where the arithmetic belongs, and let the template place the figures.
Order the entries and let the ledger own the balances
Two things make or break a statement. The first is ordering: entries should arrive from your data already sorted by date, because a statement that jumps around is impossible to reconcile against. The second is that opening and closing balances come from the ledger rather than being worked out in the document. Feed the run a filtered set of entries per account and a balance field, and month end becomes one job instead of a morning of copying rows between files.
Fill this statement of account template from Airtable, Google Sheets or a CSV
Connect an Airtable base, a Google Sheets spreadsheet or a CSV file, map each field to a placeholder, and generate. One run can produce a single document or one per matching row, delivered to your Google Drive.
Accounts · Google Sheets
Template: Google Slides or Docs
{{customer.name}}
Statement · {{period.from}} – {{period.to}}
opening {{balance.opening}}
loop: {{entries}} → row
closing {{balance.closing}}
one statement per account, entries filtered to the period
Generated output
DocsPDFAcme Co
Statement · 1 Aug – 31 Aug 2026
opening $3,400
14 entries this period
closing $7,150
Who uses this statement of account template
Credit control teams
Send every account its month-end statement in one run so chasing starts from an agreed position.
Read the guideWholesalers and distributors
Show trade customers a period of invoices and payments against a single running balance.
Read the guideProfessional services firms
Give retained clients a monthly account summary rather than a stack of separate invoices.
Read the guideRelated templates
All billing & operations →
Google Docs Invoice template
A billing document with a line-item table that grows with the job, generated one per record from your billing data.
View template
Google Docs Receipt template
A record of a payment received, listing what it settles, generated one per payment from your payments data.
View template
Google Docs Credit note template
A document that cancels part or all of an invoice, naming the lines credited and the reason, generated one per credit from your billing data.
View template
Google Docs Delivery note template
A record of goods handed over and signed for on arrival, generated one per delivery from your dispatch data.
View templateCommon questions, answered
How is a statement different from an invoice? +
How does the running balance stay right? +
Can I send a statement to every account at month end? +
Can I use my own statement design? +
Is this statement of account template free? +
Can I download this statement of account template as a PDF or Word file? +
Generate this document from your data
Start on the free plan, connect Airtable, Google Sheets or a CSV, and export a real Google Docs file. No watermark, no credit card.