The 13-week cash flow forecast is standard practice for finance teams. But accuracy is hard to maintain. They look great on day one. If left alone, the variance between projected and actual drifts quickly.

Why does this happen? When you pull accounts payable and receivable balances on Monday, they are obsolete by Tuesday. A major client delays payment by 15 days. A supplier demands early settlement. Suddenly, your cash position drops by €250,000, and your model didn't see it coming.

The failures look different depending on your company size—but the root cause is the same: static data.

Start-ups: the runway trap

For start-ups and scale-ups, cash is survival. A broken forecast doesn't just mean a missed target. It means missing payroll.

The biggest mistake start-ups make is falling into the best-case trap. Founders and early finance hires assume every invoice gets paid on day 30. They assume sales will close exactly when the CRM says they will. They don't. Enterprise deals slip. Clients stretch payment terms to 60 or 90 days.

The fix: runway triggers and precise AP/AR. Decide your thresholds in advance and model each client's real payment behaviour. … read more show less

You need to stress test the assumptions. What happens if your biggest customer churns? What happens if your next funding round is delayed by three months?

To fix this, you need strict runway triggers. Define exactly what happens if cash drops below a specific threshold. If your balance hits €500,000, maybe you freeze hiring. If it hits €250,000, you cut marketing spend. Build these triggers directly into the 13-week model. Don't wait until the bank account is empty to make hard decisions.

You also need to track AP and AR with precision. Stop looking at aggregate numbers. Look at the specific payment history of your top five clients. If Client A always pays 14 days late, model their payment at day 44, not day 30. If a vendor allows 60-day terms, do not pay them on day 15 just because the invoice arrived. If you can hold the cash without damaging relationships, you've discovered a free source of funding.

Mid-market: the integration gap

For mid-sized companies (€10m-€1bn revenue), the problem isn't survival. It's growing complexity.

You have multiple bank accounts, different currencies, and hundreds of transactions a day. A manual 13-week forecast built in Excel cannot keep up. The model fails because it is disconnected from reality.

The fix: live bank feeds, a linked pipeline, and mapped seasonality. Automate the inputs so the forecast stays tied to reality. … read more show less

The fix starts with open banking integration. Your forecast must pull live balances and transaction data directly from your banks. If you are still downloading CSV files and copying them into a master sheet, your data is already dead. Automated bank feeds give you a real-time baseline. You cannot forecast the next 13 weeks if you don't know exactly how much cash you have today.

Next, link your sales pipeline to your cash forecast. Many mid-market finance teams forecast cash based entirely on historical averages. But historical data doesn't predict the future. If your sales team just closed a €2 million contract with a 90-day payment term, that needs to hit the model immediately. Connect your CRM or ERP to your forecasting tool. When a deal moves to "Closed Won," the expected cash inflow should automatically populate in the correct week.

Finally, identify seasonal gaps. Mid-market companies often have hidden seasonality. You might pay annual software licenses in January and annual bonuses in March. You might have a massive VAT bill due in July. If your 13-week model rolls over these periods without adjusting for massive cash outflows, you will face a sudden liquidity crunch. Map out every major annual expense and build it into the specific week it hits.

Beyond the next quarter

Most finance teams live in the next 13 weeks. Short-term cash flow forecasting keeps the lights on. It tells you if you can make payroll next month. But it does not tell you if your business model is sustainable.

To make strategic decisions, you need to look further out. A 12 to 36-month forecast shifts your focus from survival to capital allocation. It forces you to ask hard questions about burn rates and debt maturity, and gives you the visibility to make strategic decisions.

The approach changes depending on your size. A start-up uses long-term forecasting to survive until the next funding round. A €200m manufacturing firm uses it to manage currency risk and debt covenants. Here is how to build your models at either end of the spectrum.

Start-ups and scale-ups: timing the next raise

For early-stage companies, cash is a ticking clock. The primary goal of a 24 to 36-month forecast is timing your next equity raise.

Founders often assume they can raise money whenever they hit a revenue milestone. The reality is different. Fundraising takes six to nine months. If your forecast shows you running out of cash in 12 months, start updating your pitch-deck now.

Build your model around milestones. If you need €5m in ARR to raise a Series B, map out the exact sales hires, marketing spend, and product development required to get there. Then, calculate the cash burn.

Keep the inputs simple. Do not model individual travel expenses. Group your outflows into major categories: payroll, marketing, server costs, and rent. Then run three scenarios:

  • Base case: your realistic growth plan.
  • Worst case: revenue growth stalls, but fixed costs remain.
  • Stretch case: sales explode, requiring faster hiring and higher working capital.

If your worst-case scenario shows cash dipping below zero before your Series B milestone, you have a problem. You must cut burn now, not in six months.

Mid-market companies: risk, gaps, and exposure

When revenue crosses €50m, the focus shifts. You are no longer fighting for survival. You are managing complexity.

For mid-sized companies, a 12 to 36-month forecast is about identifying funding gaps and market risks before they hit the P&L.

Spotting funding gaps

Growth consumes cash. If you plan to open a new facility in 18 months, your 13-week forecast will not show the capital expenditure. A 36-month model will.

Map out your debt maturity schedule. If a €10m term loan matures in 24 months, your forecast will show whether you can pay it out of free cash flow or if you need to refinance. Knowing this two years in advance gives you negotiating power with lenders. Finding out three months before maturity reduces your options and earns you a worse interest rate.

Managing pricing and FX exposure

Mid-market companies often face significant supply chain and currency risks.

Consider a €100m European retailer buying inventory from Asia in USD and selling in EUR. A 24-month forecast projects the volume of USD needed. If the EUR weakens, margins collapse. By forecasting these currency needs 12 to 24 months out, the treasury team can formulate a hedging policy and execute trades to lock in margins and reduce earnings volatility.

The same applies to interest rates. If your forecast shows a need to draw down €5m from a revolving credit facility next year, you can model the impact of a 2% rate hike. If that hike breaks your debt covenants, you can adjust your capital structure today.

How to build a model that actually works

Most long-term forecasts fail because they are too detailed. A 36-month model is not an accounting exercise, it's a strategic exercise.

Focus on the big drivers. In most businesses, revenue growth, gross margin, headcount, and major capital expenditures dictate the majority of your cash position. Focus on these.

Connect the P&L to the balance sheet. A common mistake is forecasting revenue without forecasting working capital. If your enterprise sales cycle requires 90-day payment terms, doubling your revenue will drain your cash before it increases it. Your model must reflect the cash conversion cycle.

Update it monthly. A long-term forecast is not an annual budget. It is a living document. When you close the books each month, update the actuals and roll the forecast forward. If you miss your revenue target in Q1, your 24-month cash runway just shrank. You need to know that immediately.

Stop guessing

Whether you are a start-up timing a Series B or a mid-market CFO managing currency risk, you cannot make good decisions without a map. Build the model. Keep it simple. Review it, investigate where forecasts deviate from reality, update it frequently. Repeat.