Merge Duplicate Vendors and Accounts in QuickBooks

Duplicate vendors, customers and chart of accounts entries are the most common mess in a QuickBooks file that has been through more than one person. You get "Amazon", "Amazon.com" and "AMZN Mktp US" as three separate vendors, or a "Bank Charges" expense account sitting next to "Bank Fees", and suddenly no report tells you the truth. The fix is the same in every case and it is not obvious, because QuickBooks does not put a merge command anywhere in the interface. You merge by renaming.

This guide covers vendors, customers and accounts, in both QuickBooks Online and QuickBooks Desktop, plus the specific conditions that make a merge fail and what to do about each one.

Why duplicates appear in the first place

Almost every duplicate has one of four sources. Knowing which one you have decides whether merging is a one time cleanup or something you will be doing again next quarter.

• Bank feed matching. The feed brings in a payee string straight from the bank, and if nothing matches, QuickBooks offers to create a new vendor with that raw string as the name. Accept it a few times on the same merchant and you have four versions of one vendor.
• Two people entering bills. One types "Home Depot", the other types "The Home Depot". Both are correct and QuickBooks keeps both.
• An import. CSV, IIF and QBO imports create list entries when the incoming name does not exactly match something already there. A single bulk import of a year of history can add dozens of near duplicate names in one pass.
• A chart of accounts that grew by accident. Someone needed an account, did not find the existing one, and made a new one with a slightly different name. This is why "Office Supplies" and "Office Expenses" both exist in half the files you will ever open.

The import case is worth pausing on, because it is the one you can prevent rather than repeat. When you bring historical transactions in from statements, the payee names in the file become the names in your list. Converting a PDF statement into a proper QBO file for QuickBooks before you import means the transactions arrive through the same For review queue as your bank feed, where your existing bank rules in QuickBooks Online can map raw payee strings onto vendors you already have. That is the difference between adding forty new vendors and adding none.

How do I merge vendors in QuickBooks Online?

Merging vendors in QuickBooks Online takes about thirty seconds once you know the trick. You need to be signed in with a role that can edit vendors, and you need to decide first which record survives, because everything on the other one goes away except its transactions.

1. Go to Expenses, then Vendors. Newer layouts put this under Sales and expenses or Vendors and expenses.
2. Open the vendor you want to keep. Copy its Display name as value exactly, including punctuation, spacing and capitalization. Copy and paste it rather than retyping, because a trailing space you cannot see will break the merge.
3. Go back to the list and open the duplicate, the one you want to lose.
4. Select Edit.
5. Paste the copied name into the duplicate's Display name as field, replacing what is there.
6. Select Save. QuickBooks warns you that the name is already in use and asks whether you want to merge. Confirm.

Every bill, expense, check and payment that pointed at the duplicate now points at the vendor you kept. The duplicate disappears from the list. Details that lived only on the duplicate, such as an address, an account number or a 1099 setting, are not carried across, so if the duplicate had the good contact details and the keeper did not, copy them over before you merge.

How do I merge customers in QuickBooks Online?

The process is identical, on a different list. Open Sales, then Customers, copy the display name of the customer you are keeping, open the duplicate, choose Edit, paste the name into Display name as, and save. Confirm the merge prompt.

One extra rule applies to customers that vendors do not have: sub-customers. If either record is a sub-customer of a parent, both records need to sit at the same level under the same parent before the merge will go through. A top level customer will not merge into a sub-customer, and a sub-customer of one parent will not merge into a sub-customer of a different parent. Move one of them first using the Is a sub-customer checkbox, save, then do the rename.

How do I merge accounts in QuickBooks Online?

Chart of accounts merges follow the same rename pattern but have stricter matching rules, and getting one wrong is the usual reason people conclude that QuickBooks "will not let me merge".

1. Select the gear icon, then Chart of accounts.
2. Find the account you are keeping and note its exact Account name, its Account type and its Detail type.
3. Find the duplicate, open the Action column dropdown, and choose Edit.
4. Set the duplicate's Account type and Detail type to match the keeper, then paste in the keeper's exact account name.
5. Select Save and confirm the merge prompt.

Before you start, run and export a profit and loss and a balance sheet, and save the reconciliation reports for any account with reconciliation history. Merging rewrites which account historical transactions sit in, so a prior period report can change, and you want a copy of the numbers as they were.

What stops a merge from working?

If the merge prompt never appears, one of these is almost always why.

How do I merge vendors in QuickBooks Desktop?

QuickBooks Desktop uses the same rename method, with two conditions that QuickBooks Online does not have.

