CRM wants pipeline speed. Finance wants clean books. Sync everything both ways and you’ll fight duplicates, wrong invoices, and “which system is right?” meetings. This guide is about choosing direction and ownership before writing the first mapping.
1. Name the system of record per object
Every object gets one writer of truth. Everything else is a consumer — or a carefully designed handoff.
- Contacts / companies — usually CRM (sales owns relationship data)
- Invoices / payments / chart of accounts — finance / ERP
- Products & SKUs — often ERP or a commerce system; CRM mirrors sellable subset
- Deal stage / amount — CRM until closed-won; finance owns what was invoiced
2. Prefer handoffs over continuous mirrors
Most teams don’t need every CRM tweak mirrored into ERP. They need a clear moment: “this deal is ready to bill.”
- Trigger invoice creation on closed-won (or approved quote) — not on every amount edit
- Push customer create/update to ERP only when billing starts
- Pull payment status back to CRM for CS visibility — read-only in HubSpot
- Never let reps edit invoiced amounts in CRM after ERP has billed
3. Map IDs early
- Store ERP customer ID on the HubSpot company
- Store HubSpot deal ID on the invoice/order for support lookups
- Use a stable external key (email + company domain) only as a fallback match
- Log failed matches — don’t silently create a second customer
4. Handle failures like finance cares
- Idempotent creates — same won deal doesn’t spawn three invoices
- Dead-letter queue + alert when a handoff fails
- Human fallback: ops checklist to create the invoice manually
- Reconcile weekly: closed-won without invoice, invoice without deal
5. Pattern cheat sheet
- Simple SaaS — HubSpot → Stripe/billing; light ERP or none
- Services firm — HubSpot deal → project + invoice in finance tool
- Product company — CRM for pipeline; ERP for inventory and fulfillment; sync status only
- Multi-entity — route by subsidiary before creating the invoice
Get the ownership map right and the integration stays boring — which is exactly what finance wants.