Overdue invoices quietly drain the cash your business needs to operate, invest, and grow. An AR aging report gives you a clear picture of which customers owe you, how long payments have been outstanding, and where your collections process is breaking down.

This guide breaks down what an AR aging report is, how to build and calculate one, how to read a sample, and how to act on what it tells you. The goal is simple: protect your cash flow and build stronger customer relationships.

Key takeaways

• Reviewing your AR aging report regularly protects cash flow. It helps you spot late payments early, read customer payment patterns, and make informed decisions about extending credit.
• Your AR aging percentage shows how well you manage collections. A high share of overdue invoices flags problems in your invoicing, credit policies, or collection strategies.
• Modern AR tools automate the work and surface insights. From automated invoicing and smart dunning to real-time reporting and analytics, they help you optimize AR and make data-driven decisions.

What is an AR aging report?

An accounts receivable (AR) aging report is a snapshot of your outstanding invoices, categorized by how long they've gone unpaid. It shows, at a glance, which customers owe you money and how long those payments have been outstanding. This information is critical for maintaining healthy cash flow and making informed decisions about extending credit. For a deeper background, see Investopedia's overview of accounts receivable aging.

Here's what separates a static report from a modern one. A basic report shows when invoices are due. Modern revenue automation goes further—it forecasts when cash will actually land, based on contract terms and historical payment behavior. Tabs uses AI to read the commercial context behind each contract, translating terms into accurate billing and revenue recognition rather than just flagging overdue balances.

Key components and aging buckets

AR aging reports organize invoices into time buckets, usually in 30-day intervals. This grouping—sometimes called an accounts receivable aging schedule—shows how long each invoice has been overdue. A typical report includes these buckets:

• Current (0 days): Invoices that are not yet due.
• 1–30 days past due: Invoices between one and 30 days overdue.
• 31–60 days past due: Invoices between 31 and 60 days overdue.
• 61–90 days past due: Invoices between 61 and 90 days overdue.
• Over 90 days past due: Invoices more than 90 days overdue, carrying the highest risk of non-payment.

Each bucket shows the total amount owed for that period, so you can quickly see which invoices need attention. Most reports also include customer names and contact details, which streamlines follow-up. A comprehensive report may add credit memos—records of reductions to a customer's balance—and collection notes that track your outreach.

For SaaS teams handling subscription billing, this payment history is essential for protecting recurring revenue. FreshBooks offers a useful breakdown of AR aging reports, and our guide to outstanding invoices covers follow-up tactics.

How to read and interpret your AR aging report

Start by locating each customer's outstanding balance and how it splits across the aging buckets. This lets you see who is current and who is falling behind, along with the total due in each period. Reviewing the aging of accounts receivable this way—weekly or monthly—keeps small issues from becoming big ones.

Then interpret the pattern. A large share of invoices in the 90+ day bucket signals cash flow risk and a higher chance of bad debt. Look for trends: is one customer consistently late? Are delays tied to specific products or terms? These insights help you proactively address potential issues before they escalate.

A high percentage in the older buckets often points to gaps in your invoicing processes, credit policies, or collections. Tabs uses AI to extract key contract terms and turn them into accurate invoices and follow-up, while real-time reporting shows what's been invoiced, collected, and recognized.

How to calculate your AR aging percentage

Your AR aging percentage shows what portion of your outstanding invoices is past due, broken down by how overdue they are. It's key for spotting cash flow issues and making informed decisions about your credit policies.

1. Organize your outstanding invoices by age. Group them into time buckets, typically 30, 60, 90, and 120+ days overdue. Tabs can generate this report automatically.
2. Total the outstanding invoices in each bucket. Sum all invoices 30 days overdue, then 60 days, and so on.
3. Total all outstanding invoices. This is the sum of every bucket.
4. Divide each bucket by the total and multiply by 100. The result is that bucket's percentage.

Here's an example. Say your total outstanding invoices are worth $100,000. Of that, $20,000 is 30 days overdue, $15,000 is 60 days overdue, $10,000 is 90 days overdue, and $5,000 is over 120 days overdue:

