Klair › SoloSuite › Invoice aging report

What an invoice aging report is (and how to build one)

An aging report groups every unpaid invoice by how far past its due date it is. It is the single most useful page in a freelance practice, because it turns an undifferentiated list of 'money owed' into a ranked list of what to chase first.

Last reviewed 31 October 2026

The short answer. An invoice aging report groups unpaid invoices by how many days they are past their due date, into brackets: current (not yet due), 1–30, 31–60, 61–90, and 90+ days. Each bracket is totalled. The point is not to know how much you are owed — it is to know how much of it is at risk, and which invoice deserves today's phone call.

The brackets, and what each one actually means

Bracket	Definition	What it tells you
Current	Due date has not passed	Not a problem. Money you expect to receive on schedule.
1–30 days	Up to a month past due	Usually administrative — a missed payment run, a wrong contact, a missing PO.
31–60 days	One to two months past due	No longer an oversight. Someone has seen it and not acted.
61–90 days	Two to three months past due	Treat as a dispute until proven otherwise. Find out what is actually blocking it.
90+ days	Three months or more	At real risk. Formal escalation territory.

The calculation

For each unpaid invoice:

days past due = today − due date

Negative or zero → Current. 1 to 30 → 1–30. 31 to 60 → 31–60. 61 to 90 → 61–90. Over 90 → 90+.

Use the due date, not the issue date. This sounds obvious and is the single most common error in a hand-built aging report: an invoice issued 50 days ago on 45-day terms is 5 days overdue, not 50. Getting it wrong inflates every bracket and makes every client look delinquent.

Exclude drafts. An invoice you have not sent is not a receivable, and counting it flatters the total while hiding the fact that you have not billed for the work.

Days Sales Outstanding (DSO)

An aging report tells you about individual invoices. DSO summarises the whole book into one number:

DSO = (accounts receivable ÷ total credit sales in the period) × days in the period

If your terms are net-30 and your DSO is 58, your terms are not being honoured in practice. That is a contracting and follow-up problem, not a bad-luck problem, and the aging report shows you which clients are producing it.

Reading the report

The instinct is to chase the largest invoice. The aging report exists to override that instinct. A ₹20,000 invoice at 95 days is a more urgent problem than a ₹90,000 invoice at 12 days, because the older one is the one at risk of never being paid at all.

Two patterns are worth watching over time:

Weight shifting rightward. If the total in your 60+ columns grows month over month, your follow-up is not working, regardless of how much you are invoicing.
One client across several brackets. The same name in 31–60 and 90+ is not a slow payer. It is a client who pays only when chased, and they should be on advance or milestone terms.

Why 30-day increments

The brackets align with net-30 terms and with monthly reporting, so each column maps to roughly one missed payment cycle. The precise cut-offs matter far less than consistency — the value of the report comes from comparing this month to last month, which only works if the definitions have not moved.

Build the report in a few seconds

SoloSuite sorts your unpaid invoices into these five brackets, totals each one, and drafts the matching follow-up email for anything overdue. Free, no signup, and your invoice data stays in your browser.

Open the aging tracker

Frequently asked questions

What is an invoice aging report?

An invoice aging report, also called an accounts receivable aging report, lists unpaid invoices grouped by how long they have been outstanding past their due date. The standard brackets are current (not yet due), 1-30 days, 31-60 days, 61-90 days and 90 or more days past due. Each bracket is totalled so you can see how much of what you are owed is genuinely at risk rather than simply unpaid.

What are the standard aging buckets?

Current, 1-30, 31-60, 61-90 and 90+ days past due. Thirty-day increments are conventional because they align with common net-30 payment terms and with monthly reporting cycles. Some businesses use 120+ as a final bracket; the exact cut-offs matter less than applying them consistently so that trends are comparable month to month.

Is 'current' the same as 'not overdue'?

Yes. An invoice is current when its due date has not passed. It is unpaid, but it is not late, and it is not a collections problem. Folding current invoices into the 1-30 bucket makes the first column meaningless, because every invoice would enter it the day it is issued.

How do you calculate days past due?

Days past due equals today's date minus the invoice due date. Use the due date rather than the issue date: an invoice issued 50 days ago on 45-day terms is 5 days past due, not 50. Getting this wrong systematically overstates your aging and makes every client look like a late payer.

What is DSO and how is it calculated?

Days Sales Outstanding measures the average time taken to collect payment. The formula is: DSO = (accounts receivable / total credit sales for the period) x number of days in the period. A DSO meaningfully higher than your stated payment terms means your terms are not being honoured in practice, regardless of what your contracts say.

Why does invoice age matter so much?

Because the practical difficulty of collecting rises with age. A recently due invoice usually needs a reminder; an invoice several months old often involves a changed contact, a disputed scope, or a client with its own cash problem. Age is also evidence: a documented trail of dated reminders is what a facilitation council or court will want to see.

SoloSuite aging tracker — builds this report from your invoices automatically
Payment reminder templates — what to send for each bracket
Freelance cash runway — what unpaid invoices do to your runway
GST Invoice Generator — issue invoices with clear due dates