How to Build a 13-Week Cash Flow Forecast for Your Startup or SME in India

22 Oct 2026

Profitable businesses run out of cash all the time. Customers pay late, a large GST payment lands in the same week as salaries, or a big order needs raw material paid for upfront. Your profit and loss statement won't warn you, because it records income when you earn it, not when the money arrives. A 13-week cash flow forecast does warn you. It's the most practical finance tool a growing Indian company can build, and you can do it in a spreadsheet.

Why 13 weeks?

Thirteen weeks is one quarter. It's long enough to cover a full cycle of monthly obligations (salaries, GST, TDS, PF, rent and EMIs) three times, plus quarterly items such as advance tax. It's also short enough that you can forecast with reasonable accuracy, because most of the receipts and payments in that window are already known: invoices raised, purchase orders placed, salaries fixed.

Monthly forecasts hide problems inside the month. You may end the month with ₹40 lakh in the bank but have dipped below zero in week two, when salaries and GST went out before your largest customer paid. Weekly granularity catches that.

The structure

Every 13-week forecast follows the same simple logic for each week:

Opening cash + Receipts − Payments = Closing cash

The closing cash of one week becomes the opening cash of the next.

Opening cash

Use the actual balance across all your bank accounts on the start date, reconciled to bank statements. Show the unused amount of any cash credit or overdraft limit separately, so you can see both your own cash and your total available liquidity.

Receipts

• Collections from customers, based on invoices already raised and their realistic payment dates, not the due dates on the invoice
• Expected collections from new sales you're confident of in the period
• Invoice discounting or TReDS proceeds, if you use them
• Loan disbursements, equity funding or other inflows that are actually committed
• GST refunds or other refunds only when you have a firm date

Payments

• Suppliers and vendors:based on bills you've received and agreed credit terms
• Payroll: net salaries, usually on a fixed date each month
• Statutory dues: GST (GSTR-3B is typically due on the 20th of the following month for monthly filers), TDS (generally deposited by the 7th of the following month), PF and ESI contributions (due by the 15th of the following month), and advance tax instalments in June, September, December and March
• Debt service: EMIs, interest on working capital limits and any principal repayments
• Rent, utilities, software subscriptions and other fixed costs
• Capital expenditureyou've committed to
• One-off items: annual insurance, professional fees, bonuses, festival advances

Always check current due dates for your registration type, because statutory deadlines can differ (for example, under the quarterly QRMP scheme for GST) and are sometimes extended.

Closing cash

The closing balance tells you whether you're safe each week. Set a minimum cash buffer, such as two to four weeks of fixed costs, and flag every week where the closing balance falls below it.

Building it step by step

1. Pick a start date and lay out 13 weekly columns. Most companies use Monday-to-Sunday weeks. Keep it in one spreadsheet that the whole finance team uses.
2. Enter opening cash. Reconcile every bank account to the statement on day one.
3. Build receipts from your debtor ageing. List each significant customer, its open invoices and the week you realistically expect payment, based on how that customer actually pays. If a customer usually pays in 75 days against 45-day terms, forecast 75.
4. Add expected new sales.Only include business you're confident of, and apply your actual collection lag. Keep this line separate so you can see how much of your forecast depends on sales you haven't made yet.
5. Build payments from your creditor ageing and fixed calendar. Put payroll, statutory dues, rent and EMIs on their exact dates first. Then add supplier payments according to agreed terms.
6. Add known one-offs and capex.Go through the last year's bank statements to spot annual or irregular payments you might forget.
7. Calculate weekly closing cash and flag shortfalls. Highlight any week below your minimum buffer.
8. Decide what to do about each shortfall. Options include chasing specific customers, discounting invoices, agreeing revised terms with key suppliers, deferring discretionary spend, drawing on a working capital limit or raising funds early.

A simple worked example

The table below uses illustrative numbers only, for a business with about ₹30 Cr of annual revenue. It shows the first four weeks of a 13-week forecast. All amounts are in ₹ lakh.

Suppose the business wants a minimum buffer of ₹40 lakh. The forecast shows two problems: week 2, when statutory payments cluster, and week 4, when salaries go out. Monthly, the business looks fine. Weekly, it sees two dips below its buffer and has time to act, perhaps by bringing forward a large collection due in week 3 or timing supplier payments around payroll.

Rolling it forward every week

A 13-week forecast is only useful if it stays current. Each week:

1. Replace the past week's forecast with actuals from the bank statements.
2. Update opening cash for the new week.
3. Revise receipts and payments for the remaining weeks based on what you now know.
4. Add a new week 13 at the end, so you always see a full quarter ahead.

Set a fixed time for this, such as Monday morning, and keep it to an hour or two once the template is set up.

Tracking variances

Compare actual receipts and payments with what you forecast for the week just gone. Look at the biggest differences and ask why:

• Timing: a customer paid a week late, but the money is still coming.
• Permanent: a customer paid less than expected, or a cost was higher.
• Missed items: a payment nobody put in the forecast.

Over a few weeks, patterns appear. Perhaps one customer always pays late, or the team consistently underestimates supplier payments. Feed those lessons back into the forecast. Forecast accuracy improves quickly once someone owns it and reviews variances every week.

Common mistakes

• Forecasting collections on due dates. Use the dates customers actually pay.
• Forgetting statutory dues. GST, TDS, PF and advance tax are large, fixed and non-negotiable, so leaving them out creates nasty surprises.
• Mixing up profit and cash.Depreciation and provisions don't belong in a cash forecast. Loan principal and capex do.
• Building it once and never updating it. A stale forecast is worse than none, because people still trust it.
• Being too optimistic on new sales. Keep uncommitted sales separate and stress-test the forecast without them.
• Leaving out credit limits. Show available working capital limits separately, so you know your true headroom.
• No owner. Someone specific must update and present it every week.

How it helps with lenders and investors

Banks and NBFCs want to see that you understand your cash cycle. A well-kept 13-week forecast, together with a history of how accurate it has been, shows that management is in control. It supports requests for working capital limits, helps you explain the purpose and repayment of a loan, and lets you warn lenders early if a covenant or repayment could be tight, which preserves trust.

Investors look for the same discipline. A reliable cash forecast underpins runway calculations, shows when you need to start fundraising, and makes board discussions about spending far more concrete.

Your 13-week forecast checklist

• Opening cash reconciled to bank statements for every account
• Unused working capital limits shown separately
• Customer receipts based on actual payment behaviour, invoice by invoice for key customers
• New, uncommitted sales shown on a separate line
• Supplier payments based on agreed terms and bills received
• Payroll, GST, TDS, PF, ESI and advance tax on their exact dates
• EMIs, interest and principal repayments included
• Annual and one-off payments identified from last year's bank statements
• Capex commitments included
• Minimum cash buffer set and shortfall weeks highlighted
• Weekly update with actuals and a new week 13
• Variance review with reasons and lessons recorded
• A named owner and a fixed weekly review slot

How ImpactCFO helps

ImpactCFO founder Sudhir Singal has raised over ₹1,000 Cr of debt for a microfinance lender and has led finance at SuperPe, Happy Fintech and Sarala Microfinance. We build your 13-week cash flow forecast from your actual debtor, creditor and bank data, set up a weekly review rhythm with your team, and use it to plan working capital, manage lender relationships and time your next raise.

Related: How to Calculate Your Cash Runway, and 5 Ways to Extend It · How to Prepare Your Startup or SME for a Bank or NBFC Loan in India · How to Reduce Debtor Days: A Working Capital Playbook for SMEs