How Do You Merge Duplicate Vendors in QuickBooks Online?

To merge duplicate vendors in QuickBooks Online, open the vendor you want to keep and copy its exact company and display name, then edit the duplicate and change its names to match exactly, and save. QuickBooks recognises the identical names and combines the two, moving all past transactions from the duplicate into the vendor you kept.

There's no dedicated merge button in QuickBooks Online. You merge by matching names, which is why the exact spelling matters.

This guide walks through the exact steps, plus the things that trip people up: the merge is permanent, there's a four-vendor limit, a password prompt can appear, and 1099 history needs a second look.

Key takeaways

• QuickBooks Online has no merge button; you merge by renaming the duplicate to exactly match the one you're keeping.
• Merging is permanent and cannot be undone, so decide carefully which profile to keep.
• QuickBooks Online merges up to four vendors at a time.
• If a closing-date password is set, QuickBooks may ask for it before it lets you merge.
• Check 1099 history and vendor details after merging, since some information doesn't carry over cleanly.

Why duplicate vendors happen

Duplicate vendors are one of the most common messes in a QuickBooks file, and they rarely come from carelessness. They accumulate quietly as a business grows.

The usual cause is small name variations. "Amazon", "Amazon.com", and "Amazon Web Services" become three separate vendors when they should be one or clearly distinct. Bank feeds create their own duplicates when an auto-added payee doesn't match an existing vendor name.

Imported data is another source. Migrating from another system or importing transactions often creates new vendor records that overlap with ones already in the file. However they appear, duplicates split a single vendor's history across multiple profiles, which makes reports and accounts payable harder to trust.

Before you merge: decide what to keep.

Because merging is permanent, the first step happens before you touch anything. You have to decide which vendor profile becomes the survivor.

Pick the profile with the most complete and correct information: the right legal name, address, tax ID, and payment details. This is the record that stays, so it should be the clean one. The duplicate's transactions will move into it, but the duplicate's profile details will not.

Take a moment to note anything on the duplicate that the survivor is missing, such as a tax ID or a mailing address. You'll want to copy that information into the survivor either before or after the merge, since it won't transfer automatically.

How to merge vendors in QuickBooks Online

The process is a rename trick rather than a merge tool. Follow these steps in order.

1. Go to your vendor list. Select Expenses, then Vendors, to open the full list of vendor profiles.
2. Open the vendor you're keeping. Find and open the profile you want to survive, then select Edit.
3. Copy its exact names. Note the Company name and Display name precisely, including spelling, spacing, and punctuation. Copy them so you can match them exactly.
4. Open the duplicate. Go back to the vendor list, open the profile you want to remove, and select Edit.
5. Match the names exactly. Change the duplicate's Company name and Display name to match the survivor's exactly. Any difference, even a space, stops the merge.
6. Save and confirm. Select Save, then Yes when QuickBooks asks you to confirm. QuickBooks combines the two.

Once done, QuickBooks moves all past transactions from the duplicate into the vendor you kept, and marks the duplicate as deleted or inactive. Your vendor list now shows a single, consolidated profile. Intuit's official documentation mirrors these steps.

The permanent-merge warning

This is the part to take seriously. Merging vendors in QuickBooks Online cannot be undone. There's no button to split them back apart once combined.

If you merge the wrong pair, or keep the wrong profile, your only recovery is manual: recreating the vendor and reassigning transactions one by one, which is slow and error-prone. That's why the "decide what to keep" step matters so much.

For a large cleanup, consider exporting your vendor list first as a reference. If something looks wrong after a merge, you'll at least have a record of what the profiles looked like before.

When in doubt on a complex file, do the cleanup alongside a proper accounting cleanup rather than merging in a rush.

The four-vendor limit

QuickBooks Online only lets you merge up to four vendors at a time. If you have five or more duplicates of the same vendor, you merge them in batches.

In practice, this means picking your survivor, merging three duplicates into it, then merging the next batch. It's a minor limit, but it surprises people cleaning up a badly duplicated file who expect to consolidate a dozen entries in one move.

For files with widespread duplication, work through them systematically, one vendor group at a time, rather than trying to fix everything at once. Rushing a big vendor cleanup is how the wrong profiles get merged.

The closing-date password prompt

A common blocker is QuickBooks asking for a password when you try to merge. This confuses people who don't remember setting one, and it has a specific cause.

If your company file has a closing date with a password set, QuickBooks may require that closing-date password before it lets you merge vendors, because merging can affect transactions in a closed period. This is a protection, not a bug.

To find the password, check your account settings under the advanced or closing-date section, where the closing date and its password are configured. Enter that password when prompted, and the merge proceeds. If you don't know it, whoever set your closing date, often your accountant, will have it.

What happens to 1099 history?

This is the detail most guides skip, and it matters at tax time. When you merge vendors, transaction history moves to the survivor, but you should verify your 1099 tracking afterward.

