Skip to main content
All posts

Invoice statement template: list every open invoice

Nnabuike Okoroafor

Nnabuike Okoroafor ·

One client, four unpaid invoices, two part payments and a remittance email that says “payment for recent work”. You could forward every invoice again. Or you could send one page that lists every open invoice, what has been paid against each, what is left and how late it is. That page is an invoice statement, and a good invoice statement template lets you produce it in minutes instead of rebuilding it from your inbox every month.

This guide covers what goes on an invoice statement, a filled example with ageing that you can check line by line, the two kinds of statement and which one you need, how to build your own statement template in Excel or Word, and the faster route of generating the statement from the invoices you have already sent.

If you are still deciding whether to send an invoice or a statement at all, start with invoice vs statement. This post assumes you have decided on the statement and want to make one.

In short#

  • An invoice statement lists a client's open invoices on one dated page: number, dates, amount, paid, balance and days overdue, with a total due.
  • Add an ageing summary. Current, 1 to 30, 31 to 60, 61 to 90 and over 90 days, adding up to the total due, so the client sees at once which money is oldest.
  • Two kinds exist. An open-item statement lists what is still unpaid; a balance-forward statement lists every invoice and payment in a period. Both should end at the same balance.
  • A spreadsheet works well as a template: balance = amount − paid, days overdue = statement date − due date, then sum by age.
  • Update your payments first. A statement is only as accurate as the payments you have recorded.

What an invoice statement is#

An invoice statement (also called a statement of account, a client statement or a statement of outstanding invoices) is a summary of what one client owes you on a given date. It does not ask for payment for new work, and it does not replace the invoices. It points back to them, one line each, so you and the client can agree on the balance.

That is why it carries a statement date rather than a number of its own. It is a snapshot. Next month's statement will show a different picture, and both are correct for their dates. The invoice vs statement post covers the accounting side in more depth; here the focus is the document itself.

What to put on an invoice statement#

Whatever template you use, these are the fields that make a statement useful. The ones marked essential are what the client needs to reconcile it against their own records.

FieldEssential?Why it is there
Your business name, address and contact detailsYesWho the statement is from
The word “Statement”YesSo nobody files it as a new invoice
Statement dateYesThe date the balances and ageing are measured on
Client name and addressYesWhose account it is
Invoice number, per rowYesWhat the client matches against their records
Issue date and due date, per rowYesWithout the due date, “overdue” means nothing
Original amount, paid and balance, per rowYesShows part payments were credited
Days overdue, per rowRecommendedMakes the late items obvious
Ageing summaryRecommendedCurrent, 1–30, 31–60, 61–90 and 90+ days, adding up to the total
Total dueYesThe one number the client may pay
Payment detailsYesBank details or a payment link, and what reference to use
CurrencyWhen you bill in more than oneNever add two currencies into one total
A short noteOptional“If anything does not match your records, tell us”

Leave off anything that is not about the open balance. A statement is not the place for new charges, a late fee you have not invoiced, or a sales message.

Invoice statement example: four open invoices with ageing#

Here is a statement of invoices sample you can check line by line. Every name, number and amount is invented for illustration, and the arithmetic is real. Harbour Lane Design (a sample business) has billed Fenwick Dental (a sample client) five times on Net 30 terms. One invoice has been paid in full, two have been part paid, and one is not yet due. The statement date is Friday 30 October 2026.

First, the invoices as they stand on the statement date:

InvoiceIssuedDueAmountPayments received
INV-0031Mon 6 Jul 2026Wed 5 Aug 2026$1,450.00$500.00 on Fri 18 Sep
INV-0036Mon 10 Aug 2026Wed 9 Sep 2026$780.00None
INV-0038Wed 2 Sep 2026Fri 2 Oct 2026$640.00$640.00 on Wed 14 Oct (paid in full)
INV-0039Tue 15 Sep 2026Thu 15 Oct 2026$1,200.00$300.00 on Fri 23 Oct
INV-0042Mon 5 Oct 2026Wed 4 Nov 2026$2,200.00None

INV-0038 owes nothing, so it does not go on the statement. The other four do:

Invoice no.IssuedDueAmountPaidBalanceDays overdue
INV-00316 Jul 20265 Aug 2026$1,450.00$500.00$950.0086
INV-003610 Aug 20269 Sep 2026$780.00—$780.0051
INV-003915 Sep 202615 Oct 2026$1,200.00$300.00$900.0015
INV-00425 Oct 20264 Nov 2026$2,200.00—$2,200.00Not yet due
Total$5,630.00$800.00$4,830.00

Days overdue count from the due date to the statement date: 5 August to 30 October is 86 days, 9 September to 30 October is 51, and 15 October to 30 October is 15. INV-0042 is not due until 4 November, so it counts as current.

The ageing summary groups those balances:

Current1–30 days31–60 days61–90 days90+ daysTotal due
$2,200.00$900.00$780.00$950.00$0.00$4,830.00

Drawn as the page the client receives, with what to notice:

