What Is Quarterly Rolling Forecast?

A quarterly rolling forecast is a financial projection that always looks the same distance ahead. Each quarter you drop the one that just finished and add a new one at the far end, so the horizon never shortens. A four-quarter rolling forecast in March looks through to the following March; in June it looks through to the June after.

Contrast that with an annual budget, which is set once and then decays. By October, a budget written the previous November is forecasting three months ahead using assumptions eleven months old.

How it works

• Choose a horizon, commonly four to six quarters
• At each quarter end, replace forecast with actual for the quarter that closed
• Revise the remaining quarters based on what you now know
• Add a new quarter at the end so the horizon stays constant
• Record the variance between what you forecast and what happened, and why

Why the variance step is the important one

Rolling the forecast forward without examining what you got wrong produces a document that is perpetually current and perpetually inaccurate. The variance analysis is where the learning sits: which assumptions were optimistic, which cost lines you consistently underestimate, whether seasonality behaves the way you thought.

After a few cycles you stop guessing about your own business and start forecasting from observed behaviour, which is the entire point.

Rolling forecast versus annual budget

• A budget is a commitment, used for accountability and often tied to targets
• A rolling forecast is a best estimate, updated as reality arrives
• A budget answers “are we on plan.” A forecast answers “where are we heading”

They are not mutually exclusive, and larger businesses run both. A small business that only has capacity for one is generally better served by the forecast, because it drives decisions rather than measuring against a number set before the year began.

How this differs from a 13-week cash forecast

Different horizon, different purpose. The 13-week forecast is weekly, cash-based, and about liquidity: will there be money in the account on the day it is needed. A quarterly rolling forecast is longer-range and typically covers profit and loss as well as cash, and it is about direction: hiring, capacity, pricing, and investment.

Businesses with payroll benefit from running both. They answer different questions.

Running one in a small business

A spreadsheet is sufficient. What matters is that it is built from the same chart of accounts as your actual statements, so forecast and actual can be compared line by line without translation. Forecasting against categories that do not exist in your books makes variance analysis impossible.

That also means the books need to be current and closed on a schedule. A forecast compared to actuals that are six weeks late is comparing an estimate to another estimate.

Define the rolling horizon

A rolling forecast maintains a constant forward view by closing completed periods and adding new future periods. State whether the horizon is months or quarters and how far it extends beyond the current quarter.

Lock reliable actuals

Reconcile the ledger and supporting schedules before replacing forecast periods with actual results. Preserve the prior forecast so variance can be measured rather than rewritten.

Update drivers, not every cell

Refresh customers, volume, price, utilization, headcount, wage rates, materials, collection and payment timing, capital spending, and financing from named sources. Separate inputs from formulas and assign owners.

Explain variance

Classify differences as timing, volume, price, mix, execution, assumption, scope, or data correction. Use the evidence to update future periods only when the underlying expectation changed.

Link scenarios to action

Focus downside and upside cases on uncertain drivers. For each, identify trigger, decision owner, action, lead time, and constraint. A scenario without a decision is extra output, not planning.

Quarterly process checklist

• Forecast horizon and cutoff are explicit
• Actuals reconcile and closed periods are locked
• Driver assumptions have owners and sources
• Prior forecast remains available
• Variances have consistent reason codes
• Balance, cash, and formula checks pass
• Decisions, approvals, and next actions are recorded

Separate the reporting horizon from the decision horizon. The model may cover several quarters, while a hiring, pricing, capacity, borrowing, or capital decision needs a nearer deadline and specific evidence. Keep monthly detail where timing matters and summarize later periods only when that does not hide liquidity or operational constraints. Review forecast accuracy by driver and horizon, not only total profit. A model can appear accurate because offsetting errors cancel. Preserve actual, prior forecast, current forecast, variance reason, and management action in the review pack. Approve material changes to definitions, formulas, sources, entity scope, currency, and scenario logic.