Ageing Reports, Without the Jargon: Who Owes You, Who You Owe, and for How Long

Ask most owners how much their customers owe them and you will get one number, quickly. ₹18 lakh. ₹42 lakh. The number is not wrong. It is just nearly useless, because it mixes an invoice raised last Tuesday with an invoice that has been sitting unpaid since before Diwali, and treats both as the same kind of money. They are not. An ageing report is the report that separates them. It lists every open balance, customer by customer and supplier by supplier, and sorts each one by how long it has been outstanding — so instead of one lump, you see who owes you, who you owe, and how old each debt really is. Our book-keeping page runs its whole receivables routine on this report, in its section on receivables — the money customers owe you. This post is about reading that report like an owner, not like an accountant filing it away.

What the report is, in plain words

There are two ageing reports, and they face opposite ways. The receivables ageing lists what customers owe you. The payables ageing lists what you owe suppliers. Each one has a row per party and a set of columns — the buckets — that split the party's total by age.

The buckets most accounting software uses for day-to-day work run like this: current (not yet due), then 0–30 days overdue, 31–60, 61–90, and 90+. Age is normally counted from the due date, not the invoice date — an invoice raised 40 days ago on 30-day terms is 10 days overdue, not 40 days old. Whichever basis your software uses, pick it once and stay with it, because a report that changes its basis between months cannot show you a trend.

Here is a small illustrative example — invented figures, a business of a size I see often:

The total says ₹17,90,000 is owed to this business. The buckets say something sharper: ₹5,05,000 of it is more than 90 days overdue, and ₹4,10,000 of that old money belongs to one customer. Two facts. Both invisible in the total.

Read the receivables report from the right-hand side

Most people read this report left to right, feel comforted by the big current column, and close it. Read it the other way. Start with the 90+ column, because that column is the story.

Money gets harder to collect with every bucket it crosses. An invoice 10 days overdue is usually an oversight, a missed payment run, a signatory on leave. An invoice 100 days overdue has survived several promises, and each month it sits there, the customer's own memory of why it should be paid gets weaker and your bargaining position gets worse. The 90+ column is not just old debt. It is the part of your receivables where "will be paid" quietly turns into "might be paid", and then into a provision discussion at year end.

Then look for concentration. In the example above, one customer holds most of the 90+ bucket and is also the largest debtor overall. That is two risks wearing one coat: if that customer delays further, your collections for the month collapse; if that customer fails, a large share of your receivables fails with them. A total spread evenly across twenty customers behaves nothing like the same total resting on two. The ageing report is where you see which one you have.

Last, compare this month's buckets with last month's. A healthy report shows money entering on the left and leaving as cash before it travels far right. A sick one shows the same names drifting one bucket rightward, month after month, while fresh sales keep refilling the left and flattering the total. Totals can grow while collections rot. The drift cannot hide — if you look for it.

The payables side: the mirror nobody enjoys

Now turn the report around. Your payables ageing shows what you owe, bucketed the same way, and it shows your suppliers exactly the picture your customers' ageing shows you — except you are the slow name in somebody else's 90+ column.

Stretching a supplier past the agreed terms feels free. It is not. The costs arrive quietly: the early-payment discount you no longer get offered, the dispatch that waits until your payment clears while a competitor's order ships the same day, the credit limit that shrinks without a letter ever being sent. And some of it is not quiet at all. If the supplier is a micro or small enterprise, Section 15 of the Micro, Small and Medium Enterprises Development Act, 2006 requires you to pay by the date agreed in writing, and that agreed period cannot exceed 45 days from the day the goods or services were accepted; where nothing is agreed in writing, payment falls due within 15 days. Section 16 then charges compound interest, with monthly rests, at three times the bank rate notified by the Reserve Bank of India, when that deadline is missed. That is not a late fee you negotiate away. It is a statute pricing your delay.

Read your own payables ageing with that in mind. Payables sitting in the older buckets should be there only as a deliberate, temporary decision — never because nobody looked. If cash is genuinely tight, the honest sequence is to choose who waits, tell them before the due date, and agree a date. Silence is what turns a payable into a dispute.

Why your year-end ageing schedule looks different

At year end, companies meet a second ageing format, and the difference confuses people. Schedule III to the Companies Act, 2013 requires a trade receivables ageing schedule and a trade payables ageing schedule in the notes to the financial statements. But the statutory buckets are not the 30-60-90 buckets above.

