Accounts Receivable Aging Schedule
An accounts receivable aging schedule is a report that groups a business's unpaid customer invoices into time buckets by how long they have been outstanding — such as 0-30, 31-60 and over 90 days. It is built from the sales ledger. It matters because it shows at a glance which debtors are slow, how much cash is stuck, and how large a doubtful-debt provision the accounts may need.
What Is an Accounts Receivable Aging Schedule?
An accounts receivable aging schedule lays every customer's unpaid balance across columns that measure age from the invoice or due date. Instead of one lump receivables figure, management sees how that figure splits between fresh invoices that will likely be paid and stale ones that may not. The further a balance drifts to the right of the schedule, the lower the odds of collecting it in full.
An Indian business meets the aging schedule at every collections review and every year-end. A Gurugram IT services firm running on 30-day terms uses it to spot the clients who have slipped to 90-plus days, to prioritise follow-up, and to decide the provision for doubtful debts its auditor will expect. It is also the report a bank asks for when assessing the quality of the receivables backing a cash-credit limit.
Key terms
- Days Sales Outstanding (DSO) — The single-number summary of how slow the whole ledger is.
- Dunning Letters — Escalating reminders driven by the older aging buckets.
- Bank Reconciliation — Confirms receipts that clear invoices off the schedule.
Why Accounts Receivable Aging Schedule Matters
Ignoring the ageing of debtors is how profitable businesses run out of cash:
- Cash tied up unseen — A healthy total receivables figure can hide lakhs stuck in 90-plus-day balances that are quietly turning bad.
- Under-provided doubtful debts — Without ageing, the provision for doubtful debts is guesswork, overstating profit and assets.
- Missed collection window — Debts chased only when they are very old are far harder to recover than those followed up at 30 days.
- Weaker borrowing base — Banks discount old receivables when sanctioning limits, so a stale ledger shrinks available working capital.
- Concentration risk missed — Not seeing that one client owes most of the old balance leaves the business exposed if that client defaults.
How to Read Accounts Receivable Aging Schedule
Read the schedule left to right, and these are the numbers to check first:
- 1Start with the total
The grand total ties to trade receivables in the balance sheet — confirm it agrees before trusting anything else.
- 2Scan the current bucket
The 0-30 day column is the healthy core; a high share here means the ledger is collecting on terms.
- 3Watch the 61-90 drift
Balances sliding into 61-90 days are the early-warning zone — these need a call before they harden.
- 4Zero in on 90-plus
The over-90 column is where provisions and write-offs live; read it name by name, not just as a total.
- 5Check concentration
See whether one or two customers dominate the old buckets — that is the real risk, not the aggregate.
Accounts Receivable Aging Schedule: A Practical Example
| Particulars | Amount (INR) | Treatment |
|---|---|---|
| 0-30 days | 18,00,000 | Current; collecting on terms |
| 31-60 days | 6,50,000 | Watch; gentle reminder due |
| 61-90 days | 3,00,000 | Escalate; second dunning notice |
| Over 90 days | 4,50,000 | Provide for doubtful debts |
| Total trade receivables | 32,00,000 | Ties to the balance sheet |
A Gurugram IT services firm has ₹32,00,000 of receivables. The schedule shows ₹18,00,000 current, but ₹4,50,000 has aged past 90 days — nearly all owed by one client. The firm books a doubtful-debt provision against that ₹4,50,000, escalates the ₹3,00,000 in the 61-90 bucket with a formal reminder, and flags the single-client concentration to management. The lump total looked fine; the ageing told the real story.
Ageing from invoice, not due date: Measuring age from the invoice date on 60-day terms overstates overdue amounts → age from the due date.
Common Mistakes With Accounts Receivable Aging Schedule
The schedule misleads when it is built on stale or unclean data:
- Ageing from invoice, not due date — Measuring age from the invoice date on 60-day terms overstates overdue amounts → age from the due date.
- Unapplied receipts left open — Payments received but not matched keep paid invoices on the schedule → apply receipts before ageing.
- No provision on old balances — Leaving 90-plus-day debts at full value overstates assets and profit → provide per a consistent policy.
- Ignoring credit notes — Not netting off issued credit notes inflates debtor balances → reconcile credits before reporting.
- Reading totals, not names — Looking only at bucket totals hides single-customer concentration → review the old buckets debtor by debtor.
An accounts receivable aging schedule is a report that groups a business's unpaid customer invoices into time buckets by how long they have been outstanding — such as 0-30, 31-60 and over 90 days. It is built from the sales ledger. It matters because it shows at a glance which debtors are slow, how much cash is stuck, and how large a doubtful-debt provision the accounts may need.
Need help with Accounts Receivable Aging Schedule?
Accounts Receivable Aging Schedule sits inside your day-to-day books. Patron's CA-led team keeps them accurate, compliant and audit-ready.
Applicable framework: AS 1 / Ind AS 1 presentation; Schedule III, Companies Act 2013 for receivables disclosure; provisioning practice under prudence. For general information only, not professional advice. Verify the current position for your entity before acting.