Free Template

Rolling Forecast Template

Move beyond the static annual budget with a rolling forecast that extends 12 months ahead at all times. As each month closes, actuals replace the forecast and a new month is added to the end. Includes variance tracking against the original budget.

What's included

Everything in this template

  • 12-month rolling forecast horizon
  • Automatic period extension as months close
  • Actuals vs forecast comparison
  • Variance to original budget
  • Driver-based assumption inputs
  • Trend analysis and seasonality adjustments

Template preview

See the structure

fx=IF(Month<=Current, Actual, Forecast)
Line
Actual
Forecast
Budget
Revenue
£412k
£435k
£420k
COGS
(£159k)
(£165k)
(£162k)
Gross Profit
£253k
£270k
£258k
OpEx
(£105k)
(£110k)
(£108k)
Net Income
£92k
£98k
£95k

Step by step

How to use this template

1

Start with your annual budget

Import or copy your annual budget as the starting forecast. This gives you a baseline to update each month.

2

Update actuals monthly

As each month closes, replace the forecast with actual figures. The template automatically shifts the rolling window forward.

3

Re-forecast remaining months

Review and update the forecast for all remaining months based on latest information, trends, and changing assumptions.

4

Extend the horizon

Add a new month to the end of the forecast so you always have 12 months of forward visibility.

5

Analyse variance

Compare the rolling forecast to the original budget to understand how expectations have evolved throughout the year.

Watch out

Common mistakes to avoid

Only updating the current month rather than re-forecasting all future months

Not extending the horizon — letting the rolling forecast shrink over time

Treating the rolling forecast as a restatement of budget rather than a genuine best estimate

Build this in Grove FP in minutes

Import this template directly into Grove FP and start planning. No credit card required.

FAQ

Frequently asked questions