Rolling Forecasts

What Is a 3+9 Forecast? How It Works, When to Use It and How to Implement It

What Is a 3+9 Forecast? How It Works, When to Use It and How to Implement It
11 min Reading time
3 June 2026 Date published

A rolling forecast that always shows 12 months ahead sounds straightforward. The 3+9 format is one of the most common ways to structure it: three months of verified actuals providing the recent baseline, nine months of updated forecast providing the forward view. Together, they create a plan that is grounded in recent performance and oriented toward what is likely to happen next.

This guide covers what a 3+9 forecast is, a critical distinction most articles miss, how the rolling mechanism actually works, when to use 3+9 vs other formats, how to implement it, and what challenges to expect.

Read: Rolling Forecasts: The Complete FP&A Guide (With Examples)

What Is a 3+9 Forecast?

A 3+9 forecast is a rolling forecast configuration that combines three months of actual financial results with nine months of forward projections. The total window is always 12 months. The ‘+’ separates actuals periods from forecast periods: three closed, nine open.

As each month closes, it joins the actuals section. The oldest open forecast month at the far end is updated based on the latest trends and assumptions. The total 12-month view is maintained continuously, never shrinking as the year progresses.

The 2024 FP&A Trends Survey found that 49% of companies now use rolling forecasts, up from 47% the previous year. The 3+9 format is one of the most commonly adopted configurations, particularly among businesses with quarterly planning cycles.

Read: Why Financial Forecasting Matters: 7 Reasons (With Data)

actual financial results

The Critical Distinction: 3+9 Budget vs 3+9 Forecast

This is the most important nuance in understanding whether a 3+9 is genuinely useful or misleading. Many organisations produce something they call a 3+9 that is not a rolling forecast.

The 3+9-Budget version takes three months of actuals and adds the remaining nine months from the original static annual budget, unchanged from when it was set at the start of the year. This is easy to calculate. It is also often misleading.

Example: The annual budget assumed 10% revenue growth. Q1 actuals came in at 5% growth. A 3+9-Budget report still shows the nine remaining budget months at 10% growth, producing a full-year view that says the business is broadly on track. It is not. The 9-month section reflects assumptions made before the year started, not where the business is headed given current conditions.

The 3+9-Forecast version replaces the nine-month section with an actively maintained rolling forecast that is updated monthly to reflect current trends, driver performance, and market conditions. When Q1 actuals come in at 5% growth, the 3+9-Forecast shows a revised full-year outcome that incorporates that underperformance. Leadership can see the gap and make decisions in time to respond.

The test for which version you are producing is simple: does the 9-month portion change when business conditions change? If it only updates once a year, it is a budget with an actuals section attached. If it updates monthly based on current data, it is a genuine rolling forecast.

How the Drop and Add Mechanism Works

The rolling nature of a 3+9 forecast comes from the drop and add cycle that runs at the end of each month.

Drop: The oldest period in the actuals section (if the forecast was at 3+9 last month) becomes an actual this month. The newly closed month joins the verified actuals. The forward forecast section shrinks by one month.

Add: A new forecast month is added at the far end to restore the total window to 12 months. November is added when October closes. December is added when November closes. January of next year is added when December closes.

Update: The forward forecast is revised to reflect what the latest actuals reveal about run rates, driver performance, and market trends. This is the most important step and the one that differentiates a true rolling forecast from a budget with automatic date labels.

The 3+9 label describes the state of the forecast at a particular point: after Q1 closes, three months are actual and nine months are forecast. As the year progresses, the actuals section grows (4+8 after four months, 6+6 after six months) unless the organisation adds a forecast month every time one closes, which maintains a constant 9-month forward window regardless of how many actuals have accumulated.

The Rolling Forecast Family

The 3+9 is one configuration in a family of rolling forecast formats. Each notation describes how many actuals periods combine with how many forecast periods.

Format Actuals Forecast Total Description
2+10 2 months 10 months 12 months Early year; maximum forward visibility; limited actuals history
3+9 3 months 9 months 12 months Q1 close; fast-moving industries; technology, SaaS, consumer goods
4+8 4 months 8 months 12 months After first third of year; mid-year budget calibration
6+6 6 months 6 months 12 months Mid-year reset; equal weight on actuals and forward view
9+3 9 months 3 months 12 months Q3 close; near-term operational decisions; peak season management

Benefits of the 3+9 Forecast

More accurate forward projections

In this Example of 3+9 Forecast. When three months of verified actuals are the starting point for the nine-month forecast, the projection is grounded in recent reality rather than assumptions made months earlier. Driver models calibrated against actual performance are more accurate than driver models calibrated against estimates.

