QuickBooks Online merge vendors and merge customers from one reviewed list

QuickBooks Online identifies a vendor by its display name, and display names have to be unique across the customer, vendor and employee lists. Anything that is not the identical name is a new record. So "Rivera Plumbing LLC" from a bill entered by hand, "Rivera Plumbing" created by a bank feed rule, and "Rivera Plumbing (v)" added because the same business is also a customer are three vendors from the first day.

Bank feeds, receipt capture apps, bill pay integrations and imports from older systems each create vendors in their own spelling. Bookkeepers who take over a file mid year usually inherit a vendor list where the same supplier appears two or three times, with payments spread across all of them.

Yes. QuickBooks totals 1099 payments per vendor record, so a contractor split across two records gets two partial totals, and either half can fall under the filing threshold while the real total does not. For payments made in 2025 the 1099-NEC threshold is $600. For payments made after December 31, 2025 it rises to $2,000 under Public Law 119-21, and from 2027 it is adjusted for inflation.

Picture a designer paid $1,500 under "Maria Lopez" and $1,200 under "Maria Lopez Design". Neither record reaches $2,000, so neither shows up for a 1099, while the person received $2,700. Merging before you run the 1099 wizard puts the payments back on one record. The same split also puts two W-9s, two addresses and two tax IDs on file for one payee, which is the next thing a reviewer asks about.

Open the customer profile you want to remove from the Customers tab, open the dropdown next to Edit and choose Merge contacts, then confirm the customer to keep. Before that, check that neither customer has sub-customers or projects. Intuit asks you to turn sub-customers into regular customers first, or the merge will not go through.

All data from the duplicate moves to the customer you keep, and the duplicate becomes inactive with an empty transaction history. Customer duplicates usually come from online store and payment integrations, where one buyer checks out under a second email, so the email match in the file finds most of them in one pass.

No. Intuit states that merging customers is permanent and cannot be undone, and that a merged vendor has to be recreated by hand if you need it back. The transactions that moved stay on the record you kept. That is the reason to settle the pairs in a file first, where a wrong match costs nothing, rather than deciding inside QuickBooks one merge at a time.

A reviewed list also protects the vendors you should not touch. Do not merge a vendor that is a tax agency, a payroll or direct deposit payee, or one paid through a connected bill pay service, until you have checked how that connection identifies the vendor. Mark those rows in the file and skip them.

The busiest week is the one before 1099s are due, January 31 for the 1099-NEC, and that is the worst week to find out the list is split. Running the pass in November or December leaves time to chase missing W-9s for the merged vendors and to check the totals against the bank.

The other good moment is a system change. If the books are moving off QuickBooks, merge the list before the export rather than after, because the new system will import every duplicate exactly as it finds it. The QuickBooks to NetSuite migration guide covers that move, and the vendor master data cleansing guide covers the same work on a larger vendor master. If the move is to Xero, the customer and vendor pairs that become two Xero contacts are covered in QuickBooks to Xero migration, and a file still on Desktop is handled on merge customers in QuickBooks Desktop.

The buyer is the bookkeeper or accounting firm that runs QuickBooks Online for US small business clients, or the controller of a company that has outgrown its own vendor list. They have a 1099 filing to get right, a new client file to take over, or a migration date, and they need to show which records were merged and why.

A firm with many client files gets the most from it, because the same pass runs on each client export in a few minutes. DataUntangler is a data cleaning tool on the Analyst plan at 59 dollars a month, or 348 dollars a year, with unlimited files.

DataUntangler does not connect to your QuickBooks Online company and does not merge anything there. It works on the exported list, in your browser, and returns the pairs, the cleaned file and the audit log. You run each merge in QuickBooks with Merge contacts, which keeps the decision with the person responsible for the books.

It also does not file 1099s or collect W-9s. If you need to bring in bank history from a CSV rather than a bank feed, or to load a cleaned customer list back in, those are separate steps in QuickBooks. If the next job is a NetSuite import of the same list, the file side is on NetSuite CSV import.