What’s the total value of deals I’ve won?
Your CRM says you closed $180,000 in deals this quarter. Your accounting says you collected $142,000. Which number is right? Here's how to reconcile them and get the real answer.
The short answer
What is your total closed-won value?Your CRM tracks deal values when they are marked “Closed Won.” Your accounting software tracks when money actually arrives. The two numbers rarely match because deals close in your CRM before invoices are sent, payments are collected, and scope changes happen. You need both numbers and an understanding of the gap between them.
Why your CRM pipeline value and your bank account tell different stories
Your sales team closes a $25,000 deal on March 15. It goes into the CRM as Closed Won. But the contract does not start until April 1. The first invoice goes out April 5. The client pays April 28. Another $25,000 deal closes March 22, but the scope gets renegotiated during onboarding and the final contract is $19,000.
Your CRM says you won $50,000 in March. Your accounting shows $0 collected in March from those deals. By April, you have collected $25,000 (the first deal) and $19,000 (the renegotiated deal). The real value was $44,000, not $50,000.
This gap between CRM-reported deal value and actual collected revenue is normal. But if you are making decisions based on CRM numbers without verifying against accounting, you are working with inflated figures. Understanding the gap and its causes is critical for accurate forecasting.
CRM deal value vs. collected revenue: the metrics to reconcile
Here is what you should be tracking:
- CRM closed-won value.The total deal amount in your CRM for deals marked as won. This is the “what we think we sold” number.
- Invoiced value. The total amount you actually invoiced to those customers. This accounts for scope changes and contract adjustments.
- Collected revenue.The total amount actually paid by those customers. This is the “what we actually received” number.
- Realization rate. Collected revenue / CRM closed-won value. If your realization rate is 85%, that means 15% of your pipeline value evaporates between CRM and bank account. Tracking this over time tells you how reliable your pipeline numbers are.
How to reconcile closed-won deals across CRM and accounting (6 steps)
This requires data from your CRM and accounting software. Plan for about 45-60 minutes.
- 1Export closed-won deals from your CRM
In HubSpot, go to CRM → Deals. Filter by “Deal Stage = Closed Won” and “Close Date” in the current quarter. Export with deal name, amount, close date, and associated contact email. In Salesforce, run an Opportunity report filtered to “Stage = Closed Won” for the quarter.
- 2Sum the CRM pipeline value
Total the “Amount” column. This is your CRM-reported closed-won value. In HubSpot, the Deals dashboard shows this as “Closed deal amount.” In Salesforce, the Opportunity report footer shows the sum.
- 3Export invoices and payments from accounting
In QuickBooks, run Sales by Customer Summary for the same period. Also check Invoices to see outstanding amounts. In Xero, export paid and unpaid invoices for the quarter.
- 4Match CRM deals to accounting records
In a spreadsheet, VLOOKUP by customer email or name to match each CRM deal to its corresponding invoices and payments. Note deals that have no matching invoice (closed in CRM but not yet invoiced) and deals where the invoice amount differs from the CRM amount.
- 5Calculate the gap
CRM value minus collected revenue = the gap. Break it down: how much is timing (invoiced but not yet paid)? How much is scope changes (final contract differs from CRM amount)? How much is loss (deal fell apart after being marked won)?
- 6Calculate your realization rate
Collected revenue / CRM closed-won value = realization rate. Track this quarterly. If it is declining, your pipeline accuracy is getting worse.
Total time: 45-60 minutes. The manual matching (step 4) is the bottleneck. Company names in your CRM often differ from company names in your accounting software, making matching unreliable.
Why CRM and accounting rarely agree (and why it matters)
Sales teams update the CRM. Finance updates the accounting software. They use different names, different deal structures, and different timelines. A deal in your CRM is a single record with one amount. In accounting, that deal might be three invoices over three months with a different total.
The consequence is that leadership makes decisions based on CRM pipeline numbers that are 10-20% higher than reality. Forecasts are optimistic. Hiring decisions assume revenue that has not actually been collected. Cash flow projections fall short. The fix is simple in concept (reconcile CRM to accounting every month) but tedious in practice.
Or see your true closed-won value reconciled automatically
Bottomline connects to your CRM (HubSpot or Salesforce) and your accounting software (QuickBooks or Xero). It matches every closed-won deal to its corresponding invoices and payments, calculates the gap, and shows you the real number.
The picture is clear: of $180,000 in CRM pipeline, you have collected $142,400. $25,600 is invoiced but unpaid. $12,000 evaporated due to scope adjustments. Your realization rate is 79%, which means for every dollar your sales team reports as won, you should plan on receiving about 79 cents. That insight alone is worth more than the pipeline number by itself.