Cash Flow Forecast 2027: Free Excel Template + Step-by-Step Guide

Building a cash flow forecast for 2027 is no longer optional for small businesses in France. With the PLF 2027 debate reshaping fiscal assumptions, rising working capital pressure, and banks now requiring 24-month rolling forecasts before approving credit lines, knowing exactly where your cash stands — and where it's heading — is the difference between growing with confidence and firefighting every month.

In this guide, you'll get a complete Excel-based cash flow forecasting model, a clear step-by-step method to populate it, and a transparent look at when Excel starts working against you — and what to do then. Whether you run a 3-person consulting firm or a 50-person manufacturing business, the fundamentals are the same.

What Is a Cash Flow Forecast — and Why Does 2027 Demand One?

A cash flow forecast (prévisionnel de trésorerie) is a forward-looking projection of all cash inflows and outflows over a defined period. Unlike profit and loss statements, which record economic activity on an accrual basis, a cash flow forecast tracks the actual movement of money in and out of your bank account — week by week or month by month.

For 2027 specifically, three forces make forecasting more urgent than ever:

• PLF 2027 fiscal uncertainty: R&D credit reforms, VAT timing changes, and evolving tax brackets are forcing SMEs to model multiple scenarios simultaneously. Search volume for "scenario modeling" on French SME finance forums jumped +156% year-over-year between September 2025 and September 2026.
• Working capital squeeze: French SMEs carry an average Cash Conversion Cycle of 63 days — versus 45 days for the EU average and just 35 days in Germany. That gap represents a structural cash drain that forecasting helps you anticipate and manage.
• Tighter lending conditions: Banks increasingly require rolling 24-month cash flow projections before approving revolving credit facilities. A well-maintained forecast isn't just good management — it's a financing prerequisite.

"Only 41% of French SMEs currently use automated treasury forecasting tools — meaning 59% are still relying on manual Excel spreadsheets or legacy accounting systems. Yet integrated treasury tools reduce forecast error (MAPE) from 22–28% down to just 6–11% on a 3-month horizon." — Bpifrance Digital Maturity Study, 2025

The Excel Cash Flow Forecast Model: Structure and Components

Before diving into the step-by-step method, let's define the architecture of a solid 12-month cash flow forecast in Excel. A robust model has four core sections:

Section 1 — Opening Cash Balance

The starting point. This is the actual cash balance in your bank account (or accounts) at the beginning of the forecast period. Pull this directly from your bank statement, not your accounting software, to avoid timing discrepancies caused by uncleared transactions.

Section 2 — Cash Inflows

Every source of cash entering the business. For most SMEs, this includes:

• Customer receipts (invoiced sales converted to actual payments — apply your DSO)
• Advance payments or deposits
• Loan disbursements or credit facility drawdowns
• Tax refunds (VAT, CIR, etc.)
• Asset disposals
• Grants or subsidies (BPI, Région, etc.)

Section 3 — Cash Outflows

Every payment leaving the business. Split these into:

• Fixed operating costs: Rent, salaries, insurance, subscriptions — costs that don't move with revenue. French SMEs average 58% fixed costs as a share of total operating expenses.
• Variable operating costs: Raw materials, freelancers, delivery, packaging
• Debt service: Loan repayments, leasing payments
• Tax payments: TVA, IS, CFE, payroll charges — timing matters enormously here
• Capex: Equipment purchases, software licences, fit-out costs

Section 4 — Closing Cash Balance and Minimum Reserve Check

Opening balance + total inflows − total outflows = closing balance. Add a conditional row that flags any month where closing cash falls below your minimum reserve target. Bpifrance recommends maintaining 45–60 days of operating expenses as a cash buffer at all times.

Step-by-Step Method: Building Your 2027 Cash Flow Forecast in Excel

Step 1 — Gather Your Data (30 minutes)

Pull together the last 12 months of bank statements, your current outstanding invoices (accounts receivable), your upcoming fixed commitments (rent schedule, loan repayment table, insurance renewals), and your sales pipeline for the next 3–6 months. Don't skip the bank statements — accounting records lag reality by days or weeks.

Step 2 — Set Up Your Excel Template (20 minutes)

Create a tab for each of the four sections. Use a monthly column structure across 12 months (Jan 2027 → Dec 2027), with an optional Q1 2028 column as a buffer. Lock your assumption cells (DSO, DPO, average invoice size, growth rate) in a separate "Parameters" tab — this makes scenario modelling dramatically easier in Step 5.

Step 3 — Populate Fixed Costs First (45 minutes)

Fixed costs are your most reliable data. Enter every committed outflow: rent, gross salaries, employer charges, loan repayments, leasing, SaaS subscriptions, insurance. These form the floor of your monthly cash requirement. For most French SMEs, this number alone accounts for 58% of total outflows.

Step 4 — Model Revenue and Variable Costs (1–2 hours)

This is the hardest part. Use three inputs: (1) confirmed orders/contracts, (2) pipeline probability-weighted estimates, and (3) historical seasonality factors. French SMEs experience average monthly cash flow swings of ±35% — retail and construction see even higher volatility. Apply your sector's seasonality pattern to avoid being blindsided in slow months.