Example: A manufacturing company producing automotive parts uses its three months of actual client order data and production costs to recalibrate the nine-month demand forecast. This allows the team to avoid overproduction in slow months, catch supply chain constraints early, and align inventory levels with actual order trends rather than the original budget assumption.

Faster response to market changes

A forecast that is updated monthly gives finance teams and operational leaders four to eight weeks of advance warning when business conditions shift. Technology companies with fast product cycles use this format to adjust production, headcount, and marketing spend based on actual early-period demand signals rather than waiting for a quarterly reforecast.

Consumer electronics businesses, for example, use rolling forecasts to balance production against actual sell-through data. When early sales figures on a new product come in below forecast, the 9-month section adjusts immediately, giving supply chain and operations teams time to modify orders before excess inventory becomes a problem.

Faster response to market changes

Better strategic alignment

The 9-month forward section provides enough horizon to monitor progress toward annual and multi-year strategic goals. Monthly updates keep the connection between short-term execution and long-term direction visible throughout the year, rather than surfacing the gap only at year-end when it is too late to respond.

Electric vehicle manufacturers, for example, use rolling forecast formats to align quarterly production targets with longer-term capacity and infrastructure investment plans. When actual model demand deviates from the nine-month forecast, both production scheduling and capital allocation can be adjusted before the deviation compounds.

How to Implement a 3+9 Forecast: A Step-by-Step Guide

Step 1: Decide on the Update Cadence

Monthly updates are standard for forecast in most industries. Each month-end close triggers the drop of the oldest forecast period, the add of a new forward month, and the revision of the remaining nine months. Quarterly updates are used in more stable environments but reduce the agility advantage of the format.

Step 2: Identify the Key Drivers for the 9 months (outer months) Forecast Section

The forecast should be driver-based, not line-item based. Identify the three to seven operational metrics that explain most of the financial variance in your business: revenue per customer, units shipped per production line, average deal size, headcount per function. Build the model from these drivers, not from a list of expense accounts. A driver-based model updates automatically when assumptions change; a line-item model requires manual entry for every update.

Step 3: Set the Granularity Gradient

Not all 12 months of the 3+9 window need the same level of detail. Apply a granularity gradient: the near-term months (months one to three, which will become actuals soon) should be detailed and accurate, because forecast quality here directly impacts the reliability of the actuals that follow. The mid-term months (four to nine) can be higher level, focusing on revenue and major cost drivers rather than line-item precision. This reduces the update burden while keeping the near-term section meaningful.

Step 4: Automate the Actuals Handoff

The most time-consuming step in a monthly 3+9 cycle is loading the previous month’s actuals into the model. If this step requires manual data extraction from ERP, manual entry into the forecast model, and manual reconciliation between systems, it will take days and will introduce errors. Automate actuals ingestion wherever possible to compress the time from month-end close to an updated forecast output. The faster the actuals are available, the more decision value the updated forecast has.

A forecast that is produced but not acted on delivers no value. Define in advance which decisions each monthly update will inform: capital allocation, hiring, marketing spend, pricing adjustments. Ensure the forecast outputs are available before the relevant decisions need to be made, not after. If the forecast update arrives three weeks after month close and the operational decisions have already been made on the basis of prior-month data, the update cadence needs to change.

Read: Capital Planning vs Capital Budgeting: The Practical Differences

3+9 Forecast

Challenges of the 3+9 Forecast

Data quality: The 9-month forecast is only as reliable as the actuals and driver data feeding it. Inaccurate actuals produce miscalibrated driver models, which produce unreliable projections. Data governance matters as much as the forecast methodology itself.

The Budget trap: Many organisations produce a 3+9 where the 9-month section is never properly updated. The format looks like a forecast but functions like an annual budget with an actuals section. The test: does the 9-month portion change when business conditions change? If not, it is not a genuine forecast.

Update burden: Monthly updates across multiple business units, functions, and geographies require process discipline, cross-functional coordination, and ideally automation. Without automation, the update cycle can consume as much time as the annual budget process it was supposed to replace.

Forecast fatigue: If the forecast is not directly linked to decisions, business partners will begin to view the monthly update as an administrative burden rather than a useful planning tool. Keeping the process lightweight and the outputs decision-relevant is the primary defence against fatigue. Farseer: The mechanics of the forecast are straightforward. The operational challenge is the update cycle: ensuring that actuals flow in automatically at month close, that the 9-month forecast portion is revised with current assumptions, and that the output reaches decision-makers before the action window closes. In Excel, each of these steps is manual. Farseer automates the actuals ingestion and model refresh steps, so the handoff from closed periods to forecast periods happens without manual reconciliation. The 9-month forecast updates as operational data arrives, and the full 12-month view is available in real time. For teams running monthly 3+9 cycles across multiple business units, that automation removes the main friction point in the process. See how Farseer supports rolling forecast implementation at farseer.com.

