What a cash flow forecast shows
A cash flow forecast sets all expected cash in against cash out, month by month, and shows how your bank balance develops. The goal: never become unable to pay, even when customers pay later or a larger bill falls due.
Behind it is one basic equation: opening balance + cash in − cash out = closing balance. The closing balance of one month is the opening balance of the next. This links every month without gaps.
Cash and profit are two different things. Profit arises when you deliver a product or service, cash only when the money actually flows. That is why a profitable business can run out of cash, for example when customers only pay after 60 days, inventory grows or an investment is due.
That makes your customers' payment terms decisive, measured as DSO (days sales outstanding): how many days it takes on average for the money to arrive. Book each sale in the month in which the payment arrives, even if you invoiced it earlier.
How it differs from a cash flow statement: The cash flow forecast lists cash in and cash out month by month and shows the bank balance. The cash flow statement explains the change per year, starting from the profit. The financial plan contains both.
Example: six months at a glance
A simplified example shows the principle. All amounts in euros, calculated net of VAT.
| Item | Jan | Feb | Mar | Apr | May | Jun |
|---|---|---|---|---|---|---|
| Opening balance | 20,000 | 22,500 | 26,300 | 32,050 | 36,500 | 44,200 |
| Cash in | 40,000 | 42,000 | 45,000 | 43,000 | 48,000 | 50,000 |
| − Purchase of goods | 14,000 | 14,700 | 15,750 | 15,050 | 16,800 | 17,500 |
| − Staff | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 |
| − Fixed costs | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 |
| − Debt service | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 |
| Net cash flow | 2,500 | 3,800 | 5,750 | 4,450 | 7,700 | 9,000 |
| Closing balance | 22,500 | 26,300 | 32,050 | 36,500 | 44,200 | 53,200 |
In the full plan, taxes, investments and private withdrawals are added as separate lines; the example leaves them out to keep it clear. If the closing balance falls below zero, the plan shows a cash shortfall, which you close with an overdraft facility, negotiated payment terms or an investment spread over a longer period.
Liquidity in the complete financial model
Planvik builds you a formula-driven financial model with profit and loss statement, cash flow statement, balance sheet and repayment schedules, and tracks your cash position month by month across all plan years.
Why the plan calculates directly
The cash flow forecast lists cash in and cash out directly, as in the example above. That way you see which money flows when. The second route, adjusting from net income, is the job of the cash flow statement.
Typical mistakes
- Revenue treated as cash received. Payment terms often delay the incoming money by weeks.
- Net and gross mixed up. Both are acceptable as long as you stick to one approach: gross throughout, with the VAT payable as a separate cash outflow (this is how the free template works), or net in the P&L with VAT shown at its payment date in the cash flow (this is how the Planvik financial model works).
- Investments, taxes or debt service forgotten. These large outflows are exactly what tears holes in the plan.
- Only annual figures instead of months. An annual figure hides the months in which the account is empty.
Frequently asked questions
How many months should a cash flow forecast cover?
Twelve months on a rolling basis is common. For a loan application, the first year is usually shown month by month and the following years annually.
What is the difference between a cash flow forecast and a cash flow statement?
The cash flow forecast lists cash in and cash out month by month and shows the bank balance. The cash flow statement explains the change per year, starting from the profit, usually using the indirect method.
Does the forecast include or exclude VAT?
The free template calculates gross and shows the VAT payable as a separate cash outflow, so you see your real bank balance. The Planvik financial model plans the P&L net, as is usual for bank plans, and shows VAT at its payment date in the cash flow. What matters is to stick to one approach within a plan.
What do I do if there is a cash shortfall?
Keep an overdraft facility ready, negotiate shorter payment terms with customers and longer ones with suppliers, or spread larger investments over time.