13-Week Cash Flow Forecast: The Template Every SME and Household Should Have in 2026

In 15 years of finance work — Deloitte, FIS, Star India, and now fractional CFO to a portfolio of US and India businesses — one report has done more useful work than any other: the 13-week rolling cash flow forecast. It is the report a turnaround CFO builds first, the one lenders demand before a covenant reset, and the single number a founder asks when they wake up at 3 AM.

Yet almost no small business runs one. And almost no household does either — which is odd, because a household's income is more predictable than a business's, and the discipline is trivial to install.

This is the practitioner's build: categories, formulas, cadence, and the two stress-tests that convert a forecast from a spreadsheet into a decision tool.

Why 13 Weeks, Not 12 Months

13 weeks is a fiscal quarter — long enough to catch the payment cycles of vendors and payroll runs, short enough to stay accurate. Monthly forecasts are too coarse: they miss the mid-month crunch when payroll and GST hit in the same week. Annual forecasts are too far out — the assumptions decay before the horizon closes.

The 13-week horizon is also what lenders, treasury desks, and turnaround consultants use as the standard, so if your business ever needs a debt covenant reset, a working capital line, or a distressed-M&A conversation, the 13-week is the format expected on the other side of the table.

For households the horizon flips: 12 months at monthly grain works better than 13 weeks. Household cash cycles anchor to the month (salary in, EMIs out, SIPs out), and the interesting questions — "can we afford the December trip?", "what changes if I pause SIPs for a quarter?" — need a 6-12 month view, not a 13-week one.

Direct Method Is the Only Method That Matters

There are two ways to construct a cash flow: direct and indirect. The indirect method starts from net income and adds back non-cash items — the format your annual accounts use. The direct method lists actual cash receipts and payments by category. For forecasting, always direct.

The direct method maps to the bank account. When you reconcile forecast vs. actuals each week, you compare the forecast line "customer collections" to the actual customer credits in the bank statement. There is no arithmetic in between. When the variance surfaces, you know exactly which line moved.

The Categories: A Working Template

Every 13-week model follows the same structure. Rows are line items grouped by section; columns are weeks 1 through 13.

Opening Cash

The bank balance at the start of the week, across all operating accounts. Reconciled to the actual statement, not the accounting ledger.

Operating Inflows

• Customer collections (invoiced sales, timed by expected payment date not invoice date)
• Cash sales (retail, e-commerce, walk-ins)
• Advance receipts / customer deposits
• Other operating (rent from sub-let, royalty income, refunds)

Operating Outflows

• Payroll (with statutory: PF, ESI, PT, TDS-on-salary all in the same line or split)
• Supplier payments (raw material, inventory)
• Rent (property + equipment)
• Utilities (power, internet, water)
• GST payments (monthly on the 20th)
• TDS payments (monthly on the 7th)
• Marketing spend
• Software subscriptions
• Professional fees (CA, legal, consulting)
• Other operating overheads

Non-Operating Cash

• Capex (equipment, IT hardware, one-off software licences)
• Loan disbursements (positive) and EMI/principal payments (negative)
• Interest paid
• Tax payments (advance tax quarterly, income tax on assessment)
• Owner distributions / drawings
• Investor inflows (fresh equity, convertible tranche)

Closing Cash

Opening + Inflows − Outflows. This becomes the opening of the next week. Chained across 13 weeks, it tells you exactly when — if ever — you go below zero, minimum operating balance, or a covenant threshold.

Timing Discipline: The Non-Obvious Part

The categories above are the easy part. The discipline is timing.

Customer collections are timed to expected receipt date, not invoice date. If your average Days Sales Outstanding is 45 days, a ₹5 lakh invoice raised in Week 1 should appear in Week 7, not Week 1. Most cash forecasts fail here — they inherit the accrual timing from the AR ledger and pretend it's cash.

GST is due on the 20th of the following month. If Week 1 is 1-7 October, GST for September is due in Week 3 (20 October). This is the single most common cash-crunch surprise for young Indian businesses.

Payroll is usually the last working day of the month or the 1st-5th of the following. Statutory dues (PF, ESI, PT) are due on the 15th of the following month.

Advance tax for corporates is due on 15 June, 15 September, 15 December, 15 March. For individuals in the ₹15+ lakh tax bracket, add these dates to the forecast — they are non-negotiable and often forgotten.

The Two Stress Tests That Matter

A forecast without stress tests is a wish list. There are two tests that separate a working model from a placeholder.

Stress Test 1: The DSO Shock

Push every customer collection out by 15 days. Re-close the forecast. This models the impact of one large customer paying late or a general slowdown in B2B receivables. If the closing cash goes negative in any week, you have a working capital problem, not a growth problem. Common fix: pre-negotiate an OD/CC line before you need it.

Stress Test 2: The 20% Revenue Miss

Cut customer collections by 20% across all 13 weeks. Re-close. This models a demand shock — a lost customer, a market slowdown, a product recall. The output tells you your true cash runway. If runway falls below 6 weeks, you're not "growing", you're "one bad quarter from insolvency".

Both tests take 5 minutes on a well-built model. Skipping them is why most small businesses discover their cash problem only when the cheque bounces.

Household Version: What Changes

For a household, the same skeleton works with three modifications:

1. Horizon extends to 12 months at monthly grain, because household cash decisions (holidays, insurance premiums, school fees) live in the 3-9 month window.
2. Outflows split into fixed, variable, and discretionary. Fixed = EMIs, rent, insurance, SIPs. Variable = groceries, utilities, fuel. Discretionary = dining, subscriptions, travel. This split lets you stress-test the "worst-case month" question: "if income drops for 2 months, what discretionary can I pull?"
3. Add an emergency fund tracker. Track opening EF balance, any top-up (positive), any draw-down (negative), closing balance. A household forecast without an EF tracker misses the whole point.

Cadence and Governance

The forecast is only as useful as the update cadence. For a business, Monday morning is the standard cash-forecast slot — actuals from the previous week are locked, and the coming week's plan is set before the operating rhythm starts. The bookkeeper or controller populates actuals; the CFO or founder reviews variance and re-forecasts.

Weekly variance is the single most valuable output. A stable business will show variance under 5%; a young or turbulent business will show 15-25%. The variance itself teaches you where your assumptions are weakest — usually collections timing or discretionary spend.

For a household, monthly cadence on the 1st works well. Sunday evening if you want to combine it with a bank statement review.

What Tools Actually Work

For a business under ₹10 crore revenue, Excel or Google Sheets is enough. Above that, integration with the bank feed starts to pay off — Cash Analytics, Trovata, or the treasury module in your ERP will pull in actual balances daily, saving the manual reconciliation.

For a household, a single-file browser app is enough — the AYF Cash Flow Forecaster is exactly this: 12 months of categories, editable inflows and outflows, closing balance auto-computed, and it works offline. No login, no cloud, no data leaves your device.

Frequently Asked Questions