How well are my systems connected to each other?

Disconnected systems give you wrong answers to every other question

You ask “how much revenue did this customer generate?” Your accounting software says $12,000. But Stripe shows $14,500 in payments from the same person under a slightly different email. And your CRM has them listed as two separate contacts because one record uses their work email and the other uses their personal email.

Every business question that involves the word “customer” depends on your systems agreeing on who that customer is. When they don't agree, your revenue numbers are fragmented, your ad attribution is broken, and your CRM pipeline tells a different story than your books.

The worst part is that you usually don't realize this is happening. Each tool looks fine on its own. The cracks only show up when you try to get a cross-system answer.

What “connected” actually means for your business tools

Integration isn't just “I linked my accounts.” True connection means three things:

• Identity resolution.The system can tell that “jane@company.com” in HubSpot, “Jane Smith” in QuickBooks, and “cus_4Qx8” in Stripe are the same human being.
• Data freshness. The connection is live and recent. A sync that ran once six months ago is not a connection.
• Coverage. Most or all of your records in each system have a match in the others. If only 30% of your Stripe customers match a QuickBooks client, the connection has gaps big enough to invalidate your reporting.

How to check your system connections manually (the spreadsheet way)

There is no single tool that shows you a connection health dashboard out of the box. To do this yourself, you need to export customer lists from each system and try to match them.

1. 1
   Export contacts from HubSpot

   Go to CRM → Contacts. Click the Exportbutton in the upper right. Select “All properties and associations on records” and choose CSV. HubSpot will email you a download link.

2. 2
   Export your customer list from QuickBooks Online

   Go to Sales → Customers. Click the export icon (small box with an arrow) next to the print icon. Choose “Export to Excel.” This gives you names, emails, phone numbers, and balances.

3. 3
   Export customers from Stripe

   Go to the Customers section in your Stripe Dashboard. Click the Export button in the upper right. Choose your columns (at minimum: name, email, created date) and download the CSV.

4. 4
   Load all three into a spreadsheet

   Paste each export into a separate tab in Google Sheets or Excel. Now you need to match them. The only reliable matching field is usually email, but not every system has an email for every record.

5. 5
   Try VLOOKUP or INDEX/MATCH across tabs

   Use VLOOKUP to find HubSpot contacts that exist in QuickBooks by email. Then check which Stripe customers match either system. For records without email, you are stuck trying to match on name, which is unreliable (is “J. Smith” the same as “Jane Smith”?).

6. 6
   Count your matches and gaps

   For each system pair, count how many records matched, how many are in one system but not the other, and how many could not be matched at all. This gives you a rough connection score.

Doing this every month is where it falls apart

Even if you survive the first export-and-match session, you would need to repeat it monthly to know whether your connection quality is improving or degrading. New customers get added. Emails change. Records get merged or duplicated.

In practice, nobody does this. The spreadsheet from month one sits in a folder. By month three, your systems have drifted further apart and you have no idea by how much.

Or see your connection health automatically

Bottomline connects to your QuickBooks (or Xero), HubSpot (or Salesforce), Stripe, and Google Ads accounts. It runs identity resolution across every record in every system, matching on email first, then phone, then fuzzy name matching, then transaction references and addresses.

Instead of spending hours on spreadsheet VLOOKUPs, you get a single view that shows which system pairs are well connected and which ones have gaps. And because Bottomline re-runs this matching every month, you can see whether your data quality is improving or getting worse over time.