the guide
Cash flow forecast: see your cash position months ahead
By Shivam Bhandari · Reviewed 31 October 2026 · How we write
A cash flow forecast estimates the money coming in and going out of your business month by month, and keeps a running total of cash in the bank. It shows problems — such as a month where cash goes negative — before they happen.
Profit and cash are not the same. Sales on credit, stock purchases, loan repayments and tax payments can make a profitable business short of cash. A six-month forecast gives you time to act.
the formula
Closing cash = Opening cash + Cash in − Cash out
- · Cash in: customer payments actually received, loans, investment.
- · Cash out: suppliers, salaries, rent, EMIs, taxes and other payments actually made.
- · Each month's closing cash becomes the next month's opening cash.
Worked example: three months
- Month 1: opening ₹2,00,000 + ₹5,00,000 in − ₹5,50,000 out = ₹1,50,000 closing.
- Month 2: ₹1,50,000 + ₹4,00,000 − ₹5,00,000 = ₹50,000.
- Month 3: ₹50,000 + ₹6,00,000 − ₹5,20,000 = ₹1,30,000.
- Month 2 is the danger point — the owner can arrange credit or chase receivables in advance.
Tips
- 1Forecast cash when you expect to be paid, not when you invoice.
- 2Include irregular payments such as annual insurance, GST and bonuses.
- 3Compare forecast with actual every month and improve your assumptions.
- 4Keep a minimum cash buffer, such as one or two months of fixed costs.
Frequently asked questions
What is a cash flow forecast?
A month-by-month estimate of cash coming in and going out, used to predict future cash balances.
Why is cash flow different from profit?
Profit counts sales when made and costs when incurred; cash flow counts money when it actually moves. Credit sales, stock and loan repayments create the difference.
How far ahead should I forecast cash flow?
Most small businesses benefit from a rolling 3–6 month forecast, updated monthly.
What causes cash flow problems?
Late customer payments, excess stock, rapid growth, seasonal sales, large one-off payments and thin margins.