An accounts receivable aging report groups the money customers owe you by how long it has been outstanding — typically current, 1–30 days past due, 31–60, 61–90, and over 90. Every accounting system produces one. Most owners glance at the total and close it.
That's a mistake, because the report answers three different questions depending on how you read it: who to call this week, which customers are becoming a risk, and whether your cash position is about to get worse.
The three columns that matter most
Current. Invoices not yet due. This is the healthy bucket, but the size matters — if 80% of your receivables are current and the balance is large, your terms may be financing your customers more than you realize.
31–60 days past due. This is the diagnostic bucket. Invoices land here for a reason, and the reason is usually one of three: the customer has a cash problem, there's a dispute nobody escalated, or your invoice never reached the right person. All three are fixable, and all three get harder the longer you wait.
Over 90 days. Collection probability drops sharply past this line. Industry collection data consistently shows recovery rates falling well below 50% once an invoice passes 90 days, and continuing down from there. Anything sitting here is a decision, not a receivable — pursue it, settle it, or write it off, but stop counting it as an asset you expect to collect.
Reading it for collections
Sort by amount within each past-due bucket, not by customer name. Your time is finite and the distribution is almost always lopsided — a handful of invoices usually represent most of the overdue dollars.
Then work the 31–60 bucket before the 61–90 bucket. This is counterintuitive and it's the single most useful habit in receivables management. The older invoice feels more urgent, but the fresher one is far more likely to be collected in full with a single phone call. Chasing the oldest first feels productive and collects less money.
Reading it for customer risk
This is where the report earns its keep, and where most owners never look.
Compare each customer's aging profile to their own history, not to your overall average. A customer who has always paid at 45 days on 30-day terms isn't a problem — that's just their pattern, and you should price for it. A customer who has always paid at 32 days and is now at 58 has changed. Something happened.
Look for these specifically:
- A previously reliable account slipping a full bucket. Movement from current into 31–60 is a stronger signal than a chronically late account getting later — especially if that account is also a large share of your revenue, which is its own risk worth measuring on its own terms.
- Partial payments appearing. A customer who used to pay invoices in full and now pays 60% of each one is managing cash, and you're one of several vendors being managed.
- Aging that grows while orders keep coming. This is the dangerous pattern. Rising receivables plus rising orders from the same account means you are extending increasing unsecured credit to a business that may be in trouble. It looks like growth on your sales report.
Reading it for cash flow
Your aging report is a forecast if you treat it as one. Take each bucket, apply a realistic collection probability based on your own history, and you have a rough expectation of cash arriving over the next 30 to 60 days.
The number worth watching over time is days sales outstanding — total receivables divided by average daily revenue. It tells you how long, on average, your money sits with customers before it reaches you. What matters is not the absolute figure but the trend. DSO climbing over three consecutive months while revenue is flat means your working capital is quietly being consumed, and you'll feel it as a cash squeeze about a quarter after the report first showed it.
Three things people get wrong
Treating the total as the metric. Total AR going up can mean sales are growing or collections are failing. The number alone can't tell you which. The distribution across buckets can.
Ignoring credit balances. Negative lines — overpayments, unapplied credits, deposits — distort the total and often indicate an unresolved dispute or a misapplied payment. They're worth cleaning up before you draw conclusions.
Running it once a quarter. Aging reports are only useful at the frequency at which you can act on them. Weekly is right for most businesses with meaningful receivables. Monthly is a minimum. Quarterly means you find out about problems roughly a quarter after you could have done something.
The habit that actually works
Once a week, pull the report, look at the 31–60 bucket sorted by amount, and make three calls. Not emails — calls. Then once a month, compare each significant customer's current aging to where they were 90 days ago and note anyone who has moved a full bucket in the wrong direction.
That's the whole practice. It takes under an hour a month and it catches most receivables problems while they're still conversations rather than write-offs. If you've already got the habit of reading your P&L monthly, the aging report is the natural second one to add.
When you want the report read for you
Pulling the export is the easy part. Knowing which three accounts actually need a call this week, and which ones just have a normal 45-day pattern, takes more time than most owners have.
Helm's CFO advisor connects directly to QuickBooks, so it can pull your actual aging report, flag which accounts have slipped a bucket since last quarter, and tell you which calls to make first — instead of you sorting through the export yourself. Ask it to walk through your current AR aging, or check whether a specific customer's payment pattern has actually changed.