Debtors ageing report explained: how to read it and what to do about each bucket

What is a debtors ageing report?

A debtors ageing report lists every customer who owes you money and splits each balance into time buckets by how long the money has been unpaid. The total is the same as your receivables balance. The difference is that you can see which part of it is fresh and which part is going stale.

Old money is harder to collect than new money. A balance that is ten days late is usually a customer who forgot. A balance that is ninety days late is often a customer who cannot pay, or will not. The ageing report puts that difference on one page.

What are the standard ageing buckets?

Most small businesses use five buckets, measured in days past the due date. Each bucket is a different conversation with the customer.

The actions escalate on purpose. If every overdue customer gets the same reminder, the customer who is 95 days late learns that nothing happens when they do not pay.

Should you age by invoice date or by due date?

Ageing by due date tells you how late a customer is; ageing by invoice date tells you how old the sale is. Both are useful, but they put the same invoice in different buckets, so know which one your report uses.

Take an invoice dated 5 August 2026 to a customer on 30 credit days. It falls due on 4 September. On 3 October it is:

• 59 days old by invoice date, so it sits in the 31–60 bucket.
• 29 days overdue by due date, so it sits in the 1–30 bucket.

For chasing payments, due date is the fairer measure: a customer you gave 45 days is not late on day 40. Invoice-date ageing is handy when customers have very different credit days and you want to see how long your cash is tied up regardless of terms. SimpleERP ages receivables and payables by due date.

How do you read an ageing report? A worked example

Here is the receivables ageing of Lakshmi Steel Furnitures, the fictional Coimbatore maker of steel racks and furniture used across these guides, as of 3 October 2026. Six customers owe ₹6,00,000 in all.

Read it in three passes. First the bottom row: 40% is not yet due and 25% is less than a month late, which is normal for a business selling on credit. Second, the right-hand columns: ₹1,20,000, or 20%, is more than 60 days overdue. Third, the rows: which customers own that 20%?

• Ravi Stores is current or barely late. A reminder for the ₹40,000 is enough.
• Sri Murugan Traders has the largest balance and ₹30,000 in 31–60. Call this week.
• Kovai Office Interiors has one older invoice of ₹40,000 next to current business. Ask whether that invoice is disputed.
• Annapoorna Hostels is spread across three buckets, and ₹42,000 is past 60 days. Hold new credit orders until it is cleared.
• Venkatesh Furniture Mart keeps buying while ₹30,000 sits in 61–90. Collect the old amount before the next dispatch.
• Green Valley School has one balance of ₹48,000 past 90 days. Send a formal demand and talk to your accountant about a provision.

How do partial payments show up in an ageing report?

A partial payment reduces the invoice it was allocated to, and only the remaining balance stays in that invoice's bucket. The bucket does not reset because some money came in.

Annapoorna Hostels had an invoice of ₹60,000 due on 30 July 2026. It paid ₹18,000 against that invoice in August. The remaining ₹42,000 is now 65 days past due, so it sits in 61–90, which is the figure in the table above.

This only works if payments are allocated to invoices. If a payment is recorded against the customer in general, the report cannot tell which invoice it cleared, and the old invoices look paid when the new ones are not, or the other way round. The guide on partial payments and allocation covers this in detail.

How does a party row expand to its invoices?

Each customer row in a good ageing report opens to show the invoices behind it, with each invoice's balance in its own bucket. That is the list you read out when you call the customer.

Calling with invoice numbers changes the conversation. "You owe us ₹1,40,000" invites an argument. "Invoice 0121 for ₹30,000 was due on 20 August" invites a date.

The number to watch is the share of receivables over 60 days

The percentage of receivables more than 60 days past due is the single best health check on an ageing report. It is easy to work out, it ignores normal credit, and it rises before cash gets tight.

There is no universal right number; it depends on your trade and your customers. What matters is the direction. If the figure was 12% three months ago and is 20% now, collections are slipping even if total sales are growing. Set a target with your own history in mind and track it monthly.

What is a good monthly ageing review routine?

A monthly review takes about an hour and works best on the first working day of the month, before statements go out.

1. 1

   Check that the month is complete

   Every invoice, credit note and receipt for the month is posted, and every payment is allocated to invoices.

2. 2

   Run the ageing report as of month end

   Note the total, the bucket split and the share over 60 days. Compare with last month.

3. 3

   Sort customers by the over-60 amount

   Start with the largest old balances, not the largest total balances.

4. 4

   Open each flagged customer to invoice level

   Mark disputed invoices separately, since they need a credit note or an answer, not a reminder.

5. 5

   Assign one action per customer

   Reminder, call, stop supply or formal demand, by bucket. Write the owner and the date beside each.

6. 6

   Send statements to every customer with a balance

   A statement of account with an ageing footer does half the chasing for you.

7. 7

   Review credit limits

   Customers who keep sliding into 61–90 may need lower credit limits or shorter credit days.

• All receipts allocated to invoices, none left against the customer in general
• Credit notes posted for every agreed return or discount
• Disputed invoices listed separately from slow payers
• Share over 60 days written down and compared with last month
• Every over-90 balance discussed with your accountant

How does SimpleERP build the ageing report?

SimpleERP builds receivables and payables ageing by due date from posted invoices, credit notes and allocated payments, so nobody maintains it by hand. Each party has payment terms, credit days and a credit limit, and the report shows bucket columns per party with a row that expands to its invoices.

• One payment can be allocated to many invoices, and one invoice can take many payments, so partial payments land on the right invoice.
• Invoice statuses (posted, partially paid, paid) are derived by the database, not typed in.
• Cancelling a payment re-opens the invoices it cleared, so the ageing moves back with it.
• Advances and on-account amounts sit on the party until you apply them.
• Each party has a statement of account with an ageing footer, to print, save as PDF or copy as share text.
• Every report exports to CSV.

Read more on the payments and receivables page, or start with the full accounts receivable guide.