Free Statement of Account Template Download: Excel, Word, PDF

What is a Statement of Account Template?

A statement of account template is a document sent by a seller to a buyer that provides a summary of all transactions within a specific period. It serves as a reminder of the amount due while also detailing sales, payments, and credits. Businesses typically use this document to manage credit sales and help customers stay informed about their outstanding balances. This guide will explain the components of a statement of account and how it simplifies transaction tracking for both businesses and clients.

You will also see it called an account statement, a customer statement of account, a statement of accounts, or simply an SOA. In Indonesia, the same question comes up as "statement of account adalah": dalam bahasa Indonesia, statement of account adalah ringkasan semua faktur, pembayaran, dan nota kredit antara penjual dan pembeli dalam satu periode, lengkap dengan saldo akhir yang harus dibayar. 

Statement of Account Sample

Below is a filled-in statement of account sample from our statement of account template: a wholesale supplier, Cedar Lane Wholesale Supply, summarizing October 2026 for its customer, Harbor Street Cafe Group, on 30-day terms.

Aging at Oct 31, 2026: Current $5,888.10 | 1 to 30 days $1,360.00 | 31 to 60 days $1,240.00 | Unapplied credits ($500.00) | Total due $7,988.10

The customer started October owing $4,100.00, and every document moved the running balance to $7,988.10. The aging row shows two part-paid invoices running 13 and 34 days late, plus a $500 payment with no invoice reference waiting as an unapplied credit.

Open this statement of account example in Google Sheets and change the customer ID to see it rebuild.

Importance of Statement of Account Template

A statement puts every invoice, payment and credit for one customer on one page. Both sides can spot a missed payment or a duplicate charge before it turns into a dispute, recurring customers can see exactly which invoices are settled, and the closing balance works as a polite payment reminder without you chasing each invoice separately.

Account Summary

Every account statement needs a section a client can read in five seconds and understand exactly where they stand. This usually sits near the top, right under the client's name, and pulls together the previous balance, new charges added during the period, payments and credits received, and the new balance due. Enerpize's template builds this automatically from the transaction table below it, so nobody is manually adding up a column of numbers before hitting send.

Statement of Account Format

There is no official statement of account format, but the layout that works, and the one every statement of account sample above follows, has four parts, in this order:

1. Header: your business details, the customer's details, the statement number, statement date, period covered and payment terms.
2. Account summary box: opening balance, new charges (+), payments received (-), credits and adjustments (-), closing balance.
3. Transaction table: date, type, reference, description, charges, credits and a running balance after every line.
4. Footer: aging summary, payment instructions and a remittance slip the customer returns with the payment.

If you are building your own SOA format in Excel instead of using a statement of account template Excel file, three formulas do the work. The running balance on each row is =previous balance + charges - credits. The closing balance is =opening balance + total charges - total credits. Days past due for aging is =MAX(0, statement date - due date), then you group each open invoice into Current, 1 to 30, 31 to 60, 61 to 90 or over 90 days.

What Does Template for Statement of Account Contain?

A statement of account template is designed to provide a clear summary of transactions between a business and its client. Here is every field, and why it earns its place:

If you only get one field right, make it "Applies to." A payment logged against the wrong invoice makes the balance look fine while the aging lies, and that is how a 60-day-old invoice hides inside a customer who "always pays."

What Our Statement of Account Template Includes

Most free templates give you a table with a balance column. I built this one around how statements actually go wrong: payments with no invoice reference, opening balances typed by hand, and aging nobody has time to work out.

One ledger for every customer. Log each document once. Nothing is retyped at month end, so the statement never disagrees with your records.

A statement that builds itself. Pick a customer, a period and a date, and the summary, lines and running balance fill in.

Aging on the statement itself. Every payment points to its invoice, so the template knows what is open and how late.

Two statement types in one file. Switch between balance forward and open items without rebuilding anything.

A remittance slip that comes back with the payment, already showing the statement number and amount due.

English and Spanish. One setting relabels everything, and a Labels sheet lets you translate it further.

Customer Balances. Every customer's balance and aging, a credit limit check and a "Send statement?" column.

Every format. The statement of account template Excel file and Google Sheets copy do the math. The statement of account template Word file and PDF hold a printable statement, a Spanish estado de cuenta, a filled sample and five covering emails.

Balance Forward vs. Open Item Statements

Which statement should you send? It depends on how the customer pays.

