13-Week Cash Flow Forecast: The MSME Survival Dashboard
A weekly direct-cash forecast covering committed receipts, payroll, GST, suppliers, debt service, inventory and financing headroom.
A weekly direct-cash forecast covering committed receipts, payroll, GST, suppliers, debt service, inventory and financing headroom. The objective is to convert a financing, collection or compliance issue into a cash impact, evidence file, accountable owner and dated next action.
A thirteen-week forecast tracks actual bank movement rather than accounting profit.
Opening cash should reconcile to available bank balances after blocked, lien-marked or minimum-balance amounts.
Customer receipts should be forecast invoice by invoice using credible collection dates, not contractual terms alone.
GST, payroll, TDS, loan instalments, interest and critical suppliers should appear in the week cash leaves the bank.
What the business should understand
- A thirteen-week forecast tracks actual bank movement rather than accounting profit.
- Opening cash should reconcile to available bank balances after blocked, lien-marked or minimum-balance amounts.
- Customer receipts should be forecast invoice by invoice using credible collection dates, not contractual terms alone.
- GST, payroll, TDS, loan instalments, interest and critical suppliers should appear in the week cash leaves the bank.
- Base, downside and severe-delay cases reveal the date and size of funding action before a crisis.
The five-point review
| Check | What to examine |
|---|---|
| Identity | Legal entity, Udyam, PAN, GST and bank. |
| Cash | Opening balance, receipts, payments and runway. |
| Operations | Margin, inventory, receivables and payables. |
| Credit | Limits, drawing power, debt service and covenants. |
| Control | Owner, deadline, evidence and escalation. |
Practical example
The profit and loss account shows a monthly profit, but the forecast reveals payroll and GST due two weeks before the largest customer pays. The business faces a temporary ₹18 lakh gap.
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.
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
- Profit confused with cash
- One customer dominates receivables
- GST funded by emergency borrowing
- Records conflict
- No owner for overdue action
Finin2min takeaway
MSME finance improves when every sale, invoice, tax payment, bank drawing and recovery action has traceable evidence, an owner and a cash date.