Accounts receivable aging report: How to use it to get paid faster

Published Friday 3 July 2026

Table of contents

• What is an accounts receivable aging report?
• What does an accounts receivable aging report show?
• How to read an accounts receivable aging report
• Why does an AR aging report matter for cash flow?
• How to create an AR aging report
• How do you use an AR aging report to get paid faster?
• What red flags should you watch in AR aging?
• Streamline collections with Xero
• FAQs on accounts receivable aging report

Key takeaways

• Use an accounts receivable aging report to group unpaid invoices by age so you can focus collections and speed up cash flow.
• Follow a standard aging schedule: current, 1 to 30, 31 to 60, 61 to 90, and 90+ days; older aged receivables need faster action.
• Turn overdue invoice analysis into steps: send reminders, offer easy payment options, tighten terms, and resolve disputes quickly.
• Use aging buckets to guide credit limits and estimate your allowance for doubtful accounts.

What is an accounts receivable aging report?

An accounts receivable (AR) aging report (also called an aging schedule or aging report) groups unpaid customer invoices into date ranges to show how long each amount has been outstanding. Think of it as a snapshot that reveals which customers owe you money and how overdue those invoices are.

The report organizes invoices by the number of days past their due date, making it easier to prioritize collection efforts. Instead of scrolling through a long list of unpaid bills, you see clear categories that tell you exactly where to focus your time.

Every business that extends credit to customers needs this report. Whether you're a contractor waiting on progress payments, a consultant tracking retainer invoices, or a product supplier managing net-30 terms, the accounts receivable aging report helps you stay on top of what's owed.

The longer an invoice sits unpaid, the harder it becomes to collect. An aging report brings that urgency into focus by showing you which invoices are slipping into risky territory. It transforms a messy pile of receivables into an organized action plan.

What does an accounts receivable aging report show?

An accounts receivable aging report shows who owes you, how much, and how late, so you can see risk at a glance and understand how to read each column. The report typically includes several key data points that help you assess the health of your receivables.

Customer name and contact details

Each line on the report lists the customer name, making it easy to identify who owes you money. Some reports also include contact details like email addresses or phone numbers, so you can reach out quickly without hunting for information elsewhere.

Total open balance per customer and per invoice

You'll see the total amount each customer owes, broken down by individual invoice. This helps you understand whether a customer has one large overdue bill or several smaller ones that add up to a significant balance.

Aging buckets

The report divides invoices into aging buckets based on how many days they're past due. Standard buckets are:

• Current: Invoices not yet due or due today
• 1 to 30 days: Invoices 1 to 30 days overdue
• 31 to 60 days: Invoices 31 to 60 days overdue
• 61 to 90 days: Invoices 61 to 90 days overdue
• 90+ days: Invoices more than 90 days overdue

These buckets let you prioritize your collection process. A customer with $5,000 in the 90+ column needs immediate attention, while a customer with $500 in the 1 to 30 column might just need a gentle reminder.

Invoice counts, due dates, and amounts per bucket

The report shows how many invoices fall into each bucket and lists their original due dates. This detail helps you track patterns – if a customer consistently pays 45 days late, you can adjust their terms or require deposits on future work.

Notes for disputes, promised pay dates, and credit holds

Good AR aging reports include space for notes. You can flag invoices that are disputed, record when a customer promised to pay, or mark accounts on credit hold. These notes keep your team aligned and prevent duplicate follow-up calls.

Last payment date to support overdue invoice analysis

Seeing when a customer last paid helps you gauge their reliability. If they paid on time for six months and are now 60 days late, it might signal a cash flow problem on their end. If they've never paid on time, you might need to tighten terms or stop extending credit altogether.

For more on managing your overall receivables process, see Xero’s guide on accounts receivable process.

How to read an accounts receivable aging report

Reading an AR aging report helps you turn data into decisions. You scan from left to right across each row to see who owes you, how much, and how overdue their balance is. The further right a balance sits, the more urgent the action required.

Follow these steps each time you review the report:

1. Check the 90+ column first

Any balance here is at serious risk of becoming bad debt. These accounts need immediate outreach, not a routine reminder. The longer an invoice sits in this bucket, the lower your chances of collection become. Focus your energy on these accounts before they become write-offs.

