| Item | Nov 26 | Dec 26 | Jan 27 | Feb 27 | Mar 27 | Apr 27 | May 27 | Jun 27 | Jul 27 | Aug 27 | Sep 27 | Oct 27 | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Opening balance | 2,00,000 | 2,05,000 | 2,13,400 | 75,268 | 90,673 | 1,09,687 | 72,381 | 98,828 | 1,29,105 | 1,63,287 | 2,01,453 | 2,43,682 | |
| Cash in | |||||||||||||
| Cash sales and receipts from debtors | 4,50,000 | 4,59,000 | 4,68,180 | 4,77,544 | 4,87,094 | 4,96,836 | 5,06,773 | 5,16,909 | 5,27,247 | 5,37,792 | 5,48,547 | 5,59,518 | 60,35,440 |
| Total cash in | 4,50,000 | 4,59,000 | 4,68,180 | 4,77,544 | 4,87,094 | 4,96,836 | 5,06,773 | 5,16,909 | 5,27,247 | 5,37,792 | 5,48,547 | 5,59,518 | 60,35,440 |
| Cash out | |||||||||||||
| Purchases and payments to suppliers | 2,80,000 | 2,85,600 | 2,91,312 | 2,97,138 | 3,03,081 | 3,09,143 | 3,15,325 | 3,21,632 | 3,28,065 | 3,34,626 | 3,41,318 | 3,48,145 | 37,55,385 |
| Salaries | 90,000 | 90,000 | 90,000 | 90,000 | 90,000 | 90,000 | 90,000 | 90,000 | 90,000 | 90,000 | 90,000 | 90,000 | 10,80,000 |
| Rent | 35,000 | 35,000 | 35,000 | 35,000 | 35,000 | 35,000 | 35,000 | 35,000 | 35,000 | 35,000 | 35,000 | 35,000 | 4,20,000 |
| Loan EMI | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 3,00,000 |
| Electricity, phone and other | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 1,80,000 |
| New machine | 1,50,000 | 1,50,000 | |||||||||||
| GST and tax payments | 60,000 | 60,000 | |||||||||||
| Total cash out | 4,45,000 | 4,50,600 | 6,06,312 | 4,62,138 | 4,68,081 | 5,34,143 | 4,80,325 | 4,86,632 | 4,93,065 | 4,99,626 | 5,06,318 | 5,13,145 | 59,45,385 |
| Net cash flow | 5,000 | 8,400 | −1,38,132 | 15,405 | 19,013 | −37,306 | 26,448 | 30,277 | 34,182 | 38,166 | 42,229 | 46,374 | 90,055 |
| Closing balance | 2,05,000 | 2,13,400 | 75,268 | 90,673 | 1,09,687 | 72,381 | 98,828 | 1,29,105 | 1,63,287 | 2,01,453 | 2,43,682 | 2,90,055 | |
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.
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
- Base receipts on when customers really pay. Your debtor days tell you how late that is.
- Plan for festival months, slow seasons and annual payments such as insurance and renewals.
- Update the forecast with actual figures each month and roll it forward.
- Keep a cushion: a month's fixed costs in the bank, or an agreed overdraft limit.
More business calculators
- Business and accounting calculators
- Break-even calculator
- Gross profit calculator
- EBITDA calculator
- ROI calculator
- NPV calculator
- IRR calculator
- Payback period calculator
- Working capital calculator
- Current ratio calculator
- Quick ratio calculator
- Debt to equity ratio
- Inventory turnover calculator
- Debtor days calculator
- Depreciation calculator
- Accounting basics
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.
A tax professional can call you back. Asking is free.
Get helpMore 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.