The AR Aging Report: How to Read It in 3 Minutes a Week

TL;DR

• The AR aging report is the single most useful cash management tool every small business already owns and rarely uses.

• Healthy aging: 80%+ of AR in 0–30 days, under 5% in 90+. Above those thresholds, you have a collection problem worth addressing this week.

• The 90+ bucket collects at 60–70 cents on the dollar after effort. Cash dies fast once invoices pass 90 days.

• Read it in three steps: distribution (where the dollars sit), concentration (which customers), and trend (improving or sliding).

• Invoices 45+ days overdue get a phone call, not an email. This single rule recovers more cash than any other.

Every accounting system in the country produces the same report and almost no small business owner reads it well: the accounts receivable aging report.

It’s the cleanest summary of cash that hasn’t arrived yet. It tells you which customers owe you money, how long they’ve owed it, and — implicitly — how likely you are to actually collect. For most B2B businesses, 15 minutes a week with this report is one of the highest-return cash management activities available. Some meaningful portion of cash stress is often revenue that has already been earned but not yet collected.

Most owners skip it because nothing in the report demands attention. This piece is how to read it well in three minutes, what to act on, and the small disciplines that turn aging from a passive report into an active cash management tool.

What does the AR aging report show?

The aging report buckets every open (unpaid) customer invoice by how many days it’s been outstanding past the due date. The standard four buckets:

• 0–30 days: Current. Invoices issued and within terms (or just over).
• 31–60 days: Slightly overdue. One billing cycle past terms.
• 61–90 days: Moderately overdue. Real attention warranted.
• 90+ days: Severely overdue. Likely collection problems.

Every accounting system in common use — QuickBooks, Xero, NetSuite, Wave — produces this report natively. In QuickBooks Online, it’s under Reports → Who owes you → Accounts Receivable Aging Detail.

The default view groups by customer and shows each open invoice with its bucket. The summary shows the dollar amount in each bucket as both an absolute number and a percentage of total AR.

How do you read it in three minutes?

The fast read covers three things, in order.

1. The distribution

What percentage of your total AR sits in each bucket? For a healthy B2B business on net-30 terms, the rough benchmarks:

• Current (0–30): 80% or more
• 31–60: 10–15%
• 61–90: under 5%
• 90+: under 2%

These aren’t universal — medical practices billing insurance run much older aging because of carrier processing time, and construction runs older because of progress billing cycles. But within your own industry and historical pattern, the right answer is “stable distribution heavily concentrated in current.”

If 90+ is above 10% of total AR, you have a clear problem. If 60+ combined is above 20%, the problem is structural — not a one-off slow payer, but a collections process issue.

2. The concentration

Where is the overdue exposure concentrated? Usually a small number of customers account for most of the older buckets.

The 80/20 pattern is reliable: about 20% of overdue customers usually represent 80% of overdue dollars. If you have $50K in the 60+ bucket spread across 12 customers, the 2–3 customers with the biggest balances are where you focus.

This is where aging gets actionable. “Improve collections” is abstract. “Call these three specific customers about these specific invoices this week” is operational.

3. The trend

Is the distribution drifting in the wrong direction? Compare to last week and last month.

Healthy: stable distribution with the 0–30 bucket dominating consistently. Problematic: percentage in 31–60 or 61–90 trending up over multiple weeks. Severe: percentage in 90+ growing month-over-month.

The trend tells you whether collection discipline is holding or slipping. A bad month is recoverable; a drifting pattern means the process has broken down and won’t fix itself.

Why is the 90+ bucket where cash dies?

The 90+ bucket deserves separate attention because the math gets ugly fast.

Industry collection studies consistently show that invoice collection probability drops sharply with age:

Days past due

Collection probability

0–30

95%+

31–60

~90%

61–90

~80% (often with some discount)

90–120

65–75%

120+

50–65%

12+ months

Under 25%

The economics of aged AR are worse than the apparent number suggests. A $20K invoice at 30 days is worth roughly $19K in expected cash. The same invoice at 120 days is worth $13–14K — and the cost of collection effort (phone calls, sometimes legal) is higher. Aging compounds twice: the probability of collection drops and the cost of effort rises.

This is why CFOs are paranoid about 60+ aging. By the time it hits 90+, recovery rate is already degraded, and continuing to age it makes the math worse. The right action on a 90+ invoice is rarely “send another email reminder.” It’s a phone call, a settlement offer, or in some cases acceptance of the write-off.

See which receivables are putting pressure on cash. Start a 14-day free trial — Fynso brings AR timing into your cash forecast and brief so you can prioritize follow-up while you stay in control of every customer message.