For trade receivables, Schedule III asks for amounts outstanding for 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 transaction date where no due date is specified — split between undisputed and disputed dues, and between dues considered good and doubtful. For trade payables, the buckets are less than 1 year, 1–2 years, 2–3 years and more than 3 years, split between dues of micro and small enterprises, other dues, and disputed dues in each class, with unbilled dues shown separately.

Neither format is wrong. They do different jobs. The monthly 30-60-90 report is a working tool, cut fine enough to act on while action still matters. The Schedule III schedule is a disclosure, cut in years because it is telling shareholders and lenders how stale the balances in the audited statements are. Just do not expect the two to match bucket for bucket, and do not let anyone prepare the year-end schedule from a different set of books than the one you managed with all year.

What to do with the report, every week and every month

An ageing report earns its keep only when it turns into calls, decisions and entries. The routine I recommend is simple.

1. Clean it before you read it. Knock off credit notes, allocate part-payments and receipts to the invoices they belong to. Reading a dirty report wastes the meeting — more on the common distortions below.
2. Make collection calls in bucket order, oldest first. Start at 90+ and work left. Every old balance gets a named owner in your team, the reason for the delay written down in one line, and a next date that someone will actually check.
3. Act on the pattern, not just the person. A customer who lands in 61–90 every quarter is telling you the credit terms you are giving them are fiction. Shorten the terms, ask for an advance, or put fresh supplies on hold until the old bucket clears. A credit hold feels harsh on the day you impose it. It feels obvious three months later.
4. Schedule payables by due date, not by who shouts loudest. Statutory dues and micro and small suppliers first — the 45-day clock above is real — then the suppliers your operations cannot run without, then the rest, inside their agreed terms.
5. Face the provision question monthly, not at year end. A balance parked in 90+ with no payment plan and no response is a candidate for a provision for doubtful debts. Flag it early and let the judgement be made calmly; deciding what a debt is worth is accounting judgement, which is exactly where bookkeeping ends and accounting begins. I am deliberately not giving you a percentage to provide against each bucket — no honest standard table exists for your business, and anyone who quotes you one without knowing your customers is guessing.

Where ageing reports quietly lie

The report is only as honest as the entries behind it, and a few common habits bend it out of shape.

Credit notes not knocked off. You raised a credit note for damaged goods in March, but nobody linked it to the invoice. The customer has mentally paid less; your report still shows the full amount, ageing happily into 90+, and your team chases money the customer genuinely does not owe.

Advances parked in receivables. A customer paid an advance, and it sits as a loose credit in their ledger instead of being shown as an advance or adjusted against the first invoice. The ageing now understates what they owe on invoices and overstates nothing you can act on — the picture is wrong in both directions at once.

Post-dated cheques treated as paid. A cheque dated next month is a promise, not a payment. The moment it is entered as a receipt, the invoice leaves the ageing, the chasing stops, and the money looks collected while it is still paper in a drawer. If that cheque bounces, the debt reappears — older, colder, and with weeks of follow-up lost. This is also where a current bank reconciliation protects you: only money the bank has actually cleared should be clearing invoices.

Disputes left sitting as ordinary dues. An invoice the customer has rejected — wrong rate, short delivery, a quality claim — does not become collectable by being ignored. It belongs flagged as disputed, with the dispute owned and worked. Schedule III will ask you to split disputed from undisputed dues at year end anyway; a report that hides disputes all year makes that split a year-end excavation.

Think of the report as a crate of fruit at a mandi. The total weight tells you almost nothing. What matters is how much of it has been sitting at the bottom, in the heat, since last week — because that is the part you will not be able to sell, however fresh the top layer looks. Ageing is the habit of checking the bottom of the crate while there is still time to do something about it.

Keep the bottom of the crate small

That is the whole discipline. Pull both ageing reports every month — weekly, if your volumes are high. Read the old columns first. Give every old balance an owner, a reason and a date. Pay your own side inside terms, and treat the 45-day duty to micro and small suppliers as the hard line it is. Do that steadily and the totals start meaning something again.

If your receivables and payables ledgers have drifted — credit notes unlinked, advances parked, cheques taken as cash — our book-keeping team will clean the ledgers, rebuild the ageing, and hand you both reports every month in the monthly pack, each old balance flagged with its next action. Tell us the ledgers are messy. Most are, when we first see them.