1. Switch the company file to single user mode. Go to File, then Switch to Single-user Mode. Desktop will not merge list entries while other people are in the file.
2. Back up the company file. File, then Back Up Company, then Create Local Backup. A merge in Desktop is permanent and a backup is the only way back.
3. Open Vendors, then Vendor Center.
4. Right click the vendor you want to lose and choose Edit Vendor.
5. Change the Vendor Name field to exactly match the vendor you are keeping, and select OK.
6. QuickBooks asks whether you want to merge them. Choose Yes.

Two Desktop specific limits are worth knowing before you begin. Vendors assigned different currencies on a multicurrency file cannot be merged, because the currency is fixed on the record once it has been used. And you cannot merge a vendor that is also set up as an employee or an "other name" without moving the record onto the right list first, which Desktop only lets you do in one direction.

How to merge accounts in QuickBooks Desktop

Open Lists, then Chart of Accounts. Both accounts must be the same account type, and if either is a sub-account, both must sit under the same parent. Right click the account you are losing, choose Edit Account, change the Account Name to exactly match the account you are keeping, clear the Subaccount of box if the keeper is not a sub-account, and select Save and Close. Confirm the merge.

Customers merge the same way from the Customer Center, with the same single user mode requirement, and with the additional rule that a customer with jobs beneath it behaves like a parent account: move or merge the jobs first.

Does merging delete transactions in QuickBooks?

No. Merging moves every transaction from the record you are removing onto the record you keep. Nothing is deleted and no amounts change. What does disappear is the duplicate list entry itself and any details stored only on it, such as its address, phone number, tax ID, payment terms, default expense account or notes. Copy anything you need off the duplicate first.

There is one indirect effect worth watching. If the two records were used on reconciled transactions in different accounts, merging chart of accounts entries moves reconciled activity between accounts, and your reconciliation reports for prior periods will no longer tie back to the account they were run against. That is why exporting reconciliation reports before an account merge is not optional advice.

Can you undo a merge in QuickBooks?

No. There is no undo for a merge in either QuickBooks Online or QuickBooks Desktop. In Desktop you can restore the backup you made immediately before the merge, which is the whole reason for step two above. In QuickBooks Online there is no backup to restore unless you subscribe to the Online Backup feature or use a third party backup app, so the only recovery is to recreate the record manually and re-point transactions one by one. Treat every merge as permanent and merge the smaller record into the larger one.

Can you merge more than two records at once?

Not in a single action. QuickBooks merges two records at a time, so a vendor that exists five ways takes four merges. Do them in sequence into one chosen survivor rather than chaining them, and rename the survivor to the clean version of the name first so you are pasting the same string every time. If you are looking at hundreds of duplicates rather than dozens, that is a signal the problem is upstream in how transactions arrive, not in the list itself.

How do I stop duplicates coming back?

Merging is a cure, not a prevention. Three habits keep the list clean once you have cleaned it.

• Write bank rules for the payees that keep reappearing. A rule that maps every transaction containing "AMZN Mktp" onto your existing Amazon vendor stops QuickBooks offering to create a new one. Rules run against anything in the For review queue, including transactions you imported yourself.
• Agree a naming convention and write it down. Legal name or trading name, with or without "Inc", first initial or full first name for individuals. It does not matter which you pick, only that everyone picks the same one.
• Categorize on the way in, not later. Duplicates multiply fastest when a backlog of transactions gets accepted quickly to clear the queue. If you are catching up months of history at once, bring it in as a proper QuickBooks file and review it in batches, the way you would a normal week of bank feed activity.

The volume angle matters too. A business paying two hundred vendors a month accumulates duplicates faster than anyone can merge them by hand, and the same duplicate records that break your reports also cause duplicate payments. At that scale the answer is usually to automate the invoice to payment workflow so vendor records are matched once and reused, rather than merging the same names again every quarter.

Cleaning up a file you inherited

If you have just taken over a messy QuickBooks file, do the merges in this order. It saves rework, because merging accounts after you have fixed the vendors means re-checking nothing.

1. Export first. Profit and loss, balance sheet, and reconciliation reports for every bank and credit card account. Save them outside QuickBooks.
2. Chart of accounts. Merge the account level duplicates before anything else, because vendor and customer defaults point at accounts.
3. Vendors, then customers. Sort the list alphabetically and work down it; near duplicates almost always sit next to each other.
4. Fix the categorization. Once the lists are clean, deal with any uncategorized transactions in QuickBooks that were parked while the duplicates existed.
5. Fill the gaps in history. If the file is missing months because the bank feed only reaches back 90 days, you will need the statements. Our guide to how far back QuickBooks bank feeds go covers the limits, and a PDF bank statement to QuickBooks converter fills in the period the feed will not reach.

Done in that order, a file with a few hundred duplicate list entries is usually an afternoon of work rather than a week. The part that takes judgment is not the merging, it is deciding which name survives, and that decision is worth making once and documenting for whoever opens the file after you.