BYTETOOLS

Statement of Account Generator

Build a customer statement PDF from a list of invoices, with open balances aged into 0-30, 31-60, 61-90 and 90+ buckets and a clear total due.

Invoices
£0.00
£1,960.00
£3,360.00
£1,320.00
£940.00
£11,560.00
Total invoiced
£3,980.00
Total received
£7,580.00
Total due
£0.00
Overdue
InvoiceDateDueAmountPaidBalanceDays past dueBucket
INV-2025-030114 Jan 202513 Feb 2025£2,480.00£2,480.00£0.00—no date
INV-2025-036228 Feb 202530 Mar 2025£1,960.00£0.00£1,960.00—no date
INV-2025-04172 Apr 20252 May 2025£4,860.00£1,500.00£3,360.00—no date
INV-2025-046819 May 202518 Jun 2025£1,320.00£0.00£1,320.00—no date
INV-2025-050124 Jun 202524 Jul 2025£940.00£0.00£940.00—no date
Ageing summaryNot due £0.00£0.00£0.00£0.00£0.00£7,580.00
 not yet due0–3031–6061–9090+total due

4 invoices have no usable due date, so they are counted in the total due but left out of the ageing buckets. Fill the date in to age them.

STM-2025-06 as at —: 5 invoices totalling £11,560.00, £3,980.00 received, £7,580.00 outstanding.

Everything is calculated and rendered in your browser with pdf-lib — the ledger you paste is never uploaded. Ageing bands are inclusive of their upper bound (0–30 means up to and including 30 days), and the basis is yours to choose: many suppliers age from the due date, while credit-control teams often age from the invoice date. Statutory interest on late payment varies by jurisdiction and contract, so the terms block is free text rather than a built-in rate.

What is the Statement of Account Generator?

A statement of account is the letter that gets invoices paid. It shows a customer everything outstanding on their account in one place, aged into the familiar 0-30, 31-60, 61-90 and 90+ buckets so the conversation moves from which invoice to when can you pay.

  • Open balance per invoice from amount less amount paid
  • Ageing into 0-30, 31-60, 61-90 and 90+ buckets, plus a not-yet-due column
  • Choose whether to age from the due date or the invoice date
  • Paste importer that reads CSV or tab-separated rows and detects a header
  • Total invoiced, total received, total due and oldest open balance
  • A4 or US Letter PDF with configurable terms and remittance details

How to use the Statement of Account Generator

  1. 1

    Enter your business details and the customer's name, address and account reference.

  2. 2

    Set the statement number, the statement date every age is measured from, and whether to age by due date or invoice date.

  3. 3

    Fill the invoice table, or paste five columns into the box below it and click Replace the table with the pasted rows.

  4. 4

    Edit the payment terms and remittance details that print at the foot of the statement.

  5. 5

    Check the ageing summary, then click Download statement PDF.

About the Statement of Account Generator

A statement of account is the letter that gets invoices paid. It shows a customer everything outstanding on their account in one place, aged into the familiar 0-30, 31-60, 61-90 and 90+ buckets so the conversation moves from which invoice to when can you pay. This tool turns a list of invoices into that document as a PDF.

Type invoices into the table or paste them straight out of a spreadsheet — number, invoice date, due date, amount and amount paid. Each open balance is worked out and aged from the statement date, either by days past the due date or days since the invoice date, whichever convention your credit control team uses. The ageing summary row and total due come out automatically.

All of the arithmetic and the PDF generation happen in your browser. The ledger you paste is never uploaded, which matters because it is exactly the kind of data you do not want sitting on someone else's server. Statutory interest on late payment varies by country and by contract, so the terms block is free text rather than a built-in rate.

Frequently asked questions

What is a statement of account?

It is a summary of everything a customer currently owes you, listing each open invoice with its date, amount and balance. Unlike an invoice it is not a demand for payment on any single item — it is a reconciliation document, which is why most businesses send one at the end of every month.

How does accounts receivable ageing work?

Each open balance is placed in a bucket according to how old it is on the statement date. Here 0-30 means up to and including 30 days, 31-60 the next month, and so on, with anything past 90 days grouped together. The buckets show at a glance where your collection problem actually is.

Should invoices be aged from the invoice date or the due date?

Both conventions are in common use, so this tool lets you pick. Ageing from the due date tells you how overdue something is and is what most credit-control teams want; ageing from the invoice date tells you how long the money has been outstanding in total and is more common in cash-flow reporting.

What format should I paste invoices in?

Five columns in this order: invoice number, invoice date, due date, amount, amount paid. Commas, semicolons or tabs all work, quoted fields are handled properly, and a header row is detected and skipped automatically. Dates can be yyyy-mm-dd or day/month/year.

What happens to invoices with no due date?

They still count toward the total due but are left out of the ageing buckets, and the tool tells you how many are in that state. Without a date there is no honest way to age a balance, so it shows a dash rather than guessing.

Related tools