The business does not just lose neatness. It loses a usable view of the thing it is trying to act on. Revenue gets split. Outreach gets duplicated. Service history fragments. Ownership becomes blurry. The same real-world entity gets treated like several different ones, and every downstream decision becomes a little less reliable.
Where the damage shows up first
- Reporting: totals split across near-identical records create fictional account values and misleading rankings.
- Sales and account management: two people contact the same company because the system thinks they are different accounts.
- Finance and ops: invoices, orders, or support events sit under separate identities and cannot be reviewed cleanly together.
- Leadership decisions: planning and prioritisation happen on top of fragmented entity views rather than one real customer or supplier picture.
Why one-off cleanup rarely holds
Manually merging a batch of obvious duplicates helps for a while. Then new data enters through the same forms, systems, and handoffs that created the issue in the first place. The duplicate set grows back because the business fixed the symptom once, not the matching logic behind it.
The hard part is not spotting the easiest duplicates. It is deciding what counts as the same entity, what should be left separate, what needs review, and which system should own the canonical record.
Good duplicate handling is really entity resolution plus governance: match records with enough confidence, preserve uncertainty where needed, and define what happens when new records arrive tomorrow.
What a better first step looks like
A Mini Proof-of-Work here is useful because it stays narrow. Match records across the two or three systems causing the most pain. Score likely duplicates. Surface uncertain cases clearly. Produce a reviewable output the team can use, not just a theoretical data-quality score.
Once the matching logic proves itself on real data, you have the foundation for a wider customer or supplier view. Without that proof, a bigger entity-resolution project is just expensive optimism.