Improved Customer Mapping for QBO & Xero
Friday, October 16, 2026
What it is
Customer mapping creates a reliable, lasting connection between HubSpot contacts and companies and the customers in QuickBooks Online and Xero, so invoices and payments sync to the right customer even when names or emails change. You choose how records map, review and confirm the matches, and manage them from one place. The public beta works for inbound, outbound and bidirectional syncs and for B2B and B2C billing; once mapping is set up, contact sync is turned off and hidden because the mappings now decide where invoices and payments go. Last updated September 24, 2026.
Why it matters
When the sync matches on email or name, everyday changes break it: a customer updates their email, a contact has no email, someone new is added, and invoices sync to the wrong place, create duplicate customers or fail. Mapping on stable record IDs holds when details change, so you can bill any contact at a company and the invoice lands on the right customer in the accounting system.
The Take
These record IDs are the only way to successfully create the flexibility you need to sometimes connect to a contact, sometimes connect to a company.
Casey brought this one forward because she ran into it last week, and her client is the case study. Invoices kept arriving in QuickBooks without the billing contact, because the contact was not sent over until it was associated with an invoice, and the invoice got created first. Send all the contacts instead, and QuickBooks has one billing contact field and no idea which of ten people it should be. For that customer this was the solve that had been months in the making. Years, really.
Here is why it keeps happening. HubSpot exists to communicate with humans who can be identified by an email address, so email is the unique ID, and every import and integration dedupes on it. No other system works like that. They all have their own record IDs, numbers that mean nothing outside that system, and they are built around accounts, opportunities and invoices, not the humans. QuickBooks taught the market that you can have one billing contact, from a world where invoices went in the mail and the PO box mattered more than the email. So ten associated contacts who should all get the invoice does not integrate well with a data model that does not care about contacts; you get a notes field full of names and someone copying everybody in by hand.
Then the language problem. HubSpot has contact and company. Everything else has customer, and the customer could be either thing. Guess what does not work if that is the case: an email address. Record IDs are the only way to create the flexibility to sometimes connect to a contact and sometimes to a company, which is also why a unified customer view and a unified revenue view are easier to build in HubSpot than in systems that start from an ambiguous word like customer. When you integrate, what is a customer is almost always the first point of friction, and everyone thinks it should be obvious. Talk it through first and you do not run into it later.
Even if you never touch QuickBooks or Xero, notice the direction: the data sync settings you use for other systems are turning into this kind of mapping. There is rarely a property that handles it for you; you define the rules. Who should act: anyone with the QuickBooks Online or Xero integration and a billing-contact problem, now. Who should watch: anyone syncing a system that calls your contacts and companies customers.
Watch Us Discuss This
The full segment from the show, us working through this update start to finish.
FAQ
What does customer mapping change?
Per HubSpot, mappings between HubSpot contacts or companies and QuickBooks Online or Xero customers are stable connections you choose, review and manage in one place, instead of a match on email or name that breaks when details change.
Does it work for my sync direction and business type?
The public beta covers inbound, outbound and bidirectional syncs and both B2B and B2C billing, so it fits whether you bill companies, people or both.
What happens to contact sync?
Once mapping is set up, contact sync is turned off and hidden; the mappings decide where invoices and payments go, so contact sync cannot route data to the wrong customer.
Why did invoices miss the billing contact before?
Casey Hawkins's client case: contacts were only sent to QuickBooks once associated with an invoice, and the invoice was created first, so they never connected; sending every contact instead left QuickBooks unable to pick the one billing contact.
Produced by Value-First Media
