In short
- Forecast cash when it moves, not when you earn or spend it: a sale in March paid in May is May's cash.
- Include GST, TDS, advance tax and annual bills, the lumps that sink a plan.
- Run a cautious scenario and decide in advance what you'll do if cash dips below your safety floor.
Profit tells you whether the business model works. Cash tells you whether you can pay on Friday. A cash flow forecast is a simple table that answers one question: month by month, how much money will we have in the bank?
You don't need accounting software for this. A spreadsheet and an honest afternoon are enough.
Set up the table
One column per month for the next 12 months. Rows in three groups:
- Opening cash: what you have at the start of the month (this month's closing balance).
- Cash in: customer payments received, loans drawn, any capital added.
- Cash out: supplier payments, salaries, rent, loan EMIs, taxes and anything else leaving the account.
Closing cash is opening cash plus cash in minus cash out. That closing figure becomes next month's opening.
Forecast cash in by when customers pay
This is where most forecasts go wrong. A sale made in March isn't March cash if your customer pays in 45 days. List expected sales by month, then shift each one forward by your real collection time. Use the average from your own records, not the credit terms you wish customers followed.
For uncertain items, be cautious. Count only orders you are fairly confident about, and assume a small portion of invoices will be late.
Forecast cash out by when you must pay
Start with the fixed items: rent, salaries, EMIs, insurance, software. Add purchases at the pace of your sales, shifted by your supplier terms. Then add the lumps:
| Lump | When it hits |
|---|---|
| GST payable (output tax minus input credit) | Around the 20th of each month for monthly filers |
| TDS you deducted from salaries, rent or fees | By the 7th of the next month |
| Advance tax | 15 June, 15 September, 15 December, 15 March for most taxpayers |
| Provident fund and ESI contributions | Around the 15th of the next month |
| Annual insurance, licences, audits | The month the renewal falls due |
| Bonus and festive season costs | The months you actually pay them |
Forgetting GST is the classic error. It looks like your money in the bank, but part of every GST-inclusive payment belongs to the government.
A tiny example
| Jan | Feb | Mar | |
|---|---|---|---|
| Opening cash | ₹4,00,000 | ₹3,10,000 | ₹1,40,000 |
| Cash in (customer payments) | ₹3,00,000 | ₹2,60,000 | ₹3,40,000 |
| Cash out (all costs) | ₹3,90,000 | ₹4,30,000 | ₹3,10,000 |
| Closing cash | ₹3,10,000 | ₹1,40,000 | ₹1,70,000 |
Over the quarter, cash falls from ₹4 lakh to ₹1.7 lakh, and February's closing balance of ₹1.4 lakh is far below one month of costs (about ₹4 lakh). A forecast shows that in January. A bank statement shows it in February, when it's too late to fix.
Add a safety floor
Pick a minimum balance you never want to go below, often one month of fixed costs. Mark every month where the forecast dips under it. Those are the months to act: delay a purchase, chase an invoice, arrange a limit with your bank before you need it.
Run three scenarios
- Expected: your best honest guess.
- Cautious: sales 20 per cent lower, and customers 15 days slower to pay.
- Stretch: sales higher. Check that you can fund the extra stock and wages that growth demands.
The cautious case is the useful one. If you survive it comfortably, you have a resilient plan. If not, you know what to change.
Keep it alive
- Update it on the first working day of each month with actual numbers.
- Compare forecast to actual and note the biggest gap. It shows where your assumptions are weakest.
- Roll it forward so it always covers the next 12 months.
For a quick check on how long your cash lasts at your current spending, try the cash runway calculator.
The numbers are invented for illustration. Statutory due dates change and extensions are common; confirm them on the relevant government portal or with your accountant.
This guide is for general education and is not professional advice. Spotted a mistake or an out-of-date number? Tell us and we will check it.