Do I have enough leads in the pipeline to hit next month’s number?
Your revenue target is a number. Your pipeline is supposed to get you there. But does the math actually work? Here's how to calculate pipeline coverage and know whether you're on track.
The short answer
Divide your total open pipeline by your revenue target. If your close rate is 25%, you need 4x pipeline coverage to hit your number. If you have $200K in pipeline and need $80K in revenue, that's 2.5x coverage. With a 25% close rate, you're short. Below, we show you how to pull this from HubSpot and Salesforce.
Pipeline coverage is the earliest warning signal for a revenue miss
Most business owners find out they missed their number after the month ends. By then it's too late. Pipeline coverage tells you 30 days in advance whether the math works.
The formula is simple: Total Open Pipeline divided by Revenue Target equals Pipeline Coverage Ratio. The industry standard is 3x to 4x coverage, meaning you need three to four dollars in pipeline for every dollar you plan to close. The exact multiplier depends on your historical close rate.
If your close rate is 33%, you need 3x. If it's 20%, you need 5x. And if you don't know your close rate, you're guessing at both sides of the equation.
The three numbers you need for pipeline coverage
- Total open pipeline value. Sum of all deal amounts for open opportunities with close dates next month. Exclude anything in early discovery if you want a realistic number.
- Your revenue target. What do you need to collect next month? This might come from your budget, your forecast, or simply the number you need to cover expenses and make a profit.
- Your historical close rate. Of all deals that entered your pipeline in the last 6 months, what percentage ended up as Closed Won? This is the conversion factor that turns pipeline into expected revenue.
How to calculate pipeline coverage in HubSpot
- 1Go to Sales → Deals
Switch to List view. Filter by “Close date is next month” and “Deal stage is not Closed Won or Closed Lost.” Note the total deal amount at the bottom of the list.
- 2Check the Forecast tool: Sales → Forecast
Click the Deal stagetab. Set the time period to next month. If your forecast settings use Weighted amount, you'll see pipeline adjusted by deal stage probability. If set to Total amount, you see raw pipeline value.
- 3Pull your close rate: Reports → Analytics Tools → Sales Analytics
Select Deal close rate from the sidebar. Set the date range to the last 6 months. This shows the percentage of deals that moved to Closed Won vs. total deals created.
- 4Do the math
Divide your total open pipeline by your revenue target. Then compare to 1 divided by your close rate. Example: $320K pipeline / $80K target = 4x coverage. If your close rate is 25%, you need exactly 4x. You're right on the edge.
Total time: 10-15 minutes. You need the deal board, the forecast tool, and a sales analytics report. The math itself takes 30 seconds.
How to calculate pipeline coverage in Salesforce
- 1Open Pipeline Inspection or create an Opportunity report
Navigate to Opportunities → Pipeline Inspection. Filter for close dates next month. The summary bar at the top shows total pipeline value. Alternatively, go to Reports → New Report → Opportunities and filter by close date and open stages.
- 2Calculate your historical close rate
Create a report: Reports → New Report → Opportunities. Group by “Stage” and summarize by record count. Filter to the last 6 months. Divide Closed Won count by total opportunities. That's your close rate.
- 3Compare coverage to your target
Pipeline value divided by target equals your coverage ratio. If it's less than 1 / close rate, you're statistically short. For a 20% close rate, anything under 5x means you probably won't hit the number without adding new pipeline.
Total time: 15-20 minutes. You need Pipeline Inspection and a custom report. The close rate calculation requires a bit of manual math.
Validate pipeline coverage against your actual revenue history
Your CRM says you close 25% of deals. But does your accounting data agree? Here's how to check:
- Compare CRM closed-won revenue to invoiced revenue. Pull your last 3 months of Closed Won deals from your CRM. Then pull revenue from QuickBooks or Xero for the same period. If CRM says $240K but accounting says $210K, your pipeline projections are 12% too optimistic.
- Factor in collection lag.A deal that closes on March 28 might not get invoiced until April 5 and paid until May 2. If you need cash next month, pipeline coverage alone won't tell you whether the money arrives in time.
The monthly pipeline coverage review
This check should happen at the start of every month, before the month you're forecasting for. It takes about 20-30 minutes: 10 minutes in your CRM, 10 minutes cross-referencing with accounting, and a few minutes doing the math. The problem is that by the time you realize coverage is short, you may not have enough time to generate new pipeline.
Or get your pipeline coverage calculated automatically
Bottomline connects to your CRM and accounting software and calculates pipeline coverage for you every month. It factors in your actual close rate (not an assumption), adjusts for the gap between CRM revenue and collected revenue, and tells you whether the math works.
Your historical close rate is 28%. You need 3.6x coverage to hit target. You're 0.8x short.
No more toggling between deal boards, forecast tools, and accounting reports. One number tells you whether you're on track or need to hustle.