• 30 days: ($20,000 / $100,000) × 100 = 20%
• 60 days: ($15,000 / $100,000) × 100 = 15%
• 90 days: ($10,000 / $100,000) × 100 = 10%
• 120+ days: ($5,000 / $100,000) × 100 = 5%

A higher percentage in the older buckets means your collections need focused attention. For more on interpreting these numbers, see Upflow's guide to aging reports and AR metrics.

Average collection period (DSO) formula

The average collection period (ACP), also known as days sales outstanding (DSO), tells you how long it takes, on average, to collect payment on your invoices. A shorter ACP is generally better, indicating efficient collections. Calculate it with this formula: (Days in period × Average accounts receivable) / Net credit sales. For a 90-day ACP, multiply 90 by your average AR balance over those 90 days, then divide by net credit sales for the same period.

AR aging report example

Numbers make the concept concrete. Here's a simple AR aging report for three customers:

This sample reveals the risk fast: $6,000—roughly 19% of the $32,000 total—sits in the 90+ day bucket with Globex Inc, so that account needs immediate follow-up. Use this layout as your own AR aging report template, or let real-time reporting generate it automatically from your billing data.

How to use your AR aging report

An AR aging report is a working tool, not a static document. Use it in three ways.

Manage cash flow and forecast collections

Cash flow is the lifeblood of any business, and your AR aging report helps you manage it. By reviewing overdue invoices by age, you can forecast incoming cash and plan expenses with confidence. If a large block sits in the 60+ day category, prioritize those customers before the gap hits your books. Some pricing models also produce steadier payments than others. For more on how aging shapes financial planning, see HubiFi's guide to accounts receivable aging reports.

Reduce bad debt and sharpen credit decisions

A high concentration of overdue invoices often means your credit terms are too lenient. Your report helps you estimate potential bad debt and set your allowance for doubtful accounts. Use the trends to tighten qualification criteria, shorten payment deadlines, or adjust limits for existing customers. Automated billing keeps invoices accurate, and revenue recognition software keeps your financial reporting compliant as those decisions play out.

Prioritize collections and protect customer relationships

Segment your outreach by invoice age. A gentle reminder fits a slightly overdue invoice; a direct conversation fits a 90+ day balance. Collect on the oldest invoices first, since they carry the highest risk of becoming bad debt. Align invoices with each customer's payment cycle so they arrive with time to process. For recurring billing, Tabs automates this timing, and flexible payment options make it easier for customers to pay on time—improving collection rates without straining the relationship.

Common AR aging challenges and how to solve them

Tackling late payments

Reach out promptly once an invoice is overdue. A friendly reminder often works, and for repeat late payers, automated reminders keep follow-up consistent without extra effort from your team.

Offering extended payment terms

If a client always pays but pays late, extending net-30 to net-45 can be a win-win. Document the agreement clearly, monitor it closely, and offer flexible payment terms that still ensure you get paid.

Withholding services for overdue invoices

For significantly overdue accounts, temporarily withholding services can motivate payment. Communicate the policy upfront in your contracts, and frame it as a temporary measure until the balance is settled.

Working with collection agencies

Treat a collections agency as a last resort. Exhaust calls, emails, and payment plans first, then choose a reputable agency experienced in your industry and clear on its fee structure.

Maintaining accurate AR data

Reconcile your AR aging report against the general ledger regularly to catch discrepancies. Strong internal controls—like double-checking invoice details before sending—prevent errors in invoicing and payment processing.

Limitations of AR aging reports

Why it matters: An AR aging report tells you what is overdue, not why. Read it alongside customer context before you act.

An AR aging report has real limits. It's a snapshot taken at a single moment, so month-end timing can distort the picture—an invoice paid the next day still shows as overdue. Disputed invoices and partial payments skew the buckets, making balances look worse or better than they are. And the report never explains why a customer is late. Pair it with customer context and payment history before you take action.

