Cash flow forecast

A cash flow forecast shows how much money will come in and go out of the business each month, and what will be left in the bank at each month end. It warns you weeks ahead when cash will run short, so you can arrange funds or move a payment in time.

Every month
ItemIn or out₹ a month% change a month
One-off items
ItemIn or outMonth no.₹
Month 1 is the first month of the sheet. Use one-offs for a loan received, equipment, advance tax or GST, a big order.
Cash at the end of 12 months
₹2,90,055 (2.90 lakh)
Lowest month-end balance₹72,381
Months ending below zero0

Nothing you type leaves this browser: the sheet is made here and printed by you.

Your 12-month sheet

How the sheet works

Each month: opening balance + cash in − cash out = closing balance. The closing balance becomes the next month's opening balance.

A regular item with a % change grows (or shrinks, with a negative number) by that percentage each month: amount in month n = first month's amount × (1 + change ÷ 100)^(n − 1).

Worked example

The sheet above starts with ₹2,00,000 in the bank. Receipts of ₹4,50,000 a month growing by 2%, regular payments, a machine for ₹1,50,000 in month 3 and a tax payment of ₹60,000 in month 6 leave ₹2,90,055 at the end of the year. The lowest month-end balance is ₹72,381, in month 6.

Tips for a forecast you can rely on

More business calculators

Questions people ask

How is this different from a profit and loss account?

Profit counts a sale when you make it, even if the customer pays in 60 days, and spreads the cost of a machine over years as depreciation. A cash forecast counts money only when it actually moves. A profitable business can still run out of cash.

What should I put in receipts?

Cash sales, money you expect to collect from customers that month (not the sales you make that month), loans you will receive, capital you will bring in, and any asset you will sell.

What should I put in payments?

Payments to suppliers, salaries, rent, power, loan EMIs, GST and TDS you will deposit, advance tax, and any equipment you will buy. Leave out depreciation, which is not a payment. The tax calendar lists the due dates.

Is my data saved or sent anywhere?

No. The sheet is worked out in your browser and nothing you type is sent to us. Print it or save it as PDF before you close the page.

Need help with tax, GST or your accounts?

A tax professional can call you back. Asking is free.

Get help

More calculators

Results are estimates for information only, not financial or tax advice. Rates, rules and limits change, so check with your bank, employer or a qualified adviser before you decide.