About the Sales Pipeline Coverage Calculator
This pipeline coverage calculator tells you whether there is enough open opportunity in your sales pipeline to close the gap to quota. Enter the period’s quota, what has already closed, and the open pipeline value in each stage with its win probability. You get the coverage ratio (open pipeline ÷ remaining quota), the probability-weighted pipeline, projected attainment and how much new pipeline you still need to reach your target coverage.
It is built for sales leaders, revenue operations teams, account executives and founders running forecast calls or quarterly planning. The raw coverage ratio is the quick health check most teams quote ("we are at 3×"); the weighted view accounts for the fact that early-stage deals rarely close, which makes it a better forecast.
Stage probabilities should come from your own historical win rates by stage — the defaults are only placeholders. The right coverage target depends on your win rate: a team that wins one in three qualified deals needs roughly 3× coverage, while a team winning one in four needs about 4×.
With the default inputs, the pipeline coverage ratio is 2.53 ×. Change any value above to recalculate instantly.
How to use the sales pipeline coverage calculator
- 1Enter the quota for the quarter or year and the revenue already closed.
- 2Set the coverage ratio your team aims for (often 3× to 4×).
- 3Enter the open pipeline value expected to close this period in each stage.
- 4Set each stage’s win probability from your CRM history.
- 5Read coverage, weighted pipeline and projected attainment, and plan prospecting for any gap.
Formula and method
Pipeline coverage compares the total value of open opportunities expected to close this period with the quota still to be won. Closed-won revenue is subtracted from quota first, so coverage reflects what is left to do. A ratio of 3× means there is three dollars of pipeline for every dollar of remaining quota.
The weighted pipeline multiplies each stage’s value by the probability that deals in that stage close, then adds the stages together. Adding it to closed-won revenue gives a probability-weighted forecast of attainment. The pipeline gap is the extra open pipeline needed to reach your target coverage: target × remaining quota − current pipeline.
- quota
- Revenue target for the period
- closed-won
- Revenue already booked this period
- stage win probability
- Historical chance that a deal in that stage closes
Worked examples
$1M quarter with $250k closed
Open pipeline of $1.9M against $750k of remaining quota is 2.53× coverage. Weighting each stage by its probability gives $732,500, so projected attainment is ($250k + $732.5k) ÷ $1M = 98.25%. Reaching 3× needs $2.25M of pipeline — $350k more.
Early in the year, mostly top-of-funnel
With nothing closed, $6.5M of pipeline covers the $2.4M quota 2.71 times. Because most of it is early stage, the weighted value is only $1.675M (69.8% of quota), and reaching 4× coverage requires another $3.1M of pipeline.
Quota already exceeded
Closed-won of $520k already beats the $500k quota, so remaining quota is zero and coverage is not meaningful. Including the weighted $732,500 pipeline, projected attainment is 250.5%.
Frequently asked questions
What is pipeline coverage?+
Pipeline coverage is the ratio of open sales pipeline to the quota still to be closed in a period. If you need $750,000 more and have $2.25 million of qualified opportunities, your coverage is 3×.
What is a good pipeline coverage ratio?+
Many B2B teams target 3× to 4×, but the right number is roughly 1 ÷ your win rate. If you win 25% of pipeline, you need about 4× coverage; if you win 40%, 2.5× may be enough.
How do you calculate weighted pipeline?+
Multiply each opportunity or stage value by its probability of closing and add the results. A $400,000 proposal stage at 50% contributes $200,000 to the weighted pipeline.
Should closed-won deals count toward pipeline coverage?+
No. Coverage measures open pipeline against what is left to win, so subtract closed-won revenue from quota first. Counting closed deals would overstate how healthy the remaining pipeline is.
Where do stage probabilities come from?+
Use historical conversion: of all deals that reached each stage in past periods, what share eventually closed won? Most CRMs report this. Default probabilities set by software are often optimistic.