AR aging is the practice of sorting unpaid customer invoices by how long they have been outstanding. An AR aging report lists what each customer owes and splits it into time buckets, usually current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due, so you can see at a glance which payments are recent, which are late and where cash is stuck. It is the main tool for collections, credit decisions and estimating bad debt.
Revenue can look strong on paper while the bank balance tells a different story. Many growing businesses, including consumer brands that sell wholesale to retailers, see the same pattern: sales are recorded, invoices go out, yet cash does not keep pace. The usual reason is delayed customer payments. This article explains how to read an AR aging report, how to run an AR aging analysis, how to build the report, and how to use it to collect faster. If you would rather hand the receivables work to a team, our finance and accounting outsourcing service covers it.
AR Aging Report Explained: Meaning + Example
An accounts receivable (A/R) aging report lists every unpaid invoice from your customers and groups it by how many days it is overdue. Instead of one total owed, it breaks the amount into time buckets such as 0 to 30 days, 31 to 60 days, 61 to 90 days and over 90 days.
It shows two things at once:
- The total amount each customer owes
- How long each part of that amount has been unpaid
If a large share of receivables sits in the 60+ or 90+ day ranges, payments are slowing and collection problems are building.
Example of an A/R Aging Report Explained
| Customer | Total Due | 0 to 30 Days | 31 to 60 Days | 61 to 90 Days | 90+ Days |
|---|---|---|---|---|---|
| ABC Inc | $10,000 | – | $10,000 | – | – |
| XYZ Inc | $50,000 | $25,000 | $25,000 | – | – |
| MNO Inc | $60,000 | – | – | $60,000 | – |
| FLP Inc | $100,000 | – | – | – | $100,000 |
| Total | $220,000 | $25,000 | $35,000 | $60,000 | $100,000 |
From this A/R aging report, several points stand out:
- The total outstanding amount is $220,000. Only $25,000 falls in the 0 to 30 day range. Most receivables have been pending for more than a month.
- $100,000 is over 90 days, all from FLP Inc. Invoices this old are the least likely to be collected, so this account needs direct follow-up now and a hold on further credit.
- MNO Inc. has $60,000 in the 61 to 90 day range. It is late but still recoverable if chased firmly.
- ABC Inc. and XYZ Inc. sit in the 31 to 60 day range, with XYZ also holding recent invoices. These need routine follow-up but are not yet critical.
Overall, most receivables have aged beyond 60 days, which will squeeze cash flow. The business needs to step up collections and review how it extends credit to these customers.
AR aging analysis: the numbers to watch
Reading a report customer by customer is the first step. AR aging analysis turns it into a few numbers you can track every month.
- Share over 60 days. In the example, $160,000 of $220,000, or about 73%, is more than 60 days old. A rising share month after month is the clearest warning sign.
- Share over 90 days. $100,000 of $220,000, or about 45%. This is the part most at risk of becoming bad debt.
- Concentration. One customer, FLP Inc., holds about 45% of all receivables. When a single account is that large, its payment behavior decides your cash position.
- Days sales outstanding (DSO). Accounts receivable divided by credit sales for the period, multiplied by the number of days in the period. If the business above made $330,000 of credit sales in a 90-day quarter, DSO is $220,000 divided by $330,000, times 90, or 60 days. Compare that with your payment terms: net 30 terms and a DSO of 60 mean customers are paying, on average, a month late.
- Trend. Compare this month’s report with last month’s. An invoice moving from 31 to 60 into 61 to 90 tells you follow-up has not worked.
How to create an AR aging report
Most accounting software builds the report for you. In QuickBooks Online, go to Reports, then Standard reports, and under “Who owes you” choose Accounts receivable aging summary; the same section has an aging detail report, and General options lets you change the aging periods. Other accounting platforms have their own version, usually under a name such as aged receivables.
To build one in a spreadsheet:
- Export every open invoice with customer, invoice number, invoice date, due date and amount outstanding.
- Pick a report date, usually the last day of the month.
- Calculate days past due as the report date minus the due date. Anything not yet due is current.
- Assign each invoice to a bucket: current, 1 to 30, 31 to 60, 61 to 90 and over 90.
- Use a pivot table to total each customer by bucket, and add a grand total row.
Summary versus detail
The aging summary shows one line per customer with a total in each bucket, as in the example above. The aging detail lists every invoice, so you can see which specific invoices are late. Use the summary for the monthly review and the detail for collection calls.
Aging by due date or invoice date
Aging by due date measures how late a payment is against the terms you agreed. Aging by invoice date measures how long since you billed. Most businesses age by due date for collections; a lender may ask for invoice-date aging. Be consistent, and say which one a report uses.
How to Use an AR Aging Report to Resolve Cash Flow Gaps?
Cash flow gaps build up slowly in unpaid invoices. An A/R aging report shows where money is stuck and how long it has been there, so you can decide where to act, whom to contact and which policies to change. Here are the steps.
Step I: Identify High-Risk Receivables and Act First
The oldest balances, particularly those in the 61 to 90 and 90+ day ranges, carry the highest risk of non-payment. They have already passed normal credit periods and need direct attention. Review the customers with the largest overdue balances and start formal reminders, calls or escalation. Where needed, place a temporary credit hold to stop the exposure growing.
Step II: Prioritize Collections Based on Aging Buckets
Not every receivable needs the same effort. Recent dues may only need a standard reminder, while older invoices need stronger action.
| Early-stage dues | Mid-stage dues | Late-stage dues |
|---|---|---|
| Routine reminders | Repeated follow-ups and calls | Credit holds, final notices, possible agency or legal action |
This prevents missed follow-ups and turns more receivables into cash.
Step III: Adjust Credit Terms and Customer Policies
The report reveals payment patterns. If some customers keep appearing in the older buckets, you can revise their credit limits, shorten their payment terms or ask for part payment in advance. These changes limit how much overdue balance can build up in future.
Step IV: Forecast Cash Inflows More Accurately
The aging report gives a time-based view of expected collections. Recent invoices are more likely to be paid; older ones are less certain. Weighting your forecast by bucket, rather than counting every receivable at face value, gives a more realistic cash plan.
Step V: Improve Internal Billing and Follow-Up Processes
Some delays are your own. Invoices sent late, missing purchase order numbers or no fixed reminder schedule all stretch payment cycles. If many invoices drift into older buckets, review your billing timelines, reminder schedule and how you contact customers. Invoice promptly and follow a fixed cycle.
Using AR aging to estimate bad debt
The aging report is also how many businesses set their allowance for doubtful accounts, the amount of receivables they expect never to collect. Under the aging method, you apply a higher expected loss rate to older buckets, because the older the receivable, the less likely you are to collect it. A textbook example from Lumen Learning’s financial accounting course uses 1% for invoices not yet due, 5% for 0 to 30 days past due, 10% for 31 to 60, 25% for 61 to 90 and 50% for over 90.
Applied to the example above, treating the 0 to 30 column as the 5% bucket, that gives $1,250 plus $3,500 plus $15,000 plus $50,000, or an allowance of $69,750. Your own rates should come from your collection history, reviewed with your accountant, but the point stands: in this business almost a third of receivables may never turn into cash.
How to Use the A/R Aging Report to Improve Payment Collection in 2026?
Extending credit can win sales, but it delays cash. The aging report shows which invoices are nearing their due date and which have already passed it, so you can plan when and how to follow up rather than waiting. Each bucket calls for a different level of urgency.
| Aging category | Status of invoice | What you should do |
|---|---|---|
| Current (not due yet) | Still within the agreed credit period | Send a reminder when the due date is within 7 days, so the customer prepares to pay |
| 1 to 30 days past due | Slightly overdue | Contact the customer within 2 business days by email, call or message. Start polite. If still unpaid after 14 days, send a first formal collection letter, and a second as it nears 30 days |
| 31 to 60 days past due | The delay is becoming serious | Send a third collection letter and move to weekly calls |
| 61 to 90 days past due | The account is delinquent | Send a final letter setting out what happens next, stop further credit and pause new orders, and consider a collection agency or legal steps if there is no response |
| Over 90 days past due | Collection is now doubtful | Decide between a collection agency, legal action or a settlement, keep the account on hold, and review with your accountant whether to write it off against the allowance |
This way every unpaid invoice gets attention matched to how late it is.
Want to Improve Your Cash Flow? Pass Your Accounting Headache to Atidiv in 2026
An A/R aging report lists every unpaid customer invoice and groups it by how long it has been outstanding. Used every week, it lets you track overdue invoices, follow up in the right order, spot high-risk accounts early, tighten terms for slow payers, forecast cash and fix your own billing gaps.
If you would rather not run receivables in-house, Atidiv’s finance and accounting team manages accounts receivable as part of bookkeeping for small businesses, along with financial reporting, cash flow analysis and cash flow forecasting. We work in QuickBooks, Xero, NetSuite, Sage and Bill.com. For the wider picture of cash, see our guide to the cash flow statement. To talk it through, contact us.
Related guide: Accounts Receivable Financing and Factoring: A Guide for Growing Businesses
AR Aging Report Explained: Frequently asked questions
1. What is an AR aging report?
An accounts receivable aging report organizes unpaid customer invoices by how long they have been outstanding, such as current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due. Finance teams use it to find overdue balances, track collections, judge credit risk and set the allowance for doubtful accounts.
2. What is AR aging analysis?
It is reviewing the aging report for patterns: the share of receivables over 60 and 90 days, how concentrated balances are in a few customers, days sales outstanding, and how each of those changes month to month.
3. Why am I facing cash flow issues even when sales are high?
High sales do not guarantee cash in the bank. If customers pay late, revenue stays stuck in receivables. The aging report shows how long invoices remain unpaid and where the gap between sales and cash comes from.
4. How often should I review my A/R aging report in 2026?
At least weekly for collections, and monthly for the wider analysis and bad debt estimate. Regular review means follow-ups are not missed and late accounts are caught early.
5. What should I do if a customer delays payment repeatedly?
Revise their terms: shorten the credit period, lower the credit limit or ask for part payment in advance. This limits how much they can owe you at any time.
6. At what point should I stop giving credit to a customer?
If invoices pass 60 to 90 days and there is no response to reminders, stop extending credit. Continuing to supply without payment only increases the risk. Resume once overdue balances are cleared.
7. What is a good DSO?
It depends on your terms. A useful rule is to compare DSO with your standard terms: if you offer net 30 and DSO is close to 30, customers are paying roughly on time; if it is well above, collections need attention.
8. How can Atidiv help you manage receivables and improve cash flow?
Atidiv manages accounts receivable as part of its bookkeeping service, and adds cash flow analysis, cash flow forecasting and financial reporting. Our financial process setup work can also tighten billing, so fewer invoices age in the first place.
Maximilian Straub is the Chief Operating Officer for Guild Capital and oversees all areas of the company's strategic operations and portfolio performance across the world. He is also a board member for Atidiv, supporting its growth initiatives. He served as the Chief Operating Officer and Chief Financial Officer for Spring Place and had previously spent 7 years advising clients in strategy, operational execution and organizational transformation while at McKinsey & Company.