Skip to content

Troubleshoot the QuickBooks Online data sync integration

Last updated: August 22, 2024

Available with any of the following subscriptions, except where noted:

All products and plans

Review possible reasons why records aren't syncing between HubSpot and QuickBooks. 

Common errors

If you aren't seeing your invoice sync into QuickBooks Online within a few minutes, there are a number of reasons the sync could fail.

  • If any invoice fails to sync, a banner will display at the top of the invoices index page. Clicking Sync failure details will open the Failing to sync panel in the QuickBooks Integration settings.

invoices-sync-fail

  • You can also check if the invoice sync was successful by looking at the Integrations sync card on the invoice preview panel.

quickbooks-invoice-panel

quickbooks-example-sync-error

Below are some common errors that you may encounter, and how to resolve them.

An invoice should have an associated customer. Make sure the associated customer is present in both HubSpot & QuickBooks Online to sync this invoice

Occurs because the contact on the invoice not being found in QuickBooks Online when the invoice tried to sync. Most often, this is because the contact on the invoice doesn't share the email address of the customer in QuickBooks. If you change the contact on the invoice in HubSpot to the contact that matches the email of the customer in QuickBooks, the invoice will sync.

The display name is a duplicate

Display Name fields must be unique in Quickbooks Online. The first contact from a company will have its Display Name set to the company name, but any contacts from that company that try to sync to QuickBooks Online after the first contact will fail to sync, because their Display Name is already in use. Please refer to this article.

Business Validation Error: Enter a service date for the revenue recognition line item

This error may occur if you are using QuickBooks Online’s Revenue Recognition functionality. Revenue recognition requires all line items on an invoice to have a service date. It isn’t possible to add a service date to HubSpot line items, so it’s recommended to turn off the revenue recognition setting in QuickBooks, and doing revenue recognition reporting separately. 

Line item or invoice amount modifications in HubSpot native invoices cannot be made through external applications. Please make any necessary changes directly in HubSpot

Occurs because an invoice that was created in HubSpot was changed in QuickBooks Online. Reverse the changes to the invoice in QuickBooks, and make those adjustments to the invoice in HubSpot to continue syncing.

Duplicate Document Number Error : You must specify a different number. This number has already been used

Occurs when the integration tries to send an invoice into QuickBooks Online with an invoice number that's already used by another invoice or credit memo within QuickBooks. Most often, this occurs because you have the Custom Transaction Number setting turned on, which causes Quickbooks to adopt HubSpot's prefix and number automatically. To fix this error, it's recommended to update the numbers on the invoices or credit memos in QuickBooks Online to allow the HubSpot invoices to flow into QuickBooks, then turning the Custom Transaction Numbers setting off.

Line Item or Invoice Amount Modifications in HubSpot native invoices cannot be made through external applications. Please make any necessary changes directly in HubSpot

Indicates that an invoice that was created in HubSpot and synced to QuickBooks Online has had financial information (e.g., line items, tax) added, removed, or modified in QuickBooks. These changes can't be synced back into HubSpot, so the invoice sync is failing. To fix the error, revert the changes in QuickBooks. If you need to modify the financial details of a HubSpot invoice, it's recommended to make that change in HubSpot and then allowing it to sync to QuickBooks.

Was this article helpful?
This form is used for documentation feedback only. Learn how to get help with HubSpot.