Finance & accounting
How to read and use an accounts receivable aging report
What an AR aging report shows, standard aging buckets, how to compute allowance for doubtful accounts, and how to turn aging into a weekly collection plan.
An accounts receivable aging report lists customer balances grouped by how long invoices have been outstanding, usually in buckets such as current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due. It is the single most useful report for collections, credit decisions and estimating doubtful accounts. Read weekly, it tells a finance team exactly where to spend its collection effort.
A sample aging report
| Customer | Total | Current | 1 to 30 | 31 to 60 | 61 to 90 | Over 90 |
|---|---|---|---|---|---|---|
| North Distribution | ₱1,250,000 | ₱800,000 | ₱450,000 | |||
| Bayside Hardware | ₱640,000 | ₱200,000 | ₱140,000 | ₱300,000 | ||
| Metro Builders | ₱910,000 | ₱110,000 | ₱400,000 | ₱400,000 | ||
| Total | ₱2,800,000 | ₱1,000,000 | ₱700,000 | ₱300,000 | ₱400,000 | ₱400,000 |
From this table: 36% of receivables are current, and Metro Builders holds all of the 61-to-90 and over-90-day balances. That is where the first calls go.
Aging by due date or invoice date?
- By due date: shows how late customers are against terms. Best for collections.
- By invoice date: shows how old invoices are regardless of terms. Useful when customers have very different terms.
Be consistent and label the report clearly.
How to read it
- Total overdue as a percentage of AR. Track it weekly; a rising trend is an early warning.
- Concentration. A few customers often hold most overdue balances.
- Movement between buckets. Balances moving from 31-60 into 61-90 mean promises were not kept.
- Disputed items. Separate disputes from simple late payment; they need different actions.
- Unapplied payments and credits. These distort aging; clear them quickly.
From aging to a collection plan
| Bucket | Typical action |
|---|---|
| Current | Confirm invoice receipt and counter receipt; no action otherwise |
| 1 to 30 days | Reminder call or email; confirm payment date |
| 31 to 60 days | Escalate to account owner and sales manager; consider credit hold |
| 61 to 90 days | Formal demand; credit hold; payment plan if needed |
| Over 90 days | Management escalation; legal review; provision assessment |
Assign every overdue account to an owner with a next action and date. See the collections process.
Using aging for doubtful accounts
Aging supports the estimate of expected credit losses for financial reporting. A simple approach applies loss rates by bucket based on history, then adjusts for specific accounts with known problems. Agree the methodology with your auditor under the applicable financial reporting framework. Tax deductibility of bad debts follows separate BIR rules, so coordinate with your tax adviser.
Common aging report problems
- Unapplied customer payments sitting as credits
- Invoices not recorded until weeks after delivery
- Customer withholding tax not recorded, inflating balances
- Duplicate customer records for the same company
- Aging run from spreadsheets updated manually
A weekly aging review agenda
Keep the weekly collection meeting short and focused on decisions:
- Total overdue and change since last week
- Top ten overdue customers: status, promise to pay, next action
- New disputes and who is resolving them
- Accounts proposed for credit hold or release
- Missing customer withholding tax certificates
- Actions agreed, with owners and dates
Thirty minutes a week with the right people usually does more than a long monthly report.
Classification aging
Beyond individual customers, aging by customer classification (for example key accounts, distributors, retail, government) shows which segments pay slowly and helps set credit policy per segment.
Where Cirquolus fits
Cirquolus Customer aging & collections provides customer aging inquiries, classification aging review, statements of account and aging summaries, with invoice and payment context for collection follow-up. It is part of accounts receivable and financial management. Related: accounts receivable management.
Frequently asked questions
What is an aging report?
A report that groups customer balances by how long invoices have been outstanding, used to manage collections and estimate doubtful accounts.
What are standard aging buckets?
Current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due are the most common.
How often should we review AR aging?
Weekly for collections and monthly for management and accounting purposes.
How is an aging report used in auditing?
Auditors use it to test the existence and valuation of receivables and to evaluate the allowance for doubtful accounts.
Bring this workflow to a Cirquolus demo.
Show us your current process, companies and branches. We will map it to the modules you need and propose a realistic rollout.