Sales Forecasting for RevOps: Methods and Accuracy
How to build accurate sales forecasts, choose the right forecasting methodology, and improve forecast accuracy over time.
Key Takeaways
- •Sales forecasting methods include top-down (market-based) and bottom-up (pipeline-based)—most companies use a hybrid
- •Commit/Best/Worst case scenarios provide range visibility essential for planning
- •Pipeline health metrics (coverage, velocity, stage conversion) are leading indicators of forecast accuracy
- •Forecast accuracy should be measured and tracked—target 80%+ accuracy at 90 days
- •Technology can help but process and discipline matter more than tools
Sales forecasting is one of the most important—and most difficult—responsibilities of RevOps Finance. Accurate forecasts enable better planning, resource allocation, and investor communication.
As part of our RevOps Finance framework, sales forecasting requires both analytical rigor and close partnership with sales leadership. This guide covers methods and best practices.
Forecasting Methods
There are two fundamental approaches to sales forecasting, each with distinct advantages:
Top-Down
Market-based approach
TAM x Market Share = Revenue
Bottom-Up
Pipeline-based approach
Sum of weighted opportunities
Top-Down Forecasting
Start with market size and work down to expected revenue based on market share assumptions.
Process: TAM × Market Share % = Expected Revenue
Advantage: Aligns with strategic planning, board expectations
Limitation: Doesn't account for sales execution realities
Bottom-Up Forecasting
Start with individual opportunities and aggregate up to company forecast.
Process: Sum of weighted pipeline = Expected Revenue
Advantage: Reflects actual sales reality, identifies gaps
Limitation: Can miss market-level changes
The Hybrid Approach
Most successful companies use both methods: top-down for strategic planning and investor expectations, bottom-up for operational planning and execution. The dialogue between the two reveals gaps and opportunities.
Commit, Best Case, and Worst Case
Providing a single number is insufficient for planning. Three-scenario forecasting gives leadership the range they need for decision-making.
Commit (or Budget)
The number sales leadership is confident they will achieve. This is the number used for planning.
Typically: Deals with 80%+ probability, execution is certain
Best Case
What happens if everything goes well—good weather, strong economy, favorable competitive dynamics.
Typically: Commit plus upside deals with 50-80% probability
Worst Case
What happens if things go poorly—economic downturn, key deals lost, competitive pressure.
Typically: Commit minus expected losses from high-risk deals
| Scenario | Q1 Forecast | % of Target |
|---|---|---|
| Worst Case | $1.8M | 72% |
| Commit | $2.3M | 92% |
| Best Case | $2.8M | 112% |
| Target | $2.5M | 100% |
Pipeline Health Metrics
Pipeline health metrics are leading indicators that help predict forecast accuracy:
Key Pipeline Metrics
Pipeline Coverage
Formula: Total Pipeline Value / Quota
Rule of thumb: 3-4x coverage for predictable revenue. Below 3x signals risk.
Pipeline Velocity
Formula: (Pipeline Value × Conversion Rate) / Sales Cycle Length
Measures how quickly deals move through the pipeline. Declining velocity is a warning sign.
Stage Conversion Rates
Percentage of deals that move from one stage to the next.
Compare to historical benchmarks. Significant drops indicate bottlenecks.
Measuring and Improving Forecast Accuracy
What gets measured gets improved. Tracking forecast accuracy over time reveals patterns and areas for improvement.
Forecast Accuracy Formula
Accuracy = Actual Results / Forecast × 100
A forecast of $1M that results in $900K is 90% accurate. A $1.2M result against a $1M forecast is 83% accurate.
Accuracy Benchmarks
| Time Horizon | Good | Average | Needs Work |
|---|---|---|---|
| 30 days | 90%+ | 80-90% | < 80% |
| 60 days | 85%+ | 70-85% | < 70% |
| 90 days | 80%+ | 65-80% | < 65% |
Improving Accuracy
- Standardize stage definitions: Ensure everyone has the same understanding of what qualifies a deal for each stage
- Require deal documentation: Required fields (next steps, close date, competitors) improve forecast quality
- Review forecasts regularly: Weekly pipeline reviews catch problems early
- Track accuracy over time: Measure and report accuracy to drive improvement
- Hold reps accountable: Forecast accuracy should factor into performance reviews
The Accuracy Improvement Cycle
Measure accuracy → Identify patterns → Improve process → Measure again. Most forecast errors come from a few common issues: poorly defined stages, loose close dates, or insufficient pipeline. Address the root causes systematically.
Building a Forecasting Process
Accurate forecasting is as much about process as methodology. Here's how to build a sustainable forecasting process:
Weekly
- • Pipeline review meetings
- • Update deal status and probabilities
- • Identify at-risk deals
- • Review forecast changes
Monthly
- • Full forecast review with leadership
- • Update scenario ranges
- • Review pipeline health metrics
- • Identify forecast bias patterns
Quarterly
- • Forecast accuracy analysis
- • Methodology review
- • Process improvements
- • Rolling forecast updates
Annually
- • Complete methodology review
- • Target setting
- • Tool and process assessment
- • Year-over-year accuracy comparison
Need Help with Sales Forecasting?
Eagle Rock CFO helps companies build accurate sales forecasting processes. From methodology design to pipeline analysis, we can help you improve forecast accuracy and drive better business decisions.