Table of Contents
Everyone running AR knows their aging report matters. You check it monthly, sometimes weekly, and you can spot the problem accounts at a glance. But between reviewing the report and actually collecting on those aging invoices sits a gap most teams never close properly. Follow-up gets delayed, reminders go unsent, and before long your 30-day bucket has quietly migrated into the 90+ column where recovery rates drop below 70%.
TLDR:
- Aging reports group unpaid invoices by time buckets to show who owes money and for how long
- Invoices over 90 days past due have only a 69.6% collection rate, making early action critical
- Each aging bucket should trigger a specific collection action to recover payments faster
- Invoice Butler automates the entire follow-up process by monitoring AR in real time and escalating overdue invoices without manual tracking
What Is an Aging Report in Accounting?
An aging report is a financial snapshot that groups outstanding invoices by how long they've been unpaid. Think of it as a timeline of money owed, sorted into buckets: 0–30 days, 31–60 days, 61–90 days, and 90+ days past due. Each row shows a customer or vendor, the amount outstanding, and which time bucket it falls into.
The older the bucket, the higher the risk. A 15-day overdue invoice is very different from a 95-day one, and your response to each should be different too. Aging reports apply to both receivables (money customers owe you) and payables (money you owe suppliers), which is why they sit at the center of most accounting workflows.
Accounts Receivable Aging Report Explained
Every invoice your customers owe you, sorted by time. Each row is a customer, each column is a time bucket. At a glance, you can see who's current, who's slipping, and who needs a call.
That visibility matters more than most businesses expect. Research shows that 56% of small businesses carry unpaid invoices averaging $17,500, with 47% reporting invoices sitting more than 30 days past due. Without this report, that money quietly gets absorbed into the noise of daily operations.
The report answers three questions fast: who owes you, how much, and for how long.
Accounts Payable Aging Report Explained
The accounts payable aging report tracks what your business owes to suppliers, organized by how long those invoices have been outstanding. Where the receivables version tells you who owes you money, this one tells you who you owe, and when.
Typical aging buckets run current, 1–30 days, 31–60 days, 61–90 days, and 90+ days past due. Reviewing this regularly helps you catch duplicate invoices, avoid late payment penalties, and protect supplier relationships before they sour.
Key Metrics and Benchmarks for Aging Reports
Healthy accounts receivable starts with knowing what good looks like. A few benchmarks worth keeping in your back pocket:
- Days Sales Outstanding (DSO) should ideally stay under 45 days for most businesses, though this varies by industry.
- Anything in the 90+ day bucket warrants immediate attention, as debts over 90 days have only a 69.6% collection rate on average.
- A clean AR aging report typically shows the majority of balances sitting in the current or 1–30 day columns. Tracking your turnover ratio helps validate these numbers over time.
Tracking these numbers consistently tells you far more than any single snapshot ever could.
How to Read and Analyze Your Aging Report
Start by adding a percentage column next to each bucket. Divide each bucket's total by your overall AR balance. If more than 20% of your receivables sit beyond 60 days, that's a warning worth acting on.
Then look for patterns across customers, beyond totals. One customer repeatedly aging into the 61–90 day column tells a different story than a one-time slow payer. Recurring offenders signal a relationship or process problem, not a payment delay. Without consistent follow-up processes, these patterns become harder to spot early.
Watch the Trend Over Time
A single report is a snapshot. The real insight comes from comparing reports side by side across months.
- Is your 30+ day bucket growing month over month? That's a cash flow signal, and catching it early gives you room to act before it compounds into a serious shortfall.
- Are the same invoice numbers appearing across consecutive reports? That suggests a collections follow-up gap, not just a slow customer.
- Is your current bucket shrinking as older buckets grow? That pattern points to a systemic delay in your billing or approval cycle.
Common Issues Revealed by Aging Reports
Aging reports are useful precisely because they surface problems you might not otherwise spot until they become expensive. A few patterns tend to show up again and again.
- Customers who consistently pay late signal a relationship or credit terms problem worth reviewing before the balance climbs further.
- Invoices sitting in the 60+ day bucket without any collection activity often mean your follow-up process has gaps. This is one of the clearest signs your business needs AR automation.
- A high volume of small overdue balances can quietly add up to a cash flow squeeze.
- On the payables side, missing early-payment discounts because invoices aren't tracked properly is a common and avoidable loss that adds up quickly.
How to Create an Aging Report
Building one manually takes four steps:
- Pull all open invoices from your billing system
- Calculate days outstanding per invoice (today's date minus the invoice date)
- Assign each invoice to a bucket: current, 1–30, 31–60, 61–90, or 90+ days
- Sum each bucket by customer and overall
Most accounting software (QuickBooks, Xero, NetSuite) generates this automatically under reports. In Excel, an aging formula using =TODAY()-[invoice date] handles the day calculation, and a pivot table groups totals by customer and bucket. The Excel route works fine for small invoice volumes, though it gets unwieldy fast as your customer list grows.
Aging Report Formats and Templates
Format choice comes down to who needs the data and why. Core components stay consistent across all of them: customer or vendor name, invoice numbers, due dates, aging columns, and row totals.
- Excel suits teams that want custom formulas or ad hoc analysis, giving you full control over how buckets are structured and calculated.
- PDF exports work well for audits, board presentations, or external stakeholders who need a clean, static snapshot.
- Accounting software reports (QuickBooks, Xero, NetSuite) pull live data automatically and are the most practical for daily use.
Using Aging Reports to Improve Collections
Each aging bucket should map to a specific collections action. Here is a simple framework to follow:
| Aging Bucket | Collection Action | Contact Method | Expected Response Time | Success Metric |
|---|---|---|---|---|
| Current to 30 days | Send standard payment reminder to keep invoice top of mind and confirm receipt | Automated email with payment link | 3-5 business days | 80% payment rate before moving to next bucket |
| 31 to 60 days | Follow up directly since silence usually means invoice slipped through or requires approval | Phone call or personalized email to AP contact | 2-3 business days | 65% payment rate within 10 days of contact |
| 61 to 90 days | Escalate to decision-maker rather than chasing same contact repeatedly | Direct outreach to finance manager or controller | 24-48 hours | 50% payment commitment secured within one week |
| 90+ days | Treat as high-priority collection case and pursue alternate contacts if usual route has gone cold | Multi-channel: email, phone, certified letter, executive escalation | Immediate action required | Target 70% recovery rate through aggressive follow-up |
- Current to 30 days: send a standard payment reminder to keep the invoice top of mind. Automation can handle this without manual intervention.
- 31 to 60 days: follow up by phone or a second email, since silence at this stage usually means the invoice has slipped through.
- 61 to 90 days: escalate to a decision-maker at the customer's company rather than chasing the same contact repeatedly.
- 90+ days: treat as a priority and pursue alternate contacts if your usual route has gone cold.
Track your recovery rate per bucket monthly. If your 31 to 60 day rate drops, your 90+ balance will likely grow six weeks later. Specialized recovery tools can help reverse this trend.
Inventory Aging Reports
Aging analysis doesn't stop at invoices. The same bucketing logic applies to inventory, tracking how long each SKU has been sitting in stock rather than how long a payment has been outstanding.
Typical buckets run 0–30, 31–60, 61–90, and 90+ days in stock. Products aging past 60 days usually need a decision:
- 31–60 days: consider promotions or bundling to move units faster
- 61–90 days: evaluate markdowns against carrying costs
- 90+ days: liquidation or write-off is often the most practical path
Reviewing this report monthly helps you catch what's stagnating before storage costs quietly eat into your margins.
Automating Aging Report Management with Invoice Butler
Reading an aging report is one thing. Acting on it every week, without gaps, is where most teams fall short.
Invoice Butler monitors your AR in real time and ties follow-up actions directly to invoice age. This DSO reduction approach keeps your aging buckets from growing. When an invoice crosses into the 31-day bucket, a reminder goes out. At 60 days, escalation to a decision-maker happens without you having to flag it. At 90+, alternate contacts get pursued across email, phone, or Slack, whatever it takes.
The AR inbox stays at zero. Responses get handled, disputes get routed, and payment confirmations get matched back to the right invoice automatically. Your aging report becomes a live system rather than a monthly task you dread opening.
Final Thoughts on Accounts Receivable and Payable Reports
Keeping an aging report current gives you the visibility to prevent late payments from piling up into real trouble. The difference between healthy cash flow and constant scrambling often comes down to how quickly you act on what the report shows. If manual follow-up feels like pulling teeth, book a quick session to walk through how we automate the chase for you.
FAQ
What's the difference between an AR aging report and an AP aging report?
An AR aging report tracks money customers owe you, while an AP aging report tracks money you owe suppliers. Both use the same time buckets (0-30, 31-60, 61-90, 90+ days), but AR helps you prioritize collections and AP helps you avoid late fees and protect supplier relationships.
Can I build an aging report in Excel without buying accounting software?
Yes. Use =TODAY()-[invoice date] to calculate days outstanding for each invoice, then create a pivot table to group by customer and time bucket. This works for small invoice volumes, but gets difficult to maintain as your customer list grows.
Aging report in Excel vs QuickBooks—which should I use?
QuickBooks pulls live data automatically and updates in real time, making it better for daily collections work. Excel gives you more control for custom analysis and works fine for occasional reviews, but you'll need to manually update it each time you want current numbers.
What percentage of my AR should be in the 90+ day bucket?
Keep it below 20%. Anything higher signals a collections problem worth fixing quickly, since debts over 90 days have only a 69.6% average collection rate and the recovery odds drop the longer they sit.
When should I escalate an overdue invoice to a decision-maker?
Start escalating at 61 days past due. If your usual contact hasn't responded by then, the invoice has likely slipped through or they lack authority to pay. Reaching a manager or the finance team directly at this stage often gets you paid faster than sending more reminders to the same person.
