Invoice Aging Report: Who to Chase Today and Who to Wait On
The invoice you have been meaning to chase
You have 14 open invoices and no clear idea which one matters most this morning. The oldest is not always the biggest risk, and the biggest is not always the most urgent. An invoice aging report fixes the order: it sorts what you are owed into buckets by how long it has been unpaid, so a list of 14 numbers becomes a to-do list. Freelancers skip it because it sounds like accounting. It is usually a 20-row spreadsheet and ten minutes of work.
Build an invoice aging report in ten minutes
Start with one row per invoice: invoice number, client, amount, issue date, due date, amount paid, and open balance. Two formulas do the rest. Days past due equals the as-of date minus the due date. A paid invoice drops out. A partial payment leaves the remaining balance in the bucket it belongs to.
The five buckets
| Bucket | Days past due | Example money in bucket |
|---|---|---|
| Current | Not due yet | $9,200 |
| 1–30 | 1 to 30 | $7,800 |
| 31–60 | 31 to 60 | $5,400 |
| 61–90 | 61 to 90 | $3,150 |
| 90+ | More than 90 | $1,900 |
Here is an illustrative month: 14 open invoices totaling $27,450, split Current $9,200 (33.5% of receivables), 1–30 $7,800 (28.4%), 31–60 $5,400 (19.7%), 61–90 $3,150 (11.5%), and 90+ $1,900 (6.9%).
Refresh the as-of date, not the formulas
Put the as-of date in one cell and reference it everywhere. On the first of the month you change one cell instead of retyping dates, and the report stays comparable from month to month.
Keep it to one page
Aging reports go stale when they get complicated. Skip the chart and the client drill-down, and keep the five bucket totals at the top. The report is a sorting tool, not a management dashboard. If it takes more than a minute to read, you will stop reading it, and an unread report is worse than no report because it looks like a system.
Reading the report: who to chase today
Two questions decide the order: how much money is in the bucket, and how likely is this client to pay without friction.
Age matters because recovery odds fall as invoices age. A rough rule of thumb many freelancers work from: invoices under 30 days usually clear with a reminder, 31–60 needs a phone call, 61–90 needs an escalation and a pause on new work, and past 90 days the invoice is a collection decision rather than a billing one. These cutoffs are experience, not law.
| Age | Usual next step | What to expect |
|---|---|---|
| Under 30 days | Reminder email | Most invoices clear without a call |
| 31–60 days | Phone call with a date | A partial payment or a promise |
| 61–90 days | Escalation and a pause | Needs a decision, not a reminder |
| 90+ days | Payment plan or write-off | Recovery becomes uncertain |
No table of recovery percentages is reliable at this size of business. The pattern above comes from how freelancer collections usually go, not from research.
For a simple priority score, multiply open balance by days past due, sort descending, and work top-down. In the example above, a $3,150 invoice at 75 days scores 236,250, while the $1,900 invoice at 130 days scores 247,000. The older, smaller invoice outranks the newer, larger one.
What to do in each bucket
- Current: confirm the invoice arrived and the client has it in this week's payment run.
- 1–30: send a short reminder with the invoice attached, no apology.
- 31–60: call accounts payable and get a payment date in writing.
- 61–90: escalate to your main contact, state the consequence, pause work.
- 90+: decide whether this is a payment plan, a final demand, or a write-off.
What the report exposes in your terms
An aging report is also a review of how you invoice. If almost every invoice lands in 1–30 and none in Current, your issue-to-due window is shorter than your clients' payment cycle, so every invoice starts late. If the 90+ bucket holds the same client year after year, the problem is the relationship rather than the invoice.
Three patterns are worth naming:
- Everything sits in 1–30. Your terms do not fit how clients run payments. Move to net-30 or expect the shift.
- One client in 61–90 every quarter. It is a cash flow problem on their side, and it will repeat. Ask for a deposit or milestone billing.
- A pile in Current that never ages. Those are the invoices nobody chased because they were not late yet. Confirm receipt the day you send them.
The report does not fix any of those. It only makes them visible on a Monday morning instead of in a bad month three quarters later.
The report is also your early warning system
Aging data changes how you quote and who you work with. If one client sits in 61–90 every quarter, their terms or their cash flow are the issue, and that shows up as a slow-paying relationship in client profitability. If the combined total of 61–90 and 90+ grows two months in a row, your freelance runway is shrinking even while the invoice total looks healthy.
The report also gives you a number to quote in a difficult email. "Your invoice is 47 days past due" is harder to argue with than "I haven't been paid."
Keep the monthly bucket totals where you can see them side by side. A 61–90 bucket that was $2,100 in March and $5,400 in June is a trend, and a trend is a conversation you can have before it becomes a cash problem. One bad month is noise; three months in the same direction is a decision point.
Do this today
- List every open invoice with amount, due date, and amount paid, one row each.
- Total the five buckets so you see dollars per bucket, not just a count.
- Sort by open balance times days past due and make the first call on the top line.
Free tool: invoice aging calculator — no signup.