What Bottom-Up Forecasting Means
Bottom-up forecasting is defined as a methodology that constructs revenue projections by aggregating individual deal-level or rep-level data, producing a forecast that reflects the actual composition of the pipeline. It is the most granular and defensible forecasting approach for near-term periods. According to CSO Insights (2024), bottom-up forecasts are 22% more accurate than top-down estimates for current-quarter predictions because they are grounded in observable data rather than assumptions.The principle: start with every deal, apply a realistic probability, and add them up. What you see is what you are likely to get.
How is a bottom-up forecast built?
The process follows three steps:
Step 1: Deal-level assessment. For each deal in pipeline, evaluate: - Current stage and associated close probability - Deal amount (validated, not aspirational) - Expected close date (evidence-based, not rep optimism) - Risk factors (champion status, executive engagement, competitive position) Step 2: Probability weighting. Apply historical stage conversion rates to each deal. A deal in evaluation with a 30% historical conversion rate and a $100K value contributes $30K to the weighted pipeline. Step 3: Aggregation. Sum the weighted values across all deals, by rep, by segment, and in total. Compare the bottom-up total to the target to identify gaps.| Category | What It Includes | Confidence Level |
|---|---|---|
| Commit | Deals at 80%+ probability, evidence-based | High |
| Best Case | Commit + deals at 50-79% probability | Medium |
| Upside | Best case + deals at 30-49% probability | Lower |
Why bottom-up forecasting matters for revenue teams
Bottom-up forecasting exposes the gap between target and reality at the deal level. If your top-down target is $5M and your bottom-up forecast shows $3.8M in weighted pipeline, you know exactly how big the gap is and can identify which specific deals need to close, which need to accelerate, and how much incremental pipeline is required.This transparency is what makes bottom-up forecasting valuable for operational planning. It connects the forecast to specific actions: win this deal, accelerate that one, generate this much new pipeline. Forecast accuracy improves because the forecast is grounded in deals you can see and influence.
How to improve bottom-up forecasting
- Calibrate probabilities to your data. Do not use generic stage probabilities. Calculate your actual historical conversion rates by stage, segment, and deal size. Update quarterly. Your stage 3 probability might be 40% while an industry benchmark says 50%. - Layer in deal-level signals. Stage alone is a crude probability indicator. Adjust probabilities up or down based on champion activity, multi-threading status, and time-in-stage relative to median. Deals with strong signals convert at higher rates within the same stage. - Validate with top-down forecasting. When your bottom-up forecast diverges significantly from historical booking trends, investigate. The bottom-up forecast may be biased by rep optimism, or the top-down trend may miss a genuine market shift. - Forecast by rep, not just by deal. Some reps are historically accurate forecasters. Others consistently over-forecast by 30%. Apply rep-level calibration factors to adjust for individual forecasting biases.
Common mistakes with bottom-up forecasting
Trusting deal amounts without validation. Reps often inflate deal sizes to meet pipeline targets. If a deal amount has not been validated with the buyer, discount it by 20-30% in the forecast. Amounts that have been through formal pricing discussions deserve full weighting. Not accounting for deals that have not yet entered pipeline. A bottom-up forecast only sees what is in the CRM today. For quarters more than 60 days out, a significant portion of the bookings will come from deals not yet created. Blend bottom-up with pipeline generation forecasts for future quarters.Frequently Asked Questions
When should you use bottom-up vs. top-down forecasting?
Use bottom-up for near-term operational forecasts (current and next quarter) where you have deal-level visibility. Use top-down for longer-term planning (2-4 quarters out) where historical trends are more reliable than individual deal data.
How accurate is bottom-up forecasting?
Bottom-up forecasts are typically the most accurate method for current-quarter projections, achieving 85-95% accuracy when deal data is maintained. Accuracy drops for future quarters where pipeline has not yet been generated.
What data does a bottom-up forecast require?
Deal-level data: stage, amount, close date, probability, and last activity date. Rep-level data: historical attainment rate, ramp status, and current pipeline. The more complete the CRM data, the more accurate the forecast.
Put these metrics to work
ORM builds custom revenue forecast models that turn concepts like bottom-up forecasting into prescriptive action for your team.
Schedule a Demo