How many records are in each system?
HubSpot says 1,200 contacts. QuickBooks says 430 customers. Stripe says 890. Why are the numbers so different, and what does it tell you about your data?
The short answer
How many records do you have? Each tool stores a different slice of your customer universe. Your CRM has leads and customers. Your accounting software has invoiced clients. Stripe has anyone who ever paid. The differences between these counts tell you a lot about your data health and where gaps exist.
Record count differences reveal data gaps you cannot see any other way
If your CRM has 1,200 contacts but QuickBooks only has 430 customers, that means 770 contacts in your CRM never became invoiced customers (or they did, but under different names). If Stripe has 890 customers but QuickBooks has 430, there are potentially 460 paying customers that your books do not fully account for.
These count discrepancies are the first signal that something is off. They do not tell you exactly what is wrong, but they tell you where to look. A system with far fewer records than expected likely has data that never made it over from other tools.
Tracking record counts over time also reveals growth patterns. If your CRM contact count is growing but your QuickBooks customer count is flat, your sales pipeline may be leaking. Leads are entering but not converting to paying customers.
What each record count actually represents
- CRM contacts (HubSpot/Salesforce). Everyone your business has ever interacted with: leads, prospects, customers, former customers, partners. This is usually your largest number because CRMs capture the widest net.
- Accounting customers (QuickBooks/Xero). People or companies you have invoiced. This is typically your smallest count because it only includes actual customers with financial transactions.
- Payment customers (Stripe). Anyone who has made a payment. Usually between the CRM and accounting counts. Can be higher than accounting if guest checkouts or unreconciled payments are common.
- Ad platform records (Google Ads).Click and conversion data, not customer records per se. The “record count” here is more about the volume of interactions than identifiable people.
How to count records in each system manually
- 1HubSpot: check your contact count
Go to CRM → Contacts. The total count shows at the top of the list. For a more accurate number, export all contacts (Export → All properties) and count the rows in the CSV.
- 2QuickBooks: check your customer count
Go to Sales → Customers. The list shows all customers. Export to Excel (click the export icon) and count the rows. Make sure to check whether inactive customers are included or hidden.
- 3Stripe: check your customer count
In the Stripe Dashboard, go to Customers. The total count appears at the top of the page. For the most accurate number, export all customers to CSV and count the rows.
- 4Xero (if applicable): check your contact count
Go to Contacts → Customers from the top menu. Click the three dots icon in the upper right and select “Export.” Count the rows in the downloaded CSV.
- 5Compare the counts side by side
Put all four counts in a table. Note the ratios. If your CRM has 3x more records than your accounting software, that might be normal (lots of leads). If Stripe has 2x more than QuickBooks, that is a red flag for unreconciled payments.
Total time: 15-20 minutes. Getting the counts is easy. The value comes from comparing them and understanding what the differences mean, which requires context about your business processes.
Record counts change every month and the ratios tell a story
Tracking record counts monthly reveals trends. If your CRM contact count is growing at 50 per month but your QuickBooks customer count only grows by 5, your conversion rate is declining. If Stripe customers are growing faster than QuickBooks customers, your reconciliation gap is widening.
These are early warning signals that show up in the counts before they show up in your revenue numbers.
Or see all record counts in one dashboard automatically
Bottomline pulls the record count from every connected system and displays them side by side. It also tracks the counts over time so you can spot trends without logging into each tool separately.
The numbers tell a story. HubSpot gained 52 contacts but QuickBooks only gained 8 customers. That means 44 new CRM contacts did not become paying customers this month. Is that normal for your sales cycle, or is something falling through the cracks? The counts surface the question. Your report helps you find the answer.