How much money is sitting on the table from these gaps?

Why revenue leakage is a bigger problem than slow growth

Most business owners focus on generating more leads and closing more deals. That is the growth side. But they ignore the leakage side: the revenue that is already in their pipeline or already won but never makes it to the bank account.

Consider a business that generates 150 leads per month, closes 20 deals at an average of $8,000, and brings in $160,000 in monthly revenue. Sounds healthy. But hidden in those numbers:

• 35 leads never got a call. At a 20% close rate and $8,000 average deal, that is $56,000 in potential revenue left on the table.
• 6 proposals are sitting unanswered for 14+ days. Total pipeline value: $52,000. At a reduced 15% close probability (since they are going cold), that is $7,800 in expected revenue slipping away.
• 2 won deals were never invoiced. That is $16,000 in revenue that was already earned but simply never billed.

Total money sitting on the table: roughly $80,000 per month. That is 50% of their current revenue, just from process gaps. Fixing even half of that leakage is worth more than a 25% increase in lead generation.

The three buckets of revenue leakage

To calculate your total money on the table, you need to measure three separate gaps:

• Bucket 1: Dropped leads. Leads that entered your CRM but never received a follow-up call or email. Cost = (number of dropped leads) x (close rate) x (average deal size) + (wasted ad spend to acquire those leads).
• Bucket 2: Stale proposals. Deals in the Proposal Sent stage with no activity for 14+ days. Cost = (total deal value of stale proposals) x (reduced close probability, typically 10-20%).
• Bucket 3: Uninvoiced deals. Deals marked as Closed Won in your CRM with no matching invoice in QuickBooks. Cost = full deal amount (this is already-earned revenue that was never billed).

How to calculate your total revenue leakage manually

1. 1
   Calculate Bucket 1: Dropped leads

   In HubSpot, filter contacts created in the last 30 days where Number of Times Contacted equals 0. Count them. Multiply by your close rate and average deal size for estimated lost revenue. Pull your total ad spend from Google Ads and divide by total leads to get cost-per-lead, then multiply by dropped leads for wasted ad spend.

2. 2
   Calculate Bucket 2: Stale proposals

   In HubSpot, filter deals where stage is Proposal Sent and Last Activity Date is more than 14 days ago. Sum the deal amounts. Multiply by a reduced close probability (15-20% instead of your normal rate) to estimate the at-risk revenue.

3. 3
   Calculate Bucket 3: Uninvoiced deals

   Export closed-won deals from HubSpot and invoices from QuickBooks. Cross-reference by customer name using VLOOKUP. Flag deals with no matching invoice. Sum the deal amounts. This is the most manual step because of naming mismatches between systems.

4. 4
   Add the three buckets together

   Dropped leads revenue + stale proposal revenue + uninvoiced deal revenue = total money sitting on the table. Present each bucket separately so you can prioritize which gap to fix first (usually uninvoiced deals, since that is money already earned).

5. 5
   Annualize the number

   If these gaps are recurring (they almost always are), multiply your monthly figure by 12. This is the annual cost of your broken handoffs. The annualized number is what makes the case for fixing the process.

What it takes to track revenue leakage every month

Calculating leakage once is useful. Tracking it monthly is how you measure whether your fixes are working. But the monthly work includes:

• Re-running all three analyses with updated data.
• Logging into three different systems (CRM, ad platform, accounting).
• Reconciling customer names between CRM and QuickBooks again.
• Comparing this month's leakage to last month's to see if the trend is improving.

The three-system data collection is what kills this analysis. Any one bucket is manageable. Doing all three consistently, every month, is where teams give up.

Or see your total revenue leakage automatically, every month

Bottomline connects to your CRM, ad platforms, and accounting software. Every month, it calculates all three buckets of revenue leakage and presents a single number: the total money sitting on the table.

The annualized number is the one that gets attention. When you see that broken handoffs between your systems are costing you nearly $1M per year, fixing the process stops being a “nice to have” and becomes the highest-ROI thing you can do.