The decision is the earliest cash shortfall, not the quarter-end profit
A useful rolling 13-week cash forecast starts with usable opening cash, schedules actual expected receipts and payments by week, and identifies the greatest funding need against an explicitly chosen minimum cash buffer. A positive closing quarter balance can conceal a payroll or supplier-payment gap several weeks earlier. Show the gap before assumed financing, then separately show approved available funding and the remaining unresolved shortfall.
This is a management-information and liquidity-planning method, checked on 23 October 2026. Thirteen weeks is the selected planning horizon here, not a universal statutory reporting requirement or an Ind AS measurement rule. ICAI’s Financial Management material on treasury and cash management provides the cash-budget foundation: plan receipts and payments, assess shortages and surpluses and distinguish cash movements from non-cash accounting entries. The model, controls and fictional cases below are original applications.
Use one weekly waterfall with traceable inputs
| Forecast layer | What to include | Control that makes it useful |
|---|---|---|
| Opening available cash | Cleared balances actually usable by the forecast population | Reconcile bank balances and separately identify restricted amounts |
| Operating receipts | Expected collections by customer, amount, probability scenario and settlement week | Link invoice ageing to an evidenced collection promise; remove duplicates |
| Operating payments | Payroll, suppliers, rent, taxes and other cash outgoings in their expected payment weeks | Use approved payment and statutory calendars, not expense recognition dates alone |
| Investing and financing | Capex instalments, debt principal, interest and actual approved drawdowns | Keep committed cash movements separate from proposals |
| Liquidity decision | Closing cash, minimum buffer, required funding and residual gap | Show pre-financing results and available facility headroom separately |
For each week: closing cash before new financing equals opening available cash plus receipts minus payments. Next week starts with the prior closing cash, including financing only if the scenario actually assumes an evidenced drawdown or repayment. A required funding figure is a decision output; it is not an automatic receipt. Include the interest, fees and repayment terms of a real funding proposal in the relevant later weeks before relying on it.
Define the population and the minimum buffer
State the legal entity, currency, bank accounts and period cut-off. Cash trapped in a restricted account is not automatically available to meet operating payments. For a group forecast, identify intercompany transfers that can actually occur, their timing and any legal or banking restrictions; eliminate internal transfers only when consolidating the appropriate population. Do not silently fund one entity’s shortfall with another’s cash.
The minimum cash buffer is an explicit management assumption, supported by payroll exposure, payment volatility, operating needs or facility conditions. It is not a generic statutory percentage. Compare the same definition of usable cash with the buffer each week. Where critical payments fall early in a week and collections arrive late, supplement weekly totals with daily scheduling; a positive weekly close can still conceal an intraweek gap.
Build receipts from collection behaviour and payments from obligations
Start with open invoices, confirmed customer promises and realistic settlement delays. Separate signed orders, invoices, disputed balances and speculative sales. A sale forecast becomes a cash receipt only after invoicing, contractual credit, expected collection behaviour and bank settlement are considered. Show a base case and a clearly specified downside rather than hiding collection uncertainty in an unexplained percentage.
For payments, use supplier due dates, essential operational commitments, salary dates, actual tax calendars, capex milestones and loan schedules. Cash paid includes debt principal even though it is not a P&L expense. Depreciation is excluded as a non-cash charge. Outstanding accrued expenses enter the week in which payment is expected. Keep gross bank receipts and subsequent tax payments consistent; do not net tax out of a receipt and then deduct the same tax payment again.
An illustrative thirteen-week pre-financing schedule
The following schedule uses ₹ thousand, opening available cash of 300 and a management buffer of 100. Net flow means receipts less payments before new financing. There are no financing costs or other flows in this simplified scenario; add them when assessing an actual facility.
| Week | Net cash flow: ₹ thousand | Closing before financing: ₹ thousand |
|---|---|---|
| 1 | -100 | 200 |
| 2 | -50 | 150 |
| 3 | 200 | 350 |
| 4 | -250 | 100 |
| 5 | 50 | 150 |
| 6 | 100 | 250 |
| 7 | -200 | 50 |
| 8 | 150 | 200 |
| 9 | -50 | 150 |
| 10 | 100 | 250 |
| 11 | -150 | 100 |
| 12 | 200 | 300 |
| 13 | -50 | 250 |
The quarter closes above the buffer, but week 7 falls below it. A one-off bridge can be identified only after checking when it is available and when it must be repaid. Do not draw the sum of all weekly negative net flows: opening cash and earlier surpluses also fund later outgoings. Conversely, do not assume a facility that expires before week 7 solves that week’s gap.
Roll forward every week and explain forecast error
Replace the elapsed week with reconciled actuals, carry forward the actual available closing balance and append a new final week. Keep the previous approved version so management can distinguish collection timing changes, amount changes, missed payments and classification mistakes. Reforecast the remaining weeks; do not merely shift the old spreadsheet headings.
Assign an owner and evidence date to material receipts, payments and funding lines. Give management an action list showing the earliest decision date, amount required, responsible person and status. A forecast can support payment prioritisation and financing discussions, but cannot by itself authorise non-payment of statutory dues, override contracts or establish solvency under law. Report unresolved gaps clearly rather than treating an unapproved overdraft as cash.
Worked illustrations
These illustrations use fictional facts and expressly stated assumptions. Amounts are Indian rupees unless a different currency or unit is specified. They are independent examples, not findings about any actual client.
Illustrative example 1: The minimum buffer creates a funding need
Opening available cash is ₹2,00,000, receipts ₹3,00,000 and payments ₹4,00,000. Closing cash is ₹1,00,000. Against an assumed minimum buffer of ₹1,50,000, the gap is ₹50,000 even though the bank balance remains positive. The buffer is a management assumption, not an imposed statutory limit.
Illustrative example 2: Restricted cash changes the starting point
Bank balances total ₹5,00,000, including ₹2,00,000 restricted and unavailable for the forecast payments. Usable opening cash is ₹3,00,000. Receipts of ₹1,00,000 less payments of ₹3,50,000 leave ₹50,000. A ₹1,50,000 buffer creates a ₹1,00,000 gap; treating all bank cash as usable conceals it.
Illustrative example 3: Positive period-end cash can hide a peak need
Start with ₹5,00,000. Week 1 receipts are ₹1,00,000 and payments ₹7,00,000, giving −₹1,00,000 before financing. Week 2 receipts are ₹7,00,000 and payments ₹1,00,000, restoring pre-financing cash to ₹5,00,000. A ₹1,50,000 minimum requires ₹2,50,000 funding in week 1. If drawn then and fully repaid in week 2, closing cash returns to ₹5,00,000, ignoring funding costs. The end balance alone misses the peak.
Illustrative example 4: Sanctioned limit is not undrawn availability
Opening cash ₹80,000 plus receipts ₹70,000 less payments ₹2,70,000 gives −₹1,20,000. With a ₹1,00,000 buffer, required funding is ₹2,20,000. A ₹3,00,000 facility already drawn by ₹1,00,000 has only ₹2,00,000 undrawn headroom, assuming that entire balance is drawable. Residual unfunded need is ₹20,000. Do not include the already drawn amount again.
Illustrative example 5: A receipt moves to a later week
A week originally has opening ₹1,50,000, expected receipts ₹3,00,000 and payments ₹3,50,000: closing ₹1,00,000. If ₹2,00,000 of collections move to a later week, current receipts become ₹1,00,000 and closing becomes −₹1,00,000. Against a ₹1,00,000 buffer, the new need is ₹2,00,000. Add the delayed receipt to its revised week and remove it from the original week; it is not new revenue.
Illustrative example 6: Keep gross collections and tax payments consistent
Assume an evidenced customer receipt of ₹1,18,000 includes ₹18,000 tax, and that exact tax is separately payable later, with no other flows in this isolated illustration. Record ₹1,18,000 receipt and ₹18,000 later payment: net ₹1,00,000. Recording only ₹1,00,000 receipt and then deducting ₹18,000 again gives ₹82,000, understating cash by ₹18,000. This assumed tax component is not a general tax-rate rule.
Illustrative example 7: Reconcile expenses to cash outgoings
The forecast-period expense schedule is ₹1,50,000: ₹90,000 paid in the period, ₹30,000 accrued for later payment and ₹30,000 depreciation. Separately, debt principal of ₹50,000 is payable in the period. Cash outgoings from these items are ₹90,000 + ₹50,000 = ₹1,40,000. Schedule the accrued ₹30,000 later and exclude depreciation from cash payments.
Illustrative example 8: The full thirteen-week schedule
In the schedule above, opening cash is ₹3,00,000 and the lowest pre-financing close is ₹50,000 in week 7. Against a ₹1,00,000 buffer, peak incremental funding need is ₹50,000 under the stated assumptions. Week 13 closes at ₹2,50,000. Replacing actual weeks and adding a fresh final week may change the low point, even if the original quarter-end close looked comfortable.
Ten-step verification table
| Step | Verification | Evidence to retain |
|---|---|---|
| 1 | Define the forecast boundary | Entity, currency, bank-account list and cut-off |
| 2 | Reconcile usable opening cash | Cleared bank reconciliation and restricted-cash schedule |
| 3 | Evidence material collections | Invoice references, owner and current payment promises |
| 4 | Schedule actual payment weeks | Supplier, payroll, tax, debt and capex calendars |
| 5 | Remove non-cash and duplicate entries | Expense-to-cash and gross/net reconciliation |
| 6 | Approve the cash buffer assumption | Rationale, amount and review date |
| 7 | Calculate all weekly pre-financing closes | Linked waterfall and peak-gap schedule |
| 8 | Validate funding capacity and timing | Undrawn drawable headroom, covenants, expiry and drawdown evidence |
| 9 | Run a specified downside and action plan | Delayed receipts, residual gaps, decision dates and owners |
| 10 | Roll forward against actuals | Variance explanation, refreshed opening cash and appended final week |
Sixteen practitioner FAQs
1. Why use thirteen weeks?
It is a practical selected horizon for near-term liquidity decisions across roughly a quarter. Adjust frequency and horizon to the business; it is not presented as a universal legal requirement.
2. Is this a statutory cash-flow statement?
No. It is a forward-looking management cash budget. Statutory financial reporting follows its own framework, classifications and period requirements.
3. Should the forecast start with book cash or bank cash?
Reconcile to cleared cash actually available for the forecast payments, explaining timing items and restrictions rather than using an unreconciled balance.
4. Can restricted balances support the buffer?
Only to the extent they can actually be used for the relevant payments. Identify restrictions and do not assume their release.
5. Are sales orders automatically weekly receipts?
No. Apply invoicing, credit, collection and settlement assumptions. Distinguish a confirmed receipt from an optimistic commercial pipeline.
6. How should disputed customer balances be treated?
Identify them separately, document collection assumptions and show an explicit downside rather than disguising uncertainty in ordinary collections.
7. Should receipts be shown net of GST?
Use a consistent bank-cash basis. If the forecast records gross collections and a separate tax payment, do not strip out the same tax twice.
8. Does depreciation belong in cash payments?
No. It is non-cash. Include the actual capex payment in its expected week instead.
9. Why include debt principal if it is outside EBITDA?
The forecast measures liquidity. Principal repayments consume cash regardless of their P&L classification.
10. Does an approved facility limit equal available funding?
No. Deduct existing drawings and assess drawable headroom, conditions, expiry and timing. Do not assume an unapproved increase.
11. Can positive quarter-end cash prove that no bridge is needed?
No. Review every weekly low point and, where necessary, daily timing around critical payments.
12. Should negative net flows simply be added together?
Not to measure peak funding need. Earlier surpluses and opening cash affect later availability; calculate the cumulative waterfall.
13. How should the minimum buffer be chosen?
Use an explicit documented management assumption reflecting operating needs and volatility. Review it periodically and avoid implying a universal statutory figure.
14. What happens when collections slip?
Remove the receipt from the original week, place it in the revised scenario week and recompute all subsequent closes and funding needs.
15. What makes the forecast rolling?
Each update replaces elapsed estimates with actuals, refreshes the opening balance and remaining assumptions, and adds a new final week to maintain the horizon.
16. What should the management action report show?
The earliest shortfall, funding amount, evidence of available remedies, decision deadline, owner and unresolved residual gap. A forecast output is not approval to breach payment obligations.
Conclusion
Report the first cash problem with its decision date, evidenced funding capacity and owner. Reconcile actuals weekly and keep unapproved funding out of the available-cash figure.