Creating a Cash Flow Forecast – A Practical Guide for Entrepreneurs

A cash flow forecast is the entrepreneur's most important tool for financial management – and yet surprisingly many SME entrepreneurs neglect to create one. According to a Bank of Finland study, nearly 40% of Finnish SMEs do not prepare regular cash flow forecasts. It is like driving a car without a dashboard: you roughly know where you are going, but running out of fuel comes as a surprise.

What Is a Cash Flow Forecast and Why Is It Important?

A cash flow forecast is a projection that estimates a company's future cash movements over a given period. It tells you when money comes in, when it goes out, and what the cash balance is at each point. Unlike an income statement, a cash flow forecast is based on the actual movement of money – not accounting accruals.

As an entrepreneur, I have seen how the lack of a cash flow forecast repeatedly leads to crisis situations. In my own company, the first serious cash shortfall threat came as a surprise because I had not accounted for VAT payment and payroll falling on the same week. After that, I adopted a 13-week rolling forecast and have never gone back.

The benefit of a cash flow forecast is above all anticipation. When you can see 2–3 months ahead, you have time to react to cash shortfalls. You can negotiate payment terms, apply for financing, or postpone investments. Without a forecast, you can only react when cash has already run out – and then options are fewer and more expensive.

13-Week Rolling Cash Flow Forecast – The Best Model for SMEs

The 13-week rolling cash flow forecast is an established method used by both small and large companies. Thirteen weeks covers approximately three months, which is long enough to detect cash shortfalls but short enough for accurate forecasting.

Rolling means the forecast updates each week: as one week is realised, a new week is added at the end. This keeps the forecast horizon constant. Week by week, forecast accuracy also improves as you compare projections to actuals and learn to identify patterns.

Creating a Cash Flow Forecast Step by Step

Step 1: Gather Initial Data

Start by collecting all necessary information. In practice, you need from your accounting and invoicing software: open sales invoices and their due dates, open payables, recurring fixed payments (rent, salaries, insurance, loan repayments), VAT obligations and refunds, advance tax payment schedule, and sales estimates.

In my own company, I use Procountor data as a base and transfer it to an Excel model where I prepare the actual forecast. The most important thing is that the initial data is up to date. Outdated data produces an incorrect forecast, which is worse than no forecast at all.

Step 2: Categorise Cash Flows

Divide cash flows into clear categories. On the income side, typical categories are: accounts receivable (existing invoices), expected new orders, VAT refunds, and other income (e.g. grants, rental income). On the expense side: salaries and social contributions, rent and premises, payables and materials, VAT payments, advance taxes, loan repayments and interest, and other fixed and variable costs.

Step 3: Estimate Uncertain Items

A cash flow forecast always contains uncertain items – especially future sales and customers' actual payment schedules. A good principle is to estimate income conservatively and expenses on the high side. According to Statistics Finland, Finnish SMEs have an average payment delay of about 8 days past the agreed due date, so factor this into your forecast.

Practical tip: assign a probability to each uncertain item. If a EUR 50,000 deal is 60% probable, enter EUR 30,000 in the forecast. This keeps the forecast realistic rather than based on wishful thinking.

Step 4: Calculate Net Cash Flow and Track Balance

Calculate each week's net cash flow: income minus expenses. Add it to the previous week's closing balance to get the new week's opening balance. The most important thing is to monitor whether the balance turns negative or critically low at any point. A good rule of thumb is to always have at least two weeks' fixed expenses in cash.

Scenario Analysis – Prepare for Different Situations

A single forecast is not enough. Prepare at least three scenarios: optimistic, realistic, and pessimistic. In the optimistic scenario, all sales materialise and clients pay on time. In the realistic, sales are on budget and payment delays are normal. In the pessimistic, the largest client is 30 days late and one deal falls through.

Scenario analysis is a lifesaving tool especially in uncertain times. During the 2024 recession, entrepreneurs who had prepared for the pessimistic scenario fared significantly better than those living in an optimistic bubble.

Tools for Creating a Cash Flow Forecast

There is an abundance of tools available for cash flow forecasting. The choice depends on the company's size, needs, and budget. The most important thing is to choose a tool you will actually use regularly.

Most Common Mistakes in Cash Flow Forecasting

Over the years, I have identified several recurring mistakes entrepreneurs make in their cash flow forecasts. Avoiding these significantly improves forecast reliability.

Cash Flow Forecast in Practice – An Example

Imagine a marketing agency with EUR 80,000 monthly invoicing. Clients' average payment time is 35 days. Fixed monthly expenses are EUR 55,000 (salaries EUR 35,000, rent EUR 5,000, software EUR 3,000, other EUR 12,000). Cash balance at the start of the month is EUR 25,000.

The 13-week forecast shows that in week 6 the cash balance drops below EUR 10,000, because two large clients' invoices are not due until week 8 and payroll falls on week 6. This information gives the entrepreneur an opportunity to react: they can accelerate invoicing, negotiate payable deadlines, or use invoice financing on the largest invoices.

How Does a Cash Flow Forecast Help with Financing Decisions?

A cash flow forecast is not just an internal tool – it is also a key to better financing decisions. When you know precisely when and how much additional financing you need, you can choose the most affordable option. A short-term cash gap is most affordably solved with invoice financing, while a permanent working capital need requires a longer-term solution.

Financiers also value a company that can present a cash flow forecast. It demonstrates professionalism and financial management. In Finnvera and bank financing decisions, a cash flow forecast is often one of the required documents.

Summary

A cash flow forecast is the SME entrepreneur's most important tool for managing liquidity. A 13-week rolling forecast provides sufficient visibility into future cash flows and enables proactive responses to cash shortfalls. Creating a forecast does not require complex tools – Excel is sufficient to start. The most important thing is regular updating and tracking actuals against projections.