Qees business tools › Lessons › Cash flow
How to make a cash flow forecast
A cash flow forecast tells you when money will run short in your account before it happens, so you can find a fix calmly instead of on payday.
The rule
Closing balance = opening balance + cash in − cash out
And each month's closing balance is the next month's opening balance.
What goes in each column?
- Cash in: cash sales, credit sales in the month you actually collect them, and loans and financing.
- Cash out: purchases in the month you pay for them, rent, salaries, loan repayments, taxes and equipment.
A four-month example
| Month | Opening balance | Cash in | Cash out | Closing balance |
|---|---|---|---|---|
| 1 | 10,000 | 18,000 | 21,000 | 7,000 |
| 2 | 7,000 | 20,000 | 24,000 | 3,000 |
| 3 | 3,000 | 22,000 | 26,000 | −1,000 |
| 4 | −1,000 | 26,000 | 23,000 | 2,000 |
The first shortfall is in month 3, and the lowest balance is −1,000. If you want never to go below 5,000 as a buffer, you need 6,000 more before month 3: from financing, delaying a purchase or collecting faster.
Tips
- Start with 13 weeks if cash is tight, and months for longer planning.
- Be cautious with cash in and generous with cash out.
- Update the forecast every week or month with the actual numbers.
Apply it to your business. The free cash flow tool shows the first month with a shortfall, the lowest balance and how much you need, from 13 weeks to 24 months.
Frequently asked questions
What is the difference between a cash flow forecast and an income statement?
The income statement measures profit when you sell; the cash flow measures money when it actually comes in and goes out. A profitable business can still run short of cash.
How many months should the forecast cover?
13 weeks for day-to-day management, and 12 to 24 months for planning and financing.