Try for freeTry free
Getting started

Duplicate Clients in CRM: How to Find and Merge Them

Ivan Kancyr7 min read

A client called from a different number, left a request on your website, and a second sales rep added them all over again — now the CRM has two cards. Deals are scattered, the call history is split, and reports count one client twice. Let's look at how emyCRM keeps duplicates from appearing and how to merge them if they're already there.

Contents
  1. Where duplicates come from — and where the CRM already catches them
  2. A warning when you create a card
  3. How to find duplicates in your database
  4. How to merge companies
  5. When to link cards instead of merging them
  6. Who can merge
  7. Where to start
Merge companies
FieldNorthwind SupplyNorthwind Supply LLCNameNorthwind SupplyNorthwind Supply LLCPhone+1 212 ••• 4567+1 212 ••• 8810Email—[email protected]OwnerLiam NovakSofia Reyes
An example. An empty field on the main card is taken from the other one, both phones stay, and deals and calls move over with their history.

Where duplicates come from — and where the CRM already catches them

  • An incoming call finds the card by the last digits of the number: “+1 415 555 0134” and “14155550134” are the same client. An unknown number creates a lead, and a repeat call goes to that same lead.
  • A messenger message looks for a contact, a company and an open lead by the number, and only then creates a new lead.
  • A website request with the same phone number or email lands as a note in the open lead instead of creating a second one.
  • Import from Excel skips rows that are already in the CRM, as well as repeats within the file itself.

What's left are the duplicates people create: a sales rep didn't find the client by search and added them again, or two departments each keep the same company on their own. How to load your database without repeats is covered in our article on importing clients from Excel.

A warning when you create a card

When a phone number is typed into the new contact form, the CRM checks it against the database and shows “This number is already in the CRM:” under the field, with links to the cards it found. You can still create the contact — the hint doesn't block anything, but one look is usually enough. The mobile app shows the same “Already in the CRM:” warning when you create a lead or a contact.

With the free “Company duplicates” app, the CRM checks a new company too: by tax ID, phone number and name — ignoring quotation marks and legal forms such as LLC or Ltd. The “This client may already exist:” hint shows who owns the card it found and what matched.

How to find duplicates in your database

There's no separate duplicate search across the whole database yet, but searching the lists finds repeats quickly. In companies, search looks at the name, legal name, tax ID, phone number and email, and a phone number is found in any format — five digits in a row are enough. Sort the list by name or tax ID, and similar cards will end up next to each other.

How to merge companies

  1. Open “Companies” and tick the checkboxes next to two or more cards of the same client.
  2. In the action bar, choose “Merge.”
  3. In the “Merge companies” window, mark the main card — it stays, and the others will be deleted.
  4. Check the fields: by default, the main card's values are used, and empty ones are filled in from the other cards. You can keep all phone numbers, emails and websites.
  5. Look at the “Will move to the main card” block and click “Merge.”

Everything moves to the main card: deals, invoices, leads, contacts, tasks, activity feed entries, calls, emails, company details and custom fields. Repeats aren't doubled — the same call or contact stays as a single copy. A “Merged from: …” entry appears in the feed with the name of whoever did the merge.

Sometimes two departments handle the same client — sales and service — and each needs its own card with its own owner. In that case, the cards aren't merged but linked as “Duplicates” in the “Company duplicates” app: the “Duplicates” button in the card header shows all of the client's cards and the main one, and an incoming call goes to whoever last spoke with the client.

Who can merge

To merge, you need permission to edit the main card and to delete the others. Sales reps can't delete by default, so the administrator does the merging — or someone they give the permission to in the role settings. More in our article on CRM roles and permissions.

Where to start

  1. Agree with your team: before creating a client, search for them by phone number.
  2. Go through the company list sorted by name and mark the obvious repeats.
  3. Merge two or three cards at a time, checking the main card and the fields.
  4. If different departments handle a client, link their cards instead of merging them.

How the client card works and why it matters to have just one is explained in our article on the client card in CRM.

How does the CRM know a client is already there?
By phone number: the last digits are compared, so “+1 415 555 0134” and “14155550134” are the same number. Companies are also matched by tax ID and name.
What happens to deals when you merge?
Deals, invoices, tasks, calls, emails and activity feed entries move to the main card, and repeats aren't doubled.
Can a merge be undone?
No. Deleted cards don't go to the Trash, so check the main card and the fields before you confirm.
Can I merge contacts or leads?
Not yet — only companies can be merged. The phone number check in the form helps you avoid creating duplicate contacts.
Who can merge cards?
Anyone with permission to edit the main card and delete the others. By default, that's the administrator.

One card per client — the whole history in one place

14 days free on the “Standard” plan. No card required.

Start for free

Share this article

Ivan Kancyr

Founder of emyCRM. Writes about how small teams sell over the phone and in messengers without losing clients.

← All articles

Try 14 days free

14 days of the Standard plan: up to 30 employees, telephony and AI features. No card needed — try it on your own deals.

  • No card needed, cancel anytime
  • We’ll help you move clients and deals from another CRM or Excel
  • Your data stays after the trial

First steps

  1. Account createda couple of minutes, no card
  2. Connect telephonyyou only need a SIP provider
  3. Connect WhatsApp and Telegramapps in the marketplace
  4. Move clients and dealsfrom Excel or another CRM — we’ll help
  5. Invite your teamroles and access by department
1 of 5