The AR Aging Report: A Complete Guide to Protecting Your Cash Flow

If your business has money on its books that it can't actually spend, you're not alone. According to Dun & Bradstreet's Q3 2025 U.S. Accounts Receivable Industry Report, 15 out of 202 tracked industry segments have more than 10% of their receivables sitting 91+ days past due. That's money you've already earned, already recognized as revenue, and may never actually collect.

The quiet killer here isn't a single bad debt. It's the slow drift of invoices moving from "current" to "overdue" to "hopeless" while nobody's watching the boundary closely enough. The accounts receivable aging report—usually just called an AR aging report—is the single document that lets you see that drift before it drains your bank account.

This guide covers what an AR aging report actually is, how to build one, what healthy benchmarks look like in 2026, and how to turn the report from a passive scoreboard into an active collection system.

What Is an AR Aging Report?

An AR aging report is a list of every outstanding invoice your customers owe you, organized by how long each invoice has been unpaid. Instead of telling you only the total amount customers owe, it tells you the story behind that number: which invoices just went out, which are past due, and which have been sitting uncollected for three months or more.

Think of total accounts receivable as a thermometer—it gives you one reading. The aging report is a vitals chart. It shows which specific invoices are running a fever, who keeps getting sick, and whether your overall cash flow is stable or deteriorating.

A typical aging report includes:

• Customer name and account identifier
• Invoice number, invoice date, and due date
• Original amount and outstanding balance
• Days past due (calculated from the due date)
• Aging bucket the invoice falls into
• Subtotals per bucket and a grand total of AR

The Standard Aging Buckets

Almost every AR aging report uses variations of the same four time windows:

Bucket	Status	Typical Interpretation
Current (0–30 days)	Not yet overdue or within net-30 terms	Healthy baseline — this is where most of your AR should live
31–60 days	Moderately overdue	Friendly reminder territory — still very collectible
61–90 days	Significantly overdue	Phone-call territory — collection risk climbing
90+ days	Severely delinquent	Formal collections or write-off consideration

Some teams split the 90+ column into 91–120 and 120+, especially if they sell on longer terms or work in industries like construction where payment cycles are naturally slower. The principle doesn't change: the older a dollar gets, the less likely you are to collect it.

Why Aging Buckets Matter So Much

Collection probability drops sharply with time. Data from the Commercial Collection Agency Association suggests roughly 70–80% of 90-day-past-due invoices are still collectible, but that falls to 45–55% by six months and as low as 20–30% by a year. Some SaaS-focused analyses show write-off rates jumping from 15–25% at 90 days to 40–60% past 120 days.

In other words, an invoice that's been sitting unpaid for four months isn't just "late"—it's statistically closer to a write-off than a payment.

Healthy AR Aging Benchmarks for 2026

There's no universal target, but several aggregated studies converge on similar numbers for a financially healthy small or mid-sized business:

• 80%+ of total AR should be current (0–30 days)
• Under 12% in the 31–60 day bucket
• Under 5% in the 61–90 day bucket
• Under 3% in the 90+ day bucket

If more than 20–25% of your total receivables are past due, you have a collections problem, not a cash flow coincidence.

Industry Context

DSO (days sales outstanding)—the average number of days it takes to collect an invoice—varies enormously by industry:

• Retail / e-commerce: 5–20 days
• Professional services: 30–60 days
• Manufacturing: 45–60 days
• Construction: 60–90+ days, with 18–25% of receivables commonly 90+ days past due

Atradius data shows that the global average B2B payment term is around 34 days, but real-world collection averages closer to 55 days. Benchmark yourself against your industry, not the economy as a whole.

The Problems an AR Aging Report Uncovers

1. Elevated DSO

When cash is tied up in receivables for longer than it should be, operational flexibility suffers. You might be profitable on paper and still unable to cover payroll. The aging report is the raw material you need to calculate and track DSO month over month.

2. Chronic Late Payers

A single invoice in the 90+ column might be an oversight. The same customer appearing in the 61+ column month after month is a pattern. The aging report makes those patterns visible, so you can have informed conversations about payment terms, retainers, or whether the client relationship is worth continuing.

3. Hidden Revenue Leaks

Small unpaid invoices have a way of vanishing into the background. A $380 invoice from seven months ago feels too small to chase, but 12 of them add up to real money. The aging report forces every outstanding dollar back into view.

4. Concentration Risk

If one customer represents half your AR, their payment behavior basically is your cash flow. Aging reports let you spot this before a single client's late payment becomes a crisis.

How to Create an AR Aging Report

Option 1: Your Accounting Software

Most accounting platforms generate aging reports natively:

• QuickBooks Online: Reports → Who owes you → Accounts receivable aging summary (or detail)
• QuickBooks Desktop: Reports → Customers & Receivables → A/R Aging Detail
• Xero: Business → Invoices → Aged Receivables
• Wave, FreshBooks, Zoho Books: All include built-in aging views

Default buckets are usually 30-day intervals but can typically be customized. Export to Excel or Google Sheets if you want to sort, filter, or add your own analysis layer.

Option 2: Build Your Own

If you're on a custom or plain-text accounting system, the logic is straightforward. For each open invoice:

1. Calculate days_past_due = today - due_date
2. Assign a bucket based on that value
3. Group by customer
4. Sum within buckets

A basic spreadsheet formula works:

