.png)
Why?
Because knowing how much customers owe tells only part of the story. Business owners should also understand how long those amounts have been outstanding.
That is where the accounts-receivable aging report becomes useful.
An aging report organizes unpaid customer invoices according to age. Instead of seeing one total receivable balance, the business can see which amounts are current and which have remained unpaid for 30, 60, 90, or more days.
The total accounts-receivable balance tells you how much customers owe. The aging report tells you how old that balance is.
For a business owner, that additional information can provide important insight into expected cash collections, customer-payment patterns, and the accuracy of the bookkeeping records.
🧾 What Is an Accounts-Receivable Aging Report?
An accounts-receivable aging report lists outstanding customer invoices and groups them according to how long they have remained unpaid.
A typical report might use categories such as:
- Current
- 1–30 days overdue
- 31–60 days overdue
- 61–90 days overdue
- More than 90 days overdue
The exact categories can vary by accounting system and the business's payment terms.
For example, a business with $20,000 in total accounts receivable might initially appear to have $20,000 of expected future cash collections.
But consider these two situations.
Business A
- Current: $17,000
- 1–30 days overdue: $2,000
- 31–60 days overdue: $1,000
- 61+ days overdue: $0
Business B
- Current: $3,000
- 1–30 days overdue: $2,000
- 31–60 days overdue: $3,000
- 61–90 days overdue: $4,000
- More than 90 days overdue: $8,000
Both businesses report $20,000 in accounts receivable.
But those balances tell very different stories.
Business A has most of its receivables in relatively recent invoices.
Business B has a significant amount concentrated in much older balances that deserve closer review.
That is why looking only at the total can be misleading.
🟢 What Does the “Current” Column Mean?
The Current category generally contains invoices that have not yet passed their payment due dates.
For example, suppose a business issues a $2,500 invoice with payment due in 30 days.
Before the due date, that receivable would generally appear as current.
A healthy current balance may simply mean the business regularly extends payment terms to customers.
However, even current receivables should be reviewed.
Ask:
- Does each invoice represent a valid sale?
- Was the invoice sent to the customer?
- Is the due date correct?
- Has the customer already paid through another system?
- Is the customer balance supported by appropriate documentation?
A current invoice is not necessarily a problem—but it should still be accurate.
🟡 What Does 1–30 Days Overdue Reveal?
Once an invoice passes its due date, it typically moves into an overdue aging category.
A balance in the 1–30 day range might indicate:
- A normal short payment delay
- A customer who pays slightly beyond terms
- An invoice that requires follow-up
- A payment that has been received but not applied
- A billing issue
- A dispute that has not been resolved
One overdue invoice may not signal a major problem.
A growing pattern of overdue invoices, however, may deserve attention.
For example, suppose last month's aging report showed:
1–30 days overdue: $4,000
This month it shows:
1–30 days overdue: $11,000
The business owner should ask why that category increased.
The answer could involve customer-payment behavior, increased sales, billing timing, or a bookkeeping issue.
The important point is to investigate rather than simply accept the number.
🟠 What About 31–60 and 61–90 Days?
As invoices continue aging, the business has waited longer to receive the related cash.
That matters because revenue may already have been recorded while the money needed to operate the business remains uncollected.
Older receivables may warrant questions such as:
- Has the customer acknowledged the invoice?
- Is the balance disputed?
- Was the invoice sent to the correct person?
- Has a payment been received but not applied?
- Was a credit supposed to be issued?
- Is the invoice duplicated?
- Is the customer experiencing payment difficulties?
- Does the balance still represent a valid amount owed?
The aging report does not answer those questions automatically.
It identifies where questions should be asked.
🔴 Why 90+ Day Balances Deserve Particular Attention
An invoice that remains unpaid for more than 90 days may require closer review.
That does not automatically mean the amount will never be collected.
But the longer a balance remains outstanding, the more important it becomes to understand why.
A 90+ day balance could represent:
- A genuinely slow-paying customer
- An unresolved dispute
- An invoice that was entered incorrectly
- A customer credit that was never applied
- A duplicate invoice
- A payment recorded to the wrong customer
- A balance requiring further evaluation
The key is not to assume.
Old does not automatically mean uncollectible—but old should rarely mean ignored.
💵 Accounts Receivable Is Not the Same as Cash
The aging report is especially important because accounts receivable represents expected collections—not money already sitting in the bank.
Suppose a business reports:
- Accounts receivable: $50,000
- Cash: $8,000
That $50,000 may eventually become cash, but the business cannot currently use it to pay:
- Rent
- Vendors
- Loan payments
- Insurance
- Other operating obligations
If $30,000 of that receivable is already more than 90 days old, the business owner's cash position may deserve considerably more attention than the total receivable balance initially suggests.
Revenue can be earned before cash is collected.
This is one reason a profitable business can still experience cash-flow pressure.
📈 What Changes in the Aging Report Can Reveal
Aging reports become even more useful when they are compared from month to month.
Suppose the business reviews the report at the end of each month.
Month 1
- Current: $25,000
- 1–30 days: $5,000
- 31–60 days: $2,000
- 61+ days: $1,000
Month 2
- Current: $22,000
- 1–30 days: $8,000
- 31–60 days: $5,000
- 61+ days: $3,000
The total receivable balance increased from $33,000 to $38,000.
But something else happened:
More of the balance moved into older aging categories.
That should prompt additional questions.
Has customer-payment timing changed?
Have invoices been entered incorrectly?
Are payments waiting to be applied?
Are certain customers responsible for most of the increase?
Looking at the trend provides more information than looking at one month's total.
🔍 The Aging Report Can Reveal Bookkeeping Problems Too
An aging report does not reveal only customer-payment issues.
Sometimes an old balance is actually a bookkeeping issue.
Payment received but not applied
A customer may have paid the invoice, but the payment was categorized directly from the bank feed rather than matched to the invoice.
The result?
- Cash may be correct.
- The invoice still appears outstanding.
- Accounts receivable may be overstated.
Customer credit not applied
A valid credit may exist but remain separate from the invoice.
The report continues to show a balance the customer does not truly owe.
Duplicate invoice
The same sale may have been entered twice.
One invoice is paid while the duplicate continues aging.
Payment applied to the wrong customer
The total cash may be correct, but individual customer balances become inaccurate.
Old unresolved invoice
An invoice may have remained on the books for months without anyone determining whether the balance is still valid.
These are reasons the aging report should be part of the bookkeeping-review process—not merely a collection report.
🧮 A Simple Case Example
Suppose your business has total accounts receivable of $24,000.
The aging report shows:
| Aging Category | Amount |
|---|---|
| Current | $11,000 |
| 1–30 Days | $5,000 |
| 31–60 Days | $3,000 |
| 61–90 Days | $2,000 |
| 90+ Days | $3,000 |
| Total | $24,000 |
At first, you might focus only on the $24,000 total.
But the aging report reveals that:
$8,000 is already more than 30 days overdue.
And:
$3,000 has been outstanding for more than 90 days.
Now you have better questions to ask.
- Which customers make up the $3,000?
- Are those invoices valid?
- Have any payments been received?
- Are there unresolved credits?
- Are the balances disputed?
- Has anyone reviewed the underlying documentation?
The aging report turns one number into actionable financial information.
⚠️ Common Mistake: Assuming an Aging Report Is Automatically Correct
Accounting software can produce an impressive-looking aging report.
That does not guarantee the underlying information is accurate.
The report depends on:
- Correct customer invoices
- Correct invoice dates
- Correct due dates
- Properly applied payments
- Properly recorded credits
- Accurate customer records
- Resolved duplicate transactions
If the underlying bookkeeping is wrong, the aging report can also be wrong.
This is why reports should be reviewed, not simply generated.
💻 Using Xero to Review Accounts Receivable
Cloud accounting software such as Xero can help organize:
- Customer invoices
- Outstanding balances
- Due dates
- Accounts-receivable aging
- Customer payments
- Credits
- Supporting documents
- Financial reports
Those tools can make the review process much more efficient.
However, software still depends on accurate bookkeeping.
A customer payment applied incorrectly can leave an invoice appearing overdue even though the customer has already paid.
An aging report is therefore most useful when the underlying accounts are current and properly maintained.
📊 Aging Reports and Cash-Flow Planning
Accounts-receivable aging also provides useful context for cash-flow discussions.
Suppose a business expects to collect $25,000 of its outstanding receivables next month.
If most of those receivables are current and customers historically pay according to terms, that expectation may be more reasonable.
But if much of the $25,000 has already been outstanding for 90 or more days, the owner may want to be more cautious when planning around those expected collections.
This does not require assuming that old balances will never be paid.
It simply means:
The timing and age of receivables should be considered when evaluating expected cash collections.
📅 A Practical Monthly Aging-Report Review
Business owners can make the aging report part of their monthly financial review.
1️⃣ Review the total
How much do customers currently owe?
2️⃣ Review the distribution
How much is current versus overdue?
3️⃣ Look for movement
Are balances moving into older categories?
4️⃣ Identify large items
Is one customer responsible for a significant portion of the balance?
5️⃣ Investigate unusual balances
Look for:
- Duplicate invoices
- Unapplied payments
- Old credits
- Disputes
- Incorrect customer assignments
- Unexpected aging
6️⃣ Compare with previous months
Is receivable aging improving, remaining stable, or getting older?
7️⃣ Consider cash-flow implications
How much of the outstanding balance is reasonably expected to become cash in the near term?
This process turns the aging report into a management tool rather than simply another report produced by the accounting software.
📉 One Metric Does Not Tell the Entire Story
A business owner may be tempted to decide that:
“Our accounts receivable decreased, so everything must be improving.”
Not necessarily.
The decrease could result from:
- Customer payments
- Credits
- Write-offs or adjustments
- Lower sales
- Corrections to prior errors
Likewise, an increase in accounts receivable does not automatically mean there is a problem.
It could result from higher sales.
The aging report provides context.
The question is not only:
Did accounts receivable increase or decrease?
It is also:
What changed inside the balance?
✅ Practical Business-Owner Takeaway
Your accounts-receivable balance tells you how much customers owe.
Your aging report tells you how long they have owed it.
Review both.
Pay particular attention to:
✅ Balances moving into older categories
✅ Unusually large overdue invoices
✅ Payments that may not have been applied
✅ Customer credits
✅ Duplicate invoices
✅ Unresolved disputes
✅ Month-to-month aging trends
$20,000 of current receivables tells a very different story from $20,000 concentrated in invoices more than 90 days old.
The more clearly you understand the composition of accounts receivable, the better you can understand expected collections and your overall financial position.
🧭 Complimentary Financial Health Check
Are you looking at financial reports but still unsure whether the underlying bookkeeping is giving you a clear picture?
TheAccountingDr offers a complimentary Financial Health Check designed to help identify areas of your bookkeeping that may deserve additional attention.
The review considers areas such as:
- Reconciliation status
- Account structure
- Reporting clarity
- Potential red flags
- Xero suitability
- Overall bookkeeping condition
The Financial Health Check is designed as a brief review and does not require handing over your accounting system or financial documents during the initial conversation.
Visit TheAccountingDr.com to request your complimentary Financial Health Check.
👨🏫 About the Author
Dr. Brian Routh is an accounting professor and professional bookkeeper who helps business owners gain financial clarity through professional bookkeeping.
He is the founder of TheAccountingDr, a Raleigh, North Carolina-based virtual bookkeeping practice serving North Carolina and clients nationwide.
Dr. Routh has taught accounting for more than 20 years, formerly served as an Assistant State Auditor for North Carolina, and is a Xero Certified Professional.
TheAccountingDr provides core monthly bookkeeping, cleanup and catch-up bookkeeping, account reconciliations, monthly financial reporting, inventory and product-sales bookkeeping, Xero migration and support, and complimentary Financial Health Checks.
Clarity Comes Before Decisions.
