.jpeg)
Table of Contents
Key takeaways
- A rolling forecast updates a fixed future time period on an ongoing basis, most commonly monthly or quarterly, so the outlook reflects current business conditions.
- Traditional forecasts tied to annual budgets become outdated quickly and shorten the forward view as the year progresses, limiting an organization’s ability to pivot.
- A rolling forecast is a living document that changes with market conditions and actual results, illustrated by a 3+9 model with three actual months and nine forecast months.
- A budget is a static annual plan based on the prior year’s historical data, while forecasting is typically faster, more top-down, and focused on areas from revenue to operational expenditure.
- Forecast frequency and time horizon depend on three stated factors: resource availability, pace of growth, and business volatility, with fast-growing firms often forecasting monthly or every 1–2 quarters.
- Harvard Business School identifies seven quantitative financial forecasting methods: percent of sales, straight line, moving average, simple linear regression, multiple linear regression, Delphi method, and market research.
What is a rolling forecast?
A rolling forecast is a continuously updated financial forecast that extends the planning horizon as each reporting period ends. Unlike static annual budgets, rolling forecasts help finance teams adapt quickly to changing market conditions, revenue performance, hiring needs, and operational priorities.
Most rolling forecasts are updated monthly or quarterly and maintain a constant forward-looking horizon — such as 12, 18, or 24 months ahead. This allows organizations to make faster, more informed decisions using the latest business data instead of relying on outdated annual assumptions.
One of the most common rolling forecasting models is a 3+9 forecast, which combines three months of actual financial results with nine months of projected performance. As each new month closes, actuals replace forecasted figures and a new forecast period is added, ensuring the organization always maintains a current 12-month outlook.
Finance teams use rolling forecasts to improve agility, strengthen scenario planning, optimize resource allocation, and gain a more accurate view of future business performance.
Rolling forecast example
Here’s a simple example of how a rolling forecast works.
A traditional annual forecast created in January typically covers January through December. However, by the middle of the year, that forecast already contains several months of outdated assumptions.
A rolling forecast continuously updates the planning horizon. At the end of each month or quarter, actuals replace forecasted figures, and a new future period is added.
For example:
This “add/drop” approach ensures finance teams always maintain a current view of the next 12 months rather than relying on a static annual plan.
A common structure is a 3+9 rolling forecast: three months of actual results combined with nine months of projected performance.
What is the difference between a rolling forecast and a budget?
A budget is an annual plan for the fiscal year based on the past year’s historical data. Finance teams work with individual departments to create a static view of the company’s revenue and project expenses. It's a static document.
Usually, forecasting is done at a higher level (top-down) and a faster pace compared to the budget. It focuses on topline areas like revenue forecasting, all the way down to operational expenditure.
Good forecasts are driver-based, meaning one input can provide many details.
An example would be:
Driver: Grow sales by $100M
Outputs: Increase number of sales reps required, CSMs required to support new customers, increase marketing spend to feed the top of funnel, engineering capacity, etc.
Forecasting is usually an exclusively finance team exercise. Some organizations have chosen to abandon annual budgeting completely in favor of rolling forecasts. If that is the case, then department heads will be involved on a more frequent basis - either monthly or quarterly.
Traditional Budget vs. Rolling Forecast
While both are essential components of corporate performance management, they serve entirely different strategic purposes.
Benefits of rolling forecasts
Rolling forecasts help organizations respond faster to changing business conditions while improving the accuracy and strategic value of financial planning.
Better business agility
Because rolling forecasts are continuously updated, finance teams can quickly adjust plans based on real-time performance, market changes, or economic uncertainty.
Instead of waiting for the next annual planning cycle, leaders can make faster decisions around hiring, spending, investments, and growth initiatives.
In periods of market volatility, agility becomes a competitive advantage. Explore Pigment’s latest Uncertainty Index to understand how finance leaders are adapting planning strategies in response to shifting economic conditions.
More accurate scenario planning
Rolling forecasts improve scenario planning by incorporating the latest operational and financial data into future projections.
Finance teams can model best-case, worst-case, and baseline scenarios using updated assumptions around revenue, churn, pricing, headcount, supply chain disruptions, or macroeconomic conditions.
Effective scenario planning requires more than static spreadsheets and annual assumptions. Download Pigment’s Scenario Planning Playbook to learn how modern finance teams model uncertainty, evaluate risks, and make faster strategic decisions.
Improved resource allocation
Driver-based rolling forecasts help organizations allocate resources more efficiently by connecting operational drivers directly to financial outcomes.
For example, an increase in projected ARR growth may automatically influence hiring plans, marketing spend, customer support capacity, and infrastructure investments.
Greater visibility into risk
Because forecasts are refreshed regularly, organizations can identify risks earlier and take corrective action before issues materially impact performance.
This is especially important in volatile markets where conditions can shift rapidly.
Better cross-functional alignment
Modern rolling forecasts integrate operational and financial planning across departments, helping finance, sales, HR, and operations teams align around the same assumptions and business goals.
Steps to create rolling forecasts
Outline your objectives
The framework of your forecasting process depends on the objectives based on which the financial team decides the financial forecast and how the forecast will be used.
Some common objectives are:
- Driving growth
- Reducing costs
- Maximizing customer retention
- Headcount planning and optimization
Goals and objectives will help determine the aspects of the forecast that need the most focus.
Consider the time frame
You should remember that the time horizon is not set in stone and it can change as your company scales.
The three factors to consider when deciding the frequency of your forecasting cycle are:
- Availability of resources
- Pace of growth
- The volatility of your business
Fast-growing businesses may require forecasts on a shorter time horizon: monthly or every 1-2 quarters. Less volatile business can do with quarterly forecasts.
Leverage driver-based forecasting
With a driver-based approach, updates are focussed on the key data that determine the key financial outcomes for your company. You can account for the most important variables that impact finances. This method allows you to forecast finances strategically, making your rolling forecasts more efficient and accurate.
Encourage participation
A rolling forecast is only as good as the data that goes into it. To ensure accuracy, your financial team needs updates from managers and contributors throughout the organization. Financial planning software provides access to reports and planning templates for all stakeholders and contributors involved in the process.
At this stage, the FP&A department should identify the value drivers most likely to contribute to achieving success instead of focusing on too many goals.
Align company goals
It is not uncommon for businesses to plan their operations and finances separately from each other. This can lead to disparities in resource allocation.
The most impactful rolling forecasts integrate operational and financial planning, enabling forecasts to represent the entire company.
Gather data
Gather data from multiple sources, business applications, and data lakes. Financial planning software integrates with your most important data sources to create a foundation of data integrity. The software eliminates the need to manually gather information from every corner of the business.
Find a system that works
Spreadsheet-based rolling forecast process can be tedious and prone to inaccuracy. Instead, an integrated business planning platform offers tools to streamline the forecasting process and improve data analysis. The result would be a rolling forecast budget that has higher precision and efficiency.
How to create more accurate forecasts?
1. Maintain accurate historical data
Clean and accurate data is critical for generating useful and reliable insights. It needs to be collected from a wide range of relevant sources, both internal and external.
We know that the most efficient FP&A functions will be those that can drive real business impact through creative analysis of both historical data and multiple data sets. But organizations struggle to aggregate, format, and harness the power of historical data.
Financial planning software simplifies the data preparation process for financial planning and analysis teams. By automatically importing data from multiple business systems (CRM, ATS, data lakes, spreadsheets, and others) and cleaning it, the FP&A software frees up your headspace to focus on strategic decision-making.
Another reason why FP&A departments prefer software to maintain accurate historical data is that they don’t have to juggle multiple spreadsheets or sort through email threads. Business planning software has powerful collaboration workflows to gather input from colleagues and other departments.
2. Incorporate scenario planning
Let’s start with a question: Is your finance team getting bogged down in complex spreadsheets trying to capture scenario planning opportunities?
If so, most probably, by the time the finance team offers strategic insights, your business would have moved on in the decision-making process.
Flexible scenario planning empowers your finance team to manage volatile environments, plan for the best and worst-case future outcomes, and capture all possibilities for an optimal path forward. Now more than ever, your ability to plan for all circumstances is critical and scenario planning lets you do that.
A next-generation scenario planning feature lets you create and test as many scenarios as you like at the application level. Then, you can run these scenarios to compare your model data simultaneously across several future paths. Scenario planning grabs the best parts of traditional scenario planning, building alternative paths atop a baseline scenario and enhancing it.
Scenario planning on Pigment does the following work for you:
- Rates scenario on any model with a few clicks
- Compares all possible outcomes on a single chart or grid
- Changes data and formulas for any particular scenario
- You can even share scenarios across all applications
3. Use tools that allow flexible reforecasts
To a large extent, technology is changing the way FP&A teams make decisions. The FP&A teams are expected to be able to reforecast in a window of a few days, all while sifting through unprecedented levels of data.
Flexible reforcasting solutions help FP&A professionals deliver deeper insights and stronger financial forecasts to steer the business performance effectively.
The key features of integrated business planning tools that allow flexible reforcasts are:
- Automated data preparation
- Creating unbreakable formulas
- Running comprehensive what-if scenarios in minutes
- Optimizing collaboration with personalized workflows
The agility finance teams gain from these features helps them serve the broader goals of the organization by adapting plans, budgets, and financial forecasts to changing business conditions and industry trends.
Overcoming Reforecasting Challenges
Balancing the Cadence: Overcoming Forecast Fatigue
While the benefits of continuous planning are clear, implementing a rolling forecast requires operational discipline. Organizations transitioning to this model often face two primary hurdles: forecast fatigue and cross-functional misalignment.
If you ask department heads to manually update granular operational lines every single month, engagement will plummet. The key to sustainable rolling forecasts is keeping the process high-level and driver-based. Finance teams shouldn't chase every minor line item; instead, focus on the core strategic levers—like ARR growth, headcount capacity, or customer churn—that genuinely move the needl
Methodologies used for forecasting
Many organizations’ initial approaches to financial forecasting include using pro forma statements modeled after income statements, balance sheets, and cash flow statements. Pro forma forecasting of these statements can provide a picture of the organization’s financial health and future performance, as impacted by changes in economic and market conditions. Most organizations run multiple scenarios based on different market and economic assumptions to provide alternative views of future performance.
Quantitative methods are used extensively in producing financial forecasts. They form the basis of scenario planning, where models are prepared that model the impact of market, economic, and internal factors. While they are used extensively in forecasting, it must be understood that additional factors that influence performance can't be quantified and many organizations adjust their forecasts to use qualitative approaches, relying on expert knowledge and experience to predict performance rather than historical numerical data.
The Harvard Business School has identified seven quantitative approaches that are used in financial forecasting that must be considered:
- Percent of Sales
Calculate future forecasts using a percentage of sales approach. This would include modeling forecasts using the cost of goods sold, which is typically based on a percentage of sales revenue. - Straight Line
Forecast using assumptions about historical growth rates that will remain constant. A good place to start with a forecast, however, does not take into consideration market, economic and supply chain issues. - Moving Average
Forecast using a weighted average of prior periods, such as building a forecast by averaging the previous quarter performance. This is an underlying approach in rolling forecasts. - Simple Linear Regression
Forecast metrics based upon the relationship between dependent and independent variables. - Multiple Linear Regression
Forecast metrics based upon two or more variables impacting a company’s performance. The ability to account for several variables that affect performance should lead to a more accurate forecast. - Delphi Method
Forecast involving consulting internal and external experts who analyze market conditions. Results are compiled and circulated until a consensus is reached. - Market Research
Obtain a holistic market view based on economic, market, competition, and consumer expectations. Important for new businesses when historical information is not available to understand these trends.
Modern rolling forecasting with Pigment
For many finance teams, the biggest barrier to rolling forecasting isn’t strategy — it’s technology.
Managing continuous reforecasting cycles in disconnected spreadsheets or legacy CPM systems often creates manual consolidation work, version-control issues, and broken formulas that slow decision-making.
Pigment helps organizations modernize rolling forecasting through a connected, driver-based planning platform designed for continuous planning and real-time collaboration.
With Pigment, finance teams can:
- Automatically integrate data from ERP, CRM, HRIS, and operational systems
- Build driver-based forecasting models that update dynamically
- Run multiple scenarios simultaneously
- Compare forecast versions side-by-side
- Collaborate across finance and operational teams in real time
- Reduce manual reforecasting cycles from weeks to days
By combining operational and financial planning in a single platform, organizations can move beyond static annual budgeting and build a more agile, data-driven forecasting process.
Discover how Pigment can transform your forecasting cycles. Book a live demo today.
Frequently asked questions
What is a rolling forecast?
A rolling forecast is a continuously updated financial forecast that extends the planning horizon as each reporting period ends. It helps organizations maintain a current view of future performance instead of relying on a static annual budget.
How is a rolling forecast different from a budget?
A budget is typically a fixed annual financial plan, while a rolling forecast is updated regularly using the latest actuals and business assumptions.
How often should rolling forecasts be updated?
Most organizations update rolling forecasts monthly or quarterly depending on business volatility, growth rate, and planning complexity.
What are the benefits of rolling forecasts?
Rolling forecasts improve agility, scenario planning, resource allocation, forecasting accuracy, and decision-making speed.
What industries use rolling forecasts?
Rolling forecasts are widely used across SaaS, manufacturing, retail, healthcare, supply chain, and financial services organizations.
Can rolling forecasts replace annual budgets?
Some organizations use rolling forecasts alongside annual budgets, while others replace traditional budgeting entirely with continuous planning models.
