Sales Pipeline Coverage Calculator

Pipeline coverage compares the value of open opportunities expected to close within a period with the part of that period’s quota that is not yet won. A ratio of 3.0× means the open pipeline is worth three times what remains to be booked. Sales leaders, managers and founders use it early in a quarter or month to judge whether the team should focus on closing, generate more pipeline or revisit deal timing. It is a gross capacity check, not a forecast of what will close.

First the calculator works out the remaining quota: the period quota minus the deals already won and credited against it. If that difference is negative because the quota is exceeded, it is set to zero. Then it divides the open pipeline value by that remaining quota. The result is a multiplier with no currency: 2.0× means the open deals are worth twice the amount still needed.

The numerator and denominator must describe the same period, owner and currency. Open pipeline means deals still open whose expected close date falls inside the period; already-won deals belong in the “sales already won” input, never in both. When the remaining quota reaches zero, the quota is met and coverage is shown as not applicable instead of an infinite ratio.

The result is gross coverage: each open deal counts for its full amount, whatever its stage. Weighted coverage, which first multiplies each deal by its close probability, is always lower or equal and answers a different question.

What each term means

Open pipeline value

Total eligible value of open deals expected to close during the chosen period.

Where to find it: Sum of open opportunity amounts in your CRM whose expected close date is inside the quota period, for the same team or rep. Exclude won, lost and unqualified records, and deals dated after the period end.

Sales quota

Booked sales target for a specified period.

Where to find it: The booked sales target for the period you analyse (month, quarter or year), in the same currency and on the same basis: signed bookings, not invoiced or collected revenue. Must be greater than zero.

Sales already won

Won bookings already credited against the period quota.

Where to find it: Value of deals already marked closed-won in the same period and credited to the same quota. Use the booked amount the quota is measured on; enter 0 at the start of the period.

Remaining sales target

Sales quota minus the period’s already-won value, floored at zero.

Pipeline coverage

Open pipeline value divided by the remaining target (gross, not weighted).

Hypothetical example: a team has a quarterly quota of 150,000, has already won 50,000 this quarter and holds 300,000 of open pipeline with expected close dates inside the quarter.

1. Remaining sales target150,000 − 50,000 = 100,000
2. Pipeline coverage300,000 ÷ 100,000 = 3×

Pipeline coverage = 3×

Remaining quota = 150,000 − 50,000 = 100,000. Coverage = 300,000 ÷ 100,000 = 3.0×, and 50,000 ÷ 150,000 means 33.3 % of the quota is already attained. If the team won one more 20,000 deal from that pipeline next week (70,000 won, 280,000 still open), the remaining quota would fall to 80,000 and coverage would become 280,000 ÷ 80,000 = 3.5×. If instead 60,000 of pipeline slipped to next quarter, coverage would drop to 240,000 ÷ 100,000 = 2.4× without a single deal being lost.

Hypothetical numbers, used to show the calculation. Not real company data.

Check coverage at the start of a period and again at regular points within it. Early on, a low ratio leaves time to create or accelerate opportunities; late in the period, it mainly tells you how much of the remaining number depends on a few deals.

In pipeline reviews it helps separate two different problems: not enough pipeline (coverage below what your own conversion history requires) and pipeline that exists but is not converting or is dated too late. The first calls for prospecting, the second for deal-by-deal inspection.

Calculate it per rep, team or segment rather than only for the whole company. A comfortable total can hide one team with ample coverage and another with almost none.

A target of three times coverage is often repeated in sales teams, but it is a rule of thumb, not a law. The coverage you actually need depends on how much of the pipeline due in a period your team usually converts. If you historically win about one third of in-period pipeline value, 3× is roughly break-even; if you win one quarter, you need about 4×; if you win 40 %, about 2.5× would be enough. The required ratio is approximately 1 ÷ your own conversion rate by value for comparable periods.

Timing matters as much as amount. Pipeline only counts if the customer decision can realistically happen before the period ends. Optimistic close dates inflate coverage; when they slip, coverage falls even though nothing was lost. Checking that each large deal has a dated next step and a known decision process is often more informative than the ratio itself.

Composition matters too. 3× made of many mid-stage deals is not the same as 3× made of early conversations or of one very large opportunity. Compare gross coverage with weighted coverage built from the weighted pipeline calculator: a wide difference shows that the pipeline is concentrated in low-probability stages.

Below 1.0×, the open pipeline cannot reach the remaining quota even if every deal were won; the calculator shows the pipeline gap. Between 1.0× and the ratio your own history requires, the quota depends on converting more than your usual share. Above it, the question becomes timing and quality rather than volume.

Higher coverage is not automatically better. Very high coverage can mean stale deals that nobody has closed out, or close dates nobody has questioned. A healthy reading is one you can explain deal by deal.

Practical levers

• Clean the pipeline first: close out dead deals and correct close dates so the ratio reflects reality.
• Create new qualified opportunities that can realistically close inside the period.
• Advance stalled deals with a dated next step and a confirmed decision maker.
• Agree with finance that the quota is a booking target, so that won value and quota use the same basis.

Common mistakes

• Counting pipeline dated after the period end, or deals without any close date.
• Dividing by the full quota instead of the remaining quota once deals have been won.
• Leaving already-won deals in the open pipeline, which counts them twice.
• Treating a 3× rule of thumb as a guarantee instead of deriving the ratio from your own conversion history.
• Mixing currencies, or comparing a booking quota with invoiced revenue.

Scenario comparison

The conservative case raises the quota by 10 %, lowers won value by 20 % and lowers open pipeline by 20 %; the optimistic case does the opposite. These moves are illustrative, not predictions: replace them with changes you consider plausible, such as a known deal slipping.

Look at which input moves coverage most for your numbers. Early in a period, pipeline usually dominates; late in a period, a single won or lost deal can move the remaining quota, and therefore the ratio, sharply.

Coverage is gross and ignores close probability: two pipelines with the same value can have very different chances of converting.

The ratio is only as good as the CRM data behind it. Stale opportunities, inflated amounts and optimistic close dates all overstate it.

It does not say which deals will close or when. For a dated estimate, use the weighted pipeline and revenue forecast calculators, and remember that a booking is neither recognized revenue nor cash.