Most business owners check their bank balance regularly. Most check their profit and loss at least monthly. Almost none look at their accounts receivable aging report with the same discipline, despite the fact that it is the single most direct window into when the money your business has already earned will actually arrive in your account. The AR aging report does not tell you how profitable you are. It tells you when you will have cash. For day-to-day business management, that is often the more useful number.
What an AR Aging Report Actually Shows
An AR aging report is a snapshot of every outstanding invoice your business has issued, grouped by how long each invoice has been unpaid. Most accounting platforms (QuickBooks, Xero, and others) generate this automatically. The buckets are typically: current (0-30 days), 31-60 days, 61-90 days, and 90+ days.
What the report tells you, at a glance, is this: of the revenue you have already invoiced and recognized, how much is expected soon, how much is running late, and how much is at risk of not arriving at all. That is a fundamentally different view from your P&L, which shows all of that revenue as if it has already been received.
| AR Bucket | What It Means for Cash | Collection Probability | What to Do |
|---|---|---|---|
| Current (0-30 days) | Will arrive within normal payment cycle | 95%+ | Monitor; send reminders at day 25 |
| 31-60 days overdue | Delayed; collections follow-up needed | 85-90% | Call or email immediately; confirm payment date |
| 61-90 days overdue | At risk; cash timing now unreliable | 70-80% | Escalate contact; consider payment plan or partial |
| 90+ days overdue | High risk of non-collection | 50% or below | Formal collections process or write-off decision |
The collection probability figures above are estimates. Your actual rates depend on your industry and client base. But the directional reality is consistent: money sitting in the 90+ day bucket is not the same asset as money in the current bucket, even if your balance sheet treats them identically.
The Gap Between Invoiced Revenue and Actual Cash
Here is a scenario that plays out in profitable businesses regularly. A business invoices $400,000 in a given month. The P&L looks strong. But the AR aging report shows: $120,000 current, $80,000 in the 31-60 bucket, $90,000 in 61-90, and $110,000 over 90 days. Of that $400,000 in “revenue,” only $120,000 is reliably arriving on schedule. The rest is delayed, at risk, or potentially uncollectable.
That gap between what is invoiced and what is arriving is what drives cash flow problems in profitable businesses. The owners who see it coming have one advantage: they are reading their AR aging report weekly, not monthly, and they are acting on it while there is still time to accelerate collections before a payment gap hits. Understanding why profitable businesses still run out of cash starts here.
How to Use Your AR Aging Report for Cash Planning
Reading the report is only half of it. The practical use is translating what you see into a cash forecast for the next 30 to 60 days.
- Pull the report weekly, not monthly. AR aging that you check once a month gives you 30-day-old information. By the time you act, the situation has changed. A weekly check takes five minutes and keeps your view current.
- Apply a collection probability to each bucket. Take your total in each aging bucket and apply a realistic collection rate. If you have $80,000 in the 61-90 day bucket and historically collect 75% of that, your realistic cash expectation is $60,000, not $80,000. Build your cash forecast on the realistic number.
- Identify concentration risk. If one client represents 40% of your outstanding AR and they are in the 60+ day bucket, that is not just a collections problem. That is a liquidity risk. Businesses with high client concentration in their AR need to factor that into their cash flow forecasting explicitly.
- Set a follow-up trigger. Every invoice that crosses 25 days without payment should trigger an automatic follow-up. At 35 days, a second follow-up. At 45 days, a phone call. Most late payments are not intentional. Clients simply pay whoever follows up. Systems beat hope.
- Watch the trend, not just the snapshot. A single AR aging report tells you where things stand today. Comparing last month’s report to this month’s tells you whether your collection efficiency is improving or deteriorating. DSO trending up is a leading indicator of cash stress. Catching it at 42 days versus 60 days gives you weeks of additional response time.
Take your current AR aging report. Apply these rough collection rates to each bucket: Current = 97%, 31-60 days = 88%, 61-90 days = 75%, 90+ days = 45%. Multiply each bucket’s balance by its collection rate. Add the results. That total is your realistic cash expectation from receivables, not the face value your balance sheet shows. The difference between the two numbers is your collection risk. Know this number before making any hiring, spending, or growth decisions.
The AR aging report is not a finance team tool. It is a founder tool. It answers the most practical question in business: not “how profitable are we?” but “when is the money coming?” For any business that invoices clients rather than collecting payment at the point of sale, it belongs in the same weekly review as the bank balance. Businesses that track their cash flow health systematically almost always start here.
See Your AR Aging Translated Into a Cash Forecast
Finoya connects directly to your QuickBooks or Xero account and translates your real receivables data into a forward cash view. Instead of reading the aging report and doing the math manually, you see the forecast automatically updated as your data changes.
Create your free Finoya account and see what your receivables actually mean for your cash position over the next 60 days.