At a glance
Use trusted identifiers first. Normalize names and addresses for candidate generation, then verify the entity using independent evidence. Similar names, shared office addresses and group domains can connect different companies; route ambiguous pairs to review instead of forcing a match.
| Evidence | Useful for | Failure to check |
|---|---|---|
| Authoritative entity ID | Exact matches within the same ID system | IDs from different issuers are not interchangeable |
| Domain and address | Narrowing candidates | Shared domains, branches and virtual offices |
| Normalized company name | Finding spelling and punctuation variants | Different companies with similar names |
| Fuzzy similarity score | Ranking a review queue | A score is not a probability or proof of identity |
Example: same name, different company
A CRM and directory may both contain Example Trading. Compare domains, addresses, registration evidence and source dates. Keep the candidate pair in a review queue when evidence conflicts. Save source record IDs and a reversible master-record mapping so a mistaken merge can be undone.
Before you put it into practice
- Define whether you are matching a legal entity, brand or branch.
- Keep original values alongside normalized fields.
- Measure false merges and missed matches on a human-reviewed sample.
- Record evidence, reviewer, decision date and mapping version.
Review a small matching sample
These synthetic records show why similar names alone are insufficient. The first two rows share a domain and postcode but still need entity verification; the third stays unmatched. Add source IDs, evidence, a reviewer and a decision date to your own review queue. Preserve original records and reversible mappings rather than overwriting source identities.
All downloads use demonstration data, with no client information. Discuss adapting the workflow or see what affects implementation cost.
Key takeaways
- Matching companies is an identity problem, not only a text-search problem.
- Normalize names, addresses and domains before comparing records.
- Use strong identifiers first, then score weaker matches with clear thresholds.
- Keep uncertain pairs for review instead of forcing every record into a match.
Why the same business appears different
One company may appear as a legal name in a registry, a shortened brand name in a directory and a domain-based name in a spreadsheet. Addresses may use different abbreviations, phone numbers may include country codes and websites may redirect from one domain to another.
If these records are simply joined on exact text, the result will contain duplicates and missed relationships. Entity matching creates a consistent identity layer that downstream reports can use.
Related guide: Python for Data Cleaning: A Practical Business Guide →
Normalize fields before matching
Begin by standardizing the fields that are safe to transform. Trim whitespace, normalize case, remove punctuation where appropriate and standardize phone, country, postal-code and website formats. Keep the original values alongside normalized versions so the process remains auditable.
Do not over-clean names in a way that removes meaningful distinctions. A normalization rule should reduce superficial differences without turning two genuinely different companies into one.
- Canonicalize website domains and remove tracking parameters.
- Standardize phone numbers with country context.
- Normalize address abbreviations and postal codes.
- Separate legal name, trading name and branch name where possible.
- Create consistent categories and country codes.
- Preserve original source values for review.
Use strong identifiers first
A verified company registration number, domain, tax identifier or source-specific ID can provide a strong match. Use these identifiers before fuzzy name comparisons, and confirm that the identifier refers to the same entity rather than a parent company, branch or old record.
When no strong identifier exists, combine several weaker signals such as name, location, phone, domain and category. A single similar name is rarely enough for an automatic merge.
Related guide: Build a Reliable Business Data Pipeline: A SaaS Customer Example →
Score candidate matches with clear rules
A matching score can combine field-level evidence. An exact domain may carry more weight than a partial name match; a matching city may support a result but should not decide it alone. Set separate thresholds for automatic match, manual review and no match.
Review a sample from each threshold and tune the rules against known examples. Keep the reason for each match so users can understand why two records were linked.
Create a master record and source links
The output should not discard the source history. Create a master business ID and connect every source record to it with the match status, confidence, timestamp and reviewer where applicable.
This structure lets a user see which source supplied a phone number or address, detect conflicting values and update the master record without losing the underlying evidence.
Keep matching accurate over time
Entity matching is an ongoing process. Businesses change names, domains, locations and ownership. Schedule periodic rechecks, monitor the number of unmatched and ambiguous records and feed reviewed decisions back into the rules.
A small review queue is healthier than an aggressive rule that silently merges unrelated companies. Measure precision, coverage, duplicate reduction and the time required for manual review.
Frequently asked questions
What is business entity matching?
It is the process of deciding which records from different sources refer to the same company, branch or organization and linking them to a consistent identity.
Which field is best for matching companies?
A verified registration number or stable source ID is often strongest. A domain, phone, address and name can support the match when no universal identifier is available.
Should fuzzy matching automatically merge companies?
Usually not at low confidence. Use thresholds for automatic matches, manual review and no match, and preserve the evidence behind the decision.
How do I handle companies with multiple branches?
Define whether the master identity represents the legal organization or each location. Keep separate branch records when location-specific reporting matters.
Can matching be done with Excel or Python?
Yes. Excel can support smaller review-led workflows, while Python or a database is better for larger datasets, repeatability, scoring and audit trails.