What does a weekly AR routine look like?

Here’s what a useful weekly AR routine looks like — typically Monday morning, 15–30 minutes.

Open the AR aging summary. Look at the distribution. Compare to last week. Note any meaningful shifts.

Open the AR aging detail. Sort by aging bucket. Focus on 60+ first.

For each invoice in 60+, write down the next action. Most common:

• Call the customer. Right for the largest 60+ invoices and any customer you haven’t talked to in 30+ days about payment.
• Send a tightened reminder. Right for customers with payment history that suggests they always pay eventually. A direct, dated reminder (“invoice will be sent to collections on June 15 if not paid”) is appropriate.
• Offer a settlement. For invoices 90+ with multiple failed payment attempts, sometimes 80% paid now is better than 100% paid never. Don’t make this offer reflexively — but it’s a legitimate tool.
• Send to collections. For invoices 120+ with no engagement, third-party collections recover lower amounts but at least extract something. Most owners delay this too long.
• Write off. For invoices 180+ with no customer engagement and small absolute amounts, write off and move on. The accounting cost is small and the time saved is real.

Schedule the actions for this week. Calls go on the calendar; reminders get drafted and sent.

Glance at the trend. Is 60+ shrinking from last week? Growing? The trend tells you whether the routine is working.

This whole sequence takes 15 minutes once you’ve done it for a few weeks. Owners who run this routine consistently often see overdue AR shrink because follow-up happens before invoices become stale — cash recovery from revenue they already earned.

Why do owners skip this?

The aging report has been available in accounting software for decades. The vast majority of small business owners don’t use it well. Three reasons:

It lives in the wrong place. The report is inside the accounting software, not in the owner’s daily workflow. To see it, you have to log into QuickBooks or Xero, navigate to reports, run the aging. The friction is small individually but enough that the routine never gets built.

It requires interpretation. Looking at a list of invoices and percentages doesn’t tell you what to do. The owner has to apply judgment about which customer gets a call, which gets a reminder, which gets escalated. That cognitive load is what makes daily review feel exhausting even though the actual time required is minimal.

Acting on it is uncomfortable. Calling customers about money is awkward. Most owners would rather hope invoices get paid eventually than initiate the conversation. This is the deepest reason: the work isn’t analytical, it’s interpersonal, and interpersonal friction is what stops the routine.

Which customer patterns warrant the closest watch?

Three patterns produce disproportionate aging risk:

Single large customer concentration. If one customer represents more than 20% of AR, their payment pattern alone can swing your cash position. These customers warrant proactive communication: a check-in call before the invoice is due, not after.

Newly slow customers. A customer who’s been a reliable 30-day payer for two years and suddenly slips to 50 days is usually telling you something about their financial situation, not yours. Catching the pattern early lets you tighten terms (or reduce credit exposure) before they slide further.

Repeat 60+ offenders. Some customers structurally pay slow regardless of terms — they treat your invoices as a line of credit. The right response is to require deposits, card-on-file, or shorter terms. Don’t keep extending net-30 to customers who’ve never paid in 30 days. We covered the framework in How to Collect AR Faster Without Damaging Customer Relationships.

What’s the single rule that captures most of the value?

Every invoice over 45 days past due gets a phone call.

Not an email reminder. Not another automated nudge. A person calling another person.

The phone call is the most effective collection tool ever invented, and it’s free. Most overdue invoices clear within 7–10 days of a real conversation. Most don’t clear within 30 days of an email exchange.

Owners who institute this single rule typically see AR aging shift dramatically within 60 days — not because the customers changed but because the process did.

What we do at Fynso

The 15-minute weekly routine is achievable, but most owners don’t sustain it. Fynso keeps AR pressure visible by bringing receivables, customer payment timing, and cash impact into the operating brief.

The brief helps you see which overdue invoices deserve attention first, how the pattern affects forecasted cash, and where a normally reliable payer has started to slip. Fynso does not contact customers for you; it gives you the context to decide who gets a reminder, who gets a call, and when escalation makes sense.

The work doesn’t disappear. You still make the judgment calls, still have the conversations. But the surface area shrinks from “find, interpret, and decide” to “decide” — which is the difference between a routine that gets built and one that gets dropped.

If your aging has been creeping up while revenue holds steady, the related read is Profitable on Paper, Broke in Practice — growing receivables faster than collections is the most common pattern behind tightening cash on otherwise healthy businesses.

See which receivables are putting pressure on cash. Start a 14-day free trial — Fynso brings AR timing into your cash forecast and brief so you can prioritize follow-up while you stay in control of every customer message.