Accounts Receivable Aging Report: What It Is and How to Use It

It is the first Monday of the month. Your bank balance is lower than you expected, you have three invoices you think are late, and you cannot remember which clients have already been chased twice. You open your inbox, scroll past two months of “did you ever get a chance to look at this?” replies, and try to reconstruct the picture from memory.

There is a one-page report that fixes all of this. It is called the accounts receivable aging report, and it answers the only three questions that matter when something feels off in cash flow: who owes me, how much, and how long has it been late.

This guide walks through the accounts receivable aging report the way an owner-operator actually uses it — what the buckets mean, how to build one in a spreadsheet or invoicing app, how to read the patterns it surfaces, and exactly which collection action to take at each age.

What an Accounts Receivable Aging Report Actually Is

An accounts receivable aging report is a summary of every unpaid invoice you have, sorted by client and grouped by how many days overdue each invoice is. Most reports use five buckets: current (not yet due), 1–30 days late, 31–60 days late, 61–90 days late, and 91+ days late. The report shows the dollar total in each bucket per client and a grand total at the bottom.

That is the whole report. There is no chart, no projection, no formula to memorize. It is a list, sorted by age, with totals in the right places.

What makes it powerful is not the format — it is what the format forces you to see. When every late invoice sits on one page, ranked by how long it has been overdue, you cannot pretend it is fine anymore. The 91+ bucket is the part of your business that is bleeding. The 1–30 bucket is the part fixable with one email today. The aging report makes both visible at the same time.

Why This Report Matters More Than Your P&L

A profit-and-loss statement tells you whether you made money over a period. The aging report tells you whether the money you “made” is actually yours yet.

According to the Federal Reserve’s Small Business Credit Survey, 64% of small businesses experience delayed customer payments. A profitable business with a bloated 60+ aging bucket can run out of cash in a quarter while still showing a healthy P&L.

The aging report answers questions the P&L cannot:

• Which clients are the cash-flow risk? The P&L treats all revenue equally. The aging report shows you which client owes you $14,000 across three invoices, the oldest of which is 78 days late.
• Is collection getting worse or better? Compare this month’s report to last month’s. If the 60+ bucket is growing as a percentage of total receivables, you have a collection problem regardless of what new sales look like.
• Where do you focus today? The aging report gives you a one-call list. Sort by oldest, work top-down, do not stop until the 60+ bucket is empty.
• How much of your “revenue” should you discount as risk? Industry rule of thumb: 5% of receivables 30+ days late tend to never collect; 25% of 90+ days late never collect.

Owners who run the aging report weekly stop being surprised by their bank balance.

How the Aging Buckets Work

Aging is calculated from the invoice due date, not the invoice date. If you sent an invoice on October 1 with net-30 terms, the due date is October 31. On November 5, that invoice is 5 days late and lives in the 1–30 bucket. On December 1, it crosses into the 31–60 bucket.

A few rules to keep the buckets honest:

• Aging is from due date, not invoice date. A net-60 invoice that is 35 days old is not late.
• Disputed invoices stay on the report. Flag them with a note, but do not exclude them.
• Partial payments reduce the bucket balance, not the bucket age.
• Credit memos reduce the receivable when issued, not at month-end.

What a Sample Aging Report Looks Like

Here is what a small landscaping business might see on a typical Monday morning:

This report tells you several things at a glance. Total receivables are $23,250 — but only $7,000 of that is current. The 91+ bucket is $6,950, or 30% of the total — that is dangerous. Two clients (Evergreen and Frontier) account for 100% of the 60+ exposure, so collections energy this week goes there. Dinetti has invoices in three buckets — they pay, just always late, and need a firmer terms conversation.

That is the value of the report. Without it, you remember “Evergreen is late on something.” With it, you know exactly how much, exactly how old, and exactly where to start.

How to Build an Aging Report in a Spreadsheet

If your invoicing software does not generate this report, you can build it in 20 minutes in Excel or Google Sheets.

Step 1: List every unpaid invoice. Create columns for: Client name, Invoice number, Due date, Original amount, Amount paid, Balance. Pull every unpaid invoice in. Include partial payments.

Step 2: Calculate days past due. Add a column with =TODAY()-[Due Date Cell]. Negative means not yet due (current); positive is days late.

Step 3: Bucket each invoice. Add a Bucket column: =IF(days<=0,"Current",IF(days<=30,"1-30",IF(days<=60,"31-60",IF(days<=90,"61-90","91+"))))

Step 4: Build a pivot table. Rows = Client name, Columns = Bucket, Values = Sum of Balance. Add totals row and column. Done.

Step 5: Re-run weekly. Export unpaid invoices from your invoicing tool every Monday. The pivot refreshes automatically. Maintenance takes five minutes.

How to Read an Aging Report — the Patterns to Look For

A row of numbers means nothing without context. These are the patterns that show up in real small businesses and what each one signals.

Pattern 1: One client, multiple buckets. The same client in 1–30, 31–60, and 61–90 pays in a consistent rhythm — just always late. Not a collection emergency, but a payment-terms conversation. Move them to a deposit or net-7.

Pattern 2: 91+ bucket growing month over month. If your 91+ total climbs three months straight, you are not collecting fast enough. Old debt becomes uncollectible debt. Stop new work for any client in that bucket and escalate.

Pattern 3: Concentration risk. If two clients account for 60% of your receivables, a single late payer can sink the month. The aging report exposes this before it becomes a crisis.

Pattern 4: 1–30 bucket bigger than current. Most of your invoices go past due before they get paid. Either your terms are too generous, or your follow-up process is leaky. Tighten one or both.

Read the report Monday morning before you check email. The picture takes 60 seconds and reframes the whole week.

Collection Strategy by Age Bucket

The aging report is only useful if it triggers action.