One page answers the client's question before they ask it: which invoices, how much is left, and which money is oldest.

And the same balances as a chart, which is what the ageing row is really telling the client:

Almost half the balance is not due yet. The $950.00 on INV-0031 is the part to talk about.

The total alone says the client owes $4,830.00. The ageing says something more useful: $2,200.00 of that is not due yet, and the money that needs a conversation is the $950.00 left on INV-0031, now 86 days late. If you want to track the same buckets across all your clients rather than one, the open invoices report covers that view. To keep those buckets in a spreadsheet, our invoice tracker template builds the formulas column by column, and the same tracker is a free Excel download.

Open-item vs balance-forward statements#

There are two common kinds of client statement, and choosing the right one decides what your invoice statement template needs to hold.

  • Open-item statement. Lists only the invoices that still have a balance, with ageing. Paid invoices drop off. This is the example above.
  • Balance-forward statement. Starts from an opening balance at the beginning of a period, lists every invoice and payment in that period, and ends at a closing balance. It reads like a bank statement.

For the sample account, October 2026 as a balance-forward statement runs like this:

DateActivityAmountRunning balance
1 OctOpening balance (INV-0031, 0036, 0038, 0039)$3,570.00
5 OctInvoice INV-0042$2,200.00$5,770.00
14 OctPayment, INV-0038−$640.00$5,130.00
23 OctPayment, INV-0039−$300.00$4,830.00
30 OctClosing balance$4,830.00

The opening balance is what was unpaid on 30 September: $950.00 on INV-0031 (after the $500.00 paid on 18 September), $780.00 on INV-0036, $640.00 on INV-0038 and $1,200.00 on INV-0039, which is $3,570.00. Both statements end at $4,830.00, as they must:

Different routes, same destination. If the two ever disagree, a payment or an invoice is missing from your records.

Which one to use:

Open-itemBalance-forward
ShowsWhat is still unpaid, and how lateEverything that happened in the period
Paid invoicesNot shownShown, as payments
Ageing per invoiceYesNot usually
Easiest for the client to act onYesLess so: they must work out what is open
Good forFreelancers and small businesses chasing balancesAccounts with lots of small invoices and payments every month
NeedsYour invoices and recorded paymentsThe same, plus a clean opening balance each period

For most people sending a “monthly statement invoice” to a few repeat clients, the open-item statement is the clearer page. A balance-forward statement suits accounts where the client wants to see every movement, such as a supplier with dozens of deliveries a month.

How to make an invoice statement template in Excel#

If you would rather not build it, download the free statement of account template for Excel. It does what the steps below describe: balance, days overdue and ageing worked out from the statement date, a total due, an amount due now, payment details and a filled-in example tab. It is an Excel file only; there is no Word statement. If you already use our free invoice templates, each saved invoice carries the two numbers a statement needs, in its Amount paid and Balance due cells.

To build your own instead, a statement template is a short spreadsheet on top of that.

Build it once:

  1. Header. Type your business details, the word “Statement”, a “Statement for” block for the client, and a statement date in cell B2.
  2. Columns. In row 5, type the headings Invoice no., Issued, Due, Amount, Paid, Balance and Days overdue in columns A to G. Leave rows 6 to 20 for invoices.
  3. Balance. In F6, enter the formula below and copy it down to F20. It leaves the cell empty when there is no amount.
  4. Days overdue. In G6, enter the second formula and copy it down. Format column G as a number, not a date, or Excel may show “1900” dates instead of a count.
  5. Ageing summary. Under the table, add one cell per bucket with the SUMIFS formulas below, and a total.
  6. Payment details. Add your bank details or payment link and the reference to quote.

The formulas, for the layout above:

Balance (F6):        =IF(D6="","",D6-E6)
Days overdue (G6):   =IF(C6="","",MAX(0,$B$2-C6))
Current:             =SUMIFS($F$6:$F$20,$G$6:$G$20,0)
1-30 days:           =SUMIFS($F$6:$F$20,$G$6:$G$20,">=1",$G$6:$G$20,"<=30")
31-60 days:          =SUMIFS($F$6:$F$20,$G$6:$G$20,">=31",$G$6:$G$20,"<=60")
61-90 days:          =SUMIFS($F$6:$F$20,$G$6:$G$20,">=61",$G$6:$G$20,"<=90")
90+ days:            =SUMIFS($F$6:$F$20,$G$6:$G$20,">90")
Total due:           =SUM(F6:F20)

Then, each time you send one:

  1. Record every payment first against the invoice it paid. If one payment covered two invoices, split it.
  2. Delete paid invoices from the list, and add any new ones sent since the last statement.
  3. Change the statement date in B2. The days overdue and the ageing update by themselves.
  4. Check that the buckets add up to the total due. If they do not, a row has a date missing.
  5. Save it as a PDF and attach it to a short email.

Typed into that sheet, the sample account gives days overdue of 86, 51, 15 and 0, the ageing row from the example and a total due of $4,830.00.

