In short
Applies to: Business owners, anyone learning accounting, and finance teams
- Start with accurate invoice balances and measure overdue days from the agreed due date.
- Separate disputes, missing documents and broken payment promises, then assign a follow-up owner and date. Count only actual receipts as collections; a promise or proposed credit note is not cash received.
A long outstanding report does not tell you why payment has stopped. One customer may be waiting for a missing delivery record; another may dispute quantity; a third may have a genuine cash problem. The follow-up should address the actual obstacle.
Start with a clean invoice balance
Agree each invoice to its receipt allocation, returns and approved credit notes. Check whether a payment has arrived without a customer reference or has been allocated to the wrong invoice. Chasing an already-settled invoice wastes time and weakens trust. Record the accepted credit terms and any documented change.
Use a consistent ageing basis
For a collection report, days overdue normally means days after the agreed due date. An invoice issued 45 days ago with 60-day terms is not yet overdue. Invoice-age reports can also be useful, but label them clearly. Statutory disclosure schedules may use prescribed categories and should be prepared separately.
| Collection bucket | Outstanding amount |
|---|---|
| Not yet due | ₹60,000 |
| 1–30 days overdue | ₹40,000 |
| 31–60 days overdue | ₹30,000 |
| More than 60 days overdue | ₹20,000 |
| Total outstanding | ₹1,50,000 |
Suppose ₹10,000 of the 31–60-day balance is disputed. It is already included in ₹1,50,000. Adding it again would incorrectly show ₹1,60,000. Track “disputed” as a status attached to the invoice, alongside its ageing bucket.
Give each obstacle a different response
| Obstacle | Next action |
|---|---|
| Invoice not accepted | Check submission and acceptance requirements |
| Quantity or quality dispute | Locate order, delivery and inspection evidence |
| Payment approved but not released | Confirm payment-run date and authorised contact |
| Unallocated receipt | Obtain reference and apply it once |
| Repeated broken promises | Review credit exposure and appropriate escalation |
Run a focused collection meeting
- Review the largest overdue balances and any amount crossing a risk threshold.
- Confirm the unresolved issue and the evidence needed.
- Record who will act, the next contact and the promised payment date.
- Distinguish a customer promise from a verified bank receipt.
- Review whether further credit should continue under the agreed policy.
Do not judge the team only by how many calls were made. Review verified cash received, disputes resolved and commitments missed. A ledger balance reduced by a credit note or write-off is not a collection. Keep approved settlements and accounting adjustments visible in a separate bridge.
Look beyond total overdue value
Concentration matters: the same ₹1,50,000 spread across many customers creates a different exposure from one customer owing the entire amount. Compare due balances, credit limits and recent payment behaviour. A healthy average collection period can hide a few seriously overdue accounts.
Questions that often come up
Should we stop supply immediately? Review contract terms, credit policy, commercial consequences and the facts. No single overdue-day threshold fits every customer.
Can we add interest automatically? Interest entitlement depends on the agreement and applicable law. The report itself does not create that right. See the separate MSME payment-rule guide where relevant.
Should an old balance be written off? Age is a warning, not the whole recoverability assessment. Obtain evidence and approval; tax treatment is a separate question.
Your next practical step
Take the ten largest overdue invoices. Give each one a confirmed balance, cause, owner and next event. Review progress against those commitments, rather than sending the same reminder to everyone.
Sources
This article is for general information only and does not constitute professional advice. Please consult a qualified professional before acting on it.
If you want this done for your business: Financial Advisory, MIS & CFO Support →
Tell us your situation. We reply within one working day, in English or தமிழ்.