Four Ageing Schedules Under explained: this guide covers what it means, who it applies to, the step-by-step process, documents required, fees, due dates and penalties in India — so you can stay compliant with confidence and avoid costly mistakes.
The 2021 amendment to Schedule III introduced four ageing schedules — trade receivables and trade payables, each split between disputed and undisputed dues, and capital work in progress and intangible assets under development, each split between projects in progress and projects temporarily suspended. Receivables and payables age from the due date of payment, not the invoice date.
1. Trade receivables ageing schedule
For trade receivables outstanding, the following ageing schedule is to be given, with periods measured from the due date of payment:
| Particulars | Less than 6 months | 6 months – 1 year | 1–2 years | 2–3 years | More than 3 years | Total |
|---|---|---|---|---|---|---|
| (i) Undisputed trade receivables — considered good | ||||||
| (ii) Undisputed trade receivables — considered doubtful | ||||||
| (iii) Disputed trade receivables — considered good | ||||||
| (iv) Disputed trade receivables — considered doubtful | ||||||
The buckets run from the due date of payment. A receivable invoiced in January on 90-day terms is not six months old in July — it is three months past due. Ageing systems configured on invoice date will overstate every bucket, and the error is systematic rather than random.
Where no due date is specified, the guidance note directs that the ageing be reckoned from the date of the transaction — which is a different rule for a different fact pattern, not a general fallback.
2. Trade payables ageing schedule
The payables schedule follows the same structure, with the categories split between MSME and others and between disputed and undisputed dues. The split by MSME status connects the disclosure to the separate MSME reporting obligations, so the two should be reconciled rather than prepared independently.
3. Capital work in progress ageing
CWIP is aged in four buckets — less than 1 year, 1–2 years, 2–3 years and more than 3 years — with amounts shown separately for:
- Projects in progress; and
- Projects temporarily suspended.
A second disclosure is required for projects whose completion is overdue or which have exceeded their cost compared to the original plan — set out project-wise, with the period over which the completion is expected.
4. Intangible assets under development ageing
The same structure applies:
| Intangible assets under development | Less than 1 year | 1–2 years | 2–3 years | More than 3 years | Total* |
|---|---|---|---|---|---|
| Projects in progress | |||||
| Projects temporarily suspended | |||||
* The total shall tally with the amount of intangible assets under development in the balance sheet. The guidance note states the tie-out requirement expressly, and the same applies to the CWIP schedule.
The two structural points that cause restatements
- The tie-out. Each ageing schedule must reconcile to its balance sheet line. Schedules built from a sub-ledger that does not agree with the general ledger will not tie, and the difference has to be found before publication, not after.
- "Projects temporarily suspended" is a judgement, and it is visible. Classifying a stalled project as in progress rather than temporarily suspended is a disclosure choice that an auditor and a reader can both test against the facts. The category exists precisely to surface projects that have stopped.
Preparing these at consolidated level
The guidance note states that the trade payables ageing schedule and the trade receivables ageing schedule should each be prepared at the CFS level after applying the principles of consolidation. That means constructing them from consolidated balances with intra-group items eliminated — not summing the components' standalone schedules.
What to fix in the underlying systems
- Due date capture on every invoice, so ageing can run from it.
- A dispute flag in the receivables and payables ledgers — otherwise the disputed split is a manual year-end exercise.
- An MSME flag on vendors, reconciled to the MSME disclosure.
- A project status field on CWIP and intangible development projects, updated during the year.
- Original plan cost and expected completion date recorded per project, for the overdue and cost-overrun disclosure.
Compliance checklist
- Age receivables and payables from the due date of payment.
- Split disputed and undisputed, and within each considered good and considered doubtful.
- Split payables between MSME and others and reconcile to the MSME disclosure.
- Show CWIP and intangibles under development split between in progress and temporarily suspended.
- Tally each schedule to the balance sheet line.
- Disclose overdue and cost-overrun projects separately, project-wise.
- Build consolidated schedules after consolidation, not by aggregation.
Common mistakes
- Ageing from the invoice date.
- Omitting the disputed split because the ledger does not carry a flag.
- Schedules that do not tie to the balance sheet.
- Classifying stalled projects as in progress.
- Aggregating standalone schedules to build the consolidated one.