Upflow → Blog → AR metrics
Aging Report: Meaning & Role in Accounts Receivable (AR)
Alexandre Antoine
|
October 29, 2026
Generate AI summary
An accounts receivable aging report lists every unpaid customer invoice, grouped by how long it’s been outstanding: usually current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due. Finance teams use it to see who to chase first, spot customers at risk and estimate how much they might never collect.
Reviewed every week or month, it’s one of the simplest ways to protect cash flow. In this guide, you’ll learn:
- What is an accounts receivable (AR) aging report?
- What does an AR aging report look like?
- How do you create an aging report?
- How do you read an aging report and act on it?
- Why is an AR aging report important?
- How do you automate an aging report?
Want to build your own? Download our free accounts receivable aging template.
What is an accounts receivable (AR) aging report?
An accounts receivable aging report, often called an AR aging report or simply an aging report, lists every unpaid customer invoice and groups it by how long it has been outstanding. It shows at a glance who owes you money, how much and how late they are.
Most aging reports sort invoices into these buckets:
- Current: not yet due
- 1 to 30 days past due
- 31 to 60 days past due
- 61 to 90 days past due
- Over 90 days past due
For each customer, the report shows the total of their outstanding invoices in each bucket, along with the overall balance. Many teams also show the invoice numbers, amounts and due dates behind each figure.
Most B2B finance teams age invoices from the due date, so an invoice only counts as late once its payment terms have passed. Some businesses age from the invoice date instead, which shows how long the money has been owed in total. Either works, as long as you use the same method every time so your reports stay comparable.
Finance teams use the aging report to decide which customers to chase first, to spot past-due invoices before they turn into write-offs, and to estimate how much of their receivables they may never collect. In simple terms, it tells you who owes you money and how late they are.
What does an AR aging report look like?
An aging report is a table, with one row per customer and one column per aging bucket. Here’s a simple example for a company with $62,000 in outstanding receivables:
Here’s the same report as a table:
| Customer | Current | 1–30 days | 31–60 days | 61–90 days | 90+ days | Total |
|---|---|---|---|---|---|---|
| Acme Corp | $12,000 | $4,000 | – | – | – | $16,000 |
| Brightline Ltd | $8,500 | – | $3,200 | – | – | $11,700 |
| Cobalt Systems | – | $6,000 | $2,500 | $1,800 | – | $10,300 |
| Delta Health | $15,000 | $2,000 | – | – | – | $17,000 |
| Evergreen Media | – | – | – | $2,200 | $4,800 | $7,000 |
| Total | $35,500 | $12,000 | $5,700 | $4,000 | $4,800 | $62,000 |
| % of total | 57% | 19% | 9% | 7% | 8% | 100% |
Reading across a row shows how a single customer is paying. Reading down a column shows how much of your receivables sits in each stage of lateness. The bottom row is the quickest health check: in this example, 57% of receivables are current, and 43% are past due, with 15% more than 60 days late.
Some patterns stand out straight away. Acme Corp and Delta Health are mostly current, with small amounts just past due. Cobalt Systems has balances spread across three overdue buckets, which suggests its payments are slipping. Evergreen Media has nothing current at all, and most of its balance is over 90 days late, so it’s the account to look at first.
Aging summary vs aging detail report
Most accounting systems offer two versions of the aging report:
| Aging summary report | Aging detail report | |
|---|---|---|
| What it shows | One row per customer, with totals for each bucket | One row per invoice, with invoice number, dates, amount and days past due |
| Best for | A quick overview of AR health and month-end reporting | Day-to-day collections work and following up on specific invoices |
| Typical users | CFOs, controllers and leadership | AR specialists and collectors |
The summary tells you where the problem is, and the detail tells you what to do about it. Most teams review the summary weekly or monthly, often alongside their AR dashboard, and work from the detail report when they’re chasing payments.
How do you create an aging report?
To create an aging report, list every unpaid invoice, work out how many days each one is past due, sort them into aging buckets, then total the buckets for each customer. Most accounting systems do this automatically, but the logic is the same whether you use software or a spreadsheet.
How to create an aging report, step by step
Step 1: Gather all open invoices. Pull a list of every unpaid invoice, with the customer name, invoice number, invoice date, due date and amount still owed.
Step 2: Calculate days past due. For each invoice, subtract the due date from today’s date. A negative or zero result means the invoice isn’t due yet.
Step 3: Assign each invoice to an aging bucket. Place each invoice in Current, 1 to 30, 31 to 60, 61 to 90 or 90+ days past due, based on the result from step 2.
Step 4: Group by customer and total each bucket. Add up the amounts in each bucket for every customer, then calculate the totals and the percentage of receivables in each bucket.
Step 5: Prioritize overdue accounts. Start with the oldest and largest balances, since they carry the highest risk of becoming bad debt, and check whether any customer is slipping into later buckets over time.
Building an aging report in Excel or your ERP
In Excel or Google Sheets, export your open invoices with the columns from step 1, then add two calculated columns:
- Days past due: =TODAY()-D2, where D2 is the due date
- Aging bucket: =IF(E2<=0,”Current”,IF(E2<=30,”1-30″,IF(E2<=60,”31-60″,IF(E2<=90,”61-90″,”90+”)))), where E2 is days past due
Then create a pivot table with customers as rows, aging buckets as columns, and the sum of the open amount as values. That gives you the same layout as the sample report above. The drawback is that the report is only as current as your last export, so it needs rebuilding every time you review it.
If you’d rather start from a ready-made version, our free AR aging report template has the formulas and buckets already set up.
In your accounting system or ERP, the report is usually built in. NetSuite, Sage Intacct, QuickBooks and Xero all include standard aging reports for accounts receivable, typically in both a summary and a detail version. QuickBooks and Xero call them “A/R Aging” and “Aged Receivables” reports respectively. These pull directly from your ledger, so they’re accurate as of the moment you run them, but they show balances rather than the follow-up history or context behind each overdue invoice.
Why is an AR aging report important?
An AR aging report shows where your cash is stuck and how long it’s been stuck there. That makes it one of the most useful tools for protecting cash flow, prioritizing collections and keeping bad debt under control.
Late payment is common in B2B. According to the 2026 Atradius Payment Practices Barometer for North America, late payments affect seven in ten companies, and overdue invoices make up an average of 23% of B2B receivables. Most of those invoices are paid within a month of the due date, which is exactly why it matters to catch the ones that aren’t before they age further.
Without an aging report, it’s hard to track unpaid invoices accurately, which leads to missed follow-ups, poor visibility into cash flow and inaccurate assumptions in your forecasts. At a high level, an aging report helps you:
- Keep visibility into your receivables timeline
- Prioritize collection efforts by urgency
- Act on late payments early instead of reacting to them
- Reduce the risk of cash flow disruptions
Reviewed regularly, it helps you make better decisions about collections, credit policies and customer relationships before small delays become big problems.
1. Estimate bad debt risk
Some invoices go so far past their due date that they can’t be collected and have to be written off as bad debt. The IRS lets businesses deduct bad debts, but only once they’ve determined the debt is worthless.
The aging report gives you the data to estimate those losses each period, using the aging method described above, and to calculate your bad debt expense accurately. It also shows you where to review your policies. For example, if one customer keeps contributing to bad debt, you may need to tighten their credit terms.
As a rule, the longer an invoice goes unpaid, the less likely you are to collect it. Reviewing the aging report regularly keeps bad debt under control.
2. Spot cash flow problems early
Healthy cash flow depends on customers paying on time. The U.S. Chamber of Commerce lists cash flow problems as the first reason small businesses fail, and even profitable companies can run short of cash when large invoices are paid late.
Imagine a large order where you’ve paid suppliers upfront but the customer pays 60 days late. The gap has to be covered from your own cash or by borrowing, and the cost can wipe out the margin on the deal. The aging report makes these situations visible early, so you can follow up, adjust your forecast or arrange financing before cash gets tight.
Are late payments piling up? Our free guide with tips to get paid on time covers practical ways to tackle them.
3. Improve your collection practices
The aging report shows you whether your collection process is working. If several accounts regularly reach 60 to 90 days, your follow-up probably starts too late or isn’t consistent enough.
Sometimes the fix is simple: a customer’s internal payment cycle doesn’t match your invoice dates, so aligning the two reduces late payments. In other cases, you can improve AR collection by prioritizing your efforts, sending reminders on the first day an invoice is late and adding more personal follow-up for key accounts. These accounts receivable management best practices all start with knowing which invoices are late, which is exactly what the aging report shows.
4. Assess your credit policies
The aging report is also a quick way to test your credit policy. If most of your overdue balance comes from a single customer, the problem is likely with that account, and you need to find out why they’re paying late.
If many customers are falling behind, the issue is more likely your credit policy itself, such as terms that are too generous or credit extended to higher-risk customers. Comparing your aging profile over time, and against industry norms, shows whether your credit risk is under control.
How do you automate an aging report?
You automate an aging report by connecting your accounting system or ERP to accounts receivable software that updates aging buckets automatically as invoices are issued and paid. Instead of exporting data and rebuilding a spreadsheet, you get a live view of what’s outstanding, so you can act on overdue invoices the day they slip into a new bucket.
A manual aging report is accurate only at the moment you build it. As soon as a customer pays or a new invoice goes out, the numbers are out of date, and finance teams end up chasing customers who have already paid or missing invoices that have just become overdue. Automation fixes that by keeping the aging data in sync with your ledger, and by linking the report to the actions that follow from it: reminders, escalations and follow-up tasks.
When you compare tools, look for an aging view that you can break down by customer, owner or segment, that shows how your aging profile has changed over time, and that lets you go straight from a bucket to the invoices behind it. Just as important is what happens next: the best tools use the same aging data to trigger collection workflows, so every overdue invoice gets the right follow-up without anyone building a to-do list by hand.
How Upflow keeps aging up to date
In Upflow, the aging balance in Upflow Insights updates as invoices are created and paid, and splits receivables into due, overdue for less than 30 days, 30 to 60, 60 to 90 and more than 90 days. You can break it down by customer, owner or any custom field, or view it as of a past date to see how your collection efforts have changed things. Clicking a bucket opens the invoices behind it, ready to review or export.
From there, collection workflows in Upflow Collections follow up automatically, timed from each invoice’s due date. They can start before an invoice is due and escalate as it ages, and they pause when a customer disputes an invoice or makes a promise to pay. The aging report stops being a static snapshot and becomes the starting point for every follow-up.
Want to see your own aging profile and key AR metrics? Connect your accounting system to Upflow’s free Discover plan.
Alexandre Antoine
Finance Director at Upflow
Alexandre is the Finance Director at Upflow, where he leads the company’s internal finance and accounting operations. With a background in both strategic finance and financial reporting, Alexandre brings a practical, detail-oriented approach to the complexities of B2B finance.
At Upflow, Alexandre ensures that internal processes from cash management to KPI reporting are optimized for transparency, accuracy, and growth-readiness. He helps build scalable finance systems that support Upflow’s mission to empower other finance teams through better collections and cash flow insights.
Alexandre regularly contributes to Upflow’s blog with in-depth articles on accounting metrics, financial ratios, reporting best practices, and operational benchmarks. His writing provides actionable advice for controllers, FP&A teams, and finance leaders navigating complex financial processes.
Summary
Shared
Frequently Asked Questions
Can’t find what you’re looking for?
Ask AI
An aging report shows every unpaid customer invoice, grouped by how long it’s been past due: usually current, 1 to 30, 31 to 60, 61 to 90 and over 90 days. It helps you see which customers to chase first, spot payment problems early and assess credit risk.
Review your aging report at least once a month. If you have a high volume of invoices or frequent late payments, review it weekly or every two weeks. Regular reviews let you act on overdue invoices before they move into older buckets, where they’re harder to collect.
The most common buckets are current (not yet due), 1 to 30 days past due, 31 to 60 days, 61 to 90 days and over 90 days. You can adjust them to suit your payment terms, for example adding a 120+ day bucket if you offer long terms.
An aging report highlights invoices that are significantly overdue, so you can prioritize follow-ups, escalate earlier and adjust credit terms for risky customers before payments become uncollectible. The older an invoice gets, the less likely it is to be paid, so acting early is what keeps bad debt down.
An accounts receivable aging report tracks money your customers owe you, while an accounts payable aging report tracks money you owe your suppliers. Both group balances by how long they’ve been outstanding, but they look at opposite sides of your cash flow.
Yes. Accounts receivable software like Upflow connects to your accounting system or ERP and updates your aging buckets automatically as invoices are issued and paid. You can break the aging down by customer or segment, open the invoices behind each bucket, and trigger reminders automatically as invoices age.
There’s no universal benchmark, since it depends on your industry and payment terms, but the lower the better. Most overdue B2B invoices are paid within a month of the due date, so a large or growing share of receivables over 90 days is a warning sign. Track it monthly and compare it with your own history to see whether collections are improving.
With the aging method, you apply a different expected loss percentage to each aging bucket, based on your collection history, and add up the results to estimate your allowance for doubtful accounts. Older buckets get higher percentages, since those invoices are less likely to be collected.
DSO (days sales outstanding) tells you how long, on average, it takes to collect payment after a sale. An AR aging report shows exactly which invoices and customers are behind that number, and how late each one is. DSO tracks the trend, and the aging report tells you where to act.
Most B2B finance teams age invoices by due date, so an invoice only counts as late once its payment terms have passed. Aging by invoice date shows how long the money has been owed in total, which can be useful for cash forecasting. Either works, as long as you use the same method every time.
Related articles
