The 13-Week Rolling Cash Flow Forecast: A Template for Indian SMBs

Build a 13-week rolling cash flow forecast tailored to Indian SMBs, with inputs, outputs and decision triggers that catch shortfalls early.

Why 13 Weeks and Not 12 Months

A 13-week horizon is the global cash management standard because it covers one fiscal quarter plus a week of buffer, long enough to plan around but short enough to forecast with real accuracy. Annual budgets are useful for direction but useless for survival, since most cash crises play out over four to ten weeks. The rolling part is critical, you re-forecast every week with one week dropping off and a new week getting added at the far end. This discipline turns the forecast from a static document into a living management dashboard.

Inputs That Drive the Forecast

On the inflow side, list confirmed customer invoices with realistic due dates adjusted for the customers historical pay lag, plus expected new sales by segment. On the outflow side, capture salaries with their fixed monthly date, statutory dues like GST, TDS, PF and ESI with their actual due dates, rent, utilities, vendor invoices with negotiated terms, EMIs and any expected capex. Be ruthless about realism, a customer who has historically paid in 50 days will not suddenly pay in 30 just because your invoice says Net 30. Forecast like a sceptic, not an optimist.

Building the Weekly Grid

Lay out columns for week 1 through 13 with a clearly labelled week-ending date in DD-MMM format, then rows for opening cash, total inflows, total outflows, net movement and closing cash. Split inflows and outflows into named buckets like collections from top customers, miscellaneous receipts, salaries, statutory, vendor payments, and others. Add a minimum cash buffer row, typically 4 to 6 weeks of fixed operating expenses, and a row showing surplus or shortfall against that buffer. Colour code closing cash red when it dips below the buffer, amber when within 10% above, green otherwise.

Decision Triggers That Force Action

A forecast is only useful if it triggers decisions before the crisis lands. Set rules in advance, for instance if any week within the next 4 weeks shows red, you immediately accelerate collections on the top 5 overdue customers and defer non-critical capex. If weeks 5 through 8 show red, you renegotiate vendor terms or draw on a pre-arranged working capital line. If weeks 9 to 13 show red, you re-evaluate your sales pipeline assumptions and either close gaps or cut planned spend. Without these pre-set triggers, the forecast becomes wallpaper.

Connecting the Forecast to Your Invoice Data

The biggest forecasting mistake is maintaining a forecast spreadsheet that drifts away from actual invoice data, leading to a useless model within four weeks. BillBabu gives you a real-time view of outstanding receivables by customer with ageing buckets, plus payable summaries from purchase entries, which feeds directly into your weekly forecast refresh. Pulling actuals from a single source of truth turns forecast updates from a half-day chore into a 20-minute exercise.

---

Built for Indian small businesses. BillBabu is GST-compliant billing software that helps you create invoices, manage estimates, track payments and stay audit-ready — from your phone. Learn more about BillBabu or download the app.