Accounts Receivable Aging Report: How to Read It and What It Won't Tell You

What Is an Accounts Receivable Aging Report?

An accounts receivable aging report is a financial document that groups unpaid customer invoices by how long they've been outstanding — typically in buckets of 0–30, 31–60, 61–90, and 90+ days. Every B2B credit and finance team uses one. The problem is that most teams treat it as the primary tool for credit risk management, when it's actually a record of what already happened.

What an AR Aging Report Shows

The layout is simple: one row per customer, columns broken into aging buckets, totals at the bottom. A well-maintained aging report tells you which customers owe you money, how long each invoice has been outstanding, your total exposure in each time bucket, and which accounts have broken their payment terms.

The 31–60 day bucket should be a first alert. The 61–90 bucket is a problem. Anything in 90+ is a customer your credit team already lost track of at some point.

How to Read Each Aging Bucket

0–30 days: Routine monitoring. If a customer's balance jumped significantly compared to the prior period, flag it — even if the invoice isn't technically late yet. A sudden increase in current balances can mean a customer is buying more because they can't get credit elsewhere.

31–60 days: Issue a payment reminder and review the account. Check whether this is a first offense or a pattern. If it's the second consecutive period in this bucket, escalate. Most collection teams send a dunning letter here. Most credit teams wait for the account manager to say it's fine. Don't wait.

61–90 days: Send a formal demand letter. Call the account. Put the customer on credit hold if your policy supports it. The window for resolving this without a write-off is closing. At this stage, you should also be pulling their credit file and checking for new liens or changes in trade payment behavior with other suppliers.

90+ days: You're in collections territory. Recovery rates drop sharply after 90 days and fall off a cliff past 120. If you haven't already, pull the customer's financials and ask hard questions about what changed in their business. An invoice this old rarely reflects a customer with a short-term cash flow problem — it reflects a customer in structural trouble.

What the AR Aging Report Won't Tell You

Here's the problem with treating the aging report as a risk management tool: everything in it already happened.

A customer who shows up current in your 0–30 bucket might have filed for Chapter 11 last week. A customer you've extended $200,000 in credit to might have stopped paying three other suppliers in their industry six months ago. None of that shows up in your aging report until the invoice ages past terms.

That gap — between when a customer starts deteriorating and when the deterioration shows up in your report — is where credit losses actually occur.

Envelope 1, a packaging company that filed for bankruptcy in 2023, paid invoices on time for months before the filing. Harvest Sherwood, a food distributor, looked clean in aging reports across its supplier base right up until liquidity collapsed. The signal was in the financials and in trade payment patterns across other creditors — not in anyone's AR aging bucket.

The aging report captures cash flow history. What predicts cash flow is the customer's financial health, their payment behavior with other creditors, and changes in their business — none of which show up in your report until after the invoice ages.

What Actually Catches the Risk Early

Credit teams that run their programs from an AR aging report are reviewing the crime scene after the fact. The risk showed up months earlier.

The data that catches problems before they hit your aging report:

• Business credit bureau data — trade payment behavior with other creditors. If a customer who pays you on time has started paying others late, that's an early signal you're next.
• Financial statements — a deteriorating current ratio, rising leverage, or declining margins months before the invoice ages
• Lien filings — a UCC lien filed against a customer's assets signals creditors are already protecting themselves
• Industry conditions — customers in distressed sectors face headwinds that have nothing to do with their payment history with you specifically

Continuous monitoring that surfaces these signals between your regular credit reviews is what actually prevents the write-offs your aging report eventually documents. The practice of reviewing accounts only when an invoice ages is how credit teams miss the early signals that are almost always there.

For a deeper look at the metrics that matter for monitoring your AR portfolio, see our guide to DSO formula and calculation, the DSO by industry benchmarks, and our overview of B2B credit risk monitoring.

How the AR Aging Report Fits Into a Broader Credit Program

None of this means the aging report isn't useful. It's a necessary operational tool. The 31–60 bucket triggers your dunning process. The 90+ bucket triggers collections escalation. It's the backbone of your cash flow forecast and your bad debt reserve calculation.

The mistake is treating it as a risk management tool rather than an operational one.

A healthy credit program uses the aging report to manage current receivables and uses financial monitoring to manage risk. The aging report tells you what happened. Your credit intelligence layer tells you what's about to happen.

If both functions sit in the same tool or the same weekly report, you're missing the early-warning layer that prevents the accounts your aging report will eventually categorize as uncollectible.

See how Credit Pulse approaches accounts receivable management and AR collections for the full operational picture.

FAQ

What are the typical time buckets in an AR aging report?

Most AR aging reports use 0–30, 31–60, 61–90, and 90+ day buckets. Some organizations add a 91–120 and 120+ split to better track severely delinquent accounts. The buckets should correspond to your payment terms — if you're on net 45, the first late flag appears at 46 days, not 31.

How often should you run an AR aging report?

Weekly is standard for most B2B credit teams. High-volume businesses with shorter collection cycles often run it daily. Frequency matters less than the action protocol — what happens at each threshold determines whether the report drives behavior or just documents it after the fact.

What's the difference between an AR aging report and a DSO calculation?

DSO averages collection time across your entire receivables portfolio. The AR aging report breaks it down customer by customer. DSO tells you how your program is performing overall; the aging report tells you which specific customers are causing the problem. You need both, but they answer different questions.

When should you put a customer on credit hold based on the aging report?

Most credit policies define a threshold — typically an invoice in the 61–90 bucket, or any invoice past 60 days with no response to outreach. The right threshold depends on customer concentration, industry norms, and your margin. The key is that the policy exists and gets enforced consistently, not applied differently based on relationship pressure from sales.

What does a growing 90+ balance mean for your business?

A growing 90+ bucket means write-offs that haven't been recognized yet, collection inefficiency, deteriorating customer quality, or some combination of all three. If it's concentrated in a few accounts, the risk is higher than if it's spread across many small accounts. Either way, the earlier you address it, the higher the recovery rate — and the more likely you are to catch the next one before it reaches 90 days.