2. Review the 61 to 90 column next

Balances here are overdue enough to warrant a direct call or a formal payment request, not just an email. These invoices are entering dangerous territory and need personal attention. Consider offering payment plans or discussing any issues that might be preventing payment.

3. Scan the 31 to 60 column for patterns

If the same customers appear here month after month, they are a credit risk worth addressing with tighter terms. Look for customers who consistently pay late and consider adjusting their credit limits or requiring deposits on future orders. This bucket often reveals your most problematic accounts.

4. Look at the current and 1 to 30 columns for volume

A large share of your receivables here is healthy. If these columns are shrinking while older columns grow, your collections process needs attention. Most of your receivables should sit in these two buckets if your credit and collection processes are working effectively.

5. Check the total column for concentration

If one or two customers make up a large share of your total receivables, you are exposed to concentration risk. A single non-payment could significantly affect your cash flow. Consider diversifying your customer base or setting stricter credit limits for large accounts to reduce this exposure.

Why does an AR aging report matter for cash flow?

Accounts receivable aging turns data into actions that improve collections and stability. When you know which invoices are aging and by how much, you can make smarter decisions about where to focus your energy and how to protect your business from bad debt.

Prioritizes who to contact based on age and balance

Not all overdue invoices deserve the same level of urgency. A $10,000 invoice that's 90 days late is a bigger threat to your cash flow than a $200 invoice that's 10 days late. The aging report helps you rank customers by risk so you can tackle the biggest problems first.

Forecasts incoming cash more confidently using aging buckets

When you review your aging report regularly, you start to see patterns. If most customers in the 1 to 30 bucket pay within a week of follow-up, you can forecast that cash coming in. If your 90+ bucket rarely converts, you know not to count on it. This insight helps you plan payroll, supplier payments, and other expenses more accurately.

Reduces bad debt with earlier follow-up and cleaner documentation

The sooner you follow up on an overdue invoice, the more likely you are to get paid. The aging report flags invoices as they slip from current to 1 to 30 days, giving you a clear signal to act. Early action also means better documentation – you can resolve disputes, confirm receipt, and update contact details before the trail goes cold.

Tracks days sales outstanding (DSO) trends to spot slowdowns

Days sales outstanding (DSO) measures how long it takes to collect payment after a sale. By tracking your aging report over time, you can calculate DSO and spot trends. If your average DSO is creeping up, it's a sign that your collection process is slowing down, and you need to tighten your approach.

For more on what receivables mean for your business, read what is accounts receivable.

How to create an AR aging report

Building or refreshing an accounts receivable aging report in software or a spreadsheet using consistent buckets takes just a few steps. Whether you're using accounting software or setting up a manual process, the goal is the same: organize your unpaid invoices by age so you can act on them quickly.

1. Gather open invoices and credit notes

Start by pulling a list of all unpaid invoices. Include invoice numbers, customer names, issue dates, due dates, amounts due, and any partial payments already received. Don't forget to account for credit notes or adjustments that reduce what a customer owes.

If you're using accounting software, this data should be easy to export. If you're working manually, gather it from your invoicing system, email records, and bank statements.

2. Calculate days past due

Days past due equals today's date minus the due date. If an invoice was due on March 1 and today is March 15, it's 14 days past due. Invoices that aren't due yet (or are due today) have a value of zero or less and sit in the current column.

Most accounting software calculates this automatically. If you're building a spreadsheet, use a simple formula: =TODAY() - [Due Date].

3. Set standard aging buckets

Use consistent aging buckets so you can compare reports from month to month. The standard buckets are:

• current
• 1 to 30 days
• 31 to 60 days
• 61 to 90 days
• 90+ days

Some businesses add more granular buckets (like 0 to 15, 16 to 30) if they need tighter control, but the five-bucket structure works for most small businesses.

4. Sort by buckets and risk

Group invoices by bucket, then sort by largest balances within each bucket. This gives you a clear view of where the biggest risks are. Flag high-risk customers based on payment history, credit limits, and the size of their outstanding balance.

For example, a customer with $8,000 in the 90+ bucket who has a history of late payments is a higher priority than a reliable customer with $1,000 in the 31 to 60 bucket.

