You sent the invoices. Some got paid, some didn't, and a few have slipped so far past due that you've half stopped expecting the money. If you can't answer "who owes me what, and for how long?" in under a minute, you don't have a collections problem yet. You have a visibility problem, and the collections problem is coming.
The accounts receivable aging report (also called an invoice aging report or aging schedule) fixes exactly that. It fits on a single page, and you can build it yourself with nothing fancier than a table.
The quick version
An accounts receivable (AR) aging report lists every unpaid invoice and groups it by how overdue it is. The common convention is four buckets: 0-30 days, 31-60 days, 61-90 days, and 90+ days past due. Money in the left buckets is fresh and likely to arrive; money drifting right is increasingly at risk. Reading the report tells you three things at a glance: how much you're owed in total, which clients are slipping, and where to spend your collection effort this week. You don't need accounting software to make one. A simple table with client, invoice number, amount, due date, and days overdue does the job.
What an aging report actually shows
The aging report takes every open invoice you've issued, sorts it into age bands, and subtotals each band, usually per client and for the business overall. Two details matter before you build one:
- Age from the due date, not the invoice date. Some reports count days from when the invoice was issued, which makes a net-30 invoice look "30 days old" the moment it comes due. Counting from the due date is cleaner: day zero is the day payment became late. Pick one method and stay consistent, and if you share the report with anyone, say which method you used.
- Only open invoices belong on it. Paid invoices drop off. Partially paid invoices stay on at the remaining balance, and credited invoices show the reduced amount.
Why bother? Because unpaid invoices are the norm, not the exception. According to the Intuit QuickBooks 2025 US Small Business Late Payments Report, 56% of US small businesses are owed money from unpaid invoices, averaging about $17,500, and 47% report invoices already more than 30 days past due. An aging report is how you make sure your share of that money doesn't age its way into a write-off.
The four buckets and what each one signals
The bucket structure is the whole point of the report. Each band carries a different message about collectability and calls for a different response.
| Bucket | What it usually means | What to do |
|---|---|---|
| 0-30 days past due | Normal friction: invoices in an approval queue, a missed email, a client who pays everything at month end | Light touch: a polite reminder around day 7 is plenty |
| 31-60 days | Something slipped: a lost invoice, the wrong accounts payable contact, a client quietly managing their own cash crunch | Personal nudge: direct email or a call, re-attach the invoice, ask if anything is blocking payment |
| 61-90 days | A pattern, not an accident. Silence at this age is a decision the client is making | Escalate: firm written notice, reference late fees if your terms allow them, consider pausing new work |
| 90+ days | Seriously at risk. The longer an invoice sits here, the lower the odds it gets paid in full | Final notice, then choose: payment plan, demand letter, small claims, collections, or write-off |
A few reading notes. The 0-30 bucket is not a problem bucket; most clients on net-30 terms drift a few days late without bad intent. The 31-60 bucket is where good process pays off, because most invoices here are stuck for boring administrative reasons and one well-aimed email shakes them loose. The 61-90 bucket is where you stop assuming good faith and start protecting yourself. The 90+ bucket is a decision zone: keep chasing, negotiate, or cut your losses, but don't let invoices sit there untouched.
Build a simple aging view from your invoice list
You do not need software for this. A spreadsheet, or honestly a sheet of paper, works fine for a small client list. Four steps:
- List every open invoice: client, invoice number, amount outstanding, due date.
- Calculate days overdue: today's date minus the due date.
- Assign each invoice a bucket based on days overdue.
- Subtotal by bucket, and by client if anyone has more than one open invoice.
Here's what that looks like for a small design studio running the report on July 9:
| Client | Invoice # | Amount | Due date | Days overdue | Bucket |
|---|---|---|---|---|---|
| Meridian Design Co. | 2026-031 | $2,400 | Jun 24 | 15 | 0-30 |
| Harbor Fitness | 2026-027 | $850 | Jun 2 | 37 | 31-60 |
| Harbor Fitness | 2026-033 | $1,150 | Jun 30 | 9 | 0-30 |
| TLC Property Group | 2026-018 | $3,600 | Apr 28 | 72 | 61-90 |
| Brightside Café | 2026-009 | $675 | Mar 12 | 119 | 90+ |
Bucket totals: $3,550 in 0-30, $850 in 31-60, $3,600 in 61-90, $675 in 90+. Total outstanding: $8,675.
Now the report starts talking. Roughly half of everything this studio is owed sits past 60 days, a warning sign no single invoice would have shown. TLC Property Group is the clear priority: the largest balance, deep in the escalation zone. Brightside Café's $675 is four months old, so it's time for a real decision rather than a fifth gentle reminder. And Harbor Fitness now has two open invoices, which changes how you should communicate with them (more on that below).
One prerequisite: this only works if your invoices have consistent numbers and due dates you can look up. If your numbering is improvised, fix that first; our guide on how to number invoices covers a simple scheme that makes reports like this painless.
The Monday-morning routine
An aging report you build once and never look at again is just a souvenir. Its value comes from a short, repeatable routine. Fifteen minutes every Monday is enough for most freelancers and small businesses:
- Refresh the table. Remove paid invoices, update days overdue, re-bucket anything that crossed a line over the weekend.
- 0-30 bucket: send a friendly reminder to anything about a week past due. Short, polite, invoice attached.
- 31-60 bucket: these get a personal touch, not a template blast. Email the actual human, re-attach the invoice, and ask directly whether anything is missing on their end. If you want proven wording for each stage, use our past-due invoice reminder templates.
- 61-90 bucket: escalate in writing. State the amount, the original due date, any late fee your terms allow, and a specific deadline. Decide whether new work for this client pauses until the balance clears.
- 90+ bucket: make a decision per invoice: offer a payment plan, send a final demand, file in small claims, hand it to collections, or write it off and fire the client. Our guide on what to do when a client won't pay walks through those options in order of escalation.
The discipline matters more than the format. A client who gets a reminder every time an invoice ages past a threshold learns that your invoices don't slide. A client who hears from you sporadically learns the opposite.
Clients with multiple open invoices: send a statement
Look back at Harbor Fitness: two open invoices, in two different buckets. Chasing each one separately creates exactly the confusion that lets balances hide. The client pays the newer one, everyone feels resolved, and the older $850 keeps aging quietly.
The fix is a statement of account: one document listing all open invoices, payments received, and the total balance owed. It reframes the conversation from "please pay invoice 2026-027" to "your account balance is $2,000, and here is how it breaks down." Many statements include a miniature aging summary along the bottom, which is your aging report doing double duty as a collection tool. If you're not sure how statements and invoices fit together, our billing statement vs. invoice guide covers when to send each.
Clean source documents make all of this easier. If your invoices are consistent, numbered, and dated properly, an aging table almost builds itself. You can create professional invoices with our free invoice generator in about a minute, with instant PDF download and no signup to start, and the Multiple-invoices option generates a numbered series across dates, which keeps a whole month of billing consistent from day one.
Frequently asked questions
What is an accounts receivable aging report?
It's a report that lists all unpaid invoices and groups them by how long they've been outstanding, most commonly into 0-30, 31-60, 61-90, and 90+ day buckets. It shows the total owed to you, per client and overall, and highlights which balances are becoming risky. Businesses use it to prioritize collection efforts and spot slow-paying clients early.
Should aging be calculated from the invoice date or the due date?
Both conventions exist, but counting from the due date is more useful: day zero is the first day payment is actually late, so every bucket measures true lateness. Counting from the invoice date mixes payment terms into the aging and makes a net-30 invoice look old the day it comes due. Whichever you choose, apply it consistently and note it on the report.
How often should I run an aging report?
Weekly is a good rhythm for freelancers and small businesses, and it pairs naturally with a short Monday routine of reminders and escalations. Monthly is the practical minimum, since invoices can slide a full bucket in 30 days. If cash is tight or you have several large balances outstanding, check it more often.
How much in the 90+ bucket is too much?
There's no universal threshold, and any figure someone quotes you is a rule of thumb, not a standard. A healthier way to read it: treat every invoice past 90 days as genuinely at risk, and watch the trend, because a 90+ bucket that grows month over month means your collection process is failing upstream. The goal is a report where almost everything sits in the 0-30 column.