LedgerUp Resources
Accounts Receivable Aging: Reports, Schedules & Analysis Guide
Accounts receivable aging is a periodic report that categorizes outstanding invoices by the length of time they have been unpaid, giving finance teams a clear picture of collection health and cash flow risk.
In This Article
What Is Accounts Receivable Aging?
Accounts receivable aging — sometimes called an AR aging analysis or aging of receivables — is the process of sorting unpaid customer invoices into time-based buckets according to how long each invoice has been outstanding. The resulting report is one of the most critical tools in credit management, cash-flow forecasting, and financial reporting.
The core premise: the longer an invoice remains unpaid, the less likely it is to be collected at full value. Research from the Commercial Collection Agency Association shows that the probability of collecting an account drops to roughly 73% after 90 days and below 50% after six months.
Finance teams use the AR aging report for:
- Cash-flow visibility — Understanding when receivables are likely to convert to cash.
- Credit-risk assessment — Identifying customers who consistently pay late.
- Allowance for doubtful accounts — Estimating bad-debt reserves by applying historical loss rates to each aging bucket.
- Collections prioritization — Directing effort toward the highest-risk invoices first.
- Audit readiness — Auditors routinely request the aging schedule as supporting evidence for net-realizable-value assertions.
The AR Aging Report Explained
An AR aging report organizes every open invoice into columns representing elapsed time since the payment due date. The standard aging buckets are:
- Current — Not yet past due
- 1–30 days past due — Recently overdue; addressed with a friendly reminder
- 31–60 days past due — Requires follow-up; may indicate a dispute
- 61–90 days past due — Elevated risk; escalation to management
- 90+ days past due — High risk; may warrant third-party collections
Book a LedgerUp Demo
Stop chasing invoices manually. LedgerUp’s AI agent Ari automates collections, reduces DSO, and recovers revenue on autopilot.
Book a LedgerUp DemoSample AR Aging Report
| Customer | Current | 1–30 | 31–60 | 61–90 | 90+ | Total |
|---|---|---|---|---|---|---|
| Acme Corp | $24,000 | $8,500 | — | — | — | $32,500 |
| Beacon Analytics | $12,000 | $12,000 | $6,200 | — | — | $30,200 |
| CloudBridge Inc | $9,600 | — | $4,800 | $4,800 | — | $19,200 |
| DataStream SaaS | — | $5,400 | $5,400 | $5,400 | $10,800 | $27,000 |
| Evergreen Logistics | $18,000 | — | — | — | — | $18,000 |
| TOTAL | $63,600 | $25,900 | $16,400 | $10,200 | $10,800 | $126,900 |
| % of Total | 50.1% | 20.4% | 12.9% | 8.0% | 8.5% | 100% |
In this example, roughly half of all receivables are current — a healthy sign. However, DataStream SaaS shows balances across every overdue bucket, including $10,800 at 90+ days, warranting immediate escalation.
LedgerUp Insight: The workflow described above is one that LedgerUp automates end-to-end. Teams using LedgerUp typically cut manual effort by 80% and reduce errors across their billing pipeline.
How to Create an AR Aging Schedule
Step 1: Pull All Open Receivables
Export every unpaid invoice from your billing or accounting system. Each record should include: customer name, invoice number, invoice date, payment due date, and outstanding amount.
Step 2: Determine the Aging Basis
Decide whether to age from the invoice date or the due date. Most organizations age from the due date because it reflects agreed-upon payment terms.
Step 3: Categorize into Aging Buckets
For each invoice, calculate days past due and assign to the appropriate bucket. In a spreadsheet, a nested IF formula works. In SQL, a CASE WHEN statement against a DATEDIFF result achieves the same outcome.
Step 4: Aggregate and Analyze
Summarize by customer. Add totals and percentage rows. Compare current period distribution to prior periods to identify trends. A rising share in the 61–90 and 90+ buckets is an early warning.
How to Analyze an AR Aging Report
Concentration Risk
If a single customer represents more than 15–20% of total receivables, your cash flow is disproportionately dependent on their payment behavior.
Trends Over Time
Compare snapshots across consecutive periods. If the 31–60 bucket has grown from 8% to 14% over two quarters, your collections process needs attention.
Customer-Level Patterns
Differentiate between one-time delays (invoice disputes) and chronic patterns. For repeat offenders, consider adjusting credit terms or requiring prepayment.
Percentage of Total AR Overdue
Benchmark: if more than 20–25% of total receivables are past due, the business has a collections problem. For B2B SaaS with monthly invoicing, 15% overdue should trigger a process review.
Relationship to DSO
DSO gives you a single summary number; the aging report gives you the distribution behind it. Two companies can have the same 45-day DSO but very different aging profiles.
AR Aging Best Practices
1. Review the Aging Report Weekly
Monthly is insufficient for fast-moving B2B businesses. Weekly cadence ensures newly overdue invoices are caught within days, not weeks.
2. Set Escalation Triggers by Bucket
Define explicit actions: 1–30 days = automated reminder, 31–60 = phone call + account manager CC, 61–90 = AR manager escalation, 90+ = executive review.
3. Automate Follow-Up Communications
Use your billing platform to send templated reminders at predefined intervals. Automation ensures no invoice falls through the cracks.
4. Flag Disputes Early
Tag disputed invoices separately. If your aging report doesn't distinguish between genuinely overdue and disputed invoices, you'll misallocate collections effort.
5. Segment by Customer Type
Enterprise customers with Net 60 terms will naturally appear in later buckets than SMBs on Net 30. Create separate aging reports for each segment.
6. Track Aging Trends Monthly
Build a dashboard showing percentage of AR in each bucket over 6–12 months. Trend data is more actionable than any single snapshot.
How LedgerUp Helps
LedgerUp automates the entire AR lifecycle for B2B SaaS: real-time aging dashboards, intelligent dunning sequences triggered by aging bucket, dispute tracking, and payment-prediction scoring that flags at-risk invoices before they become delinquent.
Frequently Asked Questions
What is accounts receivable aging?
Accounts receivable aging categorizes outstanding invoices by time past due — typically Current, 1–30, 31–60, 61–90, and 90+ days — so finance teams can assess collection risk and prioritize follow-ups.
What are the standard aging buckets?
The five standard buckets are: Current (not past due), 1–30 days, 31–60 days, 61–90 days, and 90+ days past due. Some organizations add 91–120 and 120+ buckets for more granularity.
How often should I run an aging report?
Weekly is best practice. Companies with high invoice volume or short payment terms benefit especially from weekly reviews. At minimum, run monthly as part of your close process.
What percentage overdue is concerning?
If more than 20–25% of total AR is past due, collections likely need attention. For B2B SaaS with monthly invoicing, 15% overdue should trigger a review.
Should I age from invoice date or due date?
Most organizations age from the due date because it reflects contractual payment terms. Aging from invoice date overstates lateness for customers on Net 60 or Net 90 terms.
How do I use aging to estimate bad debt allowance?
Apply historical loss rates to each bucket. For example: 1% of current, 5% of 1–30, 10% of 31–60, 20% of 61–90, 40% of 90+. Sum the results for your total allowance estimate.
Book a LedgerUp Demo
See how LedgerUp connects your CRM, billing, and ERP systems to eliminate manual work and accelerate revenue.
Get Started with LedgerUp