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:
- Go to All apps, then Customer Hub, then Customers & leads, and select the Customers tab.
- Open the profile you don’t want to keep.
- Select the dropdown beside Edit and choose Merge contacts.
- Change the Display name so it exactly matches the profile you’re keeping. Intuit says: “The names must be identical.”
- 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?
| Option | Good for | Watch for |
|---|---|---|
| Do it yourself with the contact list export and Intuit’s merge steps | A few dozen clear pairs | No undo; one pair at a time; easy to merge the wrong direction |
| Buy a tool: a cleanup or matching app that connects to QuickBooks | Large lists, with your team approving each match | What it merges automatically and what it asks you about |
| Hire a freelancer or your bookkeeper | A one-off cleanup alongside the books | Who approves each pair before anything is merged |
| Bring in an outside team (Cleanups & bulk changes) | Large lists, or apps that keep creating duplicates | Needs 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
- Merge duplicate customers in QuickBooks Online, Intuit QuickBooks,
- Create a mailing list using the contact list report, Intuit QuickBooks,
- Set up and use Multicurrency, Intuit QuickBooks,
- Test drive and practice using QuickBooks Online, Intuit QuickBooks,
- Find and remove duplicates, Microsoft Support,