Accounts Receivable Aging Report: How to Read, Use, and Act on It
Your AR aging report tells you exactly which invoices are at risk of going uncollected. Learn how to read it, spot danger zones, and take action before money slips away.
Most small business owners open their accounts receivable aging report, feel a wave of dread, and close it again. That response is understandable — but it's costing you money.
The AR aging report is the single most actionable document in your business. It doesn't just show you who owes what. It tells you which invoices are slipping toward uncollectible, ranked by urgency, sorted by risk. Used correctly, it is your collections command center.
This guide covers everything: how to read it, what the columns actually mean, which numbers to act on first, and how to turn a passive report into an active cash flow tool.
What Is an Accounts Receivable Aging Report?
An accounts receivable aging report (also called an AR aging schedule) is a categorized snapshot of all unpaid invoices, grouped by how long they've been outstanding. Each invoice is sorted into time "buckets":
| Bucket | What It Means |
|---|---|
| Current (0–30 days) | Not yet overdue or just past due — normal |
| 31–60 days | Mildly overdue — send a second reminder |
| 61–90 days | Significantly overdue — escalate immediately |
| 91–120 days | Serious risk of non-payment |
| 120+ days | High likelihood of uncollectible |
Every accounting platform — QuickBooks, Xero, FreshBooks — generates this report automatically. The problem isn't accessing it. The problem is knowing what to do with it.
Why the Aging Report Matters More Than Total AR
Most business owners track total accounts receivable as a single number: "We're owed $47,000." That number is almost meaningless without aging context.
Consider two companies both owed $47,000:
Company A: $44,000 current, $3,000 at 31–60 days
Company B: $12,000 current, $18,000 at 61–90 days, $17,000 at 90+ days
Company A is healthy. Company B has a serious collection problem — nearly 75% of its receivables are significantly overdue.
The aging report is what separates those two pictures.
How to Run the AR Aging Report in QuickBooks
In QuickBooks Online:
- Go to Reports in the left menu
- Search for "Accounts Receivable Aging"
- Run either the Summary (totals by customer) or Detail (line-by-line invoices) version
- Set the Aging Method to Report Date (not Due Date — more on why below)
- Export to CSV if you need to work with the data outside QBO
The Detail version is more useful for collections work. It shows you invoice numbers, amounts, due dates, and days outstanding for each customer — everything you need to prioritize outreach.
The Five Columns You Actually Need to Understand
When you open an AR aging detail report, here's what matters:
Customer Name — Who owes you. Group multiple invoices by customer to see total exposure per relationship.
Invoice Date vs. Due Date — These are different. Aging is typically calculated from the due date, not the invoice date. A Net 30 invoice sent on March 1 has a due date of March 31 — it doesn't appear as overdue until April.
Days Outstanding — How many days past the due date. This is the single most important number. An invoice that's 95 days outstanding has a statistically much lower recovery rate than one that's 35 days outstanding.
Amount Due — The unpaid balance. Prioritize large balances in old buckets first.
Bucket — Which aging column it falls into. Watch for invoices that move from one bucket to the next across reports — that's a client with a pattern.
Collection Recovery Rates by Aging Bucket
This is the data most business owners don't know — and it should change how urgently you act:
| Days Outstanding | Average Recovery Rate |
|---|---|
| 0–30 days | ~99% |
| 31–60 days | ~92% |
| 61–90 days | ~75% |
| 91–120 days | ~57% |
| 121–180 days | ~42% |
| 180+ days | ~25% or less |
Every 30 days of inaction roughly cuts your recovery odds in half once you're past 60 days. This is why waiting to "give clients space" is one of the most expensive decisions in small business.
How to Prioritize Collections from Your Aging Report
Not all overdue invoices deserve equal attention. Use this framework when you open your AR aging report:
Tier 1: 60–90 Days, High Balance
These are your highest-leverage accounts. Recovery rates are still reasonable (75%+), the amounts are significant, and a single well-timed phone call or firm email can often unlock payment. Act on these first, every time.
Tier 2: 90+ Days, Any Balance
Recovery is harder but not impossible. These require a different approach — a payment plan offer, a direct phone conversation, or a formal demand letter. Don't write these off without a real attempt.
Tier 3: 31–60 Days, Multiple Invoices
A client with three invoices in the 31–60 day bucket is a different problem than one invoice. This is a pattern, not a mistake. Flag the relationship for a direct conversation about payment terms.
Tier 4: Current, Large Balance
A $40,000 invoice that's still current but due in 7 days deserves a friendly check-in. Not a collection call — just a confirmation that payment is on track.
Red Flags to Look for in Your Aging Report
The same client appearing in multiple buckets — They're not a slow payer. They're a habitual non-payer. Adjust their payment terms or require a deposit on future work.
Invoices that never move — If an invoice has been "stuck" at 90+ days for two months, it's either disputed, lost, or the client is in financial trouble. Escalate.
Growing totals in the 60+ day buckets — If your 60+ day total is increasing month over month, your collection process isn't working fast enough. The follow-up cadence needs to start earlier.
A single client representing 30%+ of your AR — Concentration risk. One bad debt here materially affects your cash flow.
The Difference Between Aging by Invoice Date vs. Due Date
QuickBooks gives you a choice. Most accountants recommend aging by due date because it reflects actual payment obligations. Aging by invoice date makes everything look older than it is, which can trigger unnecessary alarm on Net 60 invoices that aren't actually late.
However, if all your invoices are due on receipt (or Net 15), the distinction is minimal.
How Often Should You Review Your AR Aging Report?
For most small businesses:
- Weekly if you have more than 10 open invoices at any time
- Every two weeks if your AR is smaller and mostly current
- Monthly minimum if you have a very low invoice volume
The biggest mistake is reviewing it only when something feels wrong. By then, invoices have already aged into higher-risk buckets.
Turning the Report into Automated Action
The aging report is a diagnostic tool. The actual collection work — sending reminders, escalating to phone calls, logging responses — is where most business owners lose hours.
The most effective AR teams use their aging data to trigger automated follow-up sequences. A Net 30 invoice hits day 32 → reminder email goes out automatically. Day 45 → second email. Day 60 → SMS. Day 75 → escalation email with payment link.
This kind of systematic follow-up is what separates businesses with 45-day average DSO from those stuck at 90+.
Tools like Dueflo connect directly to your QuickBooks data and execute this sequence automatically — so your AR aging report drives action without manual intervention.
Key Metrics to Track Alongside Your Aging Report
Days Sales Outstanding (DSO) — The average number of days it takes to collect payment after invoicing. Target: under 45 days for most service businesses. Learn how to calculate and reduce DSO.
Collection Effectiveness Index (CEI) — What percentage of collectable AR you actually collected in a given period. Formula: (Beginning AR + Credit Sales − Ending Total AR) ÷ (Beginning AR + Credit Sales − Ending Current AR) × 100. A CEI above 80% is generally healthy.
Bad Debt Ratio — Write-offs as a percentage of total sales. If this is creeping above 1–2%, your collection process needs structural improvement.
The Bottom Line
Your accounts receivable aging report is not a scary document. It's a prioritized action list. Every bucket tells you something different: this invoice needs a nudge, this one needs a conversation, this one needs a lawyer.
The businesses that review it weekly and act on it systematically — especially in the 31–90 day window — are the ones that collect more, write off less, and maintain the cash flow to actually grow.
Want your aging report to drive automatic follow-ups? Dueflo connects to QuickBooks and sends AI-written collection emails and SMS reminders on the right schedule — so you stop watching invoices age and start getting paid.
Comments
No comments yet. Be the first to leave one below.