Confirm that the surviving vendor is still correctly flagged for 1099 tracking if it should be and that the tax ID on the survivor is the correct one.

A merge that keeps the wrong profile can leave you with a vendor missing its tax ID or 1099 status, which causes problems when you prepare 1099 filings.

After any vendor merge involving a 1099 contractor, review the vendor's details and the year's 1099 report to make sure payments are attributed correctly. Catching this in a cleanup is far easier than discovering it during filing season.

Verifying the merge worked

Don't consider the job done the moment the profiles combine. A quick check confirms nothing was lost.

Return to the vendor list and confirm the duplicate is gone and only the survivor remains. Open the survivor and review its transaction history to make sure the duplicate's transactions came across. Check that the profile details, address, tax ID, and 1099 status, are still correct, and add anything the merge dropped.

This verification takes a minute and saves the headache of discovering a problem weeks later during reconciliation or reporting. Clean vendor records are part of what makes a month-end close fast, because reports pull from single, accurate profiles rather than scattered duplicates.

Preventing duplicate vendors

The best cleanup is the one you don't have to do. A few habits keep duplicates from piling up again.

Use a consistent naming convention for vendors, and search the existing list before creating a new profile. Most duplicates come from someone adding a vendor that already exists under a slightly different name. When you add vendors from the bank feed, match them to existing profiles rather than letting QuickBooks create new ones.

For firms managing many client files, duplicate vendors are a recurring cleanup task that eats time across every book. Automation that categorises transactions and matches payees consistently reduces how often duplicates appear in the first place. Finlens keeps categorisation consistent across the file, so vendor records stay cleaner and cleanups get smaller.

Conclusion

Merging duplicate vendors in QuickBooks Online is simple once you know it's a rename trick, not a merge button. Copy the exact company and display name of the vendor you're keeping, paste them onto the duplicate, save, and QuickBooks combines the two, moving all past transactions to the survivor.

The care goes into the details around it. The merge is permanent, so choose the survivor deliberately and keep the profile with the cleanest information. You can only merge four at a time, so large cleanups happen in batches.

A closing-date password prompt can appear, and it just needs the password your accountant set. And 1099 history deserves a second look, since a merge can leave a contractor's profile missing its tax ID or 1099 flag.

Do the cleanup carefully and verify it afterward, and your vendor list becomes a single accurate record for each supplier instead of a scattered mess. Then keep it that way by naming vendors consistently and matching bank-feed payees to existing profiles.

Clean vendor records make reports trustworthy, tax season smoother, and every future close a little faster, which is the whole point of doing the cleanup in the first place.

Frequently asked questions

How do I merge two vendors in QuickBooks Online?

Open the vendor you want to keep and note its exact company and display name. Then open the duplicate, edit it, and change its company and display name to match the survivor exactly. Save and confirm. QuickBooks combines the two and moves the duplicate's transactions to the vendor you kept.

Can you undo a vendor merge in QuickBooks Online?

No. Merging vendors is permanent and cannot be undone. If you merge the wrong profiles, the only fix is to recreate the vendor manually and reassign transactions one by one. This is why choosing the correct survivor before merging is so important.

How many vendors can you merge at once in QuickBooks Online?

QuickBooks Online lets you merge up to four vendors at a time. If you have more than four duplicates of the same vendor, you merge them in batches, consolidating a few into the survivor, then repeating for the next group until only one profile remains.

Why does QuickBooks ask for a password when I merge vendors?

If your file has a closing date with a password set, QuickBooks requires that closing-date password before merging, since a merge can affect transactions in a closed period. Find the password in your closing-date settings, or ask whoever set your closing date, often your accountant, for it.

Does merging vendors move all the transactions?

Yes. When you merge, QuickBooks moves all past transactions from the duplicate into the vendor you keep. The transaction history consolidates under the survivor. What doesn't carry over automatically is the duplicate's profile details, like a tax ID or address, so copy anything important beforehand.

What happens to 1099 information when I merge vendors?

Transactions move to the survivor, but you should verify the 1099 setup afterward. Confirm the surviving vendor is still flagged for 1099 tracking if needed and has the correct tax ID. A merge that keeps the wrong profile can drop that information, which causes problems at filing time.

How do I find duplicate vendors in QuickBooks Online?

Go to Expenses, then Vendors, and scan the list for similar names, such as a company listed with and without ".com" or with slight spelling differences. Use the search bar to check for variations of a vendor name. Sorting the list alphabetically makes near-duplicates easier to spot.

How do I stop duplicate vendors from being created?

Use a consistent naming convention and search your vendor list before adding a new profile. When adding vendors from the bank feed, match them to existing vendors instead of letting QuickBooks create new ones. Consistent categorisation across the file keeps payees mapped to single, correct profiles.