Onetribe is a consulting firm specialising in management reporting, controlling, and finance function transformation for mid-market companies in Central Europe. A rolling forecast is the practice of continuously updating financial projections on a fixed horizon — typically 12 to 18 months ahead — rather than anchoring forecasts to a fiscal year-end. Each month or quarter, the oldest period drops off and a new period is added, maintaining a constant forward view.
The concept is well understood. McKinsey identifies rolling forecasts as the single best predictor of CFO satisfaction with the planning process. AFP surveys show adoption rates of 40–55% among larger organisations. Yet at mid-market level — companies with £1–50M revenue and one to five finance staff — adoption lags far behind. This guide explains how to implement a rolling forecast with realistic resources.
Why the Annual Budget Is Not Enough
The annual budget sets targets and allocates resources. Those are valuable functions. But the budget has a structural limitation: it is fixed in time. By Q2, the assumptions behind the budget have shifted — customer demand, input costs, staffing, exchange rates — and the budget no longer reflects expected reality.
Deloitte’s UK PBF survey confirms: roughly 75% of organisations report that their annual budget is significantly disconnected from actual business conditions by mid-year. The budget becomes a historical artefact that variance analysis compares against — but the variances reflect stale assumptions, not management performance.
A rolling forecast solves this by maintaining a continuously updated view of expected outcomes. The budget says “where did we plan to go?” The forecast says “where are we actually heading?”
Rolling Forecast vs. Annual Budget
| Annual Budget | Rolling Forecast | |
|---|---|---|
| Horizon | Fiscal year-end (fixed) | 12–18 months ahead (rolling) |
| Update cadence | Annual | Monthly or quarterly |
| Level of detail | High (line-item, cost centre) | Medium (key drivers, top-level P&L) |
| Purpose | Target-setting, resource allocation | Expectation management, early warning |
| What it tells you | “What did we plan?” | “What do we now expect?” |
| When it fails | When assumptions change (always) | When discipline lapses (optional) |
These are not competing tools — they are complementary. The budget provides the target. The forecast provides the trajectory. Variance analysis connects the two.
The Onetribe Forecast Maturity Model
| Level | Name | Characteristics | Typical Company |
|---|---|---|---|
| 1 | No forecast | Company operates without forward-looking financial projections | Smallest firms, owner-managed |
| 2 | Static annual budget | One annual budget, no updates during the year | Most mid-market companies |
| 3 | Budget with ad-hoc updates | Annual budget plus occasional reforecasts when things change | Growing companies with a controller |
| 4 | Quarterly rolling forecast | 12–18 month horizon, updated quarterly, driver-based | Mature mid-market, some external pressure |
| 5 | Continuous driver-based planning | Monthly updates, scenario modelling, integrated P&L-balance-cash | Best-in-class mid-market; enterprise standard |
Most mid-market companies sit at Level 2. The goal is not to reach Level 5 overnight — it is to move one level at a time. Moving from Level 2 to Level 3 takes weeks, not months. Moving from Level 3 to Level 4 is where the real value unlocks.
How to Implement a Rolling Forecast — Six Steps
Step 1: Define the Horizon and Cadence
Horizon: 12 months is the minimum for meaningful forward visibility. 18 months is better — it always extends beyond the fiscal year-end, preventing the “cliff” effect where visibility drops to zero in December.
Cadence: Quarterly updates are the practical starting point for most mid-market companies. Monthly is better but requires more discipline and data.
Step 2: Identify 5–10 Key Drivers
Do not forecast every line item. Identify the five to ten business drivers that determine 80% of the P&L: revenue by segment, headcount, production volume, key cost categories. Build the forecast from these drivers, not from 200 general ledger lines.
Step 3: Build a Simple Model (Even in Excel)
The model connects drivers to financial outcomes. Revenue = volume × price. Personnel cost = headcount × average cost. Variable costs = volume × unit cost. This is driver-based planning — and it works in Excel.
Step 4: Establish the Update Process
Who provides driver updates? (Sales for pipeline, operations for production, HR for headcount.) When? (Five working days after month-end.) Who consolidates? (Controller or finance lead.) Without process, the forecast dies after the second cycle.
Step 5: Compare Forecast to Budget and Actuals
The rolling forecast creates a three-way comparison: budget (target), forecast (expectation), actuals (reality). This is more powerful than simple budget-vs-actual because it separates “did we set the right target?” from “is our current trajectory on track?”
Step 6: Integrate Into the Management Rhythm
The forecast should be part of the monthly or quarterly leadership meeting — not a separate exercise. Present the forecast alongside actuals and budget. Discuss the three to five largest forecast changes. Make decisions based on the forward view, not the rear-view mirror.
Common Rolling Forecast Mistakes
1. Forecasting in Too Much Detail
A rolling forecast with 200 line items takes as long as the annual budget and collapses under its own weight. Keep it at driver level. Detail belongs in the budget and the management report .
2. No Accountability for Forecast Inputs
If sales does not update the pipeline forecast, the revenue line is fiction. Each driver must have a named owner who provides updated assumptions each cycle.
3. “Forecasting” Last Year’s Numbers Forward
A forecast that simply extrapolates historical trends is not a forecast — it is a projection. A rolling forecast incorporates known changes: new contracts, lost customers, price changes, capacity constraints.
4. Abandoning the Annual Budget
The rolling forecast does not replace the budget. It complements it. The budget remains the accountability framework for targets and resource allocation. Removing it creates a governance vacuum.
5. Not Acting on the Forecast
A forecast that predicts a cash shortfall in six months but triggers no action is a waste of time. Every forecast update should identify required actions — or explicitly confirm that none are needed.
Frequently Asked Questions
Do I need to choose between an annual budget and a rolling forecast? No. They serve different purposes. Keep the annual budget for target-setting and accountability. Add a rolling forecast for continuous expectation management. The two together are more powerful than either alone.
Can I implement a rolling forecast in Excel? Yes. Most mid-market companies start in Excel. A driver-based model with 5–10 key drivers, a 12–18 month horizon, and quarterly updates is entirely feasible in a well-structured workbook. Software adds value when the number of scenarios, contributors, or consolidation dimensions grows beyond Excel’s practical limits.
How much time does maintaining a rolling forecast take? For a quarterly update with a driver-based model: two to three days of finance time per cycle, plus one to two hours from each driver owner (sales, operations, HR). The investment is modest; the return is a continuous forward view that prevents surprises.
What is the difference between a rolling forecast and a reforecast? A reforecast updates the remaining months of the fiscal year — it shrinks as the year progresses. A rolling forecast maintains a constant horizon (e.g. always 12 months ahead) regardless of where you are in the fiscal year. The rolling approach provides consistent forward visibility.
Where This Fits in Our Expertise
Rolling forecasts sit within the Planning & Projections pillar at Onetribe. They connect the annual budget (the target) to variance analysis (the investigation) and management reporting (the communication). Without a forecast, the company navigates by the rear-view mirror. With one, it navigates by the road ahead.
Further Reading
- How to Build an Annual Budget That Works — the target-setting framework that the forecast complements
- Variance Analysis — A Practical Guide — analysing deviation from both budget and forecast
- Management Reporting Framework — the reporting structure that communicates forecast outcomes
- Cost Structure Analysis — the cost framework that drives forecast accuracy
- Glossary: Rolling Forecast | Budget | Forecast | Driver-Based Planning | Scenario Analysis
Sources
- McKinsey — Forecasting Best Practices — rolling forecasts as the single best predictor of CFO planning satisfaction
- AFP — Rolling Forecast Survey 2024 — 40–55% enterprise adoption; mid-market lags significantly
- Deloitte UK — PBF Survey — 75% of budgets significantly disconnected from reality by mid-year
- The Hackett Group — FP&A Benchmark — top-quartile planning cycle benchmarks
- PwC — Finance Effectiveness Benchmarking — planning process efficiency data
- Beyond Budgeting Institute — two decades of advocacy for continuous planning
- IMA — Rolling Forecast Guidance — professional body implementation guidance
- FP&A Trends — driver-based forecasting community research
Martin Duben is CEO of Onetribe — a consulting firm specialising in management reporting, controlling, and finance function transformation for mid-market companies in Central Europe. With over 15 years of experience, he helps CFOs and business owners build information systems that support decision-making. Contact: onetribe.team .