Why Reimporting Customers into QuickBooks Online Creates Duplicates

What the native import actually does

QuickBooks Online's built-in Import Data tool, under the gear icon, covers four list types: Chart of Accounts, Customers, Vendors, and Products and Services. Customers is on that list, so a first-time upload works fine. The problem shows up on the second pass. Intuit's own support documentation is explicit that imported contacts won't overwrite existing entries, so a corrected or updated CSV doesn't find and refresh the customer it matches, it creates a new one alongside it.

The reimport trap

The usual failure mode: someone imports a customer list, spots a few wrong emails or addresses, fixes them in the spreadsheet, and reimports the same file expecting the corrections to land. Instead, QuickBooks Online now has two customer records for every row that was already there, one old and one new, and the old one is still active. Intuit's guidance for this exact situation is to make the previously imported customers inactive, or edit each one by hand, before reimporting corrected data. Neither step happens automatically. If a company file has been growing this way for a while, the customer list itself becomes the mess that needs cleaning up before any report against it is trustworthy.

What to check before you push a customer list

• Decide up front whether this run is a first-time load or a correction to something already in QuickBooks. The native Import Data tool doesn't tell the difference for you, and it has no ID-based update mode to catch it either.
• If it's a correction, inactivate or manually edit the customers being replaced before reimporting, per Intuit's own guidance above. Matching a corrected row to the right existing customer by internal ID is only possible through the QuickBooks API, not the native importer, which is what a validated bulk-import tool is doing behind the scenes.
• After the import, spot-check for customers that look like near-duplicates, same name with a trailing space, a slightly different email, before invoices or bills start posting against the wrong one.

Where this fits with invoices

A duplicate customer record doesn't just clutter the list, it splits transaction history: invoices posted against the duplicate won't show up on the original customer's balance or payment history, since QuickBooks Online treats the two records as unrelated customers. Bills carry the analogous risk on the vendor side, a duplicated vendor record splits payment history the same way a duplicated customer splits invoice history, even though bills themselves are posted against vendors, not customers. See bulk importing bills into QuickBooks Online and bulk importing invoices into QuickBooks Online for the same live-record validation this problem calls for, and the QuickBooks import validation checklist for the full row-level reference.