Debtors ageing report: format, buckets and how to read it

A debtors ageing report splits what customers owe by how long it has been outstanding. The total is the same trade receivables figure as on the balance sheet; the buckets show whether that balance is healthy. Two businesses with identical receivables can be in very different positions if one is mostly under thirty days and the other mostly over ninety.

Look at the tail first. In the example, one customer accounts for the entire over-90 bucket. That is not a collections-process problem; it is a conversation with Pinewood Traders, and possibly a provision.

Compare the shares with last month. A total that holds steady while the 31–60 share grows means this month’s problem is next month’s over-90.

Name the largest balances. Most ageing risk sits with a handful of customers. The top five by overdue amount, with the last payment date, is usually more useful than the full list.

Read it with debtor days. Debtor days say how long collection takes on average; the ageing says where the delay is. Rising debtor days with a clean ageing can simply mean sales rose late in the month, which is not a collections problem at all.

Aged receivables, aged debtors, accounts receivable aging and debtors ageing are one report. “Aged receivables” is the name many accounting systems give it, and it usually comes in two forms: a summary, with one line per customer as in the example above, and a detail version listing every open invoice under its customer. The summary goes in the monthly report; the detail is what the person chasing payment works from.

Whichever name your system uses, export it as at the same date as the trial balance, so the aged total can be agreed to the receivables figure on the balance sheet.

For Indian companies, Schedule III to the Companies Act 2013, as amended by the Ministry of Corporate Affairs on 24 March 2021, requires an ageing schedule of trade receivables in the financial statements for financial years beginning on or after 1 April 2021. The periods are fixed: less than 6 months, 6 months to 1 year, 1–2 years, 2–3 years, and more than 3 years, counted from the due date of payment — or from the date of the transaction where no due date is specified. Unbilled dues are shown separately.

The rows split receivables into undisputed and disputed, each as considered good or considered doubtful (Division I); companies reporting under Ind AS (Division II) show each instead as considered good, which have a significant increase in credit risk, or credit impaired. Trade payables have their own schedule, in periods of less than 1 year, 1–2 years, 2–3 years and more than 3 years, with MSME dues shown apart.

That is an annual disclosure, not a management format. The ageing in Magic MIS runs from the bill date into buckets set for the company, for reading every month; it is not the Schedule III schedule, which should be prepared on the due-date basis the Schedule asks for.

TallyPrime keeps bill-wise receivables under Gateway of Tally > Display More Reports > Statements of Accounts > Outstandings > Receivables. Press F6 (Ageing Method) to age by bill date or by due date and to set the ageing periods, then export the report with Alt+E (Export) and Current.

The ageing is only as good as the bill-wise entries behind it: a receipt posted on account rather than against a bill stays unallocated, and the oldest invoices look unpaid. Load the export beside the month’s trial balance and Magic MIS ages it into the same buckets every month, with bills that have no usable date shown separately rather than guessed.