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:

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.

Frequently asked questions

Sources

1. Gartner Sales Forecasting Survey 2025
2. Clari Revenue Intelligence Report 2025
3. Pavilion COO Survey 2025