Tips for Moving to Rolling Forecasts

Rolling forecasts help organisations stay agile by continually adapting plans and budgets to market shifts and competitive pressures. Unlike a static annual budget that quickly becomes outdated, a rolling forecast continuously refreshes assumptions and projections to reflect the latest business realities.

It uses an “add/drop” model, extending the forecast period as each month or quarter closes. For example, in a 12-month rolling forecast, when January 2023 ends, January 2024 is added, keeping the forecast window consistently a year ahead.

The forecast horizon can span 12, 18 or 24 month – or four, six or eight quarters – depending on business needs. This continuous process helps teams make more accurate short-term projections based on current performance while maintaining awareness of longer-term uncertainty. The result is faster, data-driven decision-making that keeps the business aligned and responsive.

To make rolling forecasts work, finance teams need visibility into how each department updates its forecasts, often on a monthly basis. While areas such as procurement and receivables may be well understood, factors like sales forecasts, production levels or marketing lead flow can be harder to track. Success with rolling forecasts depends on choosing the right update cadence and streamlining how data is collected, ensuring finance has the timely, accurate information needed for each refresh.

Traditional and Rolling Forecasts Compared

Prerequisites for Moving to Rolling Forecasts

Shifting to rolling forecasts is a major undertaking. But it aligns finance with the rest of the organisation as each department updates its own projections. The benefits for leadership and teams are clear: resource decisions are guided by accurate, up-to-date forecasts rather than assumptions. With real data replacing gut instinct, decision-makers gain a clear, current view of the business and can act with greater confidence.

Here are the things organisations need to get started:

• Alignment, collaboration and participation: The process involves people from across the business, both financial and non-financial. Everyone needs to understand their role and responsibilities. At the same time, finance must lead the process and keep the team focused and efficient.
• Talent: Finance teams need to make participation easy for colleagues. Clear communication drives results. For example, helping sales justify a new hire using accurate projections builds trust and engagement. Delivering these insights, however, requires skilled and experienced finance professionals.
• Systems: Having the right systems in place is critical. Data should flow into forecasts automatically, reducing manual work. Creating a baseline forecast is just the start: continuous analysis and updates are essential, and this quickly exceeds the limits of spreadsheets. NetSuite Planning and Budgeting (NSPB) is purpose-built to automate driver-based planning, consolidate data from ERP/CRM/HRIS and streamline workflow and approvals — eliminating spreadsheet bottlenecks and enabling true rolling forecasts.
• Models: Forecasting models should be driver-based, focusing on the things that directly influence financial and operational performance. This supports scenario planning and more accurate projections. Building models for this in Excel can be labour-intensive and error-prone; NSPB provides prebuilt model templates, scenario management, and audit trails to increase accuracy and speed.
• Data: Rolling forecasts are only as reliable as the data behind them. To stay on track, they rely on frequent imports of actual figures such as labour rates, purchase prices and selling prices. Forecasts built on real-time assumptions and actual data are far more actionable, helping organisations identify issues early and reallocate priorities and resources as needed.

5 Best Practices for Rolling Forecasts

1. Identify key drivers

   Rolling forecasts are based on drivers – such as customer numbers, market share, average price and sales volume. These drivers are built into the system so that any changes are captured and reflected throughout the year.

   There’s no set number of drivers to include. The right mix depends on your business model, objectives, desired insights, company size, industry and other internal or external factors. When identifying the most important drivers for your organisation, consider the following questions:

   • What factors are driving revenue and expenses, and are they significant enough to include?
   • What are our business goals, and which drivers align with them?
   • Should we include external drivers such as GDP?
   • Who in the organisation is closest to each driver?
   • What data will feed into each driver?

   Choose your drivers carefully. Focus on the vital few that truly impact performance, not the many that add noise.

   Concrete driver patterns:

   1. SaaS subscription model:

      • Core drivers: opening subscriptions/ARR, new logos, expansion ARR, churn, reactivation, ARPU, billings and collections cadence.
      • Example: If volume (active subscriptions) increase 10% while ARPU decreases 5% and FX tailwind adds 2% to reported revenue, NSPB can instantly recalculate revenue and cash timing. For 1,000 subs at £100 ARPU (baseline £1,000,000 monthly revenue):
      • Volume + 10% = 11,000 subs
      • ARPU –5% = £95
      • FX +2% = multiplier 1.02
      • New revenue ≈ 11,000 × £95 × 1.02 = £1,066? roughly £1.067M (about +6.7%). Downstream, NSPB updates ARR, billings, commissions, and cash automatically.

   2. Product business (multichannel):

      • Core drivers: unit volume by channel, average selling price (ASP), mix, COGS per unit, discount rate, returns, freight, inventory turns.
      • Example: Channel A volume +8% with ASP −3% and COGS flat will flow through gross margin; Channel B price promotion increases volume +15% but raises returns +2%. NSPB’s driver links update revenue, margin, working capital and capacity plans in one refresh.

