AI & Agents
Cube AI makes financial data decision-ready across every FP&A tool and workflow.
Learn more about AI at Cube →Meet the Agents
The Agentic Layer
The governed foundation — platform capabilities.
Consolidation & Close
The entire financial close and data management cycle, at a high level.
See all →Evaluate
For buyers in-cycle.
Learn & Support
Guides, resources, and help.
Company
About Cube, careers, and news.
Free template
Rolling Forecast Template: 12-Month Forecasts (Excel Template)
Organize your rolling 12-month forecast for your OpEx spending.
Best for: Companies with rolling forecasts who want to contextualize their OpEx spending.
Download template
What's inside
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:
- Department variances: Find where department expenses differ from budgeted amounts.
- OpEx variances: Identify gaps between your actual operating expenses and what you budgeted for.
- Steps: Organize the actions taken to keep your forecast updated.
- OpEx plan: Create a blueprint for anticipated operating expenses over a set period.
- Headcount analysis: Track how many employees you have compared to your planned number of employees.
- Sales & marketing: Predict and assess sales and marketing expenses.
- T&E: Monitor travel and entertainment expenses associated with business activities.
- Drivers: Keep tabs on the key factors that impact your company’s financial health.
Use with Cube
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.
-
Open the template in Excel or Sheets.
-
Customize the row and column headers to match your Cube's dimensions and filters.
-
Select the range where you want to fetch your data.
-
Fetch your data.
Definition
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 it matters
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: Rolling forecasts 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 vs. static
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.
Cadences
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.
| Cadence | Actuals | Forecasts | Best for | Update frequency |
|---|---|---|---|---|
| 3+9 | 3 months | 9 months | High-growth startups; SaaS scale-ups; rapidly evolving models | Monthly or quarterly |
| 4+8 | 4 months | 8 months | Growing mid-market firms; eCommerce; expanding B2B services | Monthly or quarterly |
| 8+4 | 8 months | 4 months | Seasonal or predictable businesses; manufacturers; stable retail | Monthly |
| 9+3 | 9 months | 3 months | Mature, low-volatility orgs; utilities; stable subscription firms | Monthly or biweekly |
How-to
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:
-
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. -
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
-
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. -
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. -
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. -
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. -
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.
-
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. -
Compare the data 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. -
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. -
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
Best practices for using a rolling forecast template
A rolling forecast is only as effective as the processes surrounding it. Even the best template won't deliver meaningful insights unless your team maintains consistent habits, clear communication, and disciplined 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.
FAQs
Rolling forecast FAQs
Get your copy
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.