What Are Aging Buckets?
Aging buckets are categories that group unpaid invoices by how long they’ve been outstanding. For example, if a customer’s $10,000 invoice was due on August 1 and it’s now September 20, that balance would sit in the 31-60 days past due aging bucket.
Splitting an accounts receivable aging report into separate buckets gives AR teams an at-a-glance view of exactly where overdue invoices are piling up. They use this to prioritize their collections efforts. An invoice in the 1-30 day bucket might get a routine reminder, but a 90+ day balance would probably need escalation or direct outreach.
Synonyms
- Aging of receivables method
- AR aging schedule
Understanding AR Aging Buckets
The easiest way to understand aging buckets is to think of them as a way of answering one question: How late is most of the money customers owe us?
You might have 100s or 1,000s of open invoices. Looking at each one individually makes it hard to see the bigger picture. Aging buckets sort those unpaid balances into time ranges so you can immediately see how much is current, slightly overdue, seriously overdue, or very old.
A typical AR aging report, split into buckets, looks like this:
Accounts receivable aging report (sample)
| Customer | 1-30 days | 31-60 days | 61-90 days | 90+ days |
|---|---|---|---|---|
| ABC Inc. | – | $10,000 | – | – |
| XYZ Ltd. | $25,000 | $25,000 | – | – |
| MNO Pvt. | – | – | $60,000 | – |
| FLP Ltd. | – | – | – | $100,000 |
| Total | $25,000 | $35,000 | $60,000 | $100,000 |
Including the “current” and “past-due” aging buckets side-by-side makes it easy to visualize AR aging across all your accounts.
Beyond that, there are seven core principles of aging buckets that you should know:
1. The clock starts with the invoice due date.
This is the most important concept.
Suppose you issue a $10,000 invoice on January 1 with Net 30 terms. It’s due January 31. Before January 31, that $10,000 is in the “Current” bucket. It transitions to the first aging bucket once it’s been unpaid for that whole month.
Only after the due date does aging begin:
How timing works for AG aging buckets (example)
| Date | Invoice status | Aging bucket |
|---|---|---|
| Jan. 15 | Not due yet | Current |
| Feb. 10 | 10 days overdue | 1-30 days |
| Mar. 15 | 43 days overdue | 31-60 days |
| Apr. 15 | 74 days overdue | 61-90 days |
| May 15 | 104 days overdue | 90+ days |
So when someone says “we have $300,000 sitting in the ‘61-90’ bucket,” they mean that customers owe $300,000 on invoices that are currently 61 to 90 days past due.
2. The buckets are ranges, not separate types of receivables.
Nothing special happens to an invoice when it enters a new bucket. It’s still the same invoice; it simply moves through the buckets as time passes.
If the customer pays it, it comes out of the aging report. That’s why an aging report is essentially a snapshot of AR at a particular moment in time.
3. Aging buckets tell you both how much you’re owed and how old that debt is.
Say you have $500,000 of outstanding AR. That number alone doesn’t tell you very much. There is a huge difference between:
Company A:
- $450k Current
- $40k 1-30 days
- $10k 31-60 days
- $0 60+ days
Company B:
- $100k Current
- $100k 1-30 days
- $100k 31-60 days
- $100k 61-90 days
- $100k 90+ days
Both have $500k in unpaid receivables, but Company B has a huge collections problem as 80% of that is overdue (most of it by several months).
4. Older buckets require a higher-touch approach.
A newly overdue invoice might simply need an automated reminder. As it ages, the company will normally escalate the response.
5. Aging applies to the remaining unpaid balance.
If someone owes you $20,000 and they pay you half of it, the AR aging report should update to show just $10,000 in the overdue balance. The remainder stays there until it’s either paid, credited, written off, or otherwise resolved.
6. Aging bucket ranges aren’t universal.
Most companies use 30-day increments because they align nicely with monthly billing cycles and payment terms (like Net 30 and Net 60).
But the right buckets depend on your collection timelines and commercial terms. If you have Net 15 terms for most of your deals, having narrower buckets prevents you from accidentally grouping new invoices and those which are overdue but haven’t yet hit the 30-day threshold together in the “Current” bucket.
7. Don’t confuse “invoice age” with “days past due.”
Imagine you sent your buyer an invoice 60 days ago with Net 60 terms. Then, its invoice age is 60 days and its days past due is zero. So it would ordinarily still be “Current,” not in the “31-60” bucket.
This is why it’s useful to check how your particular accounting system defines aging. Most give you the option to configure reports around both invoice dates and due dates. Due date aging is the one that’s more informative when evaluating overdue collections.
The Importance of Accounts Receivable Aging Analysis
AR aging reporting plays a critical role in financial planning, and aging buckets are the building blocks for evaluating collections efficiency.
There are four ways it’s useful:
Predict cash flow and plan your finances
If most of your AR sits in Current and 1-30 days past due, you can reasonably expect a larger share of it to convert to cash soon. If, instead, a growing percentage sits in 61-90 and 90+ day aging buckets, your expected cash inflows are a lot less certain.
You can combine that aging pattern with your historical collection rates to build a more realistic cash forecast. So if your company historically collects 98% of Current balances but only 60% of 90+ balances, you can calculate your actual expected cash inflows based on each dollar’s likelihood of landing in your account.
Spot bad debt, and potentially prevent it
Aging schedules support your allowance for doubtful accounts. Companies apply progressively higher expected-loss percentages to older receivables because older balances tend to carry greater collection risk.
AR aging buckets also help you spot and investigate the signs of bad debt early. For instance, if you notice an unpaid invoice in the 60-day bucket, it would prompt you to examine why.
You might find that invoices are consistently being sent to the wrong contact, or that there’s an open dispute on that invoice that your billing team missed. Once you know the exact approach you have to take, you’ll be able to collect on the overdue balance.
Evaluate your credit policy and customer creditworthiness
Say you offer standard customers Net 30 terms, but a large portion of your receivables routinely lands in the 31-60 and 61-90 buckets.
That can signal a few different problems:
- Credit terms that are too generous for certain customers
- Weak credit screening
- Credit limits that are too high
- Poor collections follow-up
- Customers routinely ignoring your stated payment terms
You can also analyze aging by customer. If Customer A consistently pays within your terms, but Customer B almost always reaches 60+ days past due, those two accounts probably shouldn’t receive identical credit treatment.
Measure and interpret other AR metrics
Days sales outstanding (DSO) estimates how many days, on average, it takes a company to collect its receivables after making a sale. You need the AR aging report to calculate it.
Aging buckets give you even more context. Let’s say your DSO rises from 38 to 52 days. That tells you collections are slowing, but it doesn’t tell you where the problem is.
Your aging report can.
You might realize your current receivables haven’t really changed but your 61-90 and 90+-day buckets have doubled. Now you know it’s older delinquent receivables that are driving your DSO figure higher, and not a general increase in sales.
How to Create an Accounts Receivable Aging Schedule
You can build an AR aging schedule manually, but that means entering every open invoice, recalculating days past due, moving balances between buckets, and updating payments yourself. That gets tedious fast and creates plenty of room for errors.
It’s better to generate the report through your accounting, ERP, or AR automation software. And if you are working in Excel, automate as much as possible with dynamic formulas, Power Query, and PivotTables so the schedule refreshes when your underlying invoice data changes.
The steps to do so are as follows:
Building an AR aging schedule
1. Connect or import your AR data.
Pull open invoices from your accounting system, ERP, billing platform, or source spreadsheet. At minimum, you’ll need the customer, invoice number, due date, and outstanding balance.
2. Set your aging rules.
Define the reporting date and the buckets you want to use, such as Current, 1–30, 31–60, 61–90, and 90+ days past due.
3. Calculate days past due automatically.
Your software should compare each invoice’s due date with the reporting date. In Excel, use a formula that updates dynamically rather than calculating this manually.
4. Automatically assign invoices to buckets.
Use your accounting platform’s aging logic or an Excel formula to classify each outstanding balance based on its days past due.
5. Summarize balances by customer and aging bucket.
Accounting software generally does this for you. In Excel, a PivotTable can group invoice balances by customer while displaying each aging bucket side by side.
6. Build in a repeatable refresh process.
Instead of recreating the schedule every month, connect it to your source data. If you’re not using dedicated software, Power Query is able to import, clean, and refresh new invoice data, while your formulas and PivotTables recalculate the aging schedule automatically.
7. Individually review exceptions.
Once the schedule is automated, your time is best spent investigating unusual balances, disputed invoices, and customers who move into older buckets.
Accounts Receivable Collection Strategies Based on Aging
Now that you have the aging data, you can use it to decide what collection action each account needs next. A customer who hasn’t reached the due date yet needs proactive nudges that make payment easy. A customer who’s 60 or 90 days overdue needs much more direct intervention.
This is where dunning — the structured process of reminding customers about unpaid invoices and escalating collection efforts as balances age — fits in.
Below you’ll find the optimal communication and collection strategies for customers in each aging bucket:
Collection strategies for AR aging buckets
| Aging bucket | Collection strategy |
|---|---|
| Current | Prevent late payment. Send invoices promptly, confirm receipt, provide clear payment instructions, and send pre-due reminders. Make payment as frictionless as possible with convenient payment methods and links. |
| 1-30 days past due | Start light-touch dunning. Send an automated overdue reminder, restate the amount and due date, include a payment link, and ask the customer to flag any billing issue preventing payment. |
| 31-60 days past due | Move to direct follow-up. Increase reminder frequency and have A/R contact the customer directly. Confirm whether there’s a dispute, approval delay, missing PO, or cash-flow issue and get a concrete payment date. |
| 61-90 days past due | Escalate the account. Involve the account manager or finance leadership if appropriate, establish a firm payment commitment, consider restricting additional credit, and document all collection activity. |
| 90+ days past due | Shift to recovery and risk control. Consider placing the account on credit hold, negotiating a payment plan, suspending further service where contracts allow, escalating to formal collections, or evaluating the balance for bad-debt treatment. |
Essentially, the older the receivable gets, the less your strategy should rely on routine reminders and the more it should focus on direct intervention, risk reduction, and recovery.
People Also Ask
How are aging buckets used in other financial processes?
Aging buckets aren’t limited to accounts receivable.
In accounts payable, they group unpaid vendor bills by how long they’ve been outstanding, so your finance team knows which payments to prioritize in order to avoid late fees and supplier issues.
In inventory management, aging analysis groups stock by how long it has been held so your team can identify slow-moving, obsolete, and excessive inventory.
What is an AR aging schedule?
An AR aging schedule is a report that organizes a company’s outstanding receivables by customer and by how long each invoice has been unpaid. Conventionally, it uses monthly aging buckets: Current, 1-30, 31-60, 61-90, and 90+ days past due.
An aging schedule shows your finance team which balances have become overdue and helps them prioritize collections and evaluate each customer’s credit risk. Since collections probability goes down the longer an invoice goes unpaid, it also helps finance teams estimate how much outstanding revenue is likely to convert into cash.
What are good percentages for each aging bucket?
There isn’t a universal “good” percentage for every aging bucket because payment terms, industry norms, and billing cycles vary, as does the mix of customers every business serves. In general, though, you want as much of your receivables concentrated in Current and the youngest overdue bucket as possible, with progressively smaller amounts in older buckets.
A healthy aging profile usually means very little AR is 60+ or 90+ days past due. But rather than relying on a single benchmark, compare your bucket percentages with your own historical performance and watch for increases in older receivables over time. If long-overdue balances keep increasing, you know something has to be done about your collections process.