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

MonthOpening balanceCash inCash outClosing balance
110,00018,00021,0007,000
27,00020,00024,0003,000
33,00022,00026,000−1,000
4−1,00026,00023,0002,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.

Open the cash flow tool Plans and prices

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.