Rolling Forecasts: A Practical Guide

The annual budget is approved once, and within a few months it describes a company that no longer exists: prices have moved, a large customer has signed, a hire has slipped. A rolling forecast solves that problem. Instead of always looking to 31 December, it keeps a fixed horizon that moves forward every month or quarter. This guide covers what a rolling forecast is, how it differs from the budget, how to design one and how to run it without overloading the finance team.

What is a rolling forecast?

A rolling forecast is a financial projection that is updated periodically and always covers the same number of periods ahead. With a 12-month horizon and monthly updates, when January closes you add a new month at the end (January of the following year) and rework the months in between with the latest information. The horizon rolls, hence the name.

It is a core practice of FP&A (financial planning and analysis), the function that turns strategy into numbers, tracks delivery and supports decisions. For the wider picture, read what FP&A is.

Rolling forecast vs. static annual budget

The difference is one of purpose, not just calendar:

• The annual budget sets targets and allocates resources. It is a commitment and rarely changes during the year.
• The rolling forecast estimates what will actually happen with the best information available. It is a decision tool, not a commitment.
• The budget ends at year-end, so in October it only sees two months ahead. The rolling forecast always sees the same horizon.
• The budget is built in great detail once a year. The forecast focuses on the variables that drive results and is revisited often.

That is why they coexist. The budget sets the target; the rolling forecast tells you whether you will hit it and what needs to change. If you are still building the former, see how to build a company budget.

Horizon and update cadence

• 12-month horizon: the most common choice for SMEs. Always a full year ahead and easy to maintain.
• 15 or 18 months: useful for long cycles, strong seasonality or when you need early sight of next year to negotiate financing.
• Monthly updates: recommended in fast-changing environments or with tight cash. Fits naturally right after the month-end close.
• Quarterly updates: enough for stable businesses. Less effort, slower reaction.

A common mix is to update the next three months monthly in more detail and review the rest of the horizon quarterly at a higher level.

Driver-based models

A rolling forecast rebuilt line by line every month quickly becomes unsustainable. The key is modelling from drivers: the operational variables behind the numbers, such as active customers, average price, billable hours, headcount by department, cost per hire or days sales outstanding. When a driver changes, revenue, costs and cash recalculate consistently.

• Subscription software: new customers, churn, average revenue per customer.
• Professional services: billable headcount, utilisation, hourly rate.
• Distribution or retail: units sold, average price, gross margin, inventory turnover.
• Overheads: headcount by area, average salary, fixed costs per office.

Pick few drivers, the ones that really move the result. Ten well-understood drivers beat two hundred lines nobody reviews.

Worked example (illustrative figures)

Take a services company with a 12-month horizon and monthly updates. The numbers are a round example, not real data:

• In January the forecast assumes 40 billable consultants, 75% utilisation and an average rate of €60 per hour.
• At January close, actual utilisation was 70%, and a contract has been signed that starts in April and needs 5 more consultants.
• In the February update, finance lowers expected utilisation for February and March, adds 5 hires from March so they are trained by April, and extends the horizon to January of next year.
• The model recalculates revenue, payroll and cash. Q1 lands slightly below budget, Q2 makes up for it, and a cash outflow peak in March becomes visible in advance.

That last insight is the point: the annual budget would not have shown it, and management can now decide in time whether to arrange a credit line or stagger the hires.

How to implement a rolling forecast step by step

1. Define the purpose: cash visibility, hiring decisions, board reporting? The purpose sets the level of detail.
2. Choose horizon and cadence: start with 12 months and monthly or quarterly updates, then adjust.
3. Identify the drivers together with the owners of each area, who know them best.
4. Build the model: link drivers to P&L, balance sheet and cash flow, starting from closed actuals.
5. Set a calendar: for example, actuals on day 5, area inputs on day 8, management review on day 10.
6. Assign owners: every driver needs someone who updates and explains it.
7. Measure and learn: track forecast versus actual to improve accuracy over time.

A dedicated rolling forecast tool helps most with steps 4 to 7: no copying tabs, version history kept, and every area entering data into the same model.

Rolling forecasts and scenarios

A rolling forecast reflects the most likely case, but management usually needs a range. On the same driver model you can build a cautious and an optimistic case by changing a handful of variables such as sales, prices or collection delays. When something changes, you already know your levers. More on this in scenario planning.

Common mistakes

• Too much detail: if an update takes two weeks, it will stop happening.
• Treating it as the budget: if every update becomes a target renegotiation, teams will game their inputs.
• Finance working alone: without sales, operations and people input, the forecast loses quality and credibility.
• Not measuring accuracy: without comparing forecast and actuals you cannot tell if the model improves.
• Ignoring cash: a P&L forecast without cash leaves out the question SMEs worry about most.

Rolling forecast checklist

• Horizon and cadence defined and communicated.
• Short list of drivers, each with an owner.
• Monthly or quarterly calendar tied to the close.
• Model linking P&L, balance sheet and cash.
• Forecast compared with actuals and with budget.
• At least one alternative scenario ready.
• Short management summary with conclusions and decisions.

A rolling forecast does not replace the budget; it makes it useful all year round. If you want to see one applied to your case, OnePlan can show you in a personalised demo.