2. Set the forecast horizon

   The time horizon for a rolling forecast can vary. Popular options include 12, 18 or 24 months, or four, six or eight quarters. The ideal length depends on factors such as industry, business cycle, product lifecycle and overall economic conditions.

   Decision guide:

   • Low-volatility, mature industries (mid-market/enterprise): quarterly updates with a 12–18-month horizon.
   • Fast-changing/high-growth sectors: monthly updates with a 12-month horizon.
   • Crisis mode or major disruption: weekly cadence with a short horizon focused on cash and capacity.

   Whatever the timeframe, the goal is to forecast with as much accuracy as possible for the current period while recognising how trends may shape the future. Because markets are unpredictable, longer horizons often require best-, worst- and most-likely-case scenarios. Work with business leaders to determine the right duration and update frequency. NSPS supports multiple scenarios side-by-side with driver sensitivities to speed this process.

3. Use a phased approach

   Engaging an entire organisation in a new forecasting process, especially during times of disruption, is a major challenge for any CFO. Many companies are keen to adopt rolling forecasts as a replacement for traditional budgets, but it’s important to think through the implications first. Leaders need to consider how the shift aligns with target setting, action planning and desired behavioural changes across the business.

   The time needed to move from annual to rolling forecasts will vary depending on company size, but a phased approach offers the best chance of success:

   • Phase 1: Finance-led pilot with a receptive function (e.g Sales or Supply Chain), using a small set of high-impact drivers.
   • Phase 2: Expand to adjacent teams; standardise driver definitions, approval workflows and data feeds.
   • Phase 3: Enterprise scale; replace annual budget tasks with rolling cycles and scenario playbooks.

   NSPB accelerates each phase with workflow, driver libraries, integrations connectors and auditability.

4. Keep the forecast updated

   Forecasts should be regularly refreshed to reflect the latest macroeconomic data and projections. A rolling forecast acts as the baseline, providing the structure to adjust assumptions, plan for future conditions and evaluate the impact of major events. Involving a scenario planning team can strengthen this process and improve the organisation’s ability to respond quickly to change. Scheduled data loads, versioning and sandbox scenarios make monthly or even weekly refreshes practical without adding manual overhead.

5. Examine your forecasts

   Avoid the common mistake of focusing all your effort on building the forecast and not enough on analysing it. Rolling forecasts should actively guide business decisions, not just report results. Work with senior leaders to define how the forecast will support mid-cycle resource planning and consider checking in with executives each month to prioritise which insights or reports are most valuable. Insights gained from rolling forecasts should drive “what if” analyses and scenario planning. The aim is to move beyond explaining what happened to understanding why it happened, what’s likely to happen next and how to influence future outcomes for the better. NetSuite’s dashboards, variance bridges and driver-based “what-ifs” make these insights accessible in minutes rather than days.

Why Choose NetSuite?

Financial management software is a valuable investment for rolling forecasts, as it automates key tasks such as analysis, reporting and forecasting. Cloud-based financial planning tools like NetSuite Planning and Budgeting make it easy to consolidate data, boost efficiency and give everyone access to accurate, real-time information for better decision-making.

NetSuite Planning and Budgeting:

• Automates data consolidation, driver rollups and report refreshes, cutting manual effort and cycle time
• Replaces fragmented spreadsheets and manual reconciliations with governed, reusable models and workflows
• Provides role-based security, audit trails, approvals and data lineage so you can trust the numbers
• Allows you to spin up best/worst/most-likely versions and sensitivity analyses in minutes

Whether you’re seeking investment or tracking growth, a clear financial plan is essential. With a complete view of your finances, you can make smarter, long-term decisions that support sustainable success.

Ready to stop relying on stale spreadsheet-based forecasts? Request or view a demo of NetSuite Planning and Budgeting to see automated, driver-based rolling forecasts in action – complete with SaaS and product-model templates, scenario simulation and real-time dashboards.