A debtors ageing report is a simple list of who owes you money, grouped by how long each invoice has been unpaid. If you run a small business in India, a monthly debtors ageing review is the quickest way to spot slow payers early, protect your cash flow and keep your books realistic.
This guide explains what the report shows, how to build it from your books, and a practical follow-up routine you can run every month.
What is a debtors ageing report?
"Debtors" (or accounts receivable) are customers who have bought on credit and not yet paid. An ageing report takes every unpaid invoice and sorts it into buckets based on days outstanding, usually measured from the invoice date or the due date.
A common bucket layout looks like this:
BucketMeaningTypical action Not yet dueWithin agreed credit periodSend a courtesy reminder a few days before the due date 1–30 days overdueSlightly latePolite call or message 31–60 days overdueNeeds attentionWritten reminder, ask for a payment date 61–90 days overdueAt riskSenior follow-up, pause fresh credit Over 90 daysHigh riskFormal notice, discuss with your CA or advisorThe bucket boundaries are a choice, not a rule. Pick ones that match your own credit terms.
Why the report matters for a small business
Profit on paper is not cash in the bank. A business can show healthy sales and still struggle to pay salaries, suppliers and taxes because customers are late. Ageing makes this visible.
- Cash planning: you can see how much is likely to come in over the next few weeks.
- Customer risk: one customer slipping from 30 to 60 to 90 days is an early warning.
- Cleaner books: old balances that will never be collected should be reviewed rather than sitting in the books for years.
- Tax awareness: GST on a supplied invoice may fall due in your return even if the customer has not paid you, so collections matter for your own cash to pay tax.
Step 1: Make sure your invoice data is complete
An ageing report is only as good as the entries behind it. Before you run it, check that:
- Every sales invoice is recorded with the correct date and customer.
- Every receipt is recorded and matched to the invoice it settles, not left as an unallocated "on account" amount.
- Credit notes issued to customers are recorded and adjusted against the right invoices. See our guide on GST credit notes under Section 34.
- Bank entries are reconciled, so that receipts that reached your bank are not still showing as pending. Our monthly bank reconciliation routine helps here.
The most common reason an ageing report looks wrong is unallocated receipts: the customer paid, but the payment was never linked to the invoice, so the invoice looks overdue.
Step 2: Run the report and read it properly
Generate the report as on the last day of the month. Then look at it in three ways:
By customer
Sort by total outstanding. A handful of customers usually account for most of the money. Focus your energy there first.
By bucket
Compare this month's bucket totals with last month's. If the over-60-day bucket is growing faster than sales, collections are weakening.
By invoice size
One large old invoice can matter more than ten small recent ones. Flag any single invoice that is more than a set share of your monthly turnover.
Step 3: Follow up on a fixed schedule
Consistency matters more than the wording of the reminder. A simple schedule many small businesses use:
- Three days before the due date: a friendly reminder with the invoice copy attached.
- On the due date or the day after: confirm receipt of the invoice and ask for the payment date.
- Day 15 overdue: phone call to the accounts contact; note the promised date in your records.
- Day 30 overdue: written reminder to the decision maker, listing all open invoices.
- Day 60 onwards: pause new credit sales until the dues are cleared or a payment plan is agreed in writing.
Record every promise ("will pay by 15th") in a note against the customer. If the promise is broken twice, escalate.
Step 4: Review doubtful balances
Once a month, list invoices over 90 days and decide for each one: is it still collectible, is there a dispute, or is it likely to become a bad debt? The accounting and tax treatment of bad debts has specific conditions, so discuss any write-off with your CA before passing an entry. Do not simply delete old invoices.
If a customer disputes an invoice because of quality, quantity or price, settle the dispute first. A properly documented credit note or revised invoice is better than leaving a contested amount ageing in the report.
Step 5: Look at your own payables too
Ageing works both ways. Your creditors' ageing shows what you owe suppliers. If you buy from micro and small enterprises, payment timelines can have tax consequences; see our explainer on Section 43B(h) and MSME payments. Likewise, GST input tax credit on unpaid supplier invoices can be affected after 180 days, as explained in our Rule 37 guide.
Common mistakes to avoid
- Running the report only when cash is already tight.
- Ageing from the invoice date for customers who have 45-day terms, which makes everyone look late.
- Leaving advances and unallocated receipts uncleared.
- Chasing small invoices while the largest overdue account is ignored.
- Continuing to supply a customer who is already well past terms.
Key takeaways
- Ageing groups unpaid invoices by days outstanding so you see risk early.
- Clean data first: allocate receipts, record credit notes, reconcile the bank.
- Review by customer, by bucket and by invoice size every month.
- Follow a fixed reminder schedule and record every payment promise.
- Take advice from your CA before writing off any balance.
Whichever accounting software you use, make a debtors ageing review part of your month-end close. A tool that keeps invoices, receipts and customer balances together makes the routine quicker, but the discipline of reviewing and following up is what actually brings the money in. This article is general guidance; please confirm specifics for your business with a Chartered Accountant.