5. Add notes and validate

Capture any relevant context: promised pay dates, disputes, partial payment plans, or credit holds. Then reconcile your totals to make sure the aging report matches your general ledger. Apply credits and allocations correctly so your report reflects the true amount owed.

Once your report is complete, review it for accuracy. Double-check customer names, invoice numbers, and amounts. A clean, accurate report is the foundation of an effective collection process.

For more on managing the broader invoicing workflow, see invoicing process.

How do you use an AR aging report to get paid faster?

You turn AR aging insights into a weekly action list that speeds up collections and improves customer communication. The report is only valuable if you act on it. Here's how to translate the data into steps that get invoices paid.

Prioritize follow-up by age and amount

Start with the invoices that pose the biggest risk to your cash flow. Focus on the largest balances in the 61 to 90 and 90+ day buckets first. These invoices are at the highest risk of becoming bad debt, so they deserve immediate attention.

• Call or email the largest balances in 61 to 90 and 90+ days first.
• For 31 to 60 days, request a promised payment date and confirm receipt of invoices.
• For current and 1 to 30 days, send light reminders to prevent slippage.

Don't wait until an invoice is 90 days late to take action. Early, consistent follow-up keeps invoices from aging into risky buckets in the first place.

Automate reminders and monthly statements

Set up automated reminders to go out before and after due dates. A friendly reminder a few days before an invoice is due can prompt payment and prevent it from becoming overdue. A follow-up reminder a few days after the due date keeps the invoice top of mind.

• Schedule reminders before and after due dates to keep invoices visible.
• Send monthly statements that summarize what is owed and by when.
• Use consistent templates so tone and timing stay professional.

Monthly statements give customers a complete picture of their account, including all open invoices and any credits. This reduces confusion and makes it easier for them to prioritize payment.

Offer payment links and multiple options

Make it as easy as possible for customers to pay. Include payment links on every invoice so customers can pay with a credit card, debit card, or automated clearing house (ACH) transfer. The fewer steps between opening the invoice and making a payment, the faster you'll get paid.

• Add payment links on invoices for cards, ACH, or direct debit.
• Offer short payment plans on large balances to reduce friction.
• Save customer payment methods where appropriate and allowed.

For customers with large balances, consider offering a payment plan. Breaking a $10,000 invoice into four $2,500 payments over two months can make it easier for them to pay and easier for you to collect.

Estimate bad debt from aging buckets

The aging report helps you estimate your allowance for doubtful accounts. Apply higher reserve percentages to older buckets to model credit risk. For example, you might assume 2% of invoices in the 1 to 30 bucket will become uncollectible, 10% in the 61 to 90 bucket, and 50% in the 90+ bucket.

• Apply higher reserve percentages to older buckets to model risk.
• Review write-offs and adjust allowance rates based on trends.

This approach helps you set realistic expectations for how much of your receivables will actually turn into cash. For more on managing cash flow challenges, see accounts receivable financing.

Resolve disputes with clean documentation

If a customer disputes an invoice, log the reason, assign an owner, and set a next action date. Attach supporting documentation like purchase orders, delivery receipts, or signed contracts to speed up resolution.

• Log the dispute reason, owner, and next action date.
• Attach proofs like purchase orders or deliveries to speed decisions.
• Set internal service targets so issues do not age into riskier buckets.

The faster you resolve disputes, the faster you can collect payment. Don't let disputed invoices linger – tackle them with the same urgency as overdue invoices.

For practical tips on following up, take a look at how to chase outstanding invoices.

What red flags should you watch in AR aging?

Your overdue invoice analysis should surface signals so you can address them early. The aging report is more than a collection tool; it's an early warning system so you can protect your cash flow. Watch for these patterns and take action before they become serious issues.

See a high share of balances in 61 to 90 or 90+ days

If a large percentage of your total receivables sits in the oldest buckets, it's a sign that your collection process isn't working. Ideally, most of your receivables should be current or in the 1 to 30 bucket. If you're seeing 20% or more in the 90+ bucket, you need to tighten your follow-up process and consider writing off uncollectible accounts.

Notice slower collections compared to recent periods