How to automate AR aging with Tabs

Manual AR—generating reports, sending invoices, chasing payments—drains time and invites errors. AR automation software handles the routine work so your team can focus on strategy. Tabs goes further than generic automation.

Tabs uses AI to read the commercial context in each signed contract—pricing, terms, and escalators—and extract key contract terms into accurate invoices. It doesn't just capture data. It understands the business implications and translates them into correct billing and compliant revenue recognition.

From there, Tabs automates invoicing, applies ASC 606-compliant revenue recognition, and gives finance real-time billing visibility. Smart dunning is tuned to each customer's payment behavior, flexible payment options reduce friction, and higher collection rates follow—with less manual work.

Ready to turn your AR aging report into faster collections? See Tabs in action.

Related articles

• All About AR Aging Reports
• Is Accounts Receivable Debit or Credit?
• A/R Accounts: Your Guide to Managing Receivables

Frequently asked questions

Why is my AR aging percentage so high?

A high AR aging percentage, especially in the older time buckets (90+ days), typically indicates that a significant portion of your outstanding invoices are overdue. This could be due to several factors, including lenient credit policies, ineffective collection strategies, or issues with your invoicing process. Examine your AR aging report closely to pinpoint where the bottlenecks are. Are certain customer segments consistently late with payments? Are there recurring issues with specific products or services? These insights can help you refine your credit policies, implement more proactive collection strategies, and improve your overall invoicing process.

How can I improve my collections process without damaging customer relationships?

Balancing efficient collections with positive customer relationships requires a nuanced approach. Start by segmenting your customers based on their payment history. For those who are consistently prompt, a simple thank you can go a long way. For occasional late payers, a friendly reminder before the due date is often sufficient. When an invoice becomes overdue, reach out to the customer promptly and inquire about the reason for the delay. There might be a legitimate reason, and a simple conversation can often resolve the issue. For chronic late payers, consider implementing stricter credit terms or offering incentives for early payment. The key is to maintain open communication and treat each customer with respect throughout the process.

What are the key metrics to track in my AR aging reports?

Beyond the total amount overdue, several key metrics provide valuable insights into your AR aging. Focus on the percentage of your total AR that falls into each aging bucket (e.g., 0-30 days, 31-60 days, etc.). A high percentage in the older buckets signals potential cash flow problems. Also, track your Days Sales Outstanding (DSO), which measures the average number of days it takes to collect payment. A rising DSO can indicate deteriorating collection efficiency. Finally, monitor trends in customer payment behavior. Are certain customers consistently late? Are there patterns related to specific products or services? These trends can help you proactively address potential issues before they escalate.

What's the difference between an AR aging report and a balance sheet?

While both provide information about your finances, they serve different purposes. Your balance sheet provides a snapshot of your company's assets, liabilities, and equity at a specific point in time. Accounts receivable is listed as a current asset, representing the total amount owed to your company. An AR aging report, on the other hand, provides a more detailed breakdown of your accounts receivable, categorizing outstanding invoices by age. This granular view helps you understand not just how much is owed, but also how long it's been outstanding, which is crucial for managing collections and forecasting cash flow.

How can software help me manage my AR aging more effectively?

AR management software can automate many of the tedious tasks associated with tracking and collecting payments. These platforms can automatically generate aging reports, send payment reminders, and even flag high-risk accounts. This automation frees up your team to focus on more strategic activities, like building customer relationships and improving collection strategies. Many AR platforms also offer robust reporting and analytics features, providing valuable insights into your payment trends and overall financial health. This data-driven approach empowers you to make informed decisions about credit policies, collections strategies, and overall financial planning.

What is an accounts receivable aging schedule?

An accounts receivable aging schedule is the underlying table that groups your receivables by age bucket. The AR aging report is how that schedule is presented and analyzed.

What is a good AR aging percentage?

There's no universal number. Most current invoices should sit in the 0–30 day bucket, and a rising share in the 90+ day bucket signals credit or collections problems. Benchmark against your own payment terms rather than a fixed target.