Bottom-Up Forecast

What is a bottom-up forecast?

A bottom-up forecast (also called a pipeline-based forecast or deal-level forecast) is a sales forecasting method that starts with every open opportunity in the CRM, assigns a probability-weighted value to each deal based on its stage, and rolls the numbers up from rep to team to company total. The forecast is grounded in what exists in the pipeline — not in a target divided by territory.

Operators who rely solely on top-down targets set a number and ask reps to hit it. That works for goal-setting but fails for forecasting. A quota of $500K says nothing about whether $500K of pipeline actually exists at a close-able stage. A bottom-up forecast answers that question: given the deals we have, at their current stages, what should we expect to close?

For B2B sales teams with 12+ months of CRM history and consistent stage definitions, a well-calibrated bottom-up forecast lands within 10-15% of actual closed revenue. Below 6 months of history, the stage probabilities are guesses — and the forecast reflects that. The method is only as good as the data underneath it.

A bottom-up forecast differs from a top-down forecast in origin. Top-down starts with a market or segment target and allocates downward. Bottom-up starts with pipeline reality and aggregates upward. Most mature revenue operations teams use both — bottom-up for the current quarter, top-down for the annual plan.

Why bottom-up forecasts matter for operators

A bottom-up forecast is the closest thing an operator has to ground truth. It doesn't predict what should happen — it predicts what will happen based on the pipeline that exists right now.

The consequence of not having one is specific. A company sets a $1.2M quarterly target based on top-down planning. By week 6, the pipeline contains $1.5M in total value — which looks like enough at a glance. But a bottom-up analysis reveals that $480K of that pipeline is in Stage 1 (discovery), which converts at 8%. The probability-weighted forecast is $740K. The company is heading for a $460K miss, and the top-down target alone didn't surface it.

Operators who run a bottom-up forecast weekly catch these gaps 4-6 weeks earlier than those who rely on rep self-reported commits. The weekly cadence matters because pipeline changes fast. Deals slip, new opportunities enter, and win rates vary by stage. A bottom-up forecast recalculated weekly against the actual pipeline reflects those shifts in near-real-time — giving the operator time to adjust: add pipeline, accelerate deals, or reset expectations before the quarter closes.

How a bottom-up forecast is built

A bottom-up forecast follows a four-step process from individual deals to company total.

Step 1: Deal-level data from the CRM

Pull every open opportunity with a close date in the forecast period. Required fields: deal value, current stage, close date, last activity date, deal owner. Missing any of these fields makes the deal un-forecastable — it should be flagged, not estimated.

Step 2: Stage probability assignment

Assign a win probability to each stage based on historical close rates — not assumptions. Example from a real B2B SaaS pipeline:

Stage 1 — Discovery:        8% win rate
Stage 2 — Qualification:   18% win rate
Stage 3 — Demo/Evaluation: 35% win rate
Stage 4 — Proposal:        52% win rate
Stage 5 — Negotiation:     72% win rate
Stage 6 — Verbal commit:   88% win rate

Multiply each deal's value by its stage probability to get the weighted value.

Step 3: Rep-level rollup

Sum the weighted values for each rep. This is the rep's probability-weighted forecast. Compare it against the rep's quota and their historical forecast accuracy. A rep who consistently over-forecasts by 20% needs a haircut applied to their number.

Step 4: Team and company rollup

Sum all rep forecasts to get the team number. Apply any historical adjustment for the team's collective accuracy. Present as a range: committed (deals in Stage 4+), probable (Stage 3+), and total pipeline (all stages). The committed number is what you staff against. The probable number is what you plan for.

The output should look like this:

Company bottom-up forecast — Q2 2026:
- Committed (Stage 4+):    $482,000   (72% confidence)
- Probable (Stage 3+):     $738,000   (48% confidence)
- Total pipeline weighted:  $914,000   (blended)
- Pipeline coverage:        2.9:1 against $520K target

Bottom-up forecast accuracy benchmarks by company type

How bottom-up forecast accuracy varies across B2B segments. Accuracy measured as variance from actual closed revenue.

Sources: Gartner Sales Forecasting Survey 2025, Clari Revenue Intelligence Report 2025, Pavilion COO Survey 2025.

Forecast accuracy improves 12-18% in the first two quarters after switching from rep-committed to probability-weighted bottom-up forecasting (Clari, 2025).

Common mistakes when building a bottom-up forecast

1. Using generic stage probabilities instead of your own close rates

Templates assign 10%, 25%, 50%, 75%, 90% to stages 1 through 5. Your Stage 3 might close at 31%. Your Stage 4 might close at 58%. Using generic percentages introduces systematic error at every level of the rollup. Calculate your own from 4-6 quarters of CRM data.

2. Counting stale deals at full weighted value

A $90K deal in proposal that has had no activity in 28 days should not carry the same weight as one with a demo scheduled for tomorrow. Without an activity-recency filter, bottom-up forecasts include pipeline that has effectively gone cold. Flag deals with no activity beyond 14 days and reduce their weight.