=IF(TODAY()-D2<=0, "Current",
 IF(TODAY()-D2<=30, "1-30",
 IF(TODAY()-D2<=60, "31-60",
 IF(TODAY()-D2<=90, "61-90", "90+"))))

Where column D holds the due date.

Required Data Hygiene

Your aging report is only as trustworthy as the data feeding it. Common data problems that break aging reports:

• Payments applied to the wrong invoice
• Credit memos that never got issued
• Manual invoice entries with incorrect due dates
• Unreconciled deposits showing customers as unpaid when they've actually paid

Before relying on an aging report for collections, verify a few random entries against your bank feed and payment processor. Chasing a client for an invoice they paid three weeks ago is the fastest way to damage a relationship.

Turning the Report Into a Collection System

Generating the report is 10% of the value. The other 90% is what you do with it.

Run It on a Schedule

Monthly is the minimum. Weekly is better. Teams that review aging biweekly catch problems while they're still 30 days old—friendly reminder territory—rather than 90 days old, when collection gets hostile.

Segment Your Follow-Up by Bucket

Different aging buckets warrant different collection tactics:

• 1–30 days past due: Automated email reminder. No escalation needed—most customers pay on the first nudge.
• 31–60 days: Personal email from the account owner. Reference the invoice specifically and confirm a payment date.
• 61–90 days: Phone call. Ask directly when the invoice will be paid and document the commitment.
• 90+ days: Formal demand letter, account hold on new work, or escalation to a collections agency. At this point, the goal is recovery, not relationship preservation.

Prioritize the High-Value Middle

Counterintuitively, the most productive collection work is often in the 30–60 day bucket for your largest invoices. These accounts are still responsive, the money is still almost certainly collectible, and the dollar amounts justify individual attention. Chasing $200 90-day invoices one at a time burns team capacity on the least recoverable balances.

Segment Clients, Not Just Invoices

Classify customers into three groups based on aging history:

• Prompt payers — rarely appear past the 0–30 bucket. Low-touch.
• Sometimes late — occasional 31–60 stints. Worth a friendly check-in process.
• Chronically late — live in the 61+ columns. Restructure their terms (deposits, prepayment, or parting ways).

Many businesses spend the same amount of collection effort on all customers. Matching intensity to history is one of the highest-leverage operational changes a finance team can make.

Linking Aging to Your Broader Financial Picture

A healthy AR aging report isn't a standalone metric—it's an input into the rest of your financial management.

Cash flow forecasting: The aging report tells you what's likely to land in the bank over the next 30, 60, and 90 days, weighted by historical collection probability.

Bad debt reserve: Public-company GAAP requires an allowance for doubtful accounts. Even if you don't report externally, estimating potential write-offs based on aging distribution is good practice. A common approach is to reserve a percentage of each bucket—for example, 1% of current, 5% of 31–60, 15% of 61–90, and 50% of 90+.

Pricing and terms decisions: If 30% of your AR is chronically late, the solution may be structural, not operational. Consider requiring deposits, moving toward retainers, adjusting net-30 to net-15, or offering small discounts for early payment (typical 2/10 net 30: 2% off if paid within 10 days).

Bookkeeping accuracy: Aging problems often surface bookkeeping errors. An "overdue" invoice that was actually paid in cash and never recorded, a duplicate invoice that was never voided, a credit memo that lives in limbo—all of these distort the report and often distort the general ledger too. Accurate, up-to-date bookkeeping is the foundation for every downstream financial decision, from tax filings to credit applications.

Common Mistakes to Avoid

Treating the report as informational instead of operational. The report exists so you can act on it. If nobody owns follow-up, the numbers just get worse each month.

Reviewing too infrequently. Quarterly aging reviews guarantee 90-day problems. By the time you see them, they're already expensive to fix.

Ignoring the current bucket. "Current" invoices can still become problems if you have a large customer whose payment pattern is shifting. Watch the trend, not just the overdue columns.

Disconnected systems. If your proposals, invoices, and payments live in three separate tools that don't talk to each other, your aging report will always lag reality. Integration is a data-accuracy problem as much as a convenience problem.

Writing off too quickly—or too slowly. Keeping 18-month-old invoices on your balance sheet inflates assets and distorts DSO. But writing off a 95-day invoice that would have paid in another 30 days just because it's easier than following up is also a mistake. Use a policy, not gut feel.

When to Automate

Once your AR volume gets past a few dozen open invoices a month, manual aging follow-up becomes a time sink. Automation can help in three layers:

1. Automated reminders: Scheduled emails at 3, 7, and 14 days past due.
2. Payment capture at agreement: Collecting ACH authorizations or card details at proposal time so invoices can be auto-debited.
3. Integrated dashboards: Real-time aging views so you're not waiting for month-end close to see deterioration.

The goal of automation isn't to eliminate the aging report—it's to shift its role. In a well-automated business, most of your AR lives in the current column, and the aging report becomes a confirmation of health rather than a to-do list of problems.

Keep Your Books Ready for the Report

An AR aging report is only as useful as the ledger it's pulled from. Missing transactions, miscategorized payments, and uncleared deposits all silently undermine every metric in this guide. Beancount.io provides plain-text accounting that gives you complete transparency over your books—every transaction is a single line you can read, audit, and version-control, with no black-box logic between you and your numbers. If you're tired of wondering whether your accounting software is telling you the truth, get started for free and see why developers and finance teams are moving to plain-text accounting. You can also explore Fava dashboards for visualizing your AR and cash flow without leaving the plain-text world.