Current (not yet due). Send a friendly one-line reminder 3–5 days before the due date. “Quick heads-up that Invoice #123 for $1,450 is due Friday.” This single email pulls payment forward in most cases.

1–30 days past due. Days 1–3: friendly first reminder, assume oversight. Days 7–14: second reminder, slightly firmer, restate the due date, attach the invoice. Mention any auto-applied late fees. For copy-paste templates, see the follow-up email for unpaid invoice guide.

If you want to add contractual late fees to these reminders, check the late payment penalty guide first — state law caps the rate on consumer accounts and your contract language controls enforceability.

31–60 days past due. Switch from passive to active. Email is no longer enough — pick up the phone. Keep the script short: “Hi [Name], I’m calling about Invoice #123, which was due [date]. Can we set a payment date?” Send a written follow-up the same day with a specific deadline — “payment must be received by [date 14 days out].” If the client has active work in progress, consider stopping it. Continuing to deliver against a 45-day-late account compounds the loss.

61–90 days past due. Final demand stage. Send a written demand letter — email plus certified mail for amounts over a few thousand dollars — with a firm 14-day deadline. State explicitly what comes after the deadline: collections referral, small claims filing, or write-off. Apply any contractual late fees and interest.

91+ days past due. Three options:

1. Collections agency. Fees typically run 25–50% of the recovered amount. Useful for amounts over $1,000–$2,000 where the client is uncommunicative but solvent.
2. Small claims court. Limits vary by state (usually $5,000–$10,000), filing fees run $30–$200, no lawyer needed. You need a signed contract, sent invoices, and a communication trail.
3. Write it off. If recovery cost exceeds the amount, write it off as bad debt. Accrual-basis businesses can deduct it; cash-basis generally cannot. Check with your accountant — Section 166 of the IRS code governs the rules.

Do not let invoices sit in the 91+ bucket indefinitely. The longer they age, the lower the recovery rate.

How to Use Aging Data to Identify Problem Clients

The aging report is also a client-quality scorecard when read across multiple months. A client appearing in 31–60 every single month is not a one-time slow-payer — they have a payment behavior, and your business is absorbing it.

Watch for three signals over a rolling 3-month view:

• Consistent presence in 31–60 or older. Every invoice running 30+ days late is a pattern, not a one-off. Re-negotiate terms (deposit, net-7, autopay) or exit the relationship.
• Increasing aging trajectory. First month 15 days late; next month 35; next month 55. The trend matters more than any single invoice.
• Excuses that change. Cash-flow-timing explanations are normal. Disputes that materialize on day 75 — after two months of delivered work — are usually a delay tactic.

Keep a quiet list of clients you would not take again. Give priority slots to clean-paying clients. The aging report is the data source for that list.

If a client has earned the “would not take again” tag, the how to fire a client guide walks through the conversation.

Tools That Generate the Report for You

Building in a spreadsheet works. Most owners stop running it once maintenance friction builds. Tools that generate the aging report automatically solve that.

Pronto Invoice surfaces days-past-due on every overdue line in real time. Sort by oldest overdue and you have your collections call list for the morning — on your phone, between jobs, without booting a laptop.

QuickBooks Online generates a full A/R Aging Summary and Aging Detail report with customizable buckets. The most thorough option for businesses already using it for accounting.

Xero has a built-in aging report with bucket customization (default 30/60/90, configurable to 7/14/30 or other splits).

FreshBooks and Wave both include aging views — FreshBooks on paid plans, Wave for free.

If you already use any of these, the report is already there. You just need to look at it weekly. For a deeper take on how aging data feeds bigger-picture decisions, see the cash flow forecasting for small business guide. The aging report is the input; the forecast is the output.

Frequently Asked Questions

What is the difference between accounts receivable and accounts receivable aging?

Accounts receivable is the total amount clients owe you. The accounts receivable aging report breaks that total down by how overdue each invoice is — so you can see not just how much is owed but how risky the receivables are. Aging is a diagnostic slice of A/R.

How often should I run an aging report?

Weekly for active management, monthly for trend tracking. The weekly run gives you your collections call list. The monthly run lets you compare bucket totals over time to spot whether collection is improving or slipping.

What is a healthy aging mix?

For most small service businesses: 70%+ of receivables in current or 1–30 days, less than 10% in 60+. Industries with longer billing cycles (construction, government contracts) run higher percentages in 30–60 as a normal pattern. Compare against your own trend, not industry averages.

Should I include disputed invoices in the report?

Yes, with a note. Disputed invoices are still uncollected revenue, and dropping them hides risk. Flag them with a status note (“disputed — pending resolution”) so you treat them differently in collections, but keep the dollar amount visible.

How does aging differ from days sales outstanding (DSO)?

DSO is a single number — average days to get paid, calculated as (accounts receivable / total credit sales) × days in period. The aging report is the underlying data: which specific invoices are late and by how much. DSO tells you the average; aging tells you the outliers. Use both.

How does aging affect my taxes?

Accrual-basis businesses already counted the invoice as income when issued. If a receivable becomes uncollectible, you can deduct it as bad-debt expense in the year it is written off. Cash-basis businesses do not recognize revenue until paid, so there is generally nothing to deduct. Check with your accountant — the documentation requirements under Section 166 matter.

The accounts receivable aging report is one of the cheapest, fastest pieces of management reporting available to a small business. It takes 60 seconds to read, surfaces the cash-flow risks no other report exposes, and tells you exactly which client to call next.

Build it once, run it every Monday morning, and use what it shows you to make three decisions: who to call today, who to renegotiate terms with this quarter, and who to stop working for entirely. Most owners who start running the report see the 60+ bucket shrink within two months — not because anything dramatic changed, but because attention turned into action.

Late receivables do not fix themselves. They age.