Merge customers in QuickBooks Desktop and merge vendors from one reviewed list

A QuickBooks Desktop file is often ten or fifteen years old. Over that time the same vendor gets added from a bill, again from a bank feed rule, again when someone types "Oakline Landscaping" on a check because "Oakline Landscaping LLC" did not come up in the dropdown fast enough. Customers pile up the same way from estimates, web store syncs and payment apps, and every one of those names is a separate record with its own balance and history.

Desktop also keeps one name list across customers, vendors, employees and other names, and a name can only be used once. A business that buys from you and sells to you ends up as "Delgado Electric" and "Delgado Electric (v)". Those two are not duplicates and should stay apart, which is exactly why a merge pass has to be read by a person and not run blind.

Vendors merge the same way. In the Vendor Center, copy the name to keep, edit the duplicate, paste the name and confirm the merge. On a Mac you can also select the vendor to remove and choose Edit, then Merge. In QuickBooks Desktop Accountant the Client Data Review tools include Merge Vendors, and in Enterprise it sits under Company, then Accounting Tools.

Intuit lists vendors that cannot be merged: tax authorities, tax exempt vendors, vendors paid through online banking and direct deposit vendors. A name with online information attached has to be disconnected from the bank first. Mark those rows in the exported file before you start, so the pass does not hand you a pair QuickBooks will refuse.

Not directly. QuickBooks Desktop will not merge a customer that has jobs, and it will not merge a job into another customer. Move the jobs first, or make the sub-customer a regular customer by clearing the sub-customer setting, then merge. If both duplicates carry jobs for the same project, decide which job list survives before you touch either record.

QuickBooks Desktop also merges only two names at a time. A supplier with four records takes three merges, which is why it pays to settle every group in a file before you open the first edit window.

No. Intuit states that a merge cannot be undone. The only way back is to restore the backup you made before merging, which also throws away every transaction entered since. That is the strongest reason to decide the pairs outside QuickBooks, on a list where a wrong match costs nothing, and to merge only what a person has approved.

The audit log from the pass helps if a merge is ever questioned. It shows the two rows, the reason they were matched and who approved them, which is the answer a reviewer or a client wants when a vendor history suddenly looks longer than it used to.

Open the Customer Center or the Vendor Center, open the Excel menu and choose Export Customer List or Export Vendor List, then pick a comma separated values file. That export carries names, company names, emails, phones, addresses and balances. If you need other columns, run Reports, then List, then Customer Contact List or Vendor Contact List, customize the columns and send it to Excel as a CSV.

Keep the headers plain, such as Vendor, Company Name, Main Email, State and Zip, and add a column for the vendors QuickBooks will not merge. Then load the file into the demo at the top of this page. Nothing uploads, the list is read and matched inside your browser tab.

Intuit stopped selling new QuickBooks Desktop Pro Plus, Premier Plus and Mac Plus subscriptions to new US customers after September 30, 2024, and many firms are now moving Desktop clients to QuickBooks Online or to another system. Any conversion copies the name list as it stands, so every duplicate in Desktop arrives as a duplicate on the other side, already attached to its transactions.

Merging in Desktop first is cheaper than merging after. Once the books are in QuickBooks Online, the same pass on the Online export is covered on QuickBooks Online merge vendors and customers. If the destination is NetSuite, the list cleanup is part of QuickBooks to NetSuite migration. Files coming the other way, from Sage 50 into QuickBooks, carry their duplicates in too, and that case is covered in Sage 50 to QuickBooks conversion.

Yes. QuickBooks Desktop totals 1099 payments per vendor record, so one contractor on two records gets two partial totals. For payments made in 2025 the 1099-NEC threshold is $600, and for payments made after December 31, 2025 it rises to $2,000 under Public Law 119-21. A designer paid $1,400 under "Kevin Brooks" and $900 under "Kevin Brooks Design" shows under the threshold twice while being paid $2,300.

The pass leaves a pair like that apart when the two records carry two different emails, because two emails can be two payees. Read those pairs yourself, and merge the ones that are one person before you run the 1099 wizard. That week before January 31 is the worst time to find the split.

The buyer is the bookkeeper or accounting firm that takes over an old Desktop file for a US client, the controller of a company running Enterprise with a vendor list nobody has cleaned in years, or the firm moving a Desktop client to a new system with a conversion date. They have a 1099 filing to get right or a migration to defend, and they need to show which records were merged and why.

A firm with many Desktop clients 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. It does not connect to your company file and writes nothing to it. You run every merge in QuickBooks Desktop yourself.