A balance forward statement starts with last period's closing balance and lists every document in the period. It suits customers who pay a lump sum on account.

An open item statement lists only documents with money still owing: original amount, paid or credited, and what is left. It suits customers who pay invoice by invoice.

Both end at the same number. The rule: send balance forward to customers who pay on account, and send open items to customers who pay invoice by invoice. If you only ever need the second kind, our open item statement template is built for exactly that.

Plantilla de Estado de Cuenta (This Template Works for Spanish-Speaking Clients Too)

Searching for a plantilla de estado de cuenta or a formato de estado de cuenta en Excel? This is the same document. Set the statement language to Español in Settings and every label switches: Cargos (Debe), Abonos (Haber), Saldo, Saldo a pagar, Antigüedad de saldos and Talón de pago. Your own descriptions stay exactly as you typed them, and there are no macros to enable.

If you are building a formato estado de cuenta clientes Excel from scratch, the formula is the same in any language: =saldo anterior + cargos - abonos on each row. In Mexico, keep the CFDI invoices behind every line, since the Código Fiscal de la Federación (Article 30) requires accounting records to be kept for five years, as ContadorMX explains. Atradius's 2026 survey of North American businesses found overdue invoices make up 23% of B2B receivables, according to its release.

How to Use the Statement of Account Template

1- Enter Business and Bank Details

Fill in your business details, currency, bank details and payment window once in Settings. Every statement reads from here.

2- Add the Customer

Give each customer an ID, contact details, payment terms and an optional credit limit. The terms set each invoice's due date for aging.

3- Log Transactions With "Applies To"

Record every invoice, debit note, payment and credit note in date order. For each payment or credit note, type the invoice number it settles; if the customer did not say, leave it blank and it shows as an unapplied credit.

4- Pick the Customer and Period

On the Statement sheet of the statement of account template, choose the customer ID, period and statement date. The opening balance comes from everything before the period, so it always matches last month's closing balance.

5- Choose the Statement Type

Pick balance forward or open items. The table, headings and totals switch to match.

6- Check the Aging Summary

Anything 31 days late or more gets the overdue email, and any unapplied credit needs a quick question to the customer.

7- Fill the Remittance Slip and Save as PDF

The slip is pre-filled. Save as PDF so the statement cannot be edited in transit.

8- Send and File

Send the statement with the covering email, then file a dated copy by customer and month. Keep it with the invoices it summarizes for as long as your tax rules require: seven years in Malaysia, five in the Philippines, South Africa and the UAE, and generally three in the US (details by country below). The Customer Balances sheet shows who else needs a statement this month.

Statement of Account vs. Invoice: What's the Difference?

They're related documents, but they serve completely different purposes and get sent at different points in the payment cycle.

An invoice is issued per transaction. Every time you sell a product or complete a service, you send an invoice requesting payment for that specific interaction. It has one transaction, one amount, one due date. It's the original payment request.

A statement of account is issued periodically, typically monthly. It summarizes all the invoices, payments, and credits that have passed between you and a client over a defined period, and shows the net outstanding balance. It's not a new payment request for a new sale. It's a consolidated reminder of everything already billed and what remains unpaid.

The practical rule: you send the invoice first. If the invoice goes unpaid, or if the client has multiple outstanding invoices across the month, you follow up with a statement. The statement says: "here's everything we've agreed on so far, here's what's settled, and here's what still needs to be resolved."

One important distinction: a statement of account is not a legal demand for payment in most jurisdictions. It's a communication and reconciliation tool. However, it can serve as supporting documentation in a payment dispute, since it provides a timestamped, itemized record of the business relationship. If you're sending both documents regularly at volume, invoicing software automates both from a single client record, with no duplication and no manual cross-referencing.

Statement of Account vs. Billing Statement

The two terms get used interchangeably, and most of the time that's fine. But there's a real distinction worth knowing. A billing statement usually covers one recurring charge cycle, the kind a subscription service or utility company sends every month for the same type of charge. A statement of account is broader. It covers everything that happened between you and a specific client during the period: invoices for different jobs, payments against different invoices, credit notes, adjustments, whatever occurred. If your business bills the same amount every month for the same service, a billing statement and a statement of account will often look identical. If a client relationship involves multiple invoices, projects, or products in a single month, the statement of account is the document built to hold all of it together.

Should a Statement of Account Show VAT or Sales Tax?

