A 13-week cash flow forecast is a week-by-week projection of every rupee expected to come in and go out over the next quarter, rebuilt each week using actuals. It shows the exact week your balance turns negative while you can still act. Virtual CFO services India SMEs rely on put it in place before any other report.
Profitable businesses rarely fail because the P&L turned red. They fail because TDS fell on the 7th, PF on the 15th, GST on the 20th, salaries at month-end, and a ₹40 lakh receivable promised for the 15th arrived on the 28th. A P&L cannot show that sequence. A weekly forecast can.
What is a 13-week cash flow forecast?
It is a direct-method forecast: you list actual expected receipts and payments by week, not accounting profit. Opening cash plus receipts minus payments gives closing cash for each week, and the closing balance of week 1 becomes the opening balance of week 2. Every Monday you replace week 1 with actuals and add a new week 13.
Why 13 weeks and not 12 months?
Thirteen weeks equals one quarter, which contains a full cycle of monthly statutory dates and, in most quarters, one advance tax instalment. It is long enough to arrange a bank limit increase or chase a large receivable, and short enough that you can forecast individual customers and vendors with reasonable accuracy. A 12-month view is useful for planning, and our post on rolling forecasts versus the annual budget explains how the two fit together.
The Indian statutory calendar every forecast must carry
|
Outflow |
Usual timing |
Forecasting note |
|---|---|---|
|
TDS deposit |
7th of the following month |
Falls in week 1 or 2 of every month |
|
PF and ESI |
15th of the following month |
Tied to payroll size, so it moves when you hire |
|
GST payment (GSTR-3B) |
Around the 20th for most monthly filers |
Cash payable is output tax minus input credit; confirm your filing frequency and due dates on the GST portal |
|
Advance tax |
15 June, 15 September, 15 December, 15 March |
Cumulative instalments, so the December and March payments are large |
|
Salaries |
Month-end or first week |
The largest fixed weekly spike for most SMEs |
|
Micro and small suppliers |
Within 45 days with a written agreement, 15 days without |
Late payment defers your tax deduction under Section 43B(h), so treat these payments as fixed, not flexible |
|
Loan instalments and interest |
As per sanction letter |
Principal repayment never appears in the P&L but always reaches the bank |
Check each due date against the latest government notifications before you finalise the forecast, as extensions and changes are common.
How to build it in six steps
-
Start with real cash. Use the bank balance, then add unused cash credit limit as a separate line so you can see headroom without mixing it with your own money.
-
Forecast receipts by the week cash arrives, not the week you invoiced. Use each customer's actual payment history.
-
Tag every receipt by confidence. Committed (confirmed date), Probable (usual payer, no date) and Hopeful (dispute or new customer). Base the plan on Committed plus half of Probable.
-
Load payments in priority order. Statutory dues and payroll first, micro and small suppliers second, everyone else last.
-
Add a minimum cash buffer line. Choose a floor, such as one week of fixed outflows, and flag any week below it.
-
Hold a Monday Cash Call. A 30-minute weekly meeting compares last week's forecast with actuals, updates the next four weeks and records what moved.
A worked example (illustrative, ₹ in lakh)
|
Week |
Opening cash |
Receipts |
Payroll |
GST, TDS, PF |
Vendors |
Closing cash |
|---|---|---|---|---|---|---|
|
1 |
42.0 |
18.0 |
14.0 |
6.5 |
9.0 |
30.5 |
|
2 |
30.5 |
11.0 |
0.0 |
2.0 |
12.0 |
27.5 |
|
3 |
27.5 |
9.0 |
0.0 |
21.0 |
10.0 |
5.5 |
|
4 |
5.5 |
6.0 |
14.0 |
0.0 |
8.0 |
-10.5 |
This business could report a healthy monthly profit and still be ₹10.5 lakh short in week 4. Because the forecast shows it three weeks ahead, the owner has options: chase the three largest receivables, move payments to non-MSME vendors by a week, draw on the cash credit limit, or discount invoices through a TReDS platform regulated by the Reserve Bank of India. Each has a cost, and the forecast lets you compare them calmly instead of in a panic.
Mistakes that make forecasts useless
-
Building it from the P&L, which repeats the exact blind spot the forecast exists to remove.
-
Using invoice dates for receipts instead of expected payment dates.
-
Ignoring the gap between GST paid on sales and input credit available.
-
Maintaining it in one person's laptop with no weekly review.
-
Never measuring forecast accuracy, so no one learns where it was wrong.
Who should own it?
The finance lead updates it and the promoter or CEO attends the Monday Cash Call. Most SMEs do not have a CFO in the room, which is where virtual CFO services or an interim CFO fit. CFOSME, formed in 2012, has worked with businesses from start-up stage to turnover above ₹1,500 crore, and the weekly cash discipline looks the same across that range. For sector examples, see how dealerships can bleed cash through floor plan interest even in a strong sales year, or how manufacturing SMEs manage raw material cycles.
Once the forecast is running, feed it into your monthly MIS dashboard so cash and profit are read together. We cover this in bookkeeping vs MIS.
FAQs
What is a 13-week cash flow forecast?
A 13-week cash flow forecast is a weekly projection of expected receipts and payments for the next quarter. It uses the direct method, shows closing cash for each week and is updated every week with actual figures.
Is cash flow forecasting for SMEs different from a cash flow statement?
Yes. A cash flow statement reports what happened after the period ends, mainly for audit, banks and filings. A forecast looks forward so you can act before a shortfall occurs.
How accurate should a 13-week forecast be?
Aim for the first four weeks to be close to actuals, and track the variance each week. Accuracy improves within two to three months as you learn how each customer actually pays.
Which CFO services India SMEs should look for to run this?
Look for a provider that builds the forecast with you, runs the weekly review and links it to your MIS, bank limits and tax calendar, rather than handing over a template once.
Next step: Want to see which week your cash runs short? Book a consultation with CFOSME and we will build your first 13-week view.