If HubSpot invoices are failing to sync into QuickBooks Online with a "Duplicate Document Number Error: You must specify a different number. This number has already been used," the usual cause is QuickBooks' Custom Transaction Numbers setting. When it is turned on, QuickBooks adopts HubSpot's invoice prefix and number automatically, and collisions follow. The fix has two parts: update the conflicting invoice or credit memo numbers inside QuickBooks Online so the HubSpot invoices can sync, then turn Custom Transaction Numbers off so it stops happening. This is one of the first settings Vantage Point's integration team checks on any HubSpot–QuickBooks rollout.
HubSpot's QuickBooks Online integration creates invoices in HubSpot and syncs them into QuickBooks. Every document that lands in QuickBooks needs a unique document number. When the integration tries to create an invoice whose number already exists on another invoice or credit memo in QuickBooks, QuickBooks rejects it, and HubSpot surfaces the failure as the duplicate document number error.
The reason this happens so often is a QuickBooks setting rather than a HubSpot bug. With Custom Transaction Numbers enabled in QuickBooks Online, QuickBooks adopts the invoice prefix and number that HubSpot sends — including on documents created or edited directly in QuickBooks. Once the two systems are independently assigning the same numbers, collisions are a matter of time. HubSpot's integration documentation recommends turning the setting off before using the integration for exactly this reason.
Start in HubSpot. If any invoice fails to sync, a banner appears at the top of the invoices index page; clicking Sync failure details opens the Failing to sync panel in the QuickBooks integration settings. You can also see sync failures on the integration's settings page under sync statuses, and on the individual invoice via the Integrations sync card in the preview panel. List every failing invoice before changing anything — renumbering one document while others are still failing just moves the problem.
In QuickBooks Online, find the invoices or credit memos whose numbers collide with the HubSpot invoices and change those numbers to free values. HubSpot's guidance is explicit: update the numbers on the existing QuickBooks documents so the HubSpot invoices can sync in. Do not rename the HubSpot side — HubSpot-generated invoices are the source of truth for this sync direction, and their financial details cannot be modified from QuickBooks.
Once the numbers are free, the queued invoices sync into QuickBooks. Verify each one landed correctly — line items, customer association, and amounts — before moving on.
With the backlog cleared, open QuickBooks Online's sales settings and turn Custom Transaction Numbers off. From then on, QuickBooks assigns its own document numbers to anything created natively, and the HubSpot-supplied numbers stop colliding with them. This is the permanent fix; skipping it means repeating this cleanup every billing cycle.
While you are in the sync panel, it is worth clearing the other common failures HubSpot documents, because they tend to travel together on a new integration:
The pattern across all four is the same as the numbering issue: one system has to own each decision. HubSpot owns the invoice; QuickBooks owns the general ledger. Teams that blur that line — editing in both places, numbering in both places — generate most of their own sync errors.
Before the first invoice syncs, confirm Custom Transaction Numbers is off in QuickBooks and record which system's numbering scheme your finance team will reference in collections and reporting. If you are migrating historical invoices, reconcile number ranges between the two systems as part of the migration plan, not after the first failure.
Because customer matching keys on email address, a clean contact database is a prerequisite for a clean invoice sync. Deduplicate contacts and align email addresses between the systems before enabling invoice sync — the same discipline we apply in any CRM integration audit.
New integrations fail in new ways for the first few weeks. A weekly check of the QuickBooks integration settings page — where all sync failures are listed — catches numbering, customer-matching, and editing conflicts while they are still a handful of invoices instead of a quarter-end backlog.
Finance-system integrations fail quietly until someone reconciles the books. We design and support HubSpot–QuickBooks rollouts end to end: numbering and matching rules, migration of open invoices, sync monitoring, and the documentation your finance team needs at close. Our HubSpot practice and integration specialists handle these implementations routinely — including the cleanup when a DIY connection has drifted.
We will clear the sync backlog, fix the numbering and customer-matching rules causing it, and leave your team with a monitoring routine that keeps it clean.
QuickBooks Online already contains an invoice or credit memo using the number HubSpot is trying to sync. Most often this happens because QuickBooks' Custom Transaction Numbers setting is on, which causes QuickBooks to adopt HubSpot's invoice prefix and numbering on documents created or edited natively — until the two systems collide.
Update the numbers on the conflicting invoices or credit memos directly in QuickBooks Online so the HubSpot numbers are free, allow the sync to complete, then turn Custom Transaction Numbers off in QuickBooks to prevent recurrence. Fix the data first — disabling the setting alone does not clear already-failed invoices.
A banner at the top of the HubSpot invoices index page opens the Failing to sync panel in the QuickBooks integration settings. The integration settings page lists all sync failures, including invoices, and an individual invoice shows its sync status on the Integrations sync card in the preview panel.
Only limited fields. Adding or removing line items, changing pricing, removing payments, or adding tax on the QuickBooks side breaks the sync for that invoice. Make financial edits in HubSpot and let them sync to QuickBooks; if a change was already made in QuickBooks, reverse it there and redo it in HubSpot.
The integration matches the HubSpot contact on the invoice to a QuickBooks customer by email address. If no QuickBooks customer shares that email, the invoice fails with an associated-customer error. Point the invoice at the contact whose email matches the QuickBooks customer record.
Not if you are using the HubSpot integration to create invoices. HubSpot recommends turning the setting off before using the integration. If your accounting process genuinely requires manual numbering in QuickBooks, reconcile the two numbering schemes deliberately — and expect to manage collisions as an ongoing cost of that design.
Vantage Point is a boutique CRM consulting firm helping businesses transform with Salesforce, HubSpot, and AI. Learn more at vantagepoint.io.