# Fix duplicate CRM records without merging different customers Published by Britixo | 2026-10-29 | CRM & integrations Canonical page: https://britixo.com/business-guides/fix-duplicate-crm-records/ Fix duplicates by finding how they enter the CRM, defining what counts as the same entity and reviewing uncertain matches before merging. Preserve the record identifiers, relationships and field history needed by connected systems. An exact email match may be useful evidence but is not a universal identity rule: shared inboxes, households and reused addresses create exceptions. Prevention at forms and integrations is as important as cleaning the existing database. ## When this guide is useful CRM administrators and sales operations teams dealing with repeated or conflicting customer records. - Several staff contact the same organisation without seeing each other's activity. - Reports count one customer more than once. - An import adds records already present under a different source identifier. - Merges unexpectedly change ownership, subscriptions or related records. ## Separate duplicate records from legitimate relationships Define whether the record represents a person, legal entity, branch, household or account. Two contacts at one company are not duplicate people, and two branches may need separate operational records. Establish the entity model before building a rule that merges anything with a similar name. Profile the source of duplicate creation: manual entry, website forms, imports or integrations. Compare timestamps and source identifiers to identify patterns. A race between two integrations may require a unique key and transaction control rather than a more aggressive fuzzy-matching rule. ## Use matching rules that expose uncertainty Normalise comparison values such as spacing or phone formatting while retaining the original fields. Combine multiple signals where appropriate, and distinguish certain matches from candidates needing review. Exclude placeholder values such as 'unknown' or a shared office number from being treated as strong identity evidence. Microsoft's duplicate-detection documentation shows that behaviour varies by operation and configuration. Verify whether your platform checks API writes, imports, offline work and concurrent creation. A warning shown to a user on one screen does not prove that every integration is protected. - Use stable external identifiers when the source provides them. - Keep a review queue for ambiguous or contradictory matches. - Test shared email addresses, renamed companies and branch accounts. ## Define what survives a merge Choose the surviving record and field values deliberately. Record ownership, contact preferences, legal-entity details and current addresses may require different precedence rules. Do not combine permissions or marketing eligibility merely because two records look similar. Inspect child records, attachments, open tasks and external links before merging. Microsoft describes how its supported merge operations handle related records, but other platforms can behave differently. Rehearse the chosen platform's process on representative cases and keep an auditable mapping from retired identifiers to the surviving record. ## Prevent recurrence and measure the right outcome Update the entry points that caused the issue. A form can check for an existing verified account; an import can match stable identifiers; an API can use an agreed unique key. Apply permission controls so users can resolve likely matches without granting everyone unrestricted merge access. Monitor new candidate duplicates and false matches separately. Reducing the duplicate count is not success if different customers are combined. Assign a data owner to review unresolved cases and maintain matching rules when the organisation's account structure or integration sources change. ## Prepare for a useful conversation - A clear definition of person, organisation and branch records. - An analysis of the entry points producing duplicates. - Matching rules with explicit exceptions and confidence categories. - Field-survival and related-record checks for approved merges. - Identifier mapping and ongoing duplicate-prevention controls. ## How Britixo can help Britixo can help investigate duplicate creation across CRM forms, imports and connected systems. A scoped engagement can include data profiling, matching rules, a review workflow and changes to prevent repeated creation. We can also assess how record merges affect activities and external identifiers before any production changes are agreed. The aim is reliable identity and usable records, rather than the lowest possible record count. Contact Britixo with examples of suspected duplicates and the systems that create them so we can identify whether the issue lies in data quality, integration behaviour or the record model. [Contact Britixo](https://britixo.com/contact/?enquiry_type=contact_consultation#contact-form) ## Common questions ### Can we automatically merge records with the same email address? Not safely as a universal rule. Shared or reused addresses can belong to different people or roles. Use additional evidence and a review path for exceptions. ### Why do duplicates still appear when detection is enabled? Coverage can differ between forms, imports, APIs and concurrent operations. Inspect the specific creation route and verify the platform's documented behaviour. ### Should the newest record always survive? No. It may contain less history or an incorrect field. Define survival rules around authoritative information, relationships and operational requirements. ## Related guides - [CRM data migration checklist: move records without losing relationships](https://britixo.com/business-guides/crm-data-migration-checklist/) - [Build a single customer view without losing the source of truth](https://britixo.com/business-guides/single-customer-view-integration/) - [Connect CRM and accounting software without creating competing records](https://britixo.com/business-guides/connect-crm-accounting-software/) ## Sources and further reading - [Microsoft: Detect duplicate records and merge](https://learn.microsoft.com/en-gb/power-platform/admin/detect-duplicate-records) - [Microsoft: Detect duplicate data with match codes and rules](https://learn.microsoft.com/en-us/power-platform/admin/detect-duplicate-data) Prepared with AI assistance and checked against linked primary documentation. [Editorial approach](https://britixo.com/business-guides/#editorial-approach). Product availability and delivery scope are confirmed for your requirements.