Glossary · Accounting & Bookkeeping
Accounts Receivable Aging Schedule
Definition
An accounts receivable aging schedule is a report that groups a business's unpaid customer invoices by how long they have been outstanding, for example 0-30, 31-60, 61-90 and over 90 days. It is built from the sales ledger. It shows which customers pay slowly, how much cash is stuck, and how much the accounts may need to provide for doubtful debts.
At a glance
- Category
- Accounting & Bookkeeping
- In this entry
- What it means for Indian businesses How to read it · Example
In practice
01 What it means for Indian businesses
A single "trade receivables" figure can look healthy and still hide old balances that may never be paid. The ageing schedule splits that figure into fresh and stale amounts. The further right a balance sits, the lower the chance of collecting it in full.
Businesses use the schedule at collection reviews and at year-end. Auditors use it to test the provision for doubtful debts. Banks ask for it when they assess the receivables behind a cash-credit limit, and they usually give little or no value to old debts.
Companies following Schedule III of the Companies Act 2013 also disclose trade receivables in age bands in their financial statements: less than 6 months, 6 months to 1 year, 1-2 years, 2-3 years and more than 3 years, split between undisputed and disputed dues, counted from the due date of payment. This ageing schedule was added to Schedule III with effect from 1 April 2021.
In detail
02 How to read it
- Check the total
The grand total must agree with trade receivables in the balance sheet.
- Look at the current bucket
A high share in 0-30 days means customers are paying on terms.
- Watch the 61-90 bucket
This is the early-warning zone. Follow up before these debts harden.
- Read the over-90 bucket name by name
This is where provisions and write-offs come from.
- Check concentration
One or two customers owning most of the old balance is a bigger risk than the total suggests.
Worked example
03 Example
An example, not advice on your facts.
A Gurugram IT services firm has ₹32,00,000 of receivables:
| Bucket | Amount (₹) | Action |
|---|---|---|
| 0-30 days | 18,00,000 | Current; collecting on terms |
| 31-60 days | 6,50,000 | Gentle reminder |
| 61-90 days | 3,00,000 | Formal reminder; escalate |
| Over 90 days | 4,50,000 | Consider a doubtful-debt provision |
| Total | 32,00,000 | Agrees with the balance sheet |
Almost all of the ₹4,50,000 is owed by one client. The firm provides for that amount under its provisioning policy, escalates the ₹3,00,000 and reports the concentration to management. The total looked fine; the ageing told the real story.
Watch out
04 Common mistakes
- Counting age from the wrong date. On 60-day terms, ageing from the invoice date makes current invoices look overdue. Decide whether you age from the invoice date or the due date, label it, and use the due date for Schedule III disclosure.
- Leaving receipts unapplied. Payments not matched to invoices keep paid invoices on the schedule.
- Ignoring credit notes. Net credit notes against the original invoice before ageing.
- No provision on old balances. Carrying 90-plus-day debts at full value overstates assets and profit.
- Reading only the totals. Totals hide single-customer risk.
An ageing schedule is the evidence; a provision for doubtful debts is the accounting entry that reduces receivables to the amount expected to be collected. Many businesses set a policy, such as a higher percentage provision for older bands, and apply it consistently.
Questions
05 Questions people ask
- What is an aging schedule for accounts receivable?
- It is a report that lists each customer's unpaid invoices and sorts them into age buckets, such as 0-30, 31-60, 61-90 and over 90 days. It helps a business decide whom to chase first and how much to provide for doubtful debts.
Need help with receivables ageing? See our Accounts Receivable Outsourcing or MIS Reporting Services.
Review and sources
Sources: Companies Act, 2013 Schedule III (Division I and II) ageing schedules
