Our free Excel statement of account template helps small businesses prepare professional customer statements and keep track of outstanding payments. It provides a clear summary of invoices, payments, credit notes and the total amount a customer owes.
The template suits businesses that manage accounts manually or use Excel for bookkeeping. It helps you identify unpaid invoices, keep customers informed, and follow up on overdue payments.
You can download the template for free, with no registration required. We also explain how to complete it and provide an example to help you get started.
Disclosure: This content may contain affiliate links, which means if you click on them, I may get a commission (without any extra cost to you).
What is a Customer Statement of Account?
A billing statement of account or customer statement is a summary of all the transactions that have taken place between a customer and a business over a period of time. The statement will show both the date of the transaction and the amount owed.
Customers typically receive a monthly statement of account, although businesses may send them more frequently if the customer has a history of late payments.
The template also includes easy-to-use remittance advice to complete with their payment.
We have included simple image examples to help you edit the statement.
Why Should I Produce Account Statements?
For businesses, statements of account can be an essential tool for managing receivables and Collections. By sending customers regular statements, businesses can track who owes them money and the amounts owed. This information can then be used to follow up with customers behind on their payments.
Account statements can help improve cash flow management by enabling customers to pay quickly. Sending regular statements is part of credit control procedures.
In short, an account statement is essential to doing business. They help businesses track receivables and ensure customers pay on time.
Customer Statement of Account with Accounting Software
If you have many customers, producing monthly statements will be time-consuming. The easiest way to create a business account statement is to use accounting software. This lets you quickly generate accurate statements and send reminders, helping you collect debts faster and improve cash flow.
Many software programs can do this, such as Sage UK, QuickBooks, and Xero.
Customer Statement of Account Template – Instructions
After downloading the billing statement template, brand it with your business logo and details. All the entries on the main statement side will be copied to the remittance advice section to save time.
• Delete ‘Your logo here’. If you have a logo, upload it and adjust the size to fit the box. To insert logo: Insert – picture – choose an image from the file.
• Enter your business name, company address and contact details.
• At the bottom is a section to enter your bank details for payment; this makes it easier for the customer to pay with online banking.
• Save the document, which will act as a template.
Once you have an account statement template, you can begin processing customer statements. For a regular customer, enter their details in the section and save the document as a template in the customer’s name. It will save time when issuing a new statement to the same client.
Enter the statement date.
Entering Sales Invoice details
You are now ready to enter the sales financial transactions into the template.
From your sales invoices or credit notes, start entering the unpaid invoices. Complete the invoice details in each column, including the date, invoice number or credit number and amount. Each transaction is copied to the remittance section. All the invoices posted are automatically totalled at the bottom, enabling you to see how much they owe.
Date format – the form is set to dd/mm/yyyy. If you want to change the format:
• Highlight the date cells
• Right-click
• Format cells
• Date
• Choose the correct format (Do this on both sides)
When you enter all the details, save the document as a new file. If you regularly send statements to a customer, you may want to set up a new folder to store all the statements.
Below is an example of the completed billing statement template.
The statement is ready to either post or email to your client. If it is emailed, the customer can mark any invoices with a ‘y’ that he is paying and return them to you. With the paper version, they can complete it by hand and return it.
Download Free Customer Statement of Account Template
By downloading our free templates, you agree to our licence agreement, allowing you to use the templates for your own personal or business use only. You may not share, distribute, or resell the templates to anyone else in any way.
Xero Accounting Software
Spend less time entering transactions into spreadsheets. Xero connects to your bank, helps you manage invoices and expenses, and supports Making Tax Digital.
- Send invoices
- Connect your bank
- Capture receipts
- MTD ready
Conclusion to Account Statement Template
Account statements are an essential tool for businesses to track receivables, and sending customers regular statements can improve cash flow. Download our free Excel account templates.
The best way to produce accurate customer invoice statements is to use accounting software, which lets you quickly set up billing statement templates and send reminders so you can collect debts promptly.
Disclaimer: This template is provided for general bookkeeping purposes and is not a substitute for professional tax advice. Check that it suits your circumstances and review current HMRC requirements before submitting information.
