How do I build a real bottom-up forecast in a 50-rep org?
Don't ask AEs to estimate pipeline. Ask them to list every deal (deal name, company, amount, close date, next step, owner, confidence). Then YOU bucket the deals by stage and probability yourself. Reps are terrible at forecasting; data doesn't lie. Your bottom-up forecast lives in your CRM, not in a manager's gut.
How to build it (monthly cadence):
Step 1: Data pull. Export your CRM: deal name, contact, amount, stage, last activity date, next step, confidence. One row per deal. (You're doing this now—if your CRM can't export this in 5 minutes, fix that first.)
Step 2: Clean & validate. Check 4 things:
- Amount is set. No $0 deals.
- Stage is filled. No "other" or blank stages.
- Next step exists. If a deal has no next step, it's dead—move to lost.
- Last activity is <21 days ago. If it's older and you're forecasting on it, that's lying.
Step 3: Assign confidence by stage, not by rep opinion. Don't trust AE confidence scores.
- Stage 1 (Discovery): 5% confidence, average cycle 30 days
- Stage 2 (Proposal): 20% confidence, average cycle 21 days
- Stage 3 (Negotiation): 50% confidence, average cycle 14 days
- Stage 4 (Commit/Legal): 75% confidence, average cycle 7 days
- Stage 5 (MSA Signed): 95% confidence, average cycle 3 days
These percentages come from your historical data. Pull 12 months of deals and calculate: "Of deals that entered Stage 2 in the past year, what % actually closed?" Use that real number, not industry benchmarks.
Step 4: Segment by rep, deal age, and size. Create a pivot showing:
- How many deals each AE has at each stage
- How many of those are >21 days old (at risk)
- Total revenue by stage
Step 5: Calculate three forecasts.
| Forecast | Definition | Formula |
|---|---|---|
| Conservative | Only Stage 4 + Stage 5 deals | Sum of Stage 4 × 0.75 + Stage 5 × 0.95 |
| Realistic | Stage 3 + 4 + 5 | Stage 3 × 0.50 + Stage 4 × 0.75 + Stage 5 × 0.95 |
| Upside | All deals by stage probability | Apply stage confidence to all stages |
Present all three to leadership. Never claim "we're making $X" when you mean "if everything closes." Say "conservative is $2.4M, realistic is $3.1M, upside is $4.2M."
Step 6: Flag red deals. Any deal >$50K that's over age-target for its stage. Pull the AE in and ask: "This deal is 40 days old in stage 2. What's changed since day 20? Is it still real?" Update it or close it.
Do this every Friday. Takes 2 hours for a 50-rep org (or less if you automate it with Salesforce Reports/Power BI). Once AEs realize you're checking the data independently every week, they stop lying on Fridays and actually work harder.
TAGS: forecasting,sales-ops,bottom-up,50-rep-org,revenue-ops