An unpaid invoice does not always mean a customer is late. One invoice may be due next month, another may be overdue, and a third may already have been paid but recorded incorrectly.
An accounts receivable aging report helps you separate these situations. It organizes outstanding customer balances so you can see what is owed and which amounts need attention.
Learning how to read an accounts receivable aging report starts with checking its date and settings. From there, you can interpret the aging columns, investigate unusual balances, and prepare a sensible follow-up list.
What Is an Accounts Receivable Aging Report?
An accounts receivable aging report groups unpaid customer balances into age ranges, often called aging buckets.
A summary report typically presents balances by customer. A detail report shows the individual transactions behind those balances, allowing you to investigate specific invoices, payments, and credits. Oracle’s documentation describes this distinction between its receivables summary and detail reports. docs.oracle.com
The report helps answer:
- Who owes the business money?
- How much remains unpaid?
- Which amounts are overdue?
- Which invoices need investigation or follow-up?
It is a snapshot of recorded receivables, not a guarantee of when customers will pay.
Check These Settings Before Reading the Numbers
1. The Report Date
Look for an “as of” date.
A report dated 31 October represents balances at that date. A payment received on 1 November may therefore leave the invoice outstanding in the October report.
Also check whether the software ages balances using today’s date or the selected report date. Intuit documents both approaches and explains that mismatched settings can affect comparisons with other accounting reports. quickbooks.intuit.com
2. The Aging Basis
Confirm whether age is measured from:
- Invoice date: How long the invoice has existed.
- Due date: How long payment has been overdue.
These are different measurements.
For example, an invoice issued 45 days ago on 60-day payment terms is not yet overdue. An invoice-date report may show it as 45 days old, while a due-date report should still classify it as current.
FreshBooks explicitly distinguishes outstanding balances aged from the invoice issue date from overdue balances aged from the due date. FreshBooks
3. Currency and Filters
Check whether the report:
- Includes all relevant customers.
- Excludes particular accounts or transaction types.
- Shows original currencies or converted amounts.
- Includes customer credits and unapplied payments.
Do not add different currencies together without an appropriate conversion basis.
Understand the Aging Columns
The following structure assumes aging is based on days past the due date.
| Column | Typical meaning |
|---|---|
| Current | Not overdue as of the report date |
| 1–30 days | Payment is 1–30 days overdue |
| 31–60 days | Payment is 31–60 days overdue |
| 61–90 days | Payment is 61–90 days overdue |
| 91+ days | Payment is more than 90 days overdue |
| Total | Customer’s net outstanding balance shown in the report |
Software may use different intervals or labels. Intuit’s guidance, for example, distinguishes current amounts from balances aged by days after their due dates. quickbooks.intuit.com
An amount in the oldest bucket deserves investigation, but age alone does not establish that it is uncollectible.
Example: Reading an Accounts Receivable Aging Report
The following figures and customer names are hypothetical. All amounts use the same currency, and balances are aged by due date.
Report date: 31 October
| Customer | Current | 1–30 days | 31–60 days | 61–90 days | 91+ days | Total |
|---|---|---|---|---|---|---|
| Cedar Studio | $1,200 | $300 | $0 | $0 | $0 | $1,500 |
| Harbor Retail | $0 | $800 | $400 | $0 | $0 | $1,200 |
| Maple Services | $600 | $0 | $0 | $500 | $0 | $1,100 |
| Summit Projects | $0 | $0 | $0 | $0 | $700 | $700 |
| Total | $1,800 | $1,100 | $400 | $500 | $700 | $4,500 |
Read Across Each Customer Row
Cedar Studio owes $1,500, but only $300 is overdue. The remaining $1,200 is current.
Harbor Retail owes $1,200 across two overdue buckets. Open the detail report to identify the invoices involved.
Maple Services has both current and older balances. Do not assume its full $1,100 is late.
Summit Projects has $700 more than 90 days overdue. Investigate the reason, previous contact, and any payment arrangement.
Read Down Each Aging Column
The column totals show the overall distribution:
- Current: $1,800.
- Overdue: $2,700.
- More than 60 days overdue: $1,200.
This helps you identify where attention is concentrated.
Calculate the Overdue Percentage
Overdue percentage = Overdue receivables ÷ Total receivables × 100
For this example:
$2,700 ÷ $4,500 × 100 = 60%
That means 60% of the balances shown are overdue.
It does not mean 60% will be lost. Compare the result with your payment terms, previous reports, disputes, and customer circumstances.
This simple calculation assumes positive receivables without unapplied credits. If credits materially affect the report, investigate them before interpreting the ratio.
Use the Detail Report Before Contacting Customers
A summary balance is a starting point. Review the underlying invoice before sending a reminder.
Check:
| Detail | Why it matters |
|---|---|
| Invoice number | Identifies the exact charge |
| Invoice and due dates | Confirms whether it is late |
| Remaining balance | Prevents requesting an amount already paid |
| Payment and credit allocations | Reveals incomplete accounting entries |
| Purchase order reference | Helps the customer process the invoice |
| Dispute status | Determines whether clarification is needed |
| Previous correspondence | Prevents conflicting follow-ups |
A partially paid invoice should contribute its remaining balance rather than its original total. Unapplied payments and credits can also affect customer totals, depending on the report. docs.oracle.com
Common Problems to Investigate
A Customer Says They Already Paid
Check the bank record, payment date, customer account, and allocation.
The payment may have been recorded after the report date or left unapplied to the invoice.
Ask for a payment reference through an appropriate private channel if necessary. Avoid sending repeated demands before checking the records.
A Negative Balance Appears
A negative amount may represent a credit, overpayment, or unapplied receipt. It does not automatically mean the report is wrong.
Investigate the transaction and its correct treatment rather than deleting it to make the total look cleaner.
The Aging Report Does Not Match the Balance Sheet
Compare the reports using the same date, relevant accounts, currency basis, and appropriate accounting settings.
Check filters, opening balances, and entries affecting receivables. Intuit specifically recommends matching report dates and using an accrual-basis balance sheet or trial balance when checking its aging reports. quickbooks.intuit.com
Ask your bookkeeper to investigate unresolved differences.
The Due Date Is Wrong
A default payment term may differ from the agreed contract.
Check the original agreement before correcting the record. Do not change dates merely to move an overdue balance into a newer bucket.
Turn the Report Into a Follow-Up Plan
Prioritize using more than age alone.
Consider the outstanding amount, payment history, dispute status, previous promises, and cash-flow importance.
| Situation | Practical next step |
|---|---|
| Current invoice | Confirm it was delivered correctly; avoid an overdue demand |
| Recently overdue | Send a polite reminder |
| Missing PO or processing information | Supply the required details |
| Disputed charge | Assign someone to resolve the issue |
| Agreed payment date missed | Follow up on the recorded commitment |
| Long-overdue balance without progress | Escalate under your approved process |
Australian government guidance recommends starting with a friendly reminder and discussing a payment date or schedule where appropriate. Formal recovery steps require attention to applicable obligations. business.gov.au
Polite Reminder Template
Subject: Payment reminder — invoice [number]
Hello [name],
Our records show an outstanding balance of [amount] on invoice [number], due on [date].
Could you please confirm the expected payment date? If payment has already been made, please share the payment reference so we can check our records.
If you need another copy of the invoice or additional processing information, please let us know.
Thank you,
[Name and business]
Use this after checking the invoice and recent payments. Keep payment disputes and personal information out of public channels.
What the Report Cannot Tell You
An aging report does not independently establish:
- Whether an invoice is correct.
- Why payment is delayed.
- Whether a customer can pay.
- Whether the balance is legally recoverable.
- The appropriate bad-debt allowance or tax treatment.
- When cash will reach your bank account.
Do not automatically write off every invoice in the oldest bucket. Assess the facts and follow the applicable accounting and tax requirements.
Create a Regular Review Routine
Choose a frequency that fits your invoice volume and cash-flow needs. A weekly operational review may suit a busy credit-sales business; another business may need a different schedule.
For each balance requiring action, record:
- Responsible staff member.
- Last contact date.
- Reason for delay.
- Agreed action.
- Promised payment date.
- Next review date.
Compare successive reports using consistent settings. A falling total is encouraging only when you understand whether it reflects payments, credits, write-offs, or other changes.
Frequently Asked Questions
1. What is the difference between accounts receivable and accounts payable aging?
Receivable aging concerns amounts customers owe your business. Payable aging concerns amounts your business owes suppliers.
2. Does “current” mean the customer has paid?
No. In a due-date-based report, current generally means the outstanding amount is not overdue.
3. Can one customer appear in several aging buckets?
Yes. Different invoices can have different due dates. Review the detail report before treating the customer’s entire balance as overdue.
4. Is every invoice over 90 days overdue a bad debt?
No. It requires investigation, but age alone does not determine collectibility or the correct accounting treatment.
5. Can I use the aging report as a cash-flow forecast?
Use it as an input. Add realistic collection dates, payment arrangements, disputes, and other expected cash movements to build a forecast.
Conclusion
Read the report in three stages: confirm the settings, understand the balances, and investigate the invoices requiring attention.
Then assign clear follow-up actions and keep payment records current. The report becomes useful when its numbers lead to accurate conversations, resolved discrepancies, and realistic collection plans.