No separate tax line. Tax was already charged on each invoice, so the statement shows invoice totals including tax; adding it again would double it. If an invoice had the wrong tax, issue a credit note and let it appear on the next statement.

Statement of Account by Business Type

Any business that sells on credit terms needs a customer statement of account, but each type has its own pressure point.

Wholesale and distribution. Returns create credit notes every week. Applying each to the right invoice keeps the aging honest.

Agencies and retainers. Monthly fees and project invoices share one account. The statement shows which ones are settled.

Construction subcontractors. Contractors often hold back retention. Log what was actually paid and it stays visible as an open amount.

Clinics and B2B services. Small invoices pile up fast. Pair the statement with an accounts receivable template to keep both records aligned.

Best Practices for Sending Statements of Account

The statement of account template handles the formatting. These practices make sure the statements of accounts you send actually get paid.

Send on a consistent, predictable schedule

Monthly is the standard for most businesses, typically on the last day of the month or the first business day of the following month. Clients who know when to expect statements are more likely to have payments ready. Inconsistent timing creates confusion about whether a statement is current or overdue.

Beat your customer's cut-off date

Many payables teams have a cut-off, often around the 5th, after which anything new waits for next month's pay run. Send statements as soon as the month closes.

Always carry the opening balance forward from the previous period

A statement that starts at zero every month is missing the point. The opening balance, whatever was outstanding at the close of the previous statement, needs to appear as the first line. Without it, clients can't see whether prior balances have been resolved, and you lose the cumulative audit trail that makes statements useful.

Match every line item to a specific invoice or reference number

Vague descriptions like "services rendered" or "outstanding amount" create disputes. Every transaction row should reference an invoice number, a payment receipt number, or a credit note number that the client can look up in their own records. Specificity eliminates the most common reason clients delay payment: they can't match your statement to their own records.

Never change an invoice that is already on a sent statement

Issue a credit note or debit note instead. Quietly editing an old invoice makes your records disagree with the customer's, and that starts disputes.

Include clear payment instructions and a due date on every statement

Don't assume the client remembers how to pay you. Bank details, payment methods accepted, and the specific due date should appear on every statement, even for long-standing clients. Making payment frictionless is the single most effective way to accelerate settlement.

Follow up within 3 to 5 business days if there's no acknowledgement

A statement sent is not a statement received. If you haven't heard back within a few days, no payment, no query, no confirmation, follow up directly. Most delayed payments are not disputes; they're overlooked emails. A brief, professional follow-up is often all it takes.

Keep a dated copy of every statement you send

After closing each statement period, use a cash reconciliation template to verify your bank records match what clients have confirmed as paid. File both documents together. If a payment dispute arises later, the combination of the sent statement and the reconciled bank record is your strongest evidence.

Statement of Account Rules and Record-Keeping by Country

Malaysia

Sending statements of account to Malaysian clients works the same way as anywhere else, but the record-keeping expectations behind them are stricter than most businesses realize. Under Section 82 of Malaysia's Income Tax Act 1967, businesses are required to retain accounting records, including the invoices and payments a statement summarizes, for seven years from the year the transaction relates to, according to Malaysia's Inland Revenue Board. That's longer than most Western jurisdictions, so a monthly statement of account isn't just a courtesy to the client, it's part of the paper trail your own business needs to hold onto for years after the balance is settled. With MyInvois, Malaysia's e-invoicing rollout, gradually becoming the primary record for underlying transactions, keeping a clean statement alongside those e-invoices makes reconciliation far easier if LHDN ever asks to see the full history.

Philippines

In the Philippines, it helps to be clear about what a statement of account is and isn't. Since April 27, 2024, under the Ease of Paying Taxes (EOPT) Act and Revenue Regulations No. 7-2024, the invoice has replaced the official receipt as the primary document for a sale, and books of accounts must be preserved for five years from the day after the filing deadline, as Grant Thornton Philippines explains.

Here is what most SOA guides miss. RR 11-2024 lets businesses convert a Statement of Account into a "Billing Invoice": with the invoice details RR 7-2024 requires and an "Invoice/Billing Invoice" stamp, it supports the buyer's input VAT claim, according to PwC Philippines. If your SOA only summarizes invoices you already issued, it stays a reconciliation tool. If it is the only billing document the customer gets, it must meet the invoice rules.

What to add for Philippine customers: both TINs on the header and the invoice number behind every line.

South Africa

