Top-Down vs. Bottom-Up Quota-Setting Framework
A side-by-side reconciliation method that runs the finance-driven top-down quota and the territory-built bottom-up quota in parallel, flags where they diverge, and gives decision rules for closing the gap before rollout, instead of after reps start pushing back.
How to use it
Run the top-down and bottom-up formulas independently for every territory, drop results into the variance worksheet, apply the matching tolerance-band action, and get sign-off before quotas are communicated to reps.
What's inside
- Step 1: Top-Down quota calculation
- Step 2: Bottom-Up (TAM/pipeline-built) quota calculation
- Step 3: Rep-by-rep / territory-by-territory variance worksheet
- Step 4: Variance tolerance bands and required action per band
- Step 5: Six reconciliation levers to close a gap
- Step 6: Escalation and sign-off path
- Rollout timing rule, lock quotas before comp communication
Why run both methods separately, before reconciling
Top-down starts from the company's revenue commitment and divides it across the sales force: it guarantees the number adds up, but can assign quota with no relationship to what's sellable in a given territory. Bottom-up starts from account/territory potential and rolls up: it's grounded in reality, but rarely lands exactly on the company number. Run both in parallel, then reconcile the gap deliberately.
Step 1: Top-Down Calculation
`` Per-Rep Quota (Top-Down) = (Company Revenue Target − Non-Rep-Sourced Revenue) ÷ Number of Quota-Carrying Reps ``
- Strip out revenue that isn't rep-sourced (auto-renewals, channel/partner-sourced) before dividing.
- Use ramp-weighted rep capacity (see Headcount-to-Quota Capacity Calculator), not a flat headcount count, if headcount changes mid-year.
Step 2: Bottom-Up Calculation
For each territory/account list: ``` Territory Quota (Bottom-Up) = (Whitespace/TAM × Expected Penetration Rate)
- (Open Pipeline Coverage × Historical Win Rate)
- (In-territory Renewal/Expansion Potential, if rep-owned)
```
- Whitespace/TAM: total addressable accounts in territory × average deal size for that segment.
- Expected penetration rate: realistic conversion %, based on comparable territories' history.
- Pipeline coverage: current open pipeline × the team's historical stage-weighted win rate.
Step 3: Variance Worksheet
| Territory/Rep | Top-Down Quota | Bottom-Up Quota | Variance ($) | Variance (%) | Flag |
|---|---|---|---|---|---|
| Rep A: Enterprise West | $600,000 | $510,000 | −$90,000 | −15% | Investigate |
| Rep B: Mid-Market East | $600,000 | $680,000 | +$80,000 | +13% | Acceptable |
`` Variance % = (Bottom-Up Quota − Top-Down Quota) ÷ Top-Down Quota ``
Step 4: Variance Tolerance Bands
| Variance | Meaning | Action |
|---|---|---|
| ±0–8% | Normal noise | Accept top-down number, no adjustment |
| ±9–20% | Meaningful mismatch | Route to reconciliation levers (Step 5) before rollout |
| >20% | Structural problem in territory design, TAM assumption, or headcount math | Escalate (Step 6); do not roll out until resolved |
Step 5, Reconciliation Levers
- Territory redesign: move accounts to rebalance TAM before quotas finalize (highest-integrity fix, needs lead time).
- Quota relief / floor adjustment: set assigned quota below strict top-down for under-built territories, redistribute shortfall across over-built ones.
- Ramp/timing adjustment: phase quota (lower H1, catches up H2) for new/reassigned reps instead of flattening across the year.
- Comp-plan lever, not quota lever, leave quota as-is but add an earlier accelerator kicker for provably harder territories.
- Blended quota,
(Top-Down × 60%) + (Bottom-Up × 40%)when both methods are directionally trustworthy but neither should own 100%. - Escalate the company target itself: if the full-org bottom-up roll-up falls meaningfully short of the top-down company number, that's a signal the company target needs revisiting, not that each territory should be squeezed.
Step 6: Escalation & Sign-Off Path
- >20% variance or a blended-method decision → Sales Leader + Finance Business Partner review jointly, decision documented in writing.
- Territory redesign triggered → RevOps/Sales Ops owns the redesign; Sales Leader approves the final map before quota is attached.
| Role | Name | Approved | Date |
|---|---|---|---|
| Sales Leader | ☐ | ||
| Finance Business Partner | ☐ | ||
| RevOps/Sales Ops | ☐ |
Rollout Timing Rule
Lock reconciled quotas before comp plan communication, not after. Reps who receive a number and then see it change during their first pipeline review lose trust in the number for the rest of the year. Reconciliation happens on paper, before rollout day: never live, in front of the rep.