Gold by MangoMagic

CRO · Framework · Advanced · Saves 60+ hours

Sales Forecasting Framework

A comprehensive framework for accurate sales forecasting.

Get coached on this — free

What's included

  • Forecasting methodologies
  • Bottoms-up forecasting process
  • Top-down reconciliation
  • Category definitions
  • Accuracy measurement
  • Continuous improvement

Best used when

  • Implementing forecasting methodology
  • Improving forecast accuracy
  • Training sales managers
  • Preparing for board meetings

The template

The Template

FORECASTING METHODOLOGY

Forecasting Methods

FORECASTING APPROACHES

BOTTOMS-UP:
Rep-level forecasting
+ High ownership
+ Deal-level detail
- Subject to bias
Best for: Mature orgs

TOP-DOWN:
Historical trend analysis
+ Less bias
+ Faster
- Less deal visibility
Best for: Predictable business

WEIGHTED PIPELINE:
Stage probability × value
+ Objective
+ Consistent
- Assumes stage accuracy
Best for: High volume

HYBRID (RECOMMENDED):
Bottoms-up with top-down validation
Weighted pipeline for sanity check

Bottoms-Up Forecasting Process

Step Owner Timing Output
1. Rep forecast AE Monday AM Deal-by-deal forecast
2. Manager review Manager Monday PM Validated forecast
3. Director rollup Director Tuesday Team forecast
4. VP reconciliation VP Wednesday Segment forecast
5. CRO submission CRO Thursday Company forecast

FORECAST CATEGORIES

Category Definitions

FORECAST CATEGORY DEFINITIONS

COMMIT:
Definition: Will close this quarter
Confidence: 90%+
Criteria:
☐ Verbal commitment received
☐ Legal/procurement in progress
☐ Close date in quarter
☐ No known blockers

BEST CASE:
Definition: Should close this quarter
Confidence: 60-90%
Criteria:
☐ Active opportunity
☐ Strong champion
☐ Decision timeline confirmed
☐ May have minor risks

PIPELINE:
Definition: Could close this quarter
Confidence: 20-60%
Criteria:
☐ Qualified opportunity
☐ Active engagement
☐ Close date in quarter
☐ Significant work remaining

UPSIDE:
Definition: Unlikely but possible
Confidence: <20%
Criteria:
☐ Early stage
☐ Timeline uncertain
☐ Not expected but possible

Forecast Submission Template

Deal Amount Category Close Date Confidence Risk
$ Commit/Best/Pipe %
$ Commit/Best/Pipe %
Total Commit $
Total Best Case $

ACCURACY MEASUREMENT

Forecast Accuracy Calculation

FORECAST ACCURACY METRICS

FORECAST ACCURACY:
Formula: 1 - |Actual - Forecast| / Actual
Example: 1 - |$950K - $1M| / $1M = 95%

WEIGHTED ACCURACY:
Apply by category:
Commit accuracy: ____%
Best case accuracy: ____%
Overall accuracy: ____%

BIAS ANALYSIS:
Over-forecast %: ____%
Under-forecast %: ____%
Bias direction: Over/Under

TARGET:
Forecast accuracy: 90%+
Commit accuracy: 95%+
Bias: Neutral

Frequently asked questions

What is the Sales Forecasting Framework?

A comprehensive framework for accurate sales forecasting.

Who is the Sales Forecasting Framework for?

It is built for CROs and their teams working on Pipeline & Forecasting. The AI coach adapts it to your company, stage, and goals.

How long does the Sales Forecasting Framework take to use?

It saves roughly 60+ hours versus building from scratch. Our AI coach can tailor the framework to your situation in minutes, then hand you a step-by-step plan.

Is the Sales Forecasting Framework free?

Yes. You can read the full framework and start getting coached through it for free. Sign in to save your tailored version and track your next steps.

How does the AI coach help with the Sales Forecasting Framework?

The coach teaches you the framework, asks a few questions about your business, tailors the framework to you, and gives you measurable next steps to execute.