Rolling Forecast Template: 12-Month Forecasts (Excel Template)

What's inside this rolling forecast template for Excel

This template helps organize your Rolling Forecast for your OpEx Spending. You can download the monthly actuals from your ERP and copy those into the actualized periods in the template. You may also input the actuals into this template and pull in the summarized data via spreadsheet formulas (SUMIFs, VLOOKUP's, etc.).

Next, you can pull in, enter, or update formulas to calculate your forecast figures. There's a "Latest Closed Month" filter on each tab to update the time horizon you are planning for.

This model has eight components:

1. Department variances: Find where department expenses differ from budgeted amounts.
2. OpEx variances: Identify gaps between your actual operating expenses and what you budgeted for.
3. Steps: Organize the actions taken to keep your forecast updated.
4. OpEx plan: Create a blueprint for anticipated operating expenses over a set period.
5. Headcount analysis: Track how many employees you have compared to your planned number of employees.
6. Sales & marketing: Predict and assess sales and marketing expenses.
7. T&E: Monitor travel and entertainment expenses associated with business activities.
8. Drivers: Keep tabs on the key factors that impact your company’s financial health.

Use this rolling forecast template with Cube

This is an Excel template. You don't need to be a Cube customer to use it! But if you are a Cube user, you can start using this template in under two minutes. Here's how.

Step 1: Open the template in Excel or Sheets.

Step 2: Customize the row and column headers to match your Cube's dimensions and filters.

Step 3: Select the range where you want to fetch your data. 

Step 4: Fetch your data.

What is a rolling forecasts?

A rolling 12-month forecast is a planning method that continuously projects your expected results over the next year, no matter what month you’re currently in.

Instead of building a forecast once a year and letting it sit, a rolling forecast is updated every month. When one month closes, you drop the completed month from your forecast and add a new month to the end, keeping the planning window a full 12 months into the future at all times.

The result is a living, breathing forecast that evolves alongside your business. Each update incorporates your most recent performance—revenue, expenses, customer growth, market shifts—so you’re always planning with the freshest data available. This allows you to:

• Integrate real results: As each month’s actuals come in, you compare them to your previous forecast and adjust future months as needed.
• Refresh assumptions: If sales are trending higher, churn is dropping, or a new cost emerges, the forecast reflects those changes immediately.
• Extend the planning horizon: You’re never stuck looking only to year-end. You always have a full 12-month picture ahead of you, which supports better strategic budgeting and long-term decision-making.
• Improve agility: Because the forecast is updated regularly, you can respond quickly to unexpected changes instead of waiting for the next annual budgeting cycle. That way, your predictions aren’t based on assumptions made many months ago, but on what’s actually happening in your business right now.

Why rolling forecasts are important

Rolling forecasts give organizations a clearer operational roadmap and help teams stay aligned around what’s coming next. This helps with:  

• Improved cash flow visibility: It’s easier to see upcoming cash needs, timing gaps, and funding requirements. This helps teams plan for expenses, investments, and liquidity before issues arise.
• Better resource allocation: Companies can adjust hiring plans, marketing spend, production schedules, and inventory levels to match what the business will really need.
• Stronger cross-functional alignment: Departments like sales, operations, and finance stay on the same page about targets, capacity, and priorities.
• More effective communication with stakeholders: Leadership, investors, and board members get a more reliable picture of what the next 12 months look like, improving transparency and confidence in decision-making.
• Early identification of constraints: XXX surface operational bottlenecks, such as bandwidth limitations, supply issues, or cost increases, before they disrupt performance.
• Support for scenario and contingency planning: Teams can model alternative plans—hiring delays, pricing changes, market shifts—and prepare backup strategies.
• Smoother long-term planning: Companies can better plan large future initiatives like product launches, capital expenditures, or geographic expansion.

Rolling forecasts vs. static budgets

Rolling forecasts and static budgets serve different purposes, and choosing the right approach depends on how your business operates.

Rolling forecasts are built for flexibility. They continuously update based on the latest actuals and assumptions, helping you respond quickly to shifting market conditions. This makes them ideal for fast-paced, dynamic environments where plans need to evolve frequently.

Static budgets, on the other hand, are fixed for a specific time period—usually a fiscal year. They promote structure, cost control, and long-term alignment. If your business environment is stable or highly regulated, static budgets can help enforce financial discipline and provide a clear benchmark for performance.

So, when should you use one over the other?

• If your company needs to stay agile and adjust plans throughout the year, rolling forecasts are a better fit.
• If your organization benefits from a consistent financial plan with less frequent changes, a static budget may be the right choice.

That said, many companies use both. A static annual budget can serve as a baseline, while rolling forecasts allow for in-year updates and more accurate decision-making. It’s not always an either/or—it’s about using the right tool for the right purpose.

Rolling forecast cadences

Rolling forecasts can be structured in different cadence formats depending on how frequently a company wants to update its outlook and how far into the future it wants visibility. They’re typically written as two numbers, such as 3+9 or 8+4, which indicate how many months of actuals you’ve completed and how many months of forecast remain in the 12-month window.

Different businesses gravitate toward specific cadences based on volatility, forecast accuracy needs, and seasonality. Here’s a breakdown of the most common formats:

• 3+9 forecast: Uses 3 months of actual results and 9 months of forecasted data. Best suited for fast-moving, high-growth companies where performance changes quickly and long runway visibility matters.
  
  Example: A SaaS startup experiencing rapid user growth uses 3+9 because they need a long forecast horizon to plan cash runway, feature launches, and hiring across the year.
  
  
• 4+8 forecast: Incorporates 4 months of actuals and 8 months of forecast. Ideal for growing mid-market companies that have somewhat stable historical patterns but still face moderate variability.
  
  Example: A scaling eCommerce brand uses 4+8 because they have reliable first-quarter results but need eight months visibility to plan inventory, hiring, and ad spend.
  
  
• 8+4 forecast: Based on 8 months of actuals and 4 months of forecast. A strong fit for companies with predictable cycles where most of the year’s performance is already known by late summer.
  
  Example: A seasonal apparel manufacturer prefers 8+4 because by August they’ve captured most of their annual sales pattern and only need to forecast the remaining few months.
  
  
• 9+3 forecast: Uses 9 months of actual performance and 3 months of forecast. Typically adopted by mature, low-volatility companies with stable long-term contracts.
  
  Example: A utility provider relies on 9+3 because demand patterns barely change month to month, and only the final quarter needs forecast attention.

How to make a 12-month forecast

Creating a rolling 12-month forecast involves several strategic steps. Here’s how to make and maintain a rolling forecast template for your business:

1. Gather accurate and current data

Effective rolling forecasts depend on robust data collection from both internal and external sources. Start with your completed budget as the foundation, then layer in actual financial figures from your financial reporting dashboards for each closed period. Internal data should include departmental performance metrics, sales pipelines, and operational KPIs that reveal business patterns.

Complement this with external market intelligence—industry benchmarks, economic indicators, and competitive analysis—to provide crucial context. This dual approach helps you anticipate market shifts while maintaining financial accuracy.

Before incorporating any data point, validate its reliability through cross-verification and assess its historical predictive accuracy. This ensures your rolling forecast remains both relevant and trustworthy, significantly reducing the risk of misguided financial decisions.

2. Define your objectives

Establishing an end goal and objectives for your company is key to a successful rolling forecast. They’re what dictate the direction your forecast takes, including which metrics you’ll track. Define what you’re forecasting, who will use the forecast, and what decisions it will inform.

Example objectives you might establish for your rolling forecast include:

• Improving cash flow management by projecting monthly runway and identifying potential cash gaps 90 days in advance
• Enhancing budgeting accuracy through monthly variance analysis with less than 5% deviation from actuals
• Supporting strategic planning by quantifying the financial impact of new market expansions or product launches
• Adjusting operational strategies based on real-time cost trends to maintain target gross margins within your goals 

3. Customize the rolling forecast template in Excel or Sheets to match your Cube's dimensions and filters

Once you’ve chosen and downloaded your free FP&A Excel template, open it in Excel or Google Sheets to start customizing it. If you’re a Cube user, the next step is to push and pull your data stored in the Cube cloud. To make it happen, customize the row and column headers of your spreadsheet so they match your Cube’s dimensions and filters exactly. This creates a delivery system between your data and the rolling forecast template.

4. Select the range where you want to fetch your data

A range is the designated rows and columns that tell Cube what data to retrieve and how to display it. It uses your dimension names to connect your spreadsheet data to your data in the cloud.

You can use any type of dimension member in your range, including tags, formulas, and attributes. Cube will recognize them so long as their names match exactly.

5. Utilize forecasting software

Forecasting and budgeting software automates data collection and consolidation, eliminating manual work and providing real-time insights so companies can strategize with speed and agility. AI forecasting tools, in particular, uncover hidden patterns and flag anomalies that usually escape even the most diligent human analysis. 

For rolling forecasts specifically, the forecasting software can incorporate your most recent actuals and preserve previous forecast versions for variance analysis. It transforms financial planning from a backward-looking compliance exercise into a forward-thinking competitive advantage that drives better business decisions.

6. Identify which stakeholders will be involved

Involve various departments in the forecasting process to gain diverse insights—including non-financial executives. Typically, finance, sales, operations, and marketing play crucial roles in contributing to a well-rounded forecast. To choose which stakeholders will provide the most valuable perspectives and data, use your objectives as the ultimate deciding factor.

7. Pick the most important metrics to hone in on

Identify key operational metrics that directly influence your company’s chosen end goal and objectives, and track them within your rolling forecast template. Any changes to these metrics can be used to analyze how your finances are being impacted so you can adjust course accordingly. 

Some example metrics your business might want to track include:

• Runway: The amount of time your company can continue at its current spending rate before it runs out of cash.
• Average revenue per account: The average revenue generated from each customer account over a specific period.
• Burn rate: How quickly your company is using up its available capital.
• Churn rate: The rate at which customers cancel their subscription or stop using your company’s service. 
• Gross margin: The percentage of revenue your company retains after deducting the direct costs of producing your product or service.
• Customer acquisition cost: The total cost your company incurs to gain a new customer.

8. Fetch your data

Your rolling forecast template can’t give you on-point financial calculations and predictions if the data being used is unreliable or outdated. Always make sure your data is accurate and up-to-date before fetching. Once you’ve confirmed your data is good to go, import it to your spreadsheet.

9. Compare the date between actual and estimated

Make sure your finance team reviews variances between projected and actual numbers. Tracking actual performance and comparing it to the forecasted data helps leadership understand which targets were met or missed—and why. 

This intel is helpful for making more reliable projections for the next round of financial forecasting models.

10. Update the forecast

The defining quality of a rolling forecast is that it can be reviewed and adjusted regularly based on current market conditions. Updating your forecast on a monthly basis will reflect the latest data and market changes so you can help you quickly determine if you need to reallocate company resources to keep your goals on track.  

Regular updates ensure your forecasts remain relevant and accurate so your company can stay agile and responsive to new information.

11. Use your data for decision-making

When your company exists in an ever-evolving landscape, rolling forecasts can help you better prepare for market shifts. They allow you to quickly adjust spending in response to current market data, helping you stay ahead of the curve while navigating economic changes. Rolling forecasts also give leadership the data necessary for identifying areas that need attention and tending to them before serious problems crop up.

Best practices for using a rolling forecast template

A rolling forecast is only effective as the processes sorrounding it. Even the best template won't deliver meaningful insights unless your team maintains consistent habits, clear communication, and discriplined review cycles.

To ensure your rolling forecast template delivers real value, follow these best practices:

• Use consistent processes for data updates: Establish a standard workflow for importing actuals, updating assumptions, and validating calculations so your forecast remains reliable month after month.
• Create clear documentation: Maintain an accessible guide that explains inputs, formulas, definitions, and ownership. This ensures new team members can onboard quickly and reduces confusion when making updates.
• Schedule regular review cycles: Set a recurring cadence—monthly or quarterly—to review performance against the forecast, discuss variances, and refine assumptions based on recent trends.
• Maintain strong stakeholder engagement: Involve leaders from finance, operations, sales, and marketing so the forecast reflects cross-functional realities and remains relevant to decision-makers.
• Limit unnecessary complexity: Use the level of detail that supports decision-making, but avoid overloading the template with inputs that create more work without improving accuracy.
• Keep assumptions transparent: Track key drivers, such as hiring, pricing, production costs, or customer growth, and make sure changes are clearly communicated and approved.
• Centralize your data sources: Whenever possible, pull actuals from a single system of record to reduce errors and ensure your forecast updates quickly and consistently.
• Monitor variance trends: Compare actual performance to projected results routinely to identify patterns, improve accuracy, and strengthen future assumptions.
• Assign clear ownership: Make sure responsibilities are defined for updating actuals, reviewing assumptions, and sharing the forecast with stakeholders so nothing falls through the cracks.
• Use the template to drive actions: Ensure the rolling forecast informs decisions about hiring, spending, investments, and growth initiatives, not just financial reporting.

Grab your free template

Our free Rolling 12-Month Forecast template for Excel is designed to enhance your financial forecasting with accuracy and efficiency.

Get started today by entering your business email to begin your download.

Rolling forecast FAQs

What's the difference between a rolling forecast and an annual budget?

The two biggest differences between a rolling forecast and an annual budget are flexibility and update frequency. A rolling forecast is continually updated, offering a flexible approach that adjusts to real-time changes and market conditions. 

In contrast, the annual budgeting process involves a fixed financial plan set for a fiscal year. It provides a static framework to guide spending and revenue expectations.

How does a rolling forecast template assist in operating expense forecasting?

A rolling forecast template acts as a jumping off point for better navigating the ever-changing landscape of operating expenses. Even a simple rolling forecast template empowers you to identify trends, react quickly to changes, and make informed decisions that keep your expenses in check. This means greater accuracy in expense forecasting and a more agile approach to financial management.

What are the challenges of using a rolling forecast?

Using a rolling forecast demands a consistent flow of accurate and up-to-date data. It also requires a commitment to regular updates and a willingness to adapt quickly. Fortunately, the benefits that come from being able to pivot and respond dynamically to business needs usually outweigh these challenges.

Is manual forecasting challenging?

Yes, manual forecasting can be difficult and time-consuming especially as your business grows. Spreadsheets are prone to formula errors, broken links, and version-control issues that can produce inaccurate projections. They’re also hard to maintain, since each update requires manual data entry, cross-checking, and troubleshooting.

And as the number of accounts or departments increases, the process becomes even harder to scale. Many teams hit a wall around 20–30 accounts before it becomes unmanageable. For this reason, more companies are turning to rolling forecast templates or automated FP&A tools that streamline updates and reduce errors.

How long does it take to implement a rolling forecast?

The timeline varies depending on your financial reporting software, data quality, and internal processes, but most teams can implement a basic rolling forecast in a few days to a few weeks. 

If you already have clean historical data and a forecasting template in place, setup is usually quick—often just a few days to align assumptions and build the initial 12-month view. More complex implementations involving multiple departments, new data sources, or FP&A software typically take a few weeks to fully configure, test, and roll out.