Step 5 — Build Three Scenarios (30 minutes)

A single-point forecast is a false sense of security. Build three versions using your Parameters tab:

• Base case: Current pipeline, no major surprises, existing payment terms maintained
• Downside case: Revenue −20%, DSO extended by 15 days, 2–3 major customers delay payment
• Upside case: Revenue +15%, faster collections, one large contract lands in Q2

In 2026, 68% of French SMEs revised their budgets at least twice due to external shocks (MEDEF, Q3 2026). Having pre-built scenarios means you update assumptions, not the entire model.

Step 6 — Review and Update Monthly (Ongoing)

A forecast you build in January and never touch again is worthless by March. Commit to a monthly review: compare actual vs. forecast, understand the variances, and roll the model forward. Manual Excel users average 6–8 hours per month on forecast maintenance — a meaningful cost for small teams.

Benchmarks: How Does Your Forecasting Practice Compare?

Use this table to benchmark your current approach against industry data for French SMEs in 2025–2026:

Source: EY CFO Barometer France 2026; Bpifrance Digital Maturity Study 2025; IDC France Finance Automation 2025.

The Limits of Excel — and When to Move On

Excel is a perfectly valid starting point. But research is clear about where it breaks down. In a 2026 survey, 71% of French SME finance professionals said Excel-based forecasting creates "moderate to high" operational risk. The top vulnerabilities cited: version control issues (84%), formula errors (76%), and no audit trail (59%).

The practical tipping points where Excel becomes a liability:

• You have more than one person editing the same forecast file
• You're managing cash across multiple bank accounts or entities
• You need your forecast to update more frequently than once a month
• Your bank requires a current, credible forecast for a credit facility review
• You're spending more than 4 hours a month on forecast maintenance

At these thresholds, the cost of Excel errors — missed payment warnings, wrong scenario assumptions, stale data — exceeds the cost of a dedicated tool. For context: treasury software adoption among French SMEs grew +31% year-over-year between 2024 and 2025 (IDC France, 2025), and Gartner projects +22% CAGR in CFO tech spend through 2028 in the French SME segment.

Platforms like Trezy connect directly to your bank via Open Banking-powered cash flow management, automatically categorise transactions with 95% AI accuracy, and generate rolling 3–12 month forecasts without manual data entry. The result: forecast error rates in the 6–11% range instead of the 22–28% typical of manual Excel, at a fraction of the time cost.

Key Cash Flow Metrics Every French SME Should Track in 2027

Your forecast is only as useful as the KPIs embedded in it. Here are the benchmarks that matter for French SMEs, based on 2025 data from CCIR and Bpifrance:

• Cash Conversion Cycle target: Below 50 days (French average is 63 — 13 days above EU average)
• Days Sales Outstanding (DSO): Monitor against your sector average (French SME mean: 52 days, range 38–71 by sector)
• Days Payable Outstanding (DPO): Optimise without damaging supplier relationships (French SME mean: 41 days)
• Minimum cash reserve: 45–60 days of operating expenses (Bpifrance guidance)
• Fixed cost ratio: Know your 58% benchmark — and flag any months where fixed costs exceed 65% of outflows
• Forecast accuracy (MAPE): Track monthly; target below 15% on a 3-month rolling horizon

Trezy's real-time P&L and KPI dashboard tracks 27+ of these metrics automatically, updated every time a transaction hits your account — no manual entry required.

Frequently Asked Questions About Cash Flow Forecasting

How far ahead should a 2027 cash flow forecast project?

For most French SMEs, a 12-month rolling forecast strikes the right balance between actionability and accuracy. The EY CFO Barometer (2026) found French SMEs average only 3.2 months of forward visibility — well below the 6.8-month average for mid-market companies. Extending your horizon to 12 months, even with wider confidence intervals in later months, materially improves your ability to act on emerging cash gaps before they become crises. For bank financing purposes, 24 months is increasingly expected.

What's the biggest mistake SMEs make in cash flow forecasting?

Conflating revenue recognition with cash receipt. An invoice raised in November may not be paid until January — especially with a 52-day average DSO in France. Building your forecast on sales figures rather than expected payment dates is the single most common source of dangerous optimism. Always apply your actual DSO when converting sales forecasts into cash inflow projections.

How often should I update my cash flow forecast?

Monthly as a minimum; weekly if you're in a growth phase, carrying significant debt, or operating with thin cash reserves. Integrated treasury tools now enable continuous updating — 62% of finance managers surveyed in 2026 described monthly manual reconciliation as an "efficiency waste" (FBF Digital Services Report, 2026). If you're on Excel, calendar a fixed 90-minute session at the start of each month for your forecast review.

Is a free Excel template enough, or do I need dedicated software?

Excel is a legitimate starting point for businesses with straightforward cash flows, a single bank account, and a finance owner with time to maintain the model. It becomes a risk once your business grows beyond roughly 10 employees, you're managing multiple accounts or entities, or forecast maintenance is eating more than 4 hours a month. At that point, the ROI on a dedicated tool — starting from €0 with Trezy's free plan — is immediate. Trezy also offers OCR document management for invoices and receipts, and supplier cost analysis to track input cost inflation directly within your forecast.