Use these data-model references to describe the records your connection needs. They are planning examples; connector availability and supported operations must be established before implementation.
Download the mapping worksheet · CSV, no email required
Customer identity
Company / Customers
Before linking HubSpot Company to Sage Intacct Customers, check whether the customer is an individual or a company. Match the correct record type in each system.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- HubSpot
- Documented record · ✅ Supported
- Sage Intacct
- Object support to establish
- Record identity
- Determine whether each customer represents an individual, a company, or a business-unit relationship before matching it to a contact or organization. Retain the source customer ID and destination ID; names and email alone are insufficient.
- Field ownership
- Separate the customer relationship from contact details, billing authority, and consent. Choose an owner for each field after identifying whether the customer is a person or company.
Fields to include
- Source customer ID
- Person/company classification
- Legal entity or business unit
- Destination identity reference
- Record dependencies
- Resolve person or company type, legal entity, business role, and any billing account before transactions.
- Validation
- Test an individual buyer, a company buyer, and one company with multiple billing relationships. Do not merge these into a single generic contact.
- Recovery
- Hold ambiguous customer matches for review and resolve customer type before retrying dependent records.
References: HubSpot: Company documentation
Customer identity
Contact / Customers
Before linking HubSpot Contact to Sage Intacct Customers, check whether the customer is an individual or a company. Match the correct record type in each system.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- HubSpot
- Documented record · ✅ Supported
- Sage Intacct
- Object support to establish
- Record identity
- Determine whether each customer represents an individual, a company, or a business-unit relationship before matching it to a contact or organization. Retain the source customer ID and destination ID; names and email alone are insufficient.
- Field ownership
- Separate the customer relationship from contact details, billing authority, and consent. Choose an owner for each field after identifying whether the customer is a person or company.
Fields to include
- Source customer ID
- Person/company classification
- Legal entity or business unit
- Destination identity reference
- Record dependencies
- Resolve person or company type, legal entity, business role, and any billing account before transactions.
- Validation
- Test an individual buyer, a company buyer, and one company with multiple billing relationships. Do not merge these into a single generic contact.
- Recovery
- Hold ambiguous customer matches for review and resolve customer type before retrying dependent records.
References: HubSpot: Contact documentation
Record matching
Invoices / AR Invoices
Compare whether HubSpot Invoices and Sage Intacct AR Invoices describe the same customer invoice in your business.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- HubSpot
- Documented record · ✅ Supported
- Sage Intacct
- Object support to establish
- Record identity
- Retain the invoice ID, issuer/legal entity, and original order reference; invoice numbers alone may overlap.
- Field ownership
- The financial system owns posting and accounting treatment. A posted invoice may need a credit or adjustment process instead of an overwrite.
Fields to include
- Source invoice ID
- Customer or supplier reference
- Line totals
- Currency
- Posting/payment status
- Record dependencies
- Resolve the customer or supplier, account codes, tax, currency, and accounting period before posting.
- Validation
- Test a posted invoice, a partial payment, tax rounding, and a closed accounting period. Compare financial totals within the same entity and currency.
- Recovery
- Determine whether a transaction posted before retrying. Follow the approved adjustment process for posted records.
References: HubSpot: Invoices documentation
Record matching
Commerce Payments / Payments
Compare whether HubSpot Commerce Payments and Sage Intacct Payments describe the same payment or settlement in your business.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- HubSpot
- Documented record · ✅ Supported
- Sage Intacct
- Object support to establish
- Record identity
- Preserve transaction ID, provider/source, currency, and links to invoices; one payment may settle several documents.
- Field ownership
- Keep payment authorization, settlement, and accounting allocation distinct.
Fields to include
- Source transaction ID
- Invoice references
- Amount and currency
- Settlement status
- Reversal reference
- Record dependencies
- Resolve the affected invoices and cash/account references before allocating the payment.
- Validation
- Test partial payment, one-to-many allocation, refund, and repeated delivery of the same transaction.
- Recovery
- Look up the original transaction before retrying to prevent duplicate allocation or charging.
References: HubSpot: Commerce Payments documentation
Business process
Users / Employees
Approved worker-to-account handoff: Sage Intacct Employees provides context for HubSpot Users. These are related records, not equivalent entities.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- HubSpot
- Documented record · ✅ Supported
- Sage Intacct
- Object support to establish
- Record identity
- Link the employment/person identity to the directory tenant and user ID; support rehires without creating duplicate accounts.
- Field ownership
- HR effective dates and access-owner approval govern provisioning or deactivation; a record update alone is not an access authorization.
Fields to include
- Source record reference
- Destination record reference
- Approved handoff state
- Duplicate-detection key
- Record dependencies
- Resolve organization, position, manager, and effective-date context before dependent changes.
- Validation
- Test a future-dated joiner, a mover, and a leaver with protected-account exceptions before applying access changes.
- Recovery
- Reconcile effective dates before applying a delayed change; route ambiguous termination or access changes for review.
References: HubSpot: Users documentation