Accounts receivable aging groups unpaid customer balances by how long they are overdue. Its purpose is not to display red numbers. It is to assign the next action that turns a valid invoice into cash.
The aging buckets
| Bucket | Typical meaning | Action |
|---|---|---|
| Current | Not yet due | Confirm delivery and prevent avoidable blockers |
| 1 to 30 days | Early overdue | Reminder and payment-date request |
| 31 to 60 days | Collection risk rising | Named owner and direct customer contact |
| 61 to 90 days | Material delay or dispute | Escalation, payment plan or service decision |
| More than 90 days | High collection and credit risk | Formal review, provision or recovery action |
Bucket labels can differ. The report date and due-date logic matter more than the exact bands. Use days past due, not days since invoice, unless the report clearly says otherwise.
A worked aging
A business has 80,000 in total receivables. Of that, 18,000 is overdue and 7,000 is more than 60 days late.
Overdue percentage = overdue receivables / total receivables = 18,000 / 80,000 = 22.5 percent.
The number becomes useful only after classification:
- 6,000 is promised for Friday.
- 5,000 is blocked by a missing purchase-order reference.
- 4,000 is disputed for a specific deliverable.
- 3,000 has no response and needs escalation.
The collection plan is now 6,000 forecast cash, a 5,000 document fix, a 4,000 dispute decision and a 3,000 credit-risk action.
Days sales outstanding
DSO = average receivables / credit sales x days in period.
If average receivables are 75,000 and quarterly credit sales are 300,000, DSO is 75,000 / 300,000 x 90 = 22.5 days.
DSO is a trend measure, not an invoice queue. Seasonality, milestone billing and sales mix can change it. Use aging for actions and DSO for direction.
A weekly collection review
- Match recent bank and gateway payments first.
- Remove approved credits and correct wrong invoices.
- Review every material overdue balance.
- Assign owner, action and next date.
- Record promise-to-pay dates separately from hope.
- Update the short-term cash forecast.
- Escalate repeated broken promises under the credit policy.
Common distortions
- Unapplied customer payments make balances look older than they are.
- Credit notes sit separately instead of reducing the related invoice.
- Invoices use the wrong due date after terms changed.
- Duplicate customers split the total and collection history.
- Disputed amounts remain mixed with collectible balances.
- Foreign-currency balances are compared without a consistent reporting rate.
Estimate credit loss honestly
An old invoice is not worth face value merely because no one has written it off. Use history, customer facts, dispute status and current evidence to estimate what is recoverable under your accounting policy. Keep commercial collection work separate from the accounting estimate.
Using Invoice Crowd
The accounts receivable aging report groups open customer balances by age. Use invoice status, payment history, customer portal access and reminder notes to turn each material row into an action. Reconcile payments before chasing so a client is never reminded for money already received.
Frequently asked questions
What is accounts receivable aging?
A report that groups unpaid customer balances by how long they are overdue. It supports collections, cash forecasting, credit decisions and estimation of amounts that may not be recovered.
Are aging days counted from invoice date or due date?
Overdue aging should usually use days past the due date. Some reports use invoice age, so confirm the report definition before comparing buckets.
What is a good overdue percentage?
There is no universal target. Compare with your terms, customer mix and history. Track total overdue, more-than-60-day balances, disputes and broken payment promises separately.
What is DSO?
Days sales outstanding estimates how many days of credit sales are tied up in average receivables. It is useful as a trend, while the aging report is better for invoice-level action.
Should disputed invoices stay in aging?
Keep the open balance visible but identify the disputed amount and owner separately. Mixing it with undisputed collectible debt produces misleading collection forecasts.
Why should payments be reconciled before reminders?
Unmatched bank or gateway receipts can leave paid invoices appearing overdue. Chasing them damages trust and creates duplicate allocation work.
