Accounts Receivable Aging Report: How to Read, Analyze & Improve AR
An accounts receivable aging report is a financial report that organizes outstanding customer invoices according to how long they have remained unpaid or past due. It shows who owes money, how much is outstanding, and how long the balance has been unpaid.
Finance and collections teams use an AR aging report to prioritize collection activity, monitor customer payment behavior, identify potentially risky receivables, support cash flow planning, and evaluate the effectiveness of credit and collections processes.
An aging report is more than a list of unpaid invoices. When analyzed over time, it can show whether receivables are becoming older, whether overdue balances are concentrated among specific customers, and where finance teams may need to investigate disputes, payment delays, or credit exposure.
This guide explains accounts receivable aging reports, aging buckets, report formats, calculations, examples, analysis techniques, collection priorities, bad-debt considerations, and how automation and AI can improve receivables management.
What Is an Accounts Receivable Aging Report?
An accounts receivable aging report is a time-based snapshot of outstanding customer receivables. It groups open invoice balances into aging categories according to how long they have remained outstanding or past due.
A typical report uses categories such as:
- Current: Invoices that are not yet past due.
- 1–30 days past due: Recently overdue invoices.
- 31–60 days past due: Moderately overdue invoices.
- 61–90 days past due: Older overdue invoices requiring closer attention.
- 91+ days past due: Significantly overdue balances requiring investigation and appropriate escalation.
The exact aging structure can vary by business, payment terms, industry, accounting system, and internal credit policies.
The report may also be called an AR aging report, A/R aging report, accounts receivable ageing report, aged receivables report, or aging schedule.
Accounts Receivable Aging Report vs. Aging Analysis
Although the terms are closely related, an aging report and aging analysis serve different purposes.
| Concept | What It Means |
|---|---|
| AR Aging Report | A report showing outstanding receivables organized by age or past-due status. |
| AR Aging Analysis | The process of interpreting the report to identify risks, trends, collection priorities, and required actions. |
| AR Aging Schedule | A structured listing of receivables by customer, invoice, and aging category. |
In simple terms, the report tells you what is outstanding; the analysis helps explain what it means and what to do next.
What Does an AR Aging Report Show?
An accounts receivable aging report provides a customer- and invoice-level view of outstanding receivables. The exact columns vary by accounting system, but a useful report typically includes:
- Customer Name: Identifies the customer with the outstanding balance.
- Invoice Number: Identifies the individual receivable.
- Invoice Date: Shows when the invoice was issued.
- Due Date: Shows when payment was expected.
- Original Amount: Shows the original invoice value.
- Current Balance: Shows the amount still outstanding.
- Days Past Due: Shows how far the invoice is beyond its due date when applicable.
- Aging Bucket: Classifies the balance according to its age.
- Collection Status: May identify follow-up, disputes, promises to pay, or other collection information.
- Total Due: Shows outstanding balances by customer and across the portfolio.
These fields allow finance teams to move from a single total AR balance to a more actionable view of customer-level exposure.
Accounts Receivable Aging Buckets Explained
Aging buckets divide open receivables into time ranges. A common structure is:
| Aging Bucket | Typical Meaning | Typical Focus |
|---|---|---|
| Current | Not yet past due | Normal monitoring |
| 1–30 Days | Recently overdue | Reminder and payment-status follow-up |
| 31–60 Days | Increasingly overdue | Investigate payment barriers and prioritize follow-up |
| 61–90 Days | Materially overdue | Escalate collection attention and investigate exceptions |
| 91+ Days | Significantly overdue | Review collection strategy, credit exposure, disputes, and collectability |
Older buckets generally warrant greater attention, but aging alone does not prove that an invoice will become uncollectible. Customer circumstances, disputes, payment commitments, credit information, and other factors should also be considered.
How Is an AR Aging Report Generated?
An AR aging report is normally generated from the accounts receivable records in an accounting or ERP system. The process typically involves:
- Collect receivables data: Gather open invoices, payments, credit memos, and relevant adjustments.
- Establish the reporting date: Define the date as of which the report is being prepared.
- Determine due dates: Use the payment terms associated with each invoice.
- Calculate aging: Determine the invoice’s age or days past due using the organization’s defined methodology.
- Assign aging buckets: Classify each outstanding balance into the appropriate category.
- Aggregate balances: Calculate totals by customer, bucket, business unit, or other reporting dimensions.
- Review exceptions: Investigate unusual balances, unapplied payments, disputes, credits, or data-quality issues.
The accounting or ERP system is typically the primary source for the underlying receivables data. Automated reporting can reduce repetitive preparation work and make it easier to refresh aging information consistently.
How to Calculate Accounts Receivable Aging
The calculation depends on the purpose of the analysis. For collections, aging is commonly based on the invoice due date so that the report distinguishes receivables that are not yet due from those that are actually overdue.
Days Past Due = As-of Date − Due Date
If the result is zero or negative, the invoice can generally remain in the current category. Positive results can then be assigned to the relevant aging bucket.
For example, if an invoice was due on June 1 and the report date is June 21:
- As-of date: June 21
- Due date: June 1
- Days past due: 20 days
- Aging category: 1–30 days past due
The accounts receivable aging analysis process provides the broader framework for interpreting these calculations.
Invoice Age vs. Days Past Due
| Measure | Calculation | Purpose |
|---|---|---|
| Invoice Age | As-of Date − Invoice Date | Measures how long the invoice has existed. |
| Days Past Due | As-of Date − Due Date | Measures how late the payment is. |
Keeping these concepts separate helps prevent an old invoice that is still within its payment terms from being incorrectly treated as delinquent.
Accounts Receivable Aging Report Format and Example
A typical AR aging report uses rows for customers or invoices and columns for aging categories. It may also include invoice dates, due dates, original amounts, current balances, and totals.
Accounts Receivable Aging Report As of: [Report Date] Customer Invoice Due Date Balance Current 1-30 31-60 61-90 91+ ------------------------------------------------------------------------------------------------ Customer A INV-001 [Date] $1,000 $1,000 $0 $0 $0 $0 Customer B INV-002 [Date] $2,500 $0 $2,500 $0 $0 $0 Customer C INV-003 [Date] $1,500 $0 $0 $1,500 $0 $0 Customer D INV-004 [Date] $3,000 $0 $0 $0 $3,000 $0 Customer E INV-005 [Date] $500 $0 $0 $0 $0 $500 ------------------------------------------------------------------------------------------------ Total $8,500 $1,000 $2,500 $1,500 $3,000 $500
This format makes it possible to see not only the total receivable balance, but also where that balance is concentrated across aging categories.
AR Aging Summary vs. Detail Report
Businesses commonly use both summary and detail versions of aging reports.
| Report | Purpose | Best Used For |
|---|---|---|
| AR Aging Summary | Shows customer balances by aging bucket. | Management reporting, portfolio review, and high-level risk analysis. |
| AR Aging Detail | Shows individual invoices and their aging information. | Collections follow-up, dispute investigation, and customer-level analysis. |
The accounts receivable aging report sample provides additional context on how an aging report can be structured.
Why Is an Accounts Receivable Aging Report Important?
An AR aging report helps finance teams understand the quality, timing, and risk of outstanding receivables. Its main uses include:
- Collections prioritization: Identify overdue accounts that need attention.
- Cash flow visibility: Understand the timing and risk of expected customer cash inflows.
- Credit risk monitoring: Identify recurring late-payment patterns.
- Bad-debt analysis: Provide receivables data for evaluating potential collection losses.
- Working-capital management: Highlight cash tied up in overdue receivables.
- Management reporting: Give finance leaders a structured view of receivables health.
- Process improvement: Reveal recurring problems with billing, payment, disputes, or collections.
The report is therefore both an operational collections tool and an important source of financial insight.
How to Read and Analyze an AR Aging Report
The most useful AR aging analysis does not stop at the total receivables balance. It examines where the balances are, how they are changing, who owes them, and why they are overdue.
1. Review the Oldest Balances
Start by examining the 61–90 and 91+ day categories. Identify the customers, invoice values, disputes, promises to pay, and collection status associated with these balances.
2. Review Movement Between Buckets
Compare the current report with previous periods. A receivable moving from 1–30 to 31–60 and then to 61–90 without payment indicates deterioration. Conversely, balances moving out of older buckets can indicate improving collections.
3. Identify Customer Concentration
Aging risk can be concentrated in a small number of customers. Identify customers contributing a significant share of overdue receivables and review their payment history, credit exposure, and current collection status.
4. Investigate Why Balances Are Overdue
An aging report tells you what is overdue, but not necessarily why it is overdue. Possible causes include:
- Customer cash-flow constraints
- Invoice errors
- Missing purchase orders
- Pricing or contract disputes
- Product or service disputes
- Approval delays
- Missing remittance information
- Payment processing issues
- Incorrect or unapplied payments
This distinction matters because different causes require different responses.
5. Compare Aging Over Time
A single aging report is a snapshot. Comparing reports across periods can reveal whether overdue balances are improving, deteriorating, or remaining concentrated in the same customers or business segments.
6. Connect Aging to Collection Action
Use the analysis to create actionable collection priorities rather than simply producing another report. The appropriate response can depend on the age, value, customer relationship, payment history, dispute status, and risk of each receivable.
Accounts Receivable Aging Analysis Example
Consider a company with $500,000 in outstanding receivables:
| Aging Category | Balance | Share of Total |
|---|---|---|
| Current | $300,000 | 60% |
| 1–30 days | $100,000 | 20% |
| 31–60 days | $50,000 | 10% |
| 61–90 days | $30,000 | 6% |
| 91+ days | $20,000 | 4% |
| Total | $500,000 | 100% |
The analysis should not conclude simply that the company has $500,000 in AR. It should identify that $100,000 is more than 30 days past due and investigate the customers and causes behind that balance.
For example, if most of the 91+ day balance belongs to one customer with an unresolved billing dispute, the appropriate response may be dispute resolution rather than simply increasing collection pressure.
What Red Flags Should You Look for in AR Aging?
Common warning signs include:
- Growing 61–90 or 91+ balances: May indicate deteriorating collection performance.
- Repeatedly aging customers: May indicate persistent payment problems or credit risk.
- Rapid growth in overdue AR: May signal changes in customer behavior or weaknesses in the collection process.
- Large customer concentration: A significant overdue balance concentrated in one customer increases exposure to that customer’s payment behavior.
- Recurring disputes: May indicate upstream problems in billing, pricing, contracts, or fulfillment.
- Unapplied payments: Can make customer balances appear inaccurate until payments are correctly matched.
- Increasing total AR without corresponding cash collection: May warrant investigation into collection effectiveness and sales growth quality.
The enhanced capabilities for accounts receivable analysis can help organizations move beyond static reporting toward deeper receivables analysis.
How AR Aging Supports Cash Flow Management
Accounts receivable aging provides visibility into the receivables that may contribute to future cash inflows and highlights balances where collection timing is uncertain.
- Identify overdue balances that may delay expected cash.
- Prioritize collection activity based on aging and exposure.
- Monitor changes in overdue receivables over time.
- Identify customer concentrations that could affect cash flow.
- Support receivables-focused cash flow forecasting.
A growing balance in older aging categories can indicate that expected customer cash may arrive later than planned. However, an aging report should be used alongside other forecasting inputs rather than treated as a guarantee of future collections.
The existing resource on improving cash flow forecasting provides related guidance.
The existing page also contains a reference to cash received and cash-flow visibility, which can remain part of the site’s internal linking structure.
AR Aging and Credit Risk
AR aging can provide useful evidence for reviewing customer payment behavior and credit exposure.
Customers who repeatedly move into older aging buckets may warrant additional review of:
- Payment history
- Credit limits
- Payment terms
- Outstanding exposure
- Dispute history
- Promises to pay
- Recent changes in payment behavior
Aging should not be used as the only measure of credit risk. It becomes more useful when combined with broader customer and credit information.
AR Aging and Bad Debt Estimation
The age of receivables is an important consideration when estimating potential collection losses. Older receivables may have a greater risk of non-collection, but aging alone does not determine the actual amount that will become uncollectible.
The aging method groups receivables into time buckets and applies estimated uncollectibility rates to those buckets. The resulting estimate can contribute to the allowance for doubtful accounts or other applicable accounting assessment, depending on the organization’s accounting framework and methodology.
A simplified conceptual calculation is:
Estimated Uncollectible Amount = (Current AR × Current Loss Rate) + (1–30 AR × 1–30 Loss Rate) + (31–60 AR × 31–60 Loss Rate) + (61–90 AR × 61–90 Loss Rate) + (91+ AR × 91+ Loss Rate)
The actual assumptions and accounting treatment should be based on the company’s applicable accounting policies, historical experience, current information, and relevant accounting requirements.
Key Metrics to Analyze With an AR Aging Report
An aging report becomes more useful when analyzed alongside broader AR performance metrics.
Days Sales Outstanding (DSO)
DSO measures the average number of days it takes to collect receivables. It provides a portfolio-level view of collection performance, while aging provides more granular visibility into individual balances and aging categories.
A useful DSO formula is:
DSO = (Average Accounts Receivable ÷ Credit Sales) × Number of Days in Period
Average Days Past Due
Average days past due provides another view of how long overdue invoices remain unpaid.
Collection Effectiveness Index (CEI)
CEI evaluates the effectiveness of collections over a defined period. It can complement aging information by helping finance teams assess collection performance.
The aging report provides the detailed receivables context behind these broader metrics.
AR Aging Report Challenges
Manual Processes and Human Error
Manual collection of invoice, payment, credit, and due-date information can create data-entry errors and delays in updating the aging report.
Incomplete or Inaccurate Data
Missing payment details, incorrect invoice information, unapplied cash, and unresolved credits can distort the customer balance shown in an aging report.
High Transaction Volumes
Large receivables portfolios can make spreadsheet-based aging difficult to maintain and analyze consistently.
Inconsistent Credit and Collection Practices
Different payment terms, collection approaches, and escalation practices across teams can make aging trends harder to interpret and manage.
Difficulty Identifying Root Causes
An aging report identifies overdue balances but may not explain whether the underlying cause is a dispute, billing problem, customer cash-flow issue, approval delay, or payment-processing problem.
These issues are part of the broader accounts receivable challenges that finance teams need to address.
Best Practices for Improving Accounts Receivable Aging
- Define a consistent aging methodology. Document whether aging is based on invoice date, due date, or another approved basis.
- Use a clear reporting date. Every report should make its as-of date clear.
- Review aging regularly. The appropriate frequency depends on transaction volume, payment terms, and business risk.
- Prioritize by risk and value. Do not focus only on the oldest invoice; consider amount, customer exposure, payment history, and disputes.
- Resolve billing disputes quickly. Legitimate disputes can keep invoices overdue even when customers intend to pay.
- Monitor recurring late payers. Repeated aging patterns can inform credit and collection decisions.
- Improve invoicing accuracy. Incorrect invoices can create avoidable payment delays.
- Improve cash application. Payments should be matched and recorded promptly so customer balances remain accurate.
- Compare aging across periods. Trend analysis is more informative than a single report.
- Automate repetitive activities. Automation can reduce manual reporting work and allow finance teams to focus on exceptions and decisions.
How Automation and AI Improve AR Aging
Automation can transform AR aging from a periodic manual report into a more continuous monitoring and action process.
Automated AR Reporting
Automated systems can collect receivables information and generate aging reports without requiring finance teams to repeatedly assemble data manually.
Automated Cash Application
Accurate payment application helps ensure that customer balances reflect payments that have actually been received. Incorrect or delayed application can make aging data less reliable.
AI-Powered Collections
AI can help analyze payment patterns, prioritize accounts for attention, identify potential exceptions, and support more targeted collection workflows.
Real-Time or Scheduled Aging Visibility
Automated dashboards can make aging information available more frequently, allowing finance teams to identify changes in overdue balances sooner.
Root-Cause and Exception Management
Advanced receivables platforms can connect aging information with disputes, payment information, customer behavior, and collection activity so teams can investigate why balances are overdue rather than simply seeing that they are overdue.
The goal is not simply to automate report generation. The larger opportunity is to connect:
Receivables Data
↓
Aging Analysis
↓
Risk & Prioritization
↓
Collection Action
↓
Exception Resolution
↓
Cash Collection
↓
Continuous Monitoring
Businesses can evaluate the benefits of automated accounts receivable solutions when considering this transition.
How Emagia Helps With Accounts Receivable Aging
Emagia’s receivables management and automation capabilities are designed to support finance teams across the broader Order-to-Cash process, including receivables visibility, collections, cash application, and reporting.
For AR aging, technology can help finance teams move from manually compiling reports toward more connected receivables monitoring and action.
- Automated receivables reporting
- Accounts receivable aging visibility
- Collection workflow support
- Payment and cash application automation
- Customer payment behavior analysis
- Exception identification
- Receivables performance monitoring
The objective is to help finance teams identify aging risk earlier, prioritize the right accounts, and spend less time on repetitive receivables administration.
Organizations can explore broader AR solutions when evaluating ways to improve receivables processes and aging performance.
Accounts Receivable Aging Checklist
- Define the report’s as-of date.
- Confirm the aging methodology.
- Verify invoice and due-date data.
- Include payments, credits, and adjustments.
- Calculate days past due consistently.
- Assign balances to aging buckets.
- Reconcile bucket totals with the underlying AR balance.
- Identify significant overdue customers.
- Review 61–90 and 91+ day balances.
- Investigate disputes and exceptions.
- Compare current aging with previous periods.
- Review customer concentration.
- Connect aging findings to collection actions.
- Review credit exposure for recurring late payers.
- Consider potential bad-debt implications using the appropriate accounting methodology.
- Automate repetitive reporting where practical.
Frequently Asked Questions About Accounts Receivable Aging Reports
What is an accounts receivable aging report?
An accounts receivable aging report is a financial report that organizes outstanding customer invoices by how long they have remained unpaid or past due. It commonly uses categories such as current, 1–30 days, 31–60 days, 61–90 days, and 91+ days.
What is the purpose of an accounts receivable aging report?
The purpose of an AR aging report is to provide visibility into outstanding receivables, prioritize collection activity, identify overdue and potentially higher-risk balances, support cash flow planning, and provide information for credit and bad-debt analysis.
What do accounts receivable aging reports show?
AR aging reports typically show customers, invoices, invoice and due dates, outstanding balances, aging categories, and totals. Depending on the system, they may also include payment status, collection notes, disputes, or other account information.
What are the common AR aging buckets?
Common aging buckets are current, 1–30 days past due, 31–60 days past due, 61–90 days past due, and 91+ days past due. Companies may customize these categories according to their payment terms and reporting requirements.
How do you calculate days past due?
Days past due can be calculated as the as-of date minus the invoice due date. Positive results indicate that the invoice is past due, while invoices that have not reached their due date remain current under a due-date-based aging methodology.
How do you read an AR aging report?
Start by reviewing older aging buckets, then examine movement between buckets, customer concentration, disputed balances, recurring late payers, and changes from previous reporting periods. The objective is to identify which receivables require action and why they are overdue.
What is the difference between an AR aging summary and detail report?
An AR aging summary report provides a high-level view of customer balances by aging bucket. An AR aging detail report lists individual invoices and their aging information, making it more useful for collections follow-up and exception investigation.
How does an AR aging report help cash flow?
An AR aging report shows where customer receivables are concentrated and which balances are overdue. This helps finance teams identify potential collection delays, prioritize follow-up, and improve visibility into expected receivables-related cash inflows.
How does AR aging support bad-debt estimation?
AR aging provides the time-based receivables information used by aging-based methods for estimating potential collection losses. Older balances may receive higher estimated loss rates, but the actual methodology and assumptions depend on the company’s accounting framework, historical experience, and other relevant information.
How can automation improve AR aging?
Automation can reduce manual effort involved in collecting receivables data, generating aging reports, updating balances, monitoring overdue accounts, prioritizing collection activity, and producing management reports.
What are aged receivables?
Aged receivables are outstanding customer balances that have remained unpaid long enough to move into older aging categories. They generally require greater attention because prolonged non-payment can increase collection and credit risk.
