Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →
Owners see a large debtors figure but cannot tell which customers are late or which amounts may never be collected.
Each unpaid invoice is placed in a bucket by its age, from invoice date or due date; the buckets add up to the total outstanding and the older buckets show collection risk.
Bill-wise tracking on every customer ledger, a fixed ageing basis, and an action rule per bucket: reminder, call, formal notice, provision.
A ranked list of overdue customers with the right follow-up for each, and an early view of balances that need provision.
A debtors ageing report groups unpaid customer invoices by how long they have been outstanding, usually 0 to 30, 31 to 60, 61 to 90 and over 90 days. It shows which customers are paying late and which balances may never be collected. Most Indian accounting tools, including TallyPrime and Zoho Books, can produce one if invoices are tracked bill by bill.
What does each bucket signal, and what should you do?
| Bucket | What it usually means | Typical action |
|---|---|---|
| 0 to 30 days | Normal credit period for many businesses | No action; send the statement of account |
| 31 to 60 days | Slightly late, or on 45 or 60 day terms | Friendly reminder by email or WhatsApp, with invoice copies |
| 61 to 90 days | Clearly overdue | Phone call to the customer’s accounts team; ask for a payment date |
| Over 90 days | Serious delay or a dispute | Formal notice, hold new supplies, discuss provision with your auditor |
The actions are common practice, not law. Adjust them to your credit terms. If you give 60 days’ credit, the 31 to 60 bucket is not late at all.
A worked example
A distributor has ₹12,40,000 outstanding from customers at month end. The ageing report shows:
| Bucket | Amount | Share of total |
|---|---|---|
| 0 to 30 days | ₹7,10,000 | 57.3 percent |
| 31 to 60 days | ₹3,00,000 | 24.2 percent |
| 61 to 90 days | ₹1,40,000 | 11.3 percent |
| Over 90 days | ₹90,000 | 7.3 percent |
| Total | ₹12,40,000 | 100 percent |
Check: ₹7,10,000 + ₹3,00,000 + ₹1,40,000 + ₹90,000 = ₹12,40,000. The over-90 share is ₹90,000 ÷ ₹12,40,000, about 7.3 percent.
What the owner should do: look at the ₹90,000 first, customer by customer. If ₹60,000 of it is one customer disputing a rate, that is a dispute to settle, not a slow payer. If ₹30,000 is a customer that has stopped answering calls, that is a candidate for provision. Then look at the ₹1,40,000 in the 61 to 90 bucket, because that is next month’s over-90 problem.
If you are a registered micro or small enterprise, remember that the MSMED Act, 2006 gives you rights when buyers pay beyond 45 days, including interest at three times the bank rate notified by RBI. The ageing report is your record of how late each buyer is.
Should buckets count from the invoice date or the due date?
Both methods are used.
- From invoice date: shows how old the sale is. Simple, and the default in many reports.
- From due date: shows how late the customer is against agreed terms. Better for follow-up when customers have different credit periods.
Example: an invoice dated 1 August on 60 day terms is 74 days old on 14 October, but only 14 days overdue. On an invoice-date report it sits in 61 to 90; on a due-date report it sits in 0 to 30 days overdue. Pick one basis, label it on the report, and keep it consistent month to month.
Why does the ageing total differ from the Sundry Debtors balance?
The ageing report adds up open invoices. The ledger adds up all entries. They differ when:
- Receipts are booked “on account” and not linked to invoices, so the invoices still look unpaid.
- TDS deducted by customers is booked but not adjusted against the invoice.
- Credit notes or advances sit unallocated in the ledger.
- Some ledgers are not bill-wise, so their invoices never appear in the ageing.
- Opening balances were carried forward as a single figure without invoice detail.
Fix the allocation, and the two totals will agree. Until they do, the ageing report overstates how late your customers are.
What to read next
- Debtors and creditors reconciliation in India covers the monthly routine, including age-wise analysis.
- TDS receivable ageing workbook in Excel applies the same idea to TDS that customers deducted.
- What is accounts receivable explains the ledger the report is built on.
- For reconciling receipts and TDS against invoices, see account reconciliation software India.