A Word version works too: a table with the same seven columns and a totals row. Word will not age the invoices or add up the balances for you, so work them out with a calculator and check the total twice. If you have more than a handful of open invoices, the spreadsheet is less error-prone. The Excel invoice template guide explains the formulas inside the invoice files, if you want to see how their Balance due is worked out.

The same four steps whether a spreadsheet or an app does them. The step people skip is recording payments before step 2.

Make the statement from your invoices in Charming#

If your invoices are already in Charming Invoices, you do not need a statement template at all. Each client on your client list has a Statement button, on every plan including the free one. It opens a PDF in your invoice design with:

  • Every open invoice for that client: issued, with a balance left, oldest first, showing invoice number, issued and due dates, amount, paid, balance and days overdue.
  • An ageing summary (current, 1–30, 31–60, 61–90 and 90+ days) and a total due.
  • A section per currency when the client has invoices in more than one, each with its own ageing and total, never one mixed sum.
  • Your payment details and payment link, if you have added them, as on your invoices.
  • A plain message when nothing is owed: “No outstanding invoices — this account is fully paid.”

What it does not do, plainly:

  • Open items only. Paid invoices and the dates of individual payments do not appear. It is not a balance-forward statement and not a full activity history.
  • Dated the day you open it. The Statement button produces today's statement.
  • Only as current as your records. Charming takes no payments itself and does not know when a client has paid: you record payments (part payments included) and mark invoices paid. Record them first, or the statement will be out of date.
  • One client at a time, downloaded as a PDF. Charming does not email the statement for you; you attach it yourself.
  • The free plan's footer. Free statements carry a small “Sent with Charming Invoices” line, the same as free invoices. Paid plans, from $29 once, hide it by default.

If that suits how you bill, create a free invoice; once a client has issued invoices, their statement is one click away. Matching a payment that covered several invoices is covered in invoice reconciliation, and what changes once an invoice is fully settled is in what a paid invoice is.

When to send an invoice statement#

A statement earns its place in a few situations:

  1. The client has two or more open invoices. One page beats several forwarded PDFs, and it stops the newest invoice being paid while the oldest sits.
  2. Part payments have muddied the picture. The statement shows exactly what was credited where.
  3. A payment arrived that you cannot match. Send the statement and ask which invoices it covers.
  4. You bill the same client every month. A statement on a fixed day each month makes the account routine. A dental lab billing a practice for each case is one example; our dental invoice template shows a lab case invoice.
  5. Before you chase. Sending a statement first gives the client a chance to say “we paid that” before a reminder lands.

When one invoice is a few days late, the invoice itself with a short note is enough. For the wording of a chaser, see overdue invoice follow-up emails, and if you are unsure which word fits which invoice, outstanding vs overdue vs unpaid sorts that out. Charming does not send payment reminders, so the statement and your own follow-up emails do that job between them.

A sample email to carry the statement:

Hi Dana,

Attached is a statement of your account as of 30 October. It lists four open invoices, $4,830.00 in total, of which $2,200.00 is not due until 4 November. The oldest is the $950.00 left on INV-0031, which was due on 5 August.

If anything does not match your records, tell me and I will check it against mine. Payment details are at the bottom of the statement.

Thanks, Sam

In practice, a statement is a summary of your own records rather than a new invoice, so what goes on it is mostly a matter of what helps the client. That is general information, not legal or tax advice; if you are unsure whether any tax rules apply to your statements, ask your accountant.

If you design your own statement, the same rules that make an invoice readable apply: the total due and the oldest balance should be the first things the reader sees. Invoice design principles covers hierarchy, type and colour in detail.

Invoice statement questions#

What is an invoice statement template?#

A reusable layout for a statement of account: your details, the client's, a statement date, a table of open invoices (number, dates, amount, paid, balance, days overdue), an ageing summary, a total due and payment details. In a spreadsheet, formulas work out the balances, days overdue and ageing for you.

What is the difference between an invoice and a statement?#

An invoice asks for payment for one piece of work and has its own number. A statement lists several invoices on one dated page so both sides can agree on what is still owed. A statement does not create a new amount owed. One invoice that bills several jobs not yet invoiced is a different document, a consolidated invoice.

Should paid invoices appear on a statement?#

Not on an open-item statement, which lists only what is unpaid. On a balance-forward statement, payments appear as activity in the period, so a paid invoice shows up as its invoice and its payment.

How often should I send a statement?#

Monthly works well for clients with several open invoices, often on the same day each month. Otherwise, send one when a client has two or more open invoices, after a part payment, or before chasing an overdue balance.

Is there a free invoice statement template in Word or Excel?#

In Excel, yes: our free statement of account template has the balance, days overdue and ageing formulas already in place, with a filled-in example. There is no Word version. The Excel steps above build the same kind of statement yourself in a few minutes, and a Word table works if you add up the balances by hand.

Can a statement have a statement number?#

It can, but it does not need one. A statement is identified by its date and the client's name. The invoices on it are what carry numbers.

Free downloads

No sign-up and no email address. More on the free templates page.