The difficult cash decision is rarely visible in the month’s profit figure. It appears when salaries, a supplier payment and a loan instalment fall due before a major customer pays. A business can be profitable and still have very little room to manage that week.
A 13-week cash-flow forecast gives the promoter and finance team a shared view of those moments. Built around expected bank movements, it brings the next quarter into weekly focus. Its value lies in the decisions it enables: which collection needs attention, which commitment needs planning and when a funding conversation must begin.
Begin with cash you can actually use
Choose a weekly cut-off and reconcile opening cash to the relevant bank accounts. Identify restricted balances, deposits held as security and money that belongs to another entity. A consolidated total is useful only if the funds can move when needed and the movement is permitted.
Keep available borrowing separate from bank cash. For each facility, record the amount already drawn, the amount currently usable and the conditions for further drawing. An application under discussion is not confirmed funding. If an overdraft account is already negative, represent that debt consistently rather than counting its limit again as cash.
Use one unit throughout the forecast, such as ₹ lakh, and one convention for receipts and payments. Agree which day closes the week. These small choices prevent errors when different teams contribute numbers and make the report easier to review quickly.
Build receipts from customers and milestones
Start with the receivables ledger, but do not simply place every invoice in its contractual due week. Ask the collection owner for the expected payment date, customer confirmation, unresolved deductions and any approval still required. A disputed invoice should be visible as a risk rather than hidden inside the normal collection total.
Add expected receipts from future sales using the likely dispatch date and actual credit cycle. An order booked this week may produce cash outside the forecast horizon. Advances, milestone payments and retention releases need separate assumptions because they follow different events.
Label uncertainty plainly. Keep the base case realistic and test major unconfirmed receipts in a downside case. Avoid spreading a large uncertain payment across several weeks merely to smooth the line. The promoter needs to see the dependency while there is still time to address it.
Put obligations in the week they leave the bank
List payroll, statutory payments, rent, utilities, debt service and committed supplier payments on their expected payment dates. Include capital expenditure, annual renewals, insurance and other irregular items that are easy to miss when copying last month’s pattern. Have the relevant professionals confirm statutory amounts and due dates.
Use gross cash movements consistently. If customer receipts and supplier payments include tax, model the related tax settlements with care so the same liability is not counted twice. Exclude non-cash charges such as depreciation. Transfers between accounts in the same forecast perimeter should not inflate receipts or payments.
Distinguish fixed commitments from spending that management can genuinely reschedule. Flexibility must be supported by an agreement or a decision, with its consequence recorded. Moving a supplier payment into a later column without speaking to the supplier improves the spreadsheet while leaving the real problem intact.
Read the lowest point, not just the closing quarter
For each week, calculate opening cash plus receipts less payments, then show confirmed financing movements separately to arrive at closing cash. Carry that closing balance into the next week. Compare it with a minimum operating buffer chosen for the business’s obligations and volatility; there is no universal buffer that suits every SME.
In the illustrative three-week extract below, the business begins with ₹20 lakh. It ends week three with ₹24 lakh, which may look comfortable in a monthly summary. But week two closes at only ₹6 lakh. Against an illustrative ₹10 lakh operating buffer, the business needs to address a ₹4 lakh gap in that week.
That gap does not automatically mean new debt is the answer. The team should first understand whether it can bring forward a supported collection, reschedule an uncommitted purchase or use a confirmed facility. A negative balance before an agreed funding action is a visible unresolved shortfall, not permission to overdraw.
| Cash movement | Week 1 | Week 2 | Week 3 |
|---|---|---|---|
| Opening cash | 20 | 18 | 6 |
| Receipts | 12 | 10 | 30 |
| Payments | 14 | 22 | 12 |
| Closing cash | 18 | 6 | 24 |
| Buffer surplus / (gap) | 8 | (4) | 14 |
Test one credible downside at a time
Begin with the uncertainties that could materially change the cash position. Delay the largest customer receipt by two weeks. Test a later commissioning date or a supplier asking for an advance. Keep the underlying assumption visible so the team knows what event would move the business into that scenario.
Then agree a response and a trigger. For example, if a customer has not approved an invoice by a specified date, the collection owner escalates it and finance refreshes the liquidity plan. A scenario becomes useful when it changes what someone does before the pressure arrives.
Do not conceal the downside by inserting an unspecified promoter contribution. Include additional capital only with clear agreement on the amount and timing. The same discipline applies to prospective loans and asset sales: an intention is different from an available source of cash.
Make the weekly update an operating habit
At the same time each week, replace the completed week with actual bank movements and add a new thirteenth week. Retain the previous forecast so material variances can be explained. Separate timing changes from permanent changes: a late receipt may shift forward, while a cancelled order requires a different response.
Keep the meeting focused. Finance explains the lowest projected balance, collections owners address the largest uncertain receipts, and the promoter resolves decisions that cross functions. Every agreed action should have an owner and a date. The spreadsheet should support the discussion rather than consume it.
A monthly review can then examine recurring forecast errors. If one customer is consistently optimistic or purchase commitments arrive late, improve the source process. Forecast accuracy develops through better information and accountability, not more elaborate formulas.
Start with a workable first version
You do not need a new system to begin. A controlled spreadsheet, reconciled balances, a receivables list and a payment calendar can establish the first version. Record assumptions in plain language and identify information gaps openly. A usable forecast with visible uncertainty is more valuable than an apparently precise one nobody trusts.
At FinDestination, the practical question is whether finance gives the promoter time to act. Start with the next 13 weeks, assign ownership and review the first set of variances. As the rhythm settles, the forecast becomes a common operating view of cash, commitments and the next decision.