How to Run a Rolling Forecast Process

A rolling forecast process is a recurring cycle in which finance updates a forward-looking forecast every month or quarter, always covering the same number of future periods, such as the next 12 months or the next four quarters, by replacing the period that just closed with a new period at the end. The budget sets the target for the year; the rolling forecast says where you now expect to land and keeps the planning horizon from shrinking as the year goes on. This guide explains how to design the process: choose the horizon and level of detail, select drivers, assign owners, set a monthly calendar, work through a roll-forward example, keep it light enough to sustain and avoid the failure modes that turn it into a second budget. It is part of budgeting and forecasting, builds on rolling forecast vs. static budget and driver-based forecasting, and connects to the annual planning calendar and quarterly business reviews.

What a rolling forecast is for

It does not replace the budget, which remains the commitment and the basis for targets. It also does not replace operating detail. It is a management tool for the few lines that drive results.

Design decisions

Horizon

Common choices: 12 months rolling, 18 months, or four to six quarters. Match it to the decisions: lead times for purchasing and hiring, financing cycles and seasonality. A business with a long supply lead time needs a longer horizon for the lines that depend on it. Add detail for the near term and less for the distant months.

Level of detail

Forecast at a level where drivers are clear and owners can explain the numbers. A typical rolling forecast covers revenue by major line, gross margin, headcount and personnel costs, a handful of large cost categories, capital spending and cash. It does not reforecast every account.

Frequency

Monthly for most businesses after the close; quarterly for stable ones; weekly for cash. The process must be light enough to run on schedule. If it takes three weeks, it is another budget.

Drivers

Select a small number of drivers for each line and keep them consistent with the budget so you can compare. See driver-based forecasting. Example drivers: units and price for revenue, margin rates, headcount and average cost, days of working capital.

A roll-forward example

A hypothetical company has a 12-month revenue budget (thousands of dollars):

The annual budget is 1,350.

After the March close, actuals for the first quarter are 96, 98 and 101, a total of 295 against a budget of 305 (100 + 100 + 105): a shortfall of 10, or 3.3 percent. The team reviews the cause (a delayed customer order and a competitor promotion) and judges that the rest of the year will run at 96 percent of budget.

Forecast for April to December = 100.8 + 105.6 + 105.6 + 110.4 + 110.4 + 115.2 + 115.2 + 120.0 + 120.0 = 1,003.2.

Full-year outlook = 295 (actual) + 1,003.2 (forecast) = 1,298.2, which is 51.8 or 3.8 percent below the budget of 1,350.

Rolling the horizon forward

A static budget now looks only to December. The rolling forecast keeps 12 months in view by adding next January to March. Suppose the team forecasts next year's first quarter at 105, 105 and 110, a total of 320.

• Next-12-months view (April to next March) = 1,003.2 + 320 = 1,323.2

Each month, the forecast drops the month just closed (replaced by the actual) and adds a new month at the end. The management question changes from "will we hit this year's budget?" to "what do the next twelve months look like, and what should we do about it?" Comparing the outlook with last month's version shows what changed: the forecast for the full year moved from the budget of 1,350 to 1,298.2, a change of -51.8, with a stated reason. Keep that history.

Roles and responsibilities

A monthly calendar

Keep a fixed calendar and protect it. Skipping a month breaks the habit and the comparison.

What to include in the pack

• Outlook versus budget and versus last forecast, with a bridge of changes.
• Key driver changes and the reasons.
• Risks and opportunities with approximate size and probability.
• Cash forecast and covenant headroom.
• Accuracy measures for prior forecasts. See how to measure financial forecast accuracy.
• Decisions required.

Keeping it light

• Forecast fewer lines than the budget.
• Update drivers, not every account.
• Use a template that owners can complete in minutes.
• Automate actuals and reports where possible.
• Reuse the structure of the budget model. See budgeting in Excel.
• Stop forecasting lines that nobody uses.

Governance

Failure modes

Link to operations

The forecast of revenue and cost should start from the operating plan. For product companies, that means the demand plan, supply plan and inventory plan. Differences between the sales forecast, purchasing plan and finance forecast are a common source of surprises. See demand planning and inventory optimization. Link margin assumptions to the economics of each product. See unit economics.

FAQs

What is a rolling forecast?

A forecast updated regularly that always covers a fixed number of future periods, such as 12 months, by adding a new period as each one closes.

How often should a rolling forecast be updated?

Usually monthly after the close, sometimes quarterly. Cash forecasts are often weekly.

How is a rolling forecast different from a budget?

A budget sets targets and resource commitments for a period; a rolling forecast gives the latest expectation and extends the horizon.

How many periods should a rolling forecast cover?

Commonly 12 months or four to six quarters, matched to your decision lead times.

Does a rolling forecast replace the annual budget?

Not usually. Many companies keep a budget for targets and use the rolling forecast for outlook and decisions.