FREE TOOL

Statement of Account Generator

Abass GassFounder of Incusia · 5 min read

Last reviewed 23 October 2026Checked against four open invoices totaling $11,300, aged from not due through over 60 days

List every unpaid invoice, age it, and download a statement with the total outstanding.

Client name

Invoice 1

Invoice number

Amount ($)

Issue date

Due date

Total outstanding

$0.00

As of 30 Oct 2026

Not due$0.00
1 to 30 days$0.00
31 to 60 days$0.00
Over 60 days$0.00

Add an invoice to fill the statement.

Four open invoices of $1,200, $2,400, $3,100, and $4,600 are $11,300 outstanding, and one payment can clear all four. The buckets say how old each part is. The total is the number to ask for if you want the account settled in one go.

Why a statement is a different document from an invoice

A statement of account is the list of what one client still owes you, gathered onto one page. Each row is an invoice that has not been settled: the number, the day you issued it, the day it was due, the amount, and how many days past that due date it now sits. At the bottom is the total outstanding. Accounts teams ask for this when they have three of your invoices in three different emails and no idea which ones are still open. Freelancers build the same page in a spreadsheet, then paste it into a message, then lose the spreadsheet.

Aging is the useful part. An invoice due next week is not the same problem as an invoice that was due in March. This statement sorts each amount into Not due, 1 to 30 days, 31 to 60 days, or Over 60 days, counted from the due date to today. Not due means the due date is today or still ahead. The day count on a late invoice is shown in red. The 1 to 30 and 31 to 60 totals are amber. Over 60 is red again, because that money has been outstanding long enough to need a different conversation than a polite nudge.

Not due: the due date has not passed
1 to 30 and 31 to 60 days: overdue, shown in amber
Over 60 days: overdue, shown in red

Send a statement when more than one invoice is open, when a month has closed, or when their bookkeeper asks for a balance. One fresh invoice does not need a statement. It needs to be paid. A statement is also the attachment that belongs with a reminder once the chase is about a running balance rather than a single number. Put the total in the first line of the email. Say the PDF matches it. Ask them to pay that total, or to reply with the invoice number they dispute and the reason. A statement with no request is a report. A statement with a request is a collection document.

Keep the original invoices. A statement does not replace them, and a client who wants to check a line will ask for invoice 1042, not for your summary. The statement should use the same numbers, the same currency, and the same client name as those invoices. If a row is wrong, fix it and download the PDF again.

Days overdue start the day after the due date. An invoice due today is not due, even if you wish they had paid this morning. An invoice with no due date sits in Not due, because there is no date to count from. Add the due date if you have it. A statement full of undated rows hides the thing the buckets are for. Issue date is there so they can find the invoice in their own files. It does not drive the aging.

The total outstanding is every amount on the statement, due and overdue together. That is the figure to ask for if you want one payment that clears the account. If they will only pay the overdue slice, the bucket totals tell you what that slice is. Say which figure you are asking for. Asking for "the outstanding" while the page shows four buckets leaves them to choose the smallest one.

A statement is earlier than a demand letter and broader than a single reminder. The reminder is the email about the balance. The letter is what you send when the emails have stopped working. Use the statement as the attachment for both, so the amount in the message is the amount on the page. This PDF is free. It downloads with no account and no email gate. You can email a copy to yourself if you want the file in your inbox. The statement is already on the screen before either button.

Nothing here is stored, and the page does not know whether a payment landed this morning. If they paid invoice 1042 yesterday, take that row off before you send the PDF. A statement that still lists a paid invoice teaches them your records are behind, and they will wait for you to catch up before they pay the rest.

How the buckets change what you ask for

A single total hides the argument. On an $11,300 statement, $1,200 is not due yet, $2,400 is inside the first month, and $4,600 has been open long enough to need a different conversation. If you only say "the balance," they will often pay the newest invoice and leave the old one. Name the bucket you mean.

Statement · Northwind StudioAs of October 24, 2026

4 open

INV-1048 · not due$1,200.00

INV-1042 · 18 days$2,400.00

INV-1033 · 44 days$3,100.00

INV-1019 · 76 days$4,600.00

Total outstanding$11,300.00

Not due $1,200. 1 to 30 days $2,400. 31 to 60 days $3,100. Over 60 days $4,600.

The statement ages every open invoice, so a bookkeeper can see which $11,300 is merely waiting and which of it is late.

Why one payment should settle the page

Four invoices in four emails produce four partial decisions. One link for $11,300 applies the money across the rows. If they dispute a line, they can name the invoice number. They should not have to choose a favorite bill and ignore the rest.

Statement for Northwind Studio: $11,300 outstanding

From Harbor Studio · to ap@northwind.example

One payment

Four invoices are still open. The oldest is 76 days past due.

This link settles all of them. The $11,300 is applied across INV-1048, INV-1042, INV-1033, and INV-1019.

Pay $11,300.00

One link clears the statement. The client does not have to pick which of the four invoices to pay.

Common questions

What is a statement of account?: A statement lists every invoice still open for one client, with the issue date, the due date, how many days each one is overdue, and a total outstanding. It is the document accounts teams expect at month end. It does not replace the invoices. It shows them together so nobody has to hunt through a thread to see what is unpaid.
How do I send a statement of account?: Download the PDF and send it from the same address that sent the invoices. Put the total in the first line of the email, and say it matches the attached statement. Ask them to pay the total, or to name any invoice they dispute. A statement that arrives with no sentence about what you want done sits in a folder.
What do the aging buckets mean?: Not due means the due date is today or still ahead. 1 to 30 days and 31 to 60 days are overdue, shown in amber. Over 60 days is overdue and shown in red, along with the day count on any invoice that is late. The buckets are a way to see which money is merely open and which money has been sitting.
Is a customer statement the same as an invoice?: An invoice asks for one job. A statement lists the invoices that are still unpaid and adds them up. You still need the original invoices. The statement is what you send when there are several, or when their accounts team asks for a balance rather than another copy of invoice 1042.
Do I have to enter an email to download the PDF?: No. The statement is on the page, and the PDF downloads with no account and no email. Sending a copy to yourself is a separate button. The file is not held back until you subscribe.