Financial Planning & Analysis Implementation Guide

Rolling Forecasts: A Constant 12-Month View Alongside the Budget

How a rolling forecast works, how to choose horizon and frequency, how it relates to the budget, with implementation steps and common mistakes.

  • A rolling forecast covers a fixed-length period ahead at every update, for example the next 12 months or 4 quarters. The horizon does not shrink as the year goes on.
  • It does not replace the budget. The budget is the target; the rolling forecast shows the direction expected on current information.
  • To work, it needs a low level of detail, a short update cycle and written assumptions. If it turns into rebuilding the budget every month, it cannot be sustained.

The annual budget rests on a forecast made at the start of the year. As the year goes on, the assumptions behind it change: prices, exchange rates, demand, costs. A traditional year-end forecast covers a shorter period every month; a year-end forecast made at the end of October covers only two months and says nothing about cash needs in the first months of the next year. A rolling forecast deals with both problems. For the basic difference between budget and forecast, see budget versus forecast.

How it works

At each update, for example at every month-end:

  1. The month just closed is entered as actual.
  2. A new month is added at the end of the horizon, so the forecast always looks the same length ahead.
  3. The remaining months are reviewed with current assumptions.
UpdatePeriod covered (12-month horizon example)
End of JanuaryFebruary – January of the following year
End of FebruaryMarch – February of the following year
End of MarchApril – March of the following year
The rolling forecast horizon moving forward at each update.

Choosing horizon and frequency

  • Horizon: For example, 12 months or 4 quarters can be chosen; this covers the period management makes decisions about. Long-term investment or financing decisions are handled in a separate medium-term plan.
  • Frequency: Monthly updates suit businesses with high volatility. In stable businesses, quarterly updates may be enough.
  • Detail: Less detail than the budget: by main revenue and cost drivers, not by account.

A driver-based approach

To keep a rolling forecast sustainable, link it to a few main drivers instead of forecasting every line by hand. For example:

  • sales: volume × price, by channel or main product group,
  • main costs: unit cost assumptions, energy and raw material prices,
  • people: headcount × average cost,
  • working capital: collection and payment periods.

When the drivers change, the forecast can be updated quickly through the model. For detail, see driver-based budgeting.

Budget, rolling forecast and performance assessment

A rolling forecast does not change the budget. Performance can continue to be assessed against the budget approved at the start of the year. The rolling forecast answers three questions:

  1. On current information, where are the year and the following months heading?
  2. If a variance from budget is expected, what should be done to close it?
  3. What are the cash and financing needs over the next 12 months?

Using the forecast as a performance target can lead people to forecast low or high on purpose. State clearly that the forecast is the “expected” outcome and that the target is kept separately.

Implementation steps

  1. Define the scope: Which statements? At least the income statement and cash flow; the balance sheet if possible.
  2. Choose the drivers: The few main drivers that determine the result.
  3. Calendar: On which working day after close the forecast is updated, and who provides which input.
  4. Assumption log: A short list of assumptions that changed at each update.
  5. Tracking: Compare earlier forecasts with actuals; measure forecast accuracy over time.

Common mistakes

  • Preparing a full budget every month: With too much detail, an update takes weeks and the process is abandoned.
  • Deleting the budget: Without a target, it becomes unclear what performance is assessed against.
  • Not writing down assumptions: The number changes but no one knows why.
  • Leaving out cash flow: A profit forecast alone does not show financing needs.

What it means for management

A rolling forecast lets management look the same distance ahead every month. The budget keeps the target; the rolling forecast shows the direction. Built with a few drivers, a short update calendar and written assumptions, it changes the question in management meetings from “how will we close the year?” to “what should we do for the next 12 months?”.

The horizon, frequency and level of detail should be set according to the company’s business model. Method: This article is professional analysis; it makes no claim that rests on legislation, a provision of a standard or statistics.

Sources last checked: