Rolling forecast: meaning, example and how to build one

Most annual budgets are out of date by the end of the first quarter. A rolling forecast fixes that by always looking the same distance ahead, so leadership never runs out of plan.

What is a rolling forecast?

A rolling forecast is a forecast that extends a fixed number of periods into the future and moves forward every time a period closes. A 12-month rolling forecast always shows the next twelve months. When January closes, February to January of next year becomes the new window.

A static annual budget, by contrast, covers a fixed fiscal year. By October it only shows two months ahead.

A 12-month rolling forecast example

Say it is the end of March and your fiscal year runs January to December.

• Static forecast: January to March are actuals, April to December are forecast. The horizon is nine months and shrinking.
• 12-month rolling forecast: January to March are actuals, and the forecast covers April this year to March next year. The horizon stays at twelve months.

At the end of April, April becomes actual and the window extends to April next year. Each cycle you re-forecast the open months using the latest actuals and assumptions.

Rolling forecast vs budget

The budget (or annual operating plan) is a target and a baseline for accountability. The rolling forecast is the current best estimate of what will happen. Most companies keep both: the budget stays fixed for variance reporting, while the rolling forecast is updated monthly or quarterly to support decisions on hiring, spend and cash.

Why driver-based forecasting matters

Re-forecasting every line item by hand every month is exactly why many rolling forecasts get abandoned. The way to make it sustainable is to forecast drivers instead of results:

• Revenue from pipeline, conversion rate and average deal size, or from customers, churn and price.
• People cost from headcount by role and fully loaded cost per head.
• Hosting or cost of sales from usage or revenue ratios.
• Opex from run rates plus known one-off items.

When a driver changes, every dependent line updates. Forecast owners only touch the handful of assumptions that actually moved, which keeps the monthly cycle to days instead of weeks.

How to build a rolling forecast model

1. Set the horizon and cadence. Twelve or eighteen months, updated monthly or quarterly. Align it with how often leadership makes decisions.
2. Separate versions. Keep Actual, Budget and Forecast as distinct versions, with a switchover date that marks where actuals end and forecast begins. The switchover moves forward each cycle.
3. Load actuals automatically. Pull closed-month actuals from the ERP and HR system on a schedule so nobody re-keys them.
4. Model the drivers. Build each forecast area from its drivers, not from typed totals, and keep assumptions in clearly owned input metrics.
5. Snapshot each cycle. Save a copy of the forecast at each cycle so you can measure forecast accuracy over time.
6. Report against all three. Show actual versus budget versus latest forecast, and forecast versus prior forecast to explain what changed.

Doing it in Pigment

Pigment's version dimension and switchover settings handle the actual-to-forecast boundary, so the same metric can show actuals for closed months and forecast for open months without separate formulas. Scenarios let you test an upside or downside case on top of the latest forecast, and snapshots preserve each cycle for accuracy tracking. The Titan demonstration shows a driver-based SaaS forecast built this way, with an ARR bridge that reconciles from beginning to ending ARR.

Common mistakes

• Forecasting at too much detail. Forecast at the level decisions are made, not at the general ledger account level.
• No ownership. Every driver needs a named owner and a deadline in the cycle.
• Overwriting history. Without snapshots you cannot tell whether forecasts are getting more accurate.
• Treating it as a finance-only exercise. Sales, HR and operations own most of the drivers.

Frequently asked questions

What does rolling forecast mean?

It means a forecast that always covers the same number of future periods and rolls forward one period each time a period closes, instead of ending at the fiscal year end.

How often should a rolling forecast be updated?

Monthly is common for fast-moving businesses; quarterly works for more stable ones. The cadence should match how often leadership makes resource decisions.

Can you do a rolling forecast in Excel?

Yes, for a small business. It becomes hard to maintain once several owners contribute, versions multiply and actuals need loading every month, which is when teams move to a planning platform such as Pigment.