Debtor Ageing: The 0-30-60-90 Day Dashboard That Protects Cash

A debtor-ageing control that separates due, overdue, disputed, unbilled, accepted, financed and legally escalated receivables. The objective is to convert a financing, collection or compliance issue into a cash impact, evidence file, accountable owner and dated next action.

What the business should understand

• Ageing should begin from the contractual due date while separately showing invoice date and delivery or acceptance date.
• Credit balances, advances, related parties, disputed invoices and unbilled revenue should not be mixed with collectible trade debtors.
• Each overdue balance needs an owner, dispute code, promised date, next action and realistic collection probability.
• Ageing should reconcile to the general ledger, GST returns, customer statements, bank drawing-power submission and TReDS or factoring records.
• A 0–30–60–90 report is a management tool, not a substitute for expected-credit-loss or tax analysis.

Use the Debt Service Coverage Ratio Calculator to work through the related inputs before acting.

The five-point review

For the connected rule, example or next step, see MSME Insolvency Prevention: The 90-Day Cash Warning System.

Practical example

For the connected rule, example or next step, see 13-Week Cash Flow Forecast: The MSME Survival Dashboard.

How to apply the framework

Start from the live legal and commercial record

Verify the legal entity, current Udyam status, customer or lender identity, contract, sanction, purchase order, invoice and portal record. A spreadsheet or certificate stored at incorporation does not prove that the enterprise, category, activity, buyer, facility or claim remains current. Match names, PAN, GSTIN, bank details, dates and authorised users before money moves.

Reconcile the operating evidence

Connect purchase order, delivery or service completion, acceptance, invoice, credit note, customer ledger, GST reporting and bank receipt. For a bank facility, connect the sanction to eligible inventory, receivables, creditors, insurance and monthly submissions. Differences should be explained through a written bridge rather than hidden in a round number.

Quantify cash before choosing the remedy

Show when cash leaves and when it is realistically expected to return. Include payroll, GST, TDS, debt service, critical suppliers and minimum operating cash. Compare a base case with customer delay, lower sales, margin compression or loss of drawing power. A profitable order can still be dangerous when tax, inventory and financing are funded months before collection.

Use the current portal, scheme and contract

New delayed-payment applications should follow the current MSME ODR workflow while Samadhaan remains relevant for monitoring, reference and legacy matters. Government credit guarantees, MUDRA categories, GeM orders, e-invoice rules and bank facilities do not create automatic approval or payment. The actual sanction, electronic contract, guarantee instrument or insurance policy wording controls the commercial exposure.

Close the loop with proof

Assign one owner, one deadline and one measurable result. Verify buyer acceptance, financier settlement, lender statement, portal conversion, signed restructuring, tax filing or actual bank credit. An application number, email promise, provisional bid, stock statement or unsigned settlement should not be reported as completed.

Implementation checkpoint

Before marking the issue closed, reconcile the final accounting entry, bank movement, GST or tax record, lender or customer ledger and supporting acknowledgement. Record the reference number, date, residual amount, next review date and unresolved exception. Preserve the actual policy wording or instrument terms wherever insurance, guarantee or contingent cover is involved.

For the connected rule, example or next step, see Inventory Ageing: Identifying Slow-Moving Stock Before Cash Gets Trapped.

Action checklist

• Verify the live official record.
• Reconcile books, GST and bank.
• Quantify cash impact.
• Assign an accountable owner.
• Set a dated next action.
• Review the outcome with evidence.

Evidence to keep

• Udyam and entity records
• Books, GST and bank statements
• Customer and supplier ledgers
• Cash forecast and dashboard
• Decision and follow-up record

Warning signs

Finin2min takeaway