Best Practices

  • Keep the outer month section as a genuine forecast, not a budget residual. Every month, validate that the forward section reflects current conditions, not the original annual plan. This is the most important practice and the one most commonly skipped.
  • Use driver-based models for the forecast month sections. Line-item forecasts require manual updates for every line. Driver-based models recalculate automatically when key assumptions change, making the monthly update cycle faster and less error-prone.
  • Apply the granularity gradient. Near-term months detailed; outer months directional. This balances accuracy where it matters with efficiency in the lower-priority outer periods.
  • Automate actuals ingestion. The faster actuals are loaded, the more lead time the updated forecast provides for decisions. A forecast that arrives three weeks after month close provides much less value than one available within 48 hours.
  • Conduct scenario analysis on the forecast section. Use the forward portion to model what happens if a key assumption changes: demand increases 20%, a major supplier has a delay, a competitor launches a competing product. Scenario analysis on the outer month section converts the forecast from a single-point estimate to a decision support tool.

Conclusion

The monthly forecast is one of the most practical configurations for organisations that want to move from static annual budgeting to continuous planning. Actuals provides recent grounding; forecast provides actionable forward visibility. The total 12-month window moves with the business rather than shrinking as the year progresses.

The key condition is that the outer months section must be genuinely updated each month to reflect current conditions. A forecast where the forward portion is the annual budget with new date labels is not a forecast. It is a misleading document that combines the rigidity of a budget with the appearance of agility. The distinction matters because decisions made on the basis of a genuine Forecast will consistently be better than decisions made on the basis of a Budget. Start with the actuals-to-forecast handoff. Automate it, shorten it, and link the output directly to a named decision that cannot wait for a quarterly cycle. From there, the case for maintaining the process builds itself.

Farseer: A forecast is only as useful as the decisions it informs. A model that takes two weeks to update and arrives after the month-end meeting has already happened is not a planning tool. Farseer is designed so that forecast outputs are available the moment they are needed: driver-based models recalculate automatically as actuals arrive, scenario analysis runs in real time, and dashboards surface the forecast view alongside budget and prior-year comparisons in a single connected model. If your team is ready to move from a static budget to a genuine driver based forecast, Farseer provides the infrastructure to make that transition practical. Explore the platform at farseer.com.

About Author

Asif Masani is an FP&A professional and entrepreneur with 12+ years of experience in financial planning, budgeting, forecasting, audit, and tax. His experience across FP&A and audit provides a well-rounded understanding of business operations and finance partnering.

FAQ

What is a 3+9 forecast?

A 3+9 forecast is a rolling forecast configuration that combines three months of actual financial results with nine months of forward projections, maintaining a 12-month total view. As each month closes, it joins the actuals section and a new forecast month is added at the far end. The ‘+’ separates actuals periods from forecast periods.

What is the difference between a 3+9 budget and a 3+9 forecast?

A 3+9 budget takes three months of actuals and adds the remaining nine months of the original static annual budget, unchanged. A 3+9 forecast takes three months of actuals and adds nine months of an actively updated rolling forecast that reflects current conditions. The 3+9 budget is common but misleading. The simple test: does the 9-month portion change when business conditions change? If not, it is a budget, not a forecast.

How does the drop and add mechanism work?

At the end of each month, the newly closed period joins the actuals section (the drop of one forecast period), and a new month is added at the far end (the add). The forward forecast is simultaneously revised to reflect what the latest actuals reveal about trends and driver performance. This keeps the total window at 12 months and always current.

What level of detail should the forecast section carry?

Apply a granularity gradient: near-term months should be detailed and driver-based because they become actuals soon and forecast accuracy matters most here. Outer months can be higher level, focusing on key revenue and cost drivers rather than line-item precision. This reduces maintenance burden while keeping the near-term section accurate and the outer section directionally useful.

How often should a forecast be updated?

Monthly is standard. Each month-end close triggers the drop of the oldest period and the add of a new forecast month, and the full forecast section is revised with current assumptions. 

What are the main challenges in running a forecast?

The three most common challenges are: data quality; the budget trap (many teams produce actuals plus remaining budget rather than an updated forecast, which produces a misleading picture); and update burden (monthly updates across multiple departments require process discipline and automation to be sustainable).