3. Rolling up without a manager adjustment

Reps are structurally optimistic about their own deals. A bottom-up forecast that sums rep pipelines without a documented manager adjustment consistently overforecasts by 10-20%. The adjustment is not pessimism — it accounts for information the CRM cannot capture: competitive risk, budget freezes, champion departures.

4. Forecasting once per quarter instead of weekly

A bottom-up forecast built in week 1 is stale by week 4. Pipeline changes every week as deals progress, stall, slip, or close. Run the full bottom-up rollup weekly. The forecast should be a living number, updated every 7 days.

5. Ignoring close-date accuracy by rep

Reps set close dates optimistically. If 40% of your "close this quarter" deals slip to next quarter, the bottom-up number is overstated by 40% of those deals' weighted value. Track close-date accuracy by rep and discount accordingly — or weight based on deal velocity rather than stated dates.

How Fairview builds bottom-up forecasts automatically

Fairview's Forecast Confidence Engine connects to your CRM — HubSpot, Salesforce, or Pipedrive — and builds a probability-weighted bottom-up forecast from the live pipeline. Each deal is weighted by your company's historical close rates per stage — not generic probabilities — and rolled up into rep, team, and company views.

The Operating Dashboard shows the bottom-up forecast alongside the quarterly target, with pipeline coverage ratio calculated in real time. When the bottom-up number falls below the target threshold, the Next-Best Action Engine flags the gap: "Bottom-up forecast is $142K below quarterly target. 4 deals in Stage 3 have not progressed in 16 days."

→ See how the Forecast Confidence Engine works

Bottom-up forecast vs top-down forecast

People often use bottom-up and top-down forecasts interchangeably. They start from opposite ends.

Bottom-up tells you what the pipeline will produce. Top-down tells you what the pipeline needs to produce. Use bottom-up for the current and next quarter. Use top-down for the annual plan. When the gap between them is large — top-down target significantly exceeds bottom-up forecast — that gap is the pipeline generation problem to solve.

FAQ

What is a bottom-up forecast in simple terms?

A bottom-up forecast builds the revenue prediction from individual deals upward. Each deal in your pipeline gets a probability based on its stage, and those weighted values are summed from rep to team to company. It tells you what your pipeline will actually produce — not what you hope it will produce.

What is a good accuracy rate for a bottom-up forecast?

For growth-stage B2B SaaS ($2-10M ARR), landing within 10% of actual closed revenue is considered strong. Early-stage companies should target within 15%. If your bottom-up forecast consistently misses by more than 20%, the stage probabilities need recalibration using historical close data (Gartner, 2025).

How do you build a bottom-up forecast?

Pull every open opportunity from your CRM with a close date in the period. Assign win probabilities by stage using historical close rates. Multiply each deal's value by its probability. Sum by rep, then by team. Present as committed (late-stage), probable (mid-stage+), and total weighted pipeline.

What is the difference between bottom-up and top-down forecasting?

Bottom-up starts with actual pipeline deals and aggregates upward to a revenue number. Top-down starts with a target and allocates downward to territories and reps. Bottom-up reflects pipeline reality. Top-down reflects growth ambition. Mature teams use both — bottom-up for near-term accuracy, top-down for annual planning.

How often should you update a bottom-up forecast?

Weekly. Pipeline changes fast — deals enter, slip, stall, and close. A monthly bottom-up forecast is stale within 2 weeks. Weekly recalculation against the live pipeline catches problems early enough to act: accelerate stalled deals, fill coverage gaps, or adjust the committed number before the quarter closes.

Why is CRM data quality critical for bottom-up forecasts?

The forecast is built from CRM deal data — stage, value, close date, and last activity. If 30% of deals have outdated stages or missing close dates, the forecast is 30% guesswork. Enforcing CRM hygiene rules (mandatory fields, weekly updates) directly improves forecast accuracy. Bad data in means bad forecasts out.

Related terms

• Sales Forecast — The broader category of revenue prediction methods, of which bottom-up forecasting is one approach
• Forecast Confidence — A score measuring how likely a sales forecast is to land within an acceptable range of actual results
• Pipeline Coverage Ratio — The ratio of total pipeline value to the revenue target, indicating whether enough pipeline exists to hit the number
• Win Rate — The percentage of opportunities that convert to closed-won, a core input to stage probability weights
• Pipeline Health — A composite measure of deal quality, velocity, and stage distribution across the active pipeline

Fairview is an operating intelligence platform that builds bottom-up forecasts automatically from your CRM pipeline — alongside forecast confidence, pipeline coverage ratio, and pipeline health. Start your free trial →

Siddharth Gangal is the founder of Fairview. He built the Forecast Confidence Engine after watching operators present single-number forecasts based on rep self-reports — then discover at quarter-end that 40% of their "committed" pipeline had been sitting in the same stage for 6 weeks.