Compare your aging report from this month to last month and the same month last year. If your current and 1 to 30 buckets are shrinking while your older buckets are growing, it's a clear trend that collections are slowing down. Investigate why – are customers struggling financially, or has your follow-up process become inconsistent?

Spot repeated lateness from key customers or industries

If the same customers show up in the older buckets every month, they're a pattern risk. Similarly, if you notice that all your customers in a particular industry (like construction or retail) are paying late, it might signal broader economic trouble in that sector. Adjust your credit terms or require deposits from these customers to protect your business.

Find many disputes tied to invoice accuracy or approvals

A high volume of disputed invoices suggests problems with your invoicing process. Are you billing for the right amounts? Are your invoices clear and easy to understand? Are customers receiving invoices on time? Fix these process issues to reduce disputes and speed up payment.

Rely on a few large customers for most aged receivables

If one or two customers make up a large share of your aged receivables, you're exposed to concentration risk. If one of those customers stops paying, it could cripple your cash flow. Diversify your customer base and consider setting stricter credit limits for large accounts.

Miss follow-ups due to unclear ownership or manual tracking

If no one on your team is clearly responsible for collections, invoices will slip through the cracks. Assign ownership, set up a regular review schedule, and use software to automate reminders and tracking. Manual processes are too slow and too error-prone to keep up with a growing business.

Streamline collections with Xero

Xero simplifies accounts receivable aging with clear aged receivables, smart reminders, and easy payment options, so you spend less time chasing and more time growing. When your aging report is always up to date and your follow-up process is automated, you can focus on running your business instead of tracking down late payments.

With automated bank feeds and real-time reporting, you get an accurate picture of who owes you money without manual data entry. Set up payment reminders that go out automatically, and give customers multiple ways to pay with integrated payment links. Get one month free.

FAQs on accounts receivable aging report

Here are answers to common questions about using an accounts receivable aging report to improve collections and manage cash flow.

How often should I run an accounts receivable (AR) aging report?

Run your AR aging report at least once a week, and daily if you have high transaction volume or tight cash flow. Weekly reviews help you catch invoices as they slip into older buckets, so you can follow up before they become serious collection problems. Monthly reviews often miss issues early. If you wait that long, an invoice can already be 60 or 90 days overdue.

What are standard aging buckets?

Standard aging buckets are current, 1 to 30, 31 to 60, 61 to 90, and 90+ days. You use these to group invoices by how long they have been overdue so you can see which ones need attention first.

What is the accounts receivable aging list?

The accounts receivable aging list is another name for the accounts receivable aging report. The terms "aging list," "aging report," and "aging schedule" all refer to the same document: a summary of unpaid customer invoices grouped by how long they have been outstanding.

How do I calculate days past due?

Days past due equals today's date minus the due date. If an invoice was due on April 1 and today is April 20, it's 19 days past due. Invoices that aren't due yet (or are due today) have a value of zero or less and sit in the current column. Most accounting software calculates this automatically, but if you're using a spreadsheet, use a simple formula: =TODAY() - [Due Date].

What is a good AR aging profile?

A healthy AR aging profile has 80% or more of receivables in the current and 1 to 30 buckets, with less than 10% in the 61 to 90 and 90+ buckets. If you're seeing more than 20% of your receivables in the oldest buckets, it's a sign that your collection process needs tightening. Compare your profile to industry benchmarks to see how you stack up.

How do I estimate the allowance for doubtful accounts using aging?

Apply higher reserve percentages to older buckets to estimate your allowance for doubtful accounts. For example, you might assume 1% of current invoices will become uncollectible, 5% of 1 to 30, 15% of 31 to 60, 30% of 61 to 90, and 50% of 90+. Adjust these percentages based on your historical write-off rates and industry norms. This approach helps you set realistic expectations for how much of your receivables will turn into cash.

What is the difference between AR aging summary and detail?

An AR aging summary shows total amounts owed by each customer, grouped into aging buckets. It gives you a high-level view of who owes you and how overdue their balances are. An AR aging detail report breaks down each customer's balance by individual invoice, showing invoice numbers, dates, and amounts. Use the summary for quick reviews and the detail for deep dives when you're following up on specific invoices.