What is an accounts receivable aging report and why your business needs one

Getting paid on time is still a real challenge for small businesses in 2026. In the Intuit QuickBooks Small Business Insights survey, 56% of U.S. small businesses said they have invoices overdue by more than 30 days, which is a direct hit to cash flow.

An accounts receivable (AR) aging report helps you stay in control. It groups unpaid invoices by how long they’ve been outstanding, like 0–30, 31–60, 61–90, and 90+ days, so you can quickly see who owes you money, how much, and how late it is. That visibility makes it easier to prioritize follow-ups, forecast cash flow, and spot patterns before they turn into bigger problems.

And when you pair your aging report with automation, like Intuit’s AI Payments Agent, you can track balances, send proactive reminders, and reduce the manual work of chasing payments, helping you get paid faster.

To help you get started, we’re answering your common questions and addressing the basics of accounts receivable aging reports.

What is an accounts receivable aging report?

An accounts receivable (AR) aging report categorizes outstanding customer invoices by how long they have been overdue, typically in 30 day intervals. It gives you a clear view of which customers are behind on payments, helping you identify collection risks early, estimate potential bad debt, and maintain healthier cash flow. With U.S. small businesses carrying hundreds of billions in unpaid invoices at any given time, consistent AR tracking is not just helpful, it is essential for financial stability.

What does an accounts receivable aging report show you?

An accounts receivable aging report, also known as an aging schedule, pulls all open invoices from your accounts receivable (A/R) and groups them into distinct date ranges. Rather than looking at individual due dates, you can see at a glance how long each invoice has been unpaid, so you can prioritize your collection efforts.

If you’re just learning how to calculate accounts receivable, aging reports are a good place to start—they give you the data you need to measure how efficiently you’re collecting payments.

Invoice date ranges commonly found on an aging schedule include:

• Current: Invoices not past due
• 1–30 days: Past due for 1–30 days
• 31-60 days: Past due for 31–60 days
• 61–90 days: Past due for 61–90 days
• 91+ days: Past due for 91 or more days

You can customize these ranges to fit your business needs. The aging report helps you see who’s paying on time and who’s falling behind, giving you a clear picture of your cash flow and collections efforts.

How accounts receivable aging reports help your business stay on top of payments

Maintain healthy cash flow

Steady cash flow keeps your business moving. An accounts receivable aging report shows you which invoices are still open and how long they’ve been outstanding, so you can see what’s overdue and take action before cash flow gets tight.

Identify late-paying customers and credit risks

Putting together regular accounts receivable aging reports, which you can easily do with invoicing software, allows you to identify regular late-paying customers. You can then avoid sending goods and services to customers before late payments become an issue and hamper cash flow.

This is also possible with QuickBooks software. ​​You can see which customers have past due balances in QuickBooks, and how long each transaction is past due. Go to reports in your software and visit the “Who owes you” section, then select “Accounts receivable aging detail.”

Guide your collections strategy

You can also use these reports to guide your collections strategy and follow-up efforts. The image below shows an example of a call script you can use when contacting customers about late or missed payments. This visual serves as the accounts receivable aging report in action—helping you follow up effectively based on payment timelines.

Improve accounts receivable turnover

AR aging reports are important because they can help businesses keep track of outstanding payments from customers. You can generate an accounts receivable aging report to calculate and improve your accounts receivable turnover ratio.

How to create an AR aging report

Preparing an accounts receivable aging report is relatively straightforward. To get started, follow these steps:

1. Gather unpaid invoices

In step one, you’ll gather all the unpaid invoices you have for customers. That’s any invoice with an open balance on it, even if it’s a partial balance. Fortunately, accounting software like QuickBooks can pull these automatically.

2. Calculate days past due

For each invoice, you’ll want to calculate the number of days past due. For example, if the invoice was due on the 15th and it’s now the 22nd, the invoice is seven days past due. In QuickBooks, this calculation is done automatically for you, so you always have up-to-date information.

3. Categorize invoices

Next, group each customer's invoices based on your aging schedule, using custom date ranges that fit your business needs. 

For example, if a customer has the following unpaid invoices: 

• One invoice for $1,000 that is not past due
• Two invoices that total $1,500 and are 15 days overdue
• One invoice for $100 that is 37 days overdue 

Your categorized accounts receivable aging report would look like this:

• Current: $1,000
• 1–30 days: $1,500
• 31–60 days: $100

4. Create an aging schedule

You’ll list all your customers that have an open invoice and then do the same thing we did in step three for all your customers. Once complete, you can total the amounts to see how much of your invoices are current, 1-30 days past due, and so on. 

How to get more value from your AR aging report

An accounts receivable (AR) aging report is more than just a list of unpaid invoices. It’s a tool that gives you insight into how well you’re managing collections, credit, and cash flow. Here’s how to put it to work:

Monitor and protect cash flow

Your aging report is like an early-warning system for cash flow. It helps you spot overdue invoices quickly, prioritize follow-ups, and remove roadblocks that slow down payments. When you address issues sooner, you’re less likely to get caught off guard by a cash crunch.

Estimate and plan for bad debt

Not every invoice gets paid. Your aging report helps estimate how much you may never collect, called bad debt, so that you can plan accordingly.

Here’s how a business might calculate its allowance for doubtful accounts:

This $32,000 estimate can help you update your allowance for doubtful accounts and stay realistic about your expected income.

As invoices age, they become less likely to be collected. Use those trends to estimate bad debt and update your allowance for doubtful accounts, so your income projections stay grounded in what you’re actually likely to collect.

Strengthen credit policies and customer risk management

Your aging report can also reveal credit policy red flags. If one customer consistently pays late, it may be time to limit their credit. But if multiple customers fall behind, your credit terms might be too lenient.

Use your report to:

• Identify high-risk customers
• Compare your credit risk to industry benchmarks
• Tighten or revise your credit terms

Also, review your collections process. If you notice frequent payments passing the 60- or 90-day mark, leverage QuickBooks to send invoices faster or offer early payment discounts.

Result: Stronger credit controls, faster payments, and a healthier bottom line.

Use AR insights to improve business strategy

AR data can inform more than collections. Over time, your aging report shows which customers are reliable and which ones create uncertainty, which is helpful when you’re deciding who gets ongoing credit terms. You can also plan purchases, staffing, or delivery schedules around your most likely cash inflows.

When you use historical aging trends to forecast and budget, your AR report becomes a tool for steady, sustainable growth rather than just a list of past-due invoices.

Run your business with confidence

An accounts receivable aging report gives you a clear view of who owes you, how much, and for how long, so you can act fast to improve cash flow. Whether it’s sending a quick reminder or escalating to collections, you’ll know exactly where to focus.

Accounting software like QuickBooks puts your accounts receivable on autopilot. Because your books update with every payment you take, your AR aging report is always tax-ready and accurate without manual intervention, giving you bookkeeping without the busywork.