Quick summary

• An AR aging report groups outstanding invoices by how many days they’ve been unpaid, typically in buckets of current, 1-30, 31-60, 61-90, and 90+ days past due.
• The report’s value isn’t the total. It’s the shape of the distribution. A rising 61-90 or 90+ bucket, even with a stable total, is an early signal that collections is falling behind.
• The 90+ day bucket deserves the most attention per dollar, since collection probability drops sharply the longer an invoice sits unpaid. Industry data generally puts recovery odds on invoices past 90 days well under 50%, and falling further the longer they age.
• Reviewing the report monthly and doing nothing about it is common and mostly wasted effort. The report should drive a specific action list, not just a status check.

---

Almost every business with B2B customers generates an AR aging report. Far fewer actually use it to change what collections does that week. Here’s the difference between generating the report and using it.

What the buckets mean

The standard AR aging report groups every open invoice into a bucket based on how many days past its due date it currently sits:

• Current: not yet due, or due today.
• 1-30 days past due: mildly late. Often just a slow payer or a minor process delay on the customer’s end.
• 31-60 days past due: meaningfully late. Worth a direct follow-up if one hasn’t happened already.
• 61-90 days past due: seriously late. At this point, something specific is wrong, whether it’s a dispute, a cash flow problem on the customer’s side, or an invoice that fell through the cracks internally.
• 90+ days past due: the highest-risk bucket. Collection probability here drops meaningfully compared to the 61-90 bucket, and continues dropping the longer the invoice ages within it.

Each bucket should show both a total dollar amount and a count of invoices, and ideally break down by customer. The dollar total tells you how much is at risk. The count and customer breakdown tell you where to actually direct effort.

Read the shape, not just the total

The number finance teams tend to fixate on is total AR outstanding. That number matters for cash flow forecasting, but it’s a lagging, aggregate figure that can hide exactly the problem you need to catch early.

Two companies can have the same total AR outstanding with completely different risk profiles. One has $500,000 outstanding, with $450,000 current and $50,000 in the 1-30 bucket, meaning most of it is normal, timely activity. The other has $500,000 outstanding, with $200,000 sitting in the 90+ bucket, meaning a real chunk of that total may never get collected.

The number to watch month over month isn’t the total. It’s the percentage of total AR sitting in the 61-90 and 90+ buckets. If that percentage is rising while the total stays flat, collections is losing ground even though the headline number looks stable, and it will eventually show up as a real cash flow problem once those older invoices get written off or heavily discounted to collect anything at all.

Days Sales Outstanding as the summary metric

DSO (Days Sales Outstanding) converts the aging report into a single number: on average, how many days does it take to collect a sale after it’s made. It’s calculated as (Total AR / Total Credit Sales) × Number of Days in Period.

DSO is useful as a trend line, tracked monthly or quarterly, rather than as a single snapshot. A DSO of 45 days isn’t inherently good or bad; it depends heavily on your stated payment terms. A company with net-30 terms and a DSO of 45 has a real collections gap. A company with net-60 terms and a DSO of 45 is actually collecting ahead of schedule.

Watch the trend, not the level. A DSO that’s climbing quarter over quarter, even slowly, is the aggregate version of the same warning the aging buckets give you: collections is losing ground.

Turning the report into action

The mistake most finance teams make is generating the report, reviewing the total, and moving on. The report only earns its keep if it drives a specific list of actions each time it’s run.

Segment the 31-60 bucket by customer, not by invoice. A customer with three invoices totaling $8,000 all sitting in the 31-60 bucket is a different problem than three unrelated customers with one invoice each. The first case usually means something specific broke down (a contact left, a dispute is unresolved, an approval is stuck), and a single conversation can resolve all three invoices at once.

Treat the 61-90 bucket as requiring a direct, personal follow-up, not an automated reminder. By 60+ days, an automated payment reminder email has almost certainly already been sent and ignored. What’s needed at this point is a phone call or a direct email from an actual person, ideally the account owner or a collections specialist, asking specifically what’s holding up payment.

Flag the 90+ bucket for escalation and, if there’s no dispute, formal collections. For invoices in this bucket without an active dispute, waiting longer rarely improves the outcome. This is the point to involve a manager, offer a payment plan if the customer’s cash flow is genuinely the issue, or engage a collections agency or factoring service if the relationship and the invoice size justify it.

Look for the same customer appearing in the aging buckets repeatedly, across months. A customer who’s chronically 30-45 days late every single cycle isn’t a collections problem so much as a credit terms problem. This is a signal to reconsider their payment terms going forward, whether that means requiring a deposit, shortening terms, or requiring payment before shipment on future orders.

What automation changes

Manually generating and reviewing an aging report monthly is workable at low invoice volume. It becomes a real burden past a few hundred open invoices, and it’s easy for the report to become a static document that nobody actually acts on.

AR automation software (cash application tools, collections platforms, and full AR suites) generates the aging report continuously rather than as a monthly snapshot, and layers automated follow-up on top of it: reminder emails at set intervals for the 1-30 and 31-60 buckets, automatic escalation flags for the 61-90 bucket, and dashboards that make the bucket-by-customer breakdown visible without a manual export and pivot table every time.

The report itself doesn’t change. What changes is the gap between generating it and acting on it, which is usually where the real collections improvement comes from. See our best accounts receivable software roundup for platforms that automate this.

Frequently asked questions

How often should an AR aging report be generated? Monthly is the minimum for most businesses, and weekly is worth it once total AR outstanding is large enough that a month of drift is a meaningful cash flow risk. Software-based AR tools generate it continuously, so the question becomes how often someone actually reviews it and acts on it, not how often it’s technically available.

What’s a healthy percentage of AR in the 90+ bucket? This varies by industry, but under 5% of total AR sitting in the 90+ bucket is generally considered healthy for a B2B business with reasonable credit controls. Above 10% suggests either weak credit vetting on new customers, a collections process that isn’t escalating aggressively enough, or both.

Should invoices in dispute be counted the same as regular past-due invoices? No, and lumping them together distorts the aging report’s usefulness. A disputed invoice sitting at 75 days past due isn’t a collections failure in the same sense as an invoice with no dispute that’s simply gone unpaid. Most AR platforms let you tag disputed invoices separately so they don’t inflate the collections team’s apparent backlog or trigger the same automated escalation as a genuinely overdue account.

Is DSO or the aging report more useful for spotting problems early? They serve different purposes. DSO is a good trend-line metric for board reporting and high-level cash flow forecasting. The aging report, broken down by bucket and customer, is what actually tells collections staff where to spend their time this week. Use DSO to know whether things are getting better or worse overall, and the aging report to know specifically what to do about it.