Field guide · Small business · QuickBooks Online

How to merge duplicate customers in QuickBooks Online safely

QuickBooks Online can merge two customer profiles into one. You change the duplicate’s display name to exactly match the profile you keep, and its transactions move across. Intuit’s own help page warns: “This action is permanent and can’t be undone.” So the safe way is to list every pair, rule out the ones that aren’t true duplicates, practice first, and merge one pair at a time.

Published · Get the PDF

Why do duplicate customers keep appearing?

  • Names get typed, not picked. Someone types “Acme Supply Co.” on an invoice instead of choosing “Acme Supply” from the list, and QuickBooks creates a new profile. The same happens when a new name is added while categorizing a bank transaction.
  • Apps create customers on their own. Store connectors, payment apps and invoicing tools can add a new customer when they don’t find a match.
  • Some “duplicates” are deliberate. Intuit’s multicurrency guide says “You can only assign one currency per customer or vendor profile” and “You need to create new profiles to assign a new currency.”

How do you merge duplicates yourself?

1. Export the list. Go to Reports, then Standard reports. In Find report by name, select Customer Contact List. Use Columns to choose and order the fields you want (email, phone and billing address are the useful ones), then select Export/Print and Export to Excel.

2. Find likely pairs. In Excel, add a column with a cleaned-up name: lowercase, no punctuation, no “Inc,” “LLC” or “Co.” Sort by it. Then highlight repeats in the cleaned name, email and phone columns with Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values. Rows that match on two of the three are your strongest candidates. Highlight, don’t delete: Microsoft’s own page notes that Excel’s Remove Duplicates permanently deletes data.

3. Rule out the false pairs.

  • Do the two profiles use different currencies? Leave them apart.
  • Are they really separate businesses or separately billed locations? Ask whoever handles that account.
  • Does either one have sub-customers or projects? Intuit says: “Check that neither customer has sub-customers before you merge them.” Sub-customers include linked projects, so Intuit’s page means those have to be dealt with first.

4. Choose the profile to keep. Usually the one with the correct legal name, the most history, and any connection to your payment or store apps. Write the merge list: the profile you keep, the one you remove, and the reason.

5. Note the balances. Write down both profiles’ open balances. After the merge, the kept profile should show their sum.

6. Copy what you need from the duplicate. Intuit says data from the duplicate moves into the profile you keep, but check for yourself. Copy any extra email address, notes or tax-exemption details onto the profile you keep, and confirm afterward that they’re there.

7. Practice once in the sample company. Intuit’s test drive company, Craig’s Design and Landscaping Services, lets you try the steps without touching your books. Intuit says the demo “doesn’t save any changes you make.”

8. Merge one pair. Intuit’s current steps are:

  1. Go to All apps, then Customer Hub, then Customers & leads, and select the Customers tab.
  2. Open the profile you don’t want to keep.
  3. Select the dropdown beside Edit and choose Merge contacts.
  4. Change the Display name so it exactly matches the profile you’re keeping. Intuit says: “The names must be identical.”
  5. Select Save, then confirm with Yes.

Intuit says the removed profile is saved as inactive and its transactions are added to the kept profile’s history. Reactivating it later doesn’t bring that history back.

9. Check and log. Open the kept profile, confirm the balance matches your note from step 5, and scan the transaction list. For a customer with three versions, repeat the steps for the second pair.

Merging moves transactions to a different customer, which changes customer reports for past periods. If those periods are closed or reviewed, ask your accountant before merging.

What are your options?

OptionGood forWatch for
Do it yourself with the contact list export and Intuit’s merge stepsA few dozen clear pairsNo undo; one pair at a time; easy to merge the wrong direction
Buy a tool: a cleanup or matching app that connects to QuickBooksLarge lists, with your team approving each matchWhat it merges automatically and what it asks you about
Hire a freelancer or your bookkeeperA one-off cleanup alongside the booksWho approves each pair before anything is merged
Bring in an outside team (Cleanups & bulk changes)Large lists, or apps that keep creating duplicatesNeeds read access and time with whoever knows the accounts

FAQ

Can I undo a customer merge in QuickBooks Online? No. Intuit says the merge “is permanent and can’t be undone.” The removed profile is saved as inactive, and reactivating it doesn’t restore its transactions.

Which name do I change, the one I keep or the one I remove? Open the profile you don’t want to keep and change its display name to exactly match the one you keep. Its transactions move into the profile you keep.

Can I merge three customers at once? Intuit’s steps merge one profile into another. For three versions, merge the second into the first, then the third into the first.

Can I merge customers that have sub-customers or projects? Not as they are. Intuit says to check that neither customer has sub-customers before you merge, and its page counts projects linked to the customer as sub-customers, so remove those first.

Should I merge a customer I bill in two currencies? No. QuickBooks Online allows one currency per customer profile, so the second profile is there on purpose.

Sources

Have one problem in mind?

Walk us through it on a free 30-minute call. Within two business days you get a one-page note on what we’d fix first, yours to keep.

Walk us through one problemFree 30-minute call.