South African businesses sending statements of account should keep one number in mind: five years. That's how long SARS requires supporting documents, including the invoices and payment records a statement summarizes, to be retained after a tax return is submitted, according to SARS's own guidance. A statement of account doesn't replace a VAT invoice for tax purposes, but it's a genuinely useful reconciliation layer on top of one, especially for businesses managing recurring B2B credit accounts across the retail, wholesale, and service sectors that make up a large share of South Africa's SME economy. Keeping a dated copy of every statement sent, alongside the underlying invoices, gives you a much easier audit trail if SARS ever comes calling.

United Arab Emirates

UAE businesses have two reasons to tidy up their statements of accounts now. First, VAT records, including the tax invoices a statement summarizes, must be kept for at least five years after the end of the tax period under Cabinet Decision No. 74 of 2023, as PwC Middle East summarizes. Second, e-invoicing is coming: businesses with annual revenue of AED 50 million or more go live on January 1, 2027, and everyone else on July 1, 2027, according to KPMG. Our UAE e-invoicing guide covers the deadlines. Collections matter too: Atradius found that 58% of B2B credit sales in the UAE are paid late, on average payment terms of 47 days, as reported by Malay Mail.

Practical note for UAE businesses: show your TRN on the statement and the e-invoice number on every line.

United States

In the US, a statement of account isn't a tax document on its own. The underlying invoices and receipts are what the IRS actually cares about, and the general guidance is to keep those records for at least three years after filing, per the IRS's recordkeeping guidance for small businesses. Where the statement of account earns its keep in the US market is on the collections side. American B2B clients are used to net-30 and net-60 terms, and late payment affects seven in ten North American companies, according to Atradius's 2026 survey. A clear monthly statement that shows exactly what's outstanding, and for how long, is often what turns a vague "we'll get to it" into an actual payment date.

How to Request a Statement of Account from a Supplier

Sometimes you are the customer. Ask suppliers for an account statement before your month-end close, then compare it line by line with your payables to catch a missing invoice or a payment they never recorded:

Subject: Statement of account request, [Your Company]
Hi [Name], could you send us a statement of account for [period], showing invoices, payments and credit notes with the running balance? We are reconciling our payables before month end. Thank you.

What to Do After You Send a Statement

Sending the statement is not the last step, it's the first one. A statement that goes unanswered needs a plan, not a shrug.

If a week passes with no payment and no reply, send a short, polite follow-up that references the statement directly. Most late payments aren't disputes, they're emails that got buried.

If two weeks pass with still no response, pick up the phone. Confirm the client actually received the statement, ask whether there's a dispute on any line item, and try to agree on a payment date while you have them on the line.

If a balance is still unpaid after 30 days, put it in writing. A short, formal letter that restates the amount owed, the invoices involved, and a firm deadline moves the account into a different category in the client's mind.

Past that point, most businesses either pause future credit terms for that client or hand the account to collections. Neither is a fun conversation, but a documented trail, the original statement, the follow-up emails, the call notes, is what makes that next step defensible if it comes to it.

Grouping Outstanding Balances by Age

Once you're managing more than a handful of clients with open balances, a single running total stops being useful. You need to know which balances are fresh and which ones are becoming a problem. The standard way to do this is by grouping invoices according to how many days they've been outstanding.

• 0 to 30 days: recently due. A gentle reminder is usually enough here.
• 31 to 60 days: starting to age. This is where a phone call, not just an email, starts to make sense.
• 61 to 90 days: significantly overdue. Worth a more direct conversation and a firm deadline.
• 90 plus days: at this stage, most businesses are weighing whether to escalate to a formal demand or collections.

Sorting outstanding statements into these buckets, even in a simple spreadsheet column, turns a wall of numbers into a prioritized to-do list.

Statement of Account Email Templates

Sending the document is only half the job, the email around it matters too. Here are four you can adapt.

For a routine monthly statement:
Subject: Your statement of account for [Month], [Your Company Name]
Dear [Client Name], attached is your statement of account for the period ending [date]. Your current balance is [amount]. If payment is already on its way, you can disregard this note. Questions about any of the transactions listed, just reply here.

For an overdue balance:
Subject: Outstanding balance, statement of account for [Client Name]
Dear [Client Name], attached is your updated statement of account, showing an outstanding balance of [amount] against invoice(s) [invoice numbers]. We'd appreciate payment at your earliest convenience. If there's a question or a dispute about any of the invoices listed, reach out and we'll sort it out before taking any further steps.

