AR Aging Report Analysis: 8 Checks a Controller Should Run Every Month
The aging report already shows where cash is stuck. Eight checks a controller or AR manager can run every month to see whether the book is getting healthier, and what to change when it is not.
Sia Ghazvinian
Co-Founder & CEO
Table of contents
Share
To analyze an AR aging report, look past the total and run eight checks: the share of receivables over 60 and 90 days, how each bucket moved since last month, which customers hold the largest past-due balances, how concentrated the book is, how much of the aging is credits and unapplied cash, how much is disputed or deducted, whether the report matches the general ledger, and whether the trend agrees with your DSO. The aging report already tells you where cash is stuck. Most teams only read the first line of it.
The stakes are high because age is the strongest predictor you have. Atradius reports that 43% of credit-based B2B sales in the US are overdue, and that bad debts now affect 5% of long overdue invoices. NACM, citing Commercial Law League of America data, notes that the likelihood of recovering a commercial account falls from 94% at 30 days to 74% at 90 days, and to 27% at one year. A balance that slides one bucket to the right is harder to collect every month it stays there.
This guide is for the controller or AR manager running a collections team of three to five people across hundreds of open invoices in NetSuite, Sage Intacct, Dynamics or QuickBooks Enterprise. It is not about building the weekly call list; it is about reading the whole report once a month and deciding what the numbers say about your process.
What Is AR Aging Report Analysis?
An AR aging report lists every open invoice by customer and sorts the balances into buckets by age, usually current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due. If you need the mechanics of pulling one, our guides cover exporting the aging report from QuickBooks, NetSuite and Business Central.
Analysis is different from collection. Collection asks "who do we contact this week?" Analysis asks "is the book getting healthier or sicker, and why?" The first is a daily job for your collectors. The second is a monthly job for whoever owns the AR number, and it is the one that tends to get skipped when the team is busy.
Summary view versus detail view
Use both. The summary view (one line per customer) shows where the money is concentrated. The detail view (one line per invoice) shows why a balance is old: one large invoice in dispute looks very different from twenty small invoices nobody chased.
Pick one aging basis and keep it
Most systems can age by invoice date or by due date. Aging by due date shows what is actually late; aging by invoice date mixes in terms. Either works for trend analysis as long as you use the same basis, the same bucket sizes and the same cutoff day every month. A change in settings can make a bad month look like a good one.
Which 8 Checks Should You Run on the Aging Report?
The table below is the monthly review in one place. Each check gets its own section after it.
Check | What to look at | Healthy sign | Warning sign |
|---|---|---|---|
1. Past-due mix | Share of total AR over 60 and over 90 days | Stable or shrinking month over month | Over-90 share growing two months in a row |
2. Bucket roll | How last month's 31 to 60 balance moved | Most of it paid or resolved | Most of it rolled into 61 to 90 |
3. Top past-due accounts | The 10 to 20 largest past-due balances | Each has an owner and a next step | Same names, same balances, no notes |
4. Concentration | Share of past-due AR held by the top few customers | Spread across many accounts | One or two customers dominate |
5. Credits and unapplied cash | Negative lines, unapplied payments, open credit memos | Small and recent | Old credits sitting against old invoices |
6. Disputes and deductions | Past-due balance tied to a dispute or short payment | Logged with a reason and a date | Large, old, with no reason code |
7. Ledger tie-out | Aging total versus the AR control account | Matches, or differences explained | Unexplained gap |
8. DSO agreement | Aging trend versus your DSO trend | Both moving the same way | DSO improving while the aging gets older |
Check 1: How Much of Your AR Is Over 60 and Over 90 Days?
Start with the past-due mix: the share of total receivables in each bucket. Calculate the share over 60 days and the share over 90 days, and write both down every month.
The absolute number matters less than the direction. Two months of a growing over-90 share is a signal, even if total AR fell. It usually means the team is collecting the easy current invoices and the hard ones are aging quietly.
Look at the number of accounts, not only the dollars
Count how many customers have anything over 90 days. A rising count with a flat balance often means small accounts are being skipped. Small balances rarely get a call on a busy team, and they add up. Our guide to the most common excuses for late payment covers the reasons behind the long tail.
Check 2: Where Did Last Month's Balances Go?
The bucket roll is the most useful number most teams never calculate. Take last month's 31 to 60 day balance and ask how much of it was paid, how much was credited or written off, and how much rolled into 61 to 90.
If most of it was paid, your follow-up is working at that stage. If most of it rolled forward, invoices are not getting attention between day 30 and day 60, which is exactly when the recovery odds are still high. Repeat the same question for the 61 to 90 bucket.
Roll rates show process gaps
A high roll rate in one bucket points at one step in your process. Heavy roll from 1 to 30 into 31 to 60 often means the first reminder goes out late or to the wrong person. Heavy roll from 61 to 90 into over 90 often means nobody has decided when to escalate an invoice.
Check 3: Which Past-Due Accounts Are the Largest, and Who Owns Them?
Sort the summary view by past-due balance and take the top 10 to 20 customers. For each one, ask three questions:
Who owns this account on the team?
What happened last (call, email, promise to pay, dispute)?
What is the next step, and when?
If the answer to any of them is blank, that is the finding. A large balance with no owner and no next step is the most expensive line on the report. A large balance with a dated promise and a named owner is under control even if it is old.
Check 4: Is Your Past-Due AR Concentrated in a Few Customers?
Add up the past-due balance of your three or five largest customers and divide by total past-due AR. If one or two customers hold most of it, your cash flow depends on a few conversations going well.
Concentration is not a collections problem on its own, but it changes how you work those accounts: earlier contact, a senior relationship owner and a closer look at their credit terms. Our guide to AR concentration risk goes deeper, and assessing customer credit risk covers what to review before you extend more terms to a large customer who is already slow.
Check 5: How Much of the Aging Is Credits and Unapplied Cash?
Look for negative lines: unapplied payments, open credit memos and overpayments. They make the total look smaller than the real past-due balance, and they make individual accounts look worse than they are.
Why this matters for collectors
An account with a $20,000 invoice and an $18,000 unapplied payment looks like a $20,000 problem on the detail view. A collector who calls about it is calling about money the customer already sent. Apply cash before you chase. If old unapplied cash keeps appearing, the fix is usually in cash application, not in collections. The year-end AR cleanup checklist is a good template for clearing it in one pass.
Check 6: How Much Past-Due AR Is Disputed or Short-Paid?
Disputed invoices and deductions age just like everything else, but reminders do not move them. They need someone to fix the underlying issue: a missing PO, a pricing difference, a damaged shipment, a missing proof of delivery.
Tag every disputed or short-paid invoice with a reason and a date, then total them on the aging. If disputes make up a large share of the over-60 balance, your bottleneck is resolution, not follow-up. Our guide to customer deductions and short payments covers how to work them down.
Group the reasons
Sort the disputes by reason. The same reason showing up across many customers is usually a billing or fulfillment problem upstream, and fixing it once removes a whole category of past-due invoices from next month's report.
Check 7: Does the Aging Report Tie to the General Ledger?
The aging total should match the AR control account on the same date. If it does not, find out why before you draw any other conclusion. Common causes are manual journal entries posted straight to AR, timing differences on cash receipts, and invoices sitting in a different entity or currency.
This check is quick and it protects every other check on this list. An aging report that does not tie can make collections look better or worse than it is, and decisions made from it will be off.
Check 8: Does the Aging Trend Agree With Your DSO?
Days sales outstanding and the aging report should tell the same story. If DSO improves while the over-90 share grows, something is off: a strong sales month can lower DSO on paper while old invoices keep aging. Our guide on how to calculate DSO and the 3 numbers that move it explains why, and the DSO benchmarks by industry give you a point of comparison.
Read the two together. DSO tells you how fast you collect on average; the aging tells you where the exceptions are. A team can hold a good DSO and still be carrying a growing pile of old invoices. If you track a broader set of measures, these 9 accounts receivable KPIs fit alongside this review.
How Do You Turn the Analysis Into Action?
Each check should end with a decision, not a note. A simple way to run the monthly review with a team of three to five:
Before the meeting
The AR manager pulls the aging on the same cutoff day as last month, ties it to the ledger and fills in the eight checks. This takes an hour or two once the template exists.
In the meeting
Spend 30 minutes on findings, not on reading the report aloud. For each warning sign, agree on one change: an owner for an account, a dispute to escalate, a cash application backlog to clear, a step in the follow-up cadence to move earlier.
After the meeting
Write the changes down with a name and a date and check them at the next review. The trend line across three or four months is what tells you whether the process changed, not any single report.
Where Does Automation Help With an Aging Report?
Most of the warning signs in the table come from the same root cause: routine follow-up does not happen consistently on every account, so balances roll forward and small invoices go untouched. That is the part of the work automation is good at. Our guide to lowering DSO without hiring covers the wider case.
How Does Abivo Help AR Teams Keep the Aging Report Healthy?
Kate, Abivo's AI collections agent, calls, texts and emails customers about overdue invoices from your accounting system or ERP, logs every promise to pay and hands disputes and sensitive conversations to the right person on your team. Applied to the checks above:
Every past-due account gets contacted on its cadence, so the 31 to 60 bucket gets attention before it rolls forward.
Cadence can differ by account or segment, so large and concentrated accounts can follow their own rhythm.
One invoice can be paused while a dispute is worked, and the rest of the account keeps moving.
One message can cover all open invoices on an account, with details such as job, site, PO or billing period, which cuts down on "send me a copy" delays.
Sensitive accounts can be flagged to a named owner, so your largest past-due customers stay with the person who owns the relationship.
OFS Group, a fire protection company, went from four collectors to one with Abivo, recovered $842,518 in four months and cut DSO by more than 30 days; the full story is in the OFS Group case study. If you are comparing tools for a team your size, see our roundup of collections software for AR teams with 3 or more collectors.
Practical Takeaways for Controllers and AR Managers
Run the review monthly on the same cutoff day, aging basis and bucket sizes.
Track the over-60 and over-90 share and the number of accounts in each, not only dollars.
Calculate the bucket roll from 31 to 60 into 61 to 90; it shows where follow-up breaks down.
Give every top past-due account an owner and a dated next step.
Apply cash and clear old credits before collectors chase.
Tag disputes with a reason and fix repeat causes upstream.
Tie the aging to the ledger before you trust anything else on it.
Read DSO and the aging together, and judge progress on the trend across several months.
Related guides for AR teams: how to structure a collections team of 3 to 5 people, how to prioritize collections accounts each week, how to resolve invoice disputes, how to track promises to pay and how to keep the right AP contact on every account.
Frequently Asked Questions
How do you analyze an accounts receivable aging report?
Compare it with last month's report using the same settings. Check the share of AR over 60 and 90 days, how much of last month's balances rolled into older buckets, who owns the largest past-due accounts, how concentrated the past-due balance is, how much is credits, unapplied cash or disputes, whether the total ties to the ledger, and whether the trend matches your DSO.
What percentage of AR over 90 days is acceptable?
There is no single right number, because it depends on your industry, terms and customer mix. The more useful test is the trend: if the over-90 share grows for two months in a row, find out why. Compare against your own history first and industry DSO benchmarks second.
How often should you review the AR aging report?
Collectors work from it daily or weekly. The controller or AR manager should run a full analysis monthly, on the same cutoff day each time, so changes in the numbers reflect real changes in the book rather than timing.
What is a bucket roll rate in accounts receivable?
It is the share of a bucket's balance that moves into the next older bucket by the following month instead of being paid or resolved. For example, if half of last month's 31 to 60 day balance is now in 61 to 90, the roll rate for that bucket is 50%.
Why does my aging report show negative balances?
Negative lines usually come from unapplied payments, open credit memos or overpayments. Apply them to the right invoices before collectors contact the customer, so nobody chases money that was already paid.
Ready to see how an AI collections agent keeps every past-due account moving? Get started with Abivo.
