Accounts Receivable Aging Report: Small-Business Guide
Accounts Receivable Aging Report: A Complete Guide for Small Businesses
Your total accounts receivable balance tells you how much customers owe.
It does not tell you how much is overdue, how long invoices have remained unpaid or which accounts require immediate attention.
An accounts receivable aging report answers those questions by separating outstanding invoices according to age.
Used correctly, the report becomes more than an accounting document. It becomes a working collection tool.
What is an accounts receivable aging report?
An accounts receivable aging report organizes unpaid customer invoices into time-based categories called aging buckets.
A typical report contains:
- Current invoices
- 1–30 days overdue
- 31–60 days overdue
- 61–90 days overdue
- More than 90 days overdue
The report may also show:
- Customer name
- Invoice number
- Invoice date
- Due date
- Original invoice amount
- Outstanding balance
- Total amount owed by each customer
- Collection notes
- Dispute status
- Last contact date
- Next planned action
The purpose is to show not only how much money is outstanding but where collection risk may be building.
What do the aging buckets mean?
Current
These invoices have not reached their due date.
Current does not mean they should be ignored. Large invoices, new customers and accounts with complicated approval procedures may benefit from a courteous pre-due-date confirmation.
1–30 days overdue
These invoices are recently past due.
The first step is usually to confirm that the invoice was received and determine whether an administrative problem is delaying payment.
31–60 days overdue
At this stage, follow-up should become more direct.
The business should identify disputes, request a payment status and obtain a specific payment date when possible.
61–90 days overdue
These balances require greater attention.
Management may need to review continued credit, broken payment promises, unresolved disputes and the likelihood of collection.
More than 90 days overdue
Invoices in this category may represent elevated collection risk.
The business should verify the documentation, determine why payment remains outstanding and decide whether internal escalation or qualified outside assistance is appropriate.
How to calculate invoice age
Invoice age should normally be measured from the contractual due date—not automatically from the invoice date.
For example:
- Invoice date: July 1
- Payment terms: Net 30
- Due date: July 31
- Reporting date: August 20
The invoice is 20 days overdue on August 20.
If the report calculates age from July 1, it would incorrectly show the invoice as 50 days old without distinguishing between the allowed payment period and actual delinquency.
Why aging reports matter
Aging reports help businesses:
- Identify overdue balances
- Detect growing collection problems
- Prioritize follow-up activity
- Review customer payment behavior
- Track disputed invoices
- Evaluate credit decisions
- Estimate allowance for doubtful accounts
- Support cash-flow planning
- Monitor collection performance
The report also helps expose operational weaknesses. If many invoices become overdue for the same reason, the problem may be billing accuracy or internal workflow—not customer behavior.
Example of an aging report
| Customer | Current | 1–30 Days | 31–60 Days | 61–90 Days | 90+ Days | Total |
|---|---|---|---|---|---|---|
| Customer A | $8,000 | $0 | $0 | $0 | $0 | $8,000 |
| Customer B | $0 | $4,500 | $0 | $0 | $0 | $4,500 |
| Customer C | $0 | $0 | $7,200 | $0 | $0 | $7,200 |
| Customer D | $0 | $0 | $0 | $3,100 | $6,500 | $9,600 |
Customer D deserves attention because the account contains both 61–90-day and 90-plus-day balances.
However, the report alone does not explain whether the invoices are disputed, covered by a payment arrangement or already scheduled for payment.
Analyze your own receivables
Use the free Accounts Receivable Aging Calculator to enter balances by aging category and calculate:
- Total accounts receivable
- Total overdue receivables
- Percentage overdue
- Percentage more than 60 days overdue
- Distribution by aging bucket
The calculator provides directional analysis. It is not a substitute for reviewing individual customer accounts.
How to use the report for collections
Do not simply start with the oldest invoice and work downward.
Consider:
- Amount outstanding
- Days overdue
- Customer payment history
- Recent communication
- Broken payment promises
- Open disputes
- Last follow-up date
- Strategic importance
- Likelihood of recovery
Read How to Prioritize Overdue Invoices for a more complete prioritization method.
Aging report versus DSO
An aging report and Days Sales Outstanding measure different things.
An aging report shows where unpaid balances are sitting. DSO estimates how long the business takes to convert credit sales into cash.
Use the free DSO Calculator to measure collection speed, then compare that result with the aging report.
A reasonable DSO can still conceal several severely overdue invoices.
Common aging-report mistakes
Avoid:
- Aging invoices from the wrong date
- Leaving paid invoices open
- Ignoring credits and partial payments
- Combining disputed and undisputed balances
- Failing to update payment promises
- Using broad customer totals without invoice detail
- Treating every overdue balance the same
- Allowing multiple spreadsheet versions to circulate
The report must be accurate before it can guide action.
Turn aging data into a workflow
A report identifies the problem. It does not manage the follow-up.
PaymentPilot’s AI accounts receivable software helps small businesses organize invoices, identify priority accounts, review recommended next actions and maintain collection history with human oversight.
Use your aging report to determine where money is sitting, then make sure every important overdue invoice has an owner and next action.
Additional business resources
Use the free Small Business Assessment Tool to review additional operational and insurance considerations.
To discuss your business, schedule a 30-minute conversation.
Samuel Bennett, Licensed Insurance Agent
Island Insurance Group
sam@islandinsurancegroup.com
954-804-8144
This article provides general information and is not accounting, financial or legal advice. Aging methods and reporting practices should be reviewed with a qualified accounting professional.