When a customer disputes a line:
Subject: Re: [invoice number] on your statement
Dear [Client Name], thanks for flagging [invoice number]. The invoice and delivery record are attached. If it is still wrong, I will issue a credit note and a corrected statement. The rest of the balance, [amount], is due on [date].

When the customer has a credit balance:
Subject: Credit balance of [amount] on your account
Dear [Client Name], your statement shows a credit of [amount] in your favor. Would you like a refund, or should we apply it to your next invoice?

Key Takeaways

• A statement of account summarizes every invoice, payment and credit for one customer over a period, from opening balance to closing balance.
• A free statement of account template saves rebuilding this monthly. The standard statement of account format has four parts: header, account summary, transaction table, and a footer with aging and a remittance slip.
• Link every payment and credit note to the invoice it settles, or the aging will be wrong.
• Send balance forward statements to customers who pay on account and open item statements to customers who pay per invoice.
• Do not add a tax line to a customer statement of account. Invoices carry the tax; the statement shows their totals.
• Send statements before your customers' pay-run cut-off and keep a dated copy for as long as your country requires.

FAQs

How do you write a statement of account?

Add your business and customer details, the statement date, period and opening balance. List every invoice, payment and credit note in date order with its reference and a running balance, then finish with the closing balance, aging, payment instructions and a due date.

How do I get a statement of account from a supplier?

Email the supplier's accounts team for an account statement covering a specific period, with invoices, payments, credit notes and the running balance, then compare it with your own payables records.

What is the difference between a balance forward and an open item statement?

A balance forward statement starts from last period's closing balance and lists every document in the period. An open item statement lists only unpaid documents. Both reach the same total.

Can a statement of account show a credit balance?

Yes. If the customer overpaid or has an unused credit note, the closing balance is negative, a credit in their favor. Offer a refund or apply it to the next invoice.

What is the difference between a statement of account and an invoice?

An invoice is issued per transaction: it requests payment for a specific sale or service and has its own due date. A statement of account is issued periodically and summarizes multiple invoices, payments, and credits over a set period. You send an invoice first; you send a statement when one or more invoices remain outstanding or when you want to give the client a full picture of the account. If you mail statements rather than email them, our client statement template is built around a tear-off remittance slip designed for print and manual check payments.

How often should a statement of account be sent?

Monthly is the standard for most businesses, typically aligned with the end of the calendar month or billing cycle. High-volume suppliers or businesses with shorter payment terms may send statements bi-weekly. Service businesses with retainer arrangements often send quarterly. The key principle is consistency: clients should be able to predict when your statement will arrive, which makes payment planning easier on their end.

What should be included in a statement of account?

Every statement of account template should cover your business and customer details, the statement number, date and period, the opening balance, every invoice, payment and credit with its reference, a running balance, the closing balance, an aging summary, a payment due date, payment instructions and a remittance slip.

Can I use a statement of account as proof of debt?

A statement of account can serve as supporting evidence in a payment dispute or legal proceeding, but it is not a formal legal instrument on its own. It demonstrates that invoices were raised, that the client was notified of the outstanding balance, and that the business maintained organized records. Courts and arbitrators typically treat a well-maintained statement of account, especially one that was sent to and acknowledged by the client, as credible documentation. For formal debt recovery, consult a legal professional in your jurisdiction. The statement is part of your evidence, not the entirety of it.

How do I create a statement of account in Excel?

Start from a statement of account format: a header, then a table with date, type, reference, description, charges, credits and running balance, using =previous balance + charges - credits on each row. Add the closing balance, aging and due date at the bottom. Or grab the statement of account template Excel free download above, where all of it is already built.

What does a statement of account look like?

It typically looks like a simple table: a header with your business and client details, an opening balance carried from the previous period, a row for each invoice and payment, a running balance column, and a closing balance at the bottom, followed by an aging summary and a remittance slip. See the statement of account sample and statement of account example image above for exactly how this comes together, or open the statement of account template Word file for a printable version.

About the Author

Omar El Bahr is a Senior Digital Growth Specialist at Enerpize, where he leads SEO, content strategy, and organic growth across international markets. He is a Forbes Communications Council contributor and has written for Entrepreneur on business communication and digital strategy.

Disclaimer

This template and guide are for general business use and are not tax, legal or accounting advice. A statement of account summarizes invoices already issued and does not replace a tax invoice. Record-keeping and invoicing rules vary by country and change over time, so check the rules that apply to your business.