
It is 18 November and your outstanding report says the market owes you ₹38,40,000. That number alone tells you almost nothing. The ageing report splits it by how long each rupee has been overdue, and that split tells you who to call today, whose orders to hold, and how much of the balance is really at risk.
For a distributor, the ageing report is the most useful page in the books after the stock summary. Most owners open it only when cash gets tight. This guide shows how to read it properly, why it often overstates the problem, and a weekly routine that turns it into collections.
What does an outstanding ageing report show?
An ageing report (also called a debtors ageing or receivables ageing report) lists every unpaid sales bill and places it in a time bucket based on its age. The usual buckets are 0 to 30 days, 31 to 60, 61 to 90 and above 90, though a distributor with 21-day credit terms may prefer narrower ones such as 0 to 15, 16 to 30, 31 to 45 and 46 to 60.
You can read it two ways. The summary view gives one row per customer with a total in each bucket. The detailed view lists bills under each customer, with bill number, bill date, due date, amount and days overdue. The summary tells you where the money is stuck. The detail tells you why.
Should you age bills by bill date or by due date?
Use the due date. Ageing by bill date treats a bill raised yesterday on 30-day credit the same as one that is already a week late, which pushes perfectly healthy bills into older buckets and makes the report look worse than it is.
Due-date ageing needs one thing to be right: the credit period on each customer's ledger. If a retailer gets 21 days and a modern trade chain gets 45, set those terms in the party master before you rely on the report. A bill that is 40 days old is fine for the chain and 19 days late for the retailer.
How do you read the buckets? A worked example
Say you run an FMCG distributorship in Vadodara (an example business) supplying about 180 retailers on 21-day credit. Credit sales run at roughly ₹32,00,000 a month. On 18 November the ageing summary, by due date, looks like this:
Days overdue | Amount (₹) | Share of total |
|---|---|---|
Not yet due to 30 days | 18,20,000 | 47.4% |
31 to 45 days | 7,40,000 | 19.3% |
46 to 60 days | 5,60,000 | 14.6% |
61 to 90 days | 4,10,000 | 10.7% |
Above 90 days | 3,10,000 | 8.1% |
Total | 38,40,000 | 100% |
Three readings come out of this table.
Days sales outstanding. ₹38,40,000 divided by ₹32,00,000 of monthly credit sales, multiplied by 30, gives 36 days. Your terms are 21 days, so on average the market is paying 15 days late.
The money that needs a phone call. Everything beyond 30 days overdue adds up to ₹20,20,000 (7,40,000 + 5,60,000 + 4,10,000 + 3,10,000), more than half the book.
The money at real risk. The 61 to 90 and above-90 buckets total ₹7,20,000, or 18.8% of the book. These are the bills that turn into write-offs if nobody acts this month.
Look at the trend as well as the snapshot. If the above-90 bucket was ₹2,20,000 last month and ₹3,10,000 now, someone is sliding, and the customer-wise view will show you who.
Why does the ageing report overstate what customers owe?
In most distributor books we review, the ageing report is wrong before anyone reads it. The usual reason is receipts that were never matched to bills.
Take a retailer, Shree Ganesh Traders (an illustrative name), with three open bills on 18 November:
Bill date | Amount (₹) | Age in days |
|---|---|---|
10 August | 1,18,000 | 100 |
25 September | 64,900 | 54 |
28 October | 53,100 | 21 |
The bills total ₹2,36,000 and the ledger shows the full amount as outstanding, with ₹1,18,000 sitting in the above-90 bucket. But your salesman collected ₹50,000 by UPI in October, and it was posted "on account" without being set against any bill. There is also a scheme credit note of ₹11,800 for a September display offer that was approved and never issued. That missing credit note is exactly why the retailer stopped paying the August bill.
Once the ₹50,000 is adjusted against the oldest bill and the credit note is issued, the August bill drops to ₹56,200 (1,18,000 minus 50,000 minus 11,800). Total outstanding falls to ₹1,74,200 (56,200 + 64,900 + 53,100). The account still needs attention, but the conversation with the retailer changes from "you owe us ₹1,18,000 from August" to "here is your credit note, please clear ₹56,200".
Unadjusted receipts, pending scheme and rate-difference credit notes, and unbooked returns are the three things to clean up before you call anyone. For the GST side of those adjustments, see our guide to issuing a rate difference credit note under GST. Under Section 34 of the CGST Act, a credit note for a supply made in one financial year has to be declared by 30 November of the next year or the date of filing the annual return, whichever is earlier, so old schemes cannot wait forever.
A weekly collection routine built on the ageing report
Running the report once a month is too slow for a distributor whose retailers order every week. This routine takes about an hour every Monday.
Post and match all receipts up to Saturday. Bank, UPI and cash collections from salesmen go in first, each set against specific bills. Anything you cannot match goes into a short list for the salesman to confirm.
Clear pending credit notes and returns. Check approved schemes, rate differences and goods returned during the week. Issue the notes before you print the report.
Run the ageing by due date, customer-wise. Sort by the above-60 columns, largest first. The top 15 to 20 names usually hold most of the overdue money.
Split the list by salesman or beat. Each salesman gets his own overdue list for the week's visits, with bill numbers and amounts, so he collects against bills rather than "whatever they can give".
Send reminders to the 31 to 60 day group. A WhatsApp or email reminder with the bill copy settles most of these without a visit. Our post on automating WhatsApp payment reminders covers the wording and timing.
Decide holds for the above-60 group. Mark which accounts get no fresh supply until a payment comes in, and tell the dispatch team the same day.
Note last week's promises. If a retailer promised ₹40,000 by Friday and paid nothing, he moves up the call list.
When should you stop supply or provide for a doubtful debt?
Write down a simple credit policy and apply it from the ageing report, not from memory. A common one for FMCG and pharma distribution is: reminder at 7 days overdue, salesman visit at 15, owner call at 30, supply on cash only beyond 45, and a hold on all supply beyond 60 until the account is regularised.
For bills above 90 days with no payment, no promise and no dispute, talk to your CA about a provision for doubtful debts at year-end. Whether that provision or a later write-off is allowed for income tax depends on the facts, so treat it as an accounting call first and a tax call second. Keep the ageing report printout and your follow-up notes; they are the evidence that you tried to recover the money.
Does the MSME 45-day rule help you collect?
It can, if your business is a micro or small enterprise registered on Udyam and your customer is not. Under Section 15 of the MSMED Act, 2006, a buyer must pay a micro or small supplier by the agreed date, and that agreed period cannot exceed 45 days from acceptance of the goods. With no written agreement, the limit is 15 days. Section 16 adds compound interest with monthly rests at three times the bank rate notified by the RBI on late payments.
There is a tax angle that buyers care about. Under the Income-tax Act, 2025, section 37(2)(g) carries forward the old section 43B(h) rule: a buyer who pays a micro or small supplier after the MSMED Act deadline gets the expense deduction only in the year of actual payment. Larger retail chains and companies track this closely, so mentioning your Udyam status on invoices and in your statement of account often speeds them up.
If a buyer still does not pay, a registered micro or small enterprise can file a delayed payment application on the MSME Samadhaan portal. Most distributors will never need it, but knowing it exists makes the reminder letter firmer.
Where hisabkitab fits in
In hisabkitab, the ageing and outstanding reports are built from the same sales, receipt and credit note entries you already make, so the Monday routine above is a report you open rather than a spreadsheet you rebuild. From the overdue list you can send WhatsApp or email payment reminders, and the mobile app lets you check a retailer's outstanding before a salesman releases the next order. The receivables and payables management page shows these reports in more detail.
If you run a distribution business across beats and salesmen, the page on accounting software for FMCG distributors explains how billing, e-way bills and collections tie together.
Frequently asked questions
What is a good days sales outstanding for a distributor?
It should sit close to your credit terms. If you give 21 days and your DSO is 36, retailers are paying about 15 days late on average and the overdue buckets will show where.
How often should a distributor check the ageing report?
Weekly. Retailers order every week, so a monthly review lets an account grow for four weeks before anyone notices.
Why does a customer's ageing show old bills even after they paid?
The receipt was most likely posted on account and not matched to the bills. Adjust it against the oldest open bills and the ageing will correct itself.
Should credit notes be adjusted before running the ageing report?
Yes. Pending scheme, rate-difference and return credit notes reduce what the customer owes. Leaving them out inflates the overdue buckets and starts arguments with retailers.
Can a micro or small distributor charge interest on late payments?
Under Section 16 of the MSMED Act, 2006, a buyer who pays a registered micro or small supplier late is liable for compound interest at three times the RBI bank rate. In practice most distributors mention it in follow-ups rather than bill it.
Want your outstanding ageing report ready every Monday morning? Start a free trial or compare plans.




