Entity Resolver / Master Data Map
the ops or data person stuck reconciling a CRM against an accounting export against a mailing list, where nothing shares a key. It’s the join you’d build by hand if the names ever agreed.
Give it two or more CSV exports that describe the same clients, vendors or contacts, and it decides which rows are the same real-world entity even when the name is spelled differently in each system.
Then it hands you a master record, a crosswalk, and a list of the suspected matches to review. The match cutoff defaults to 0.7.
$75 a month. Cancel any day. The crosswalk and master records are files you keep on your machine.
Three systems, one client, three spellings
The CRM calls them Acme Inc. Accounting has Acme, Incorporated. The mailing list has ACME with a typo in the email address. Every report that needs all three has to be stitched together by hand.
The stitching is wrong often enough that nobody fully trusts the client count, and the person who does the stitching is the only one who knows where the bodies are buried. A spreadsheet lookup only works when the key matches, and here it never does.
The cost isn’t the data. It’s every downstream number that quietly disagrees with every other one.
How it decides two rows are one entity
- It parses and normalizes. Every source CSV is read, each row tagged with its file and a row id. The fields you list in
MATCH_FIELDSget normalized: names lowercased with punctuation stripped, phones reduced to digits, emails trimmed. - It blocks. Records are grouped by a cheap key, the email domain or the first three letters of a name, so it only compares rows that could plausibly match rather than every pair in the file.
- It scores and clusters. Each pair inside a block gets a score blending token overlap that ignores word order with an edit-distance ratio that tolerates typos. Pairs at or above
MATCH_THRESHOLD, default 0.7, are merged with a union-find and each cluster gets amaster_idand a canonical name.
What the master data map contains
MASTER_ENTITIES.md, the canonical name and member count per entity, so you can see how many source rows collapsed into each real one.CROSSWALK.csv, mapping every source row to itsmaster_id, so any downstream report can finally join across systems that never shared a key.DUPLICATES.md, every suspected-same pair with its score, for a human to confirm, because nothing gets merged in your actual systems.- Matching that treats an exact email or phone as a strong signal, connects “Smith John” to “John Smith” because word order is ignored, and forgives “Jon Smith” against “John Smith” because typos are tolerated.
- Transitive clustering, so a link chaining across three source rows collapses into one entity instead of three half-merges.
entities.json, the full machine-readable detail, if you want to build your own review screen on top.
Who this is for, and who needs more
A team resolving a few thousand to a few hundred thousand records across a handful of exports, where the join key was never agreed on.
Not for you if you need governed, continuous master data management with survivorship rules and an audit trail across the whole enterprise. Informatica and Tamr are built for that scale and that governance. This is a desktop resolve you run against exports, and its output is a review list, not an authority.
What it replaces, and where the big suites win
What you’re using now is probably a spreadsheet and a lookup, which fail the moment the key doesn’t match, which is the entire problem. The heavy alternative is a master data management suite like Informatica, genuinely better at scale, survivorship and governance, and priced for a department that has a data team.
This sits in the gap between them: real fuzzy matching, run locally, cheap enough to use on a Tuesday, with the honest caveat that it proposes and a person disposes.
Why the files never leave your machine
Every source file is read from disk and nothing touches the network. The four outputs are the only things written, at 0600, under OUTPUT_FOLDER.
One limit worth knowing up front: blocking can miss a pair that shares no blocking key, so two rows where one has only a name and the other only an email may never get compared. The docs tell you to spot-check near-misses across entities.json rather than trusting a single block.
The price, and the first resolve
$75 a month. List your sources and match fields, run it, and the first master map comes back in seconds to a minute depending on row count.
Security and privacy
Handles client/vendor/contact records pulled from multiple business systems (CRM, accounting, mailing lists). Security is designed in.
Principles
– Local-first. Every file in SOURCES is read from disk and never transmitted anywhere; nothing in this tool touches the network. Nothing is uploaded, no telemetry, no cloud dependency.
– Non-destructive. Source CSVs are only read, never modified or deleted.
– Least privilege. Reads only the paths listed in SOURCES, writes only under OUTPUT_FOLDER.
Protections implemented (v0.1.0)
– Path-traversal defense — every output filename is sanitized (safeSegment) and every write is checked with assertWithinRoot(), so the master data map can’t be written outside OUTPUT_FOLDER.
– Fail-fast config validation — clear errors for missing/invalid SOURCES/MATCH_FIELDS/OUTPUT_FOLDER/MATCH_THRESHOLD before any file is touched.
– Restrictive permissions — the generated output (MASTER_ENTITIES.md, CROSSWALK.csv, DUPLICATES.md, entities.json) is written 0600.
– Defensive parsing — the CSV parser never throws on malformed input (missing fields default to empty string); a bad row degrades that row’s match quality rather than crashing the run.
– Secrets discipline — .env and generated Entities/ output are git-ignored; no secrets or client data in the repo.
Distribution / AV trust
Known limitations / roadmap
– Blocking can miss cross-block matches. Two rows for the same entity that land in different blocks (e.g. one row has only a name, the other only an email, and neither shares a blocking key) will never be compared and so will not be clustered. Review ONLY-style gaps by spot-checking near-miss names across the full entities.json, not just within a block.
– This is a decision aid, not an authority. DUPLICATES.md lists every suspected-same-entity pair with its score for human review; nothing is automatically merged in any upstream system. Treat master_id assignments as a working hypothesis until a person confirms them.
– Similarity weights are fixed in v0.1.0 — email and phone are hard-coded as the strongest signals; per-deployment weight tuning (e.g. de-emphasizing phone for a dataset where it’s unreliable) is on the roadmap via .env.
– MATCH_THRESHOLD is a single global cutoff — a very low threshold over-merges distinct entities into one; a very high threshold under-merges genuine duplicates. Start at the default 0.7 and review DUPLICATES.md before tightening or loosening it.
Reporting
Report suspected vulnerabilities privately to the maintainer before public disclosure.
Frequently asked questions about Entity Resolver / Master Data Map
What does entity resolver software do, and why would an SMB need it?
Entity resolver software solves a problem that grows quietly as a small business adds tools. The same client shows up in your accounting system, your invoicing tool, and your email list, spelled three different ways with three different records. The same vendor appears twice because someone typed the name with and without an abbreviation. The tool matches those scattered records, figures out which ones refer to the same real client, vendor, or property, and builds one resolved master list. It brings order to data that has drifted apart across systems that never talked to each other.
The workflow is designed for an operations or bookkeeping lead, not a data engineer. You load exports from the tools that hold your client or vendor records, often as CSV files. The matching engine compares them and resolves the duplicates and near-duplicates into linked or merged entities. You review the proposed master map and confirm the matches, merging or linking records as you go. Entity resolver software turns hours of manual list-matching into a reviewable set of suggestions you can accept or reject with judgment.
Having one accurate map of who and what you deal with lines up with recognized security and governance thinking. The NIST Cybersecurity Framework puts Identify among its core functions, which includes knowing your assets and your data. You cannot manage or protect information well when the same customer exists as five conflicting records nobody can reconcile. A resolved master list is a cleaner answer to the basic question of what data you actually hold, which is where the Identify function starts.
The blunt reason an SMB needs this is that duplicated, inconsistent records cause real errors. You send two statements to the same client, you miss that two vendors are one, or your reconciliation breaks because the same property is recorded three ways. Those mistakes cost time and trust, and they multiply every time you add another tool to the stack. The tool exists to stop that fragmentation from turning into wrong numbers and awkward conversations with the people you serve.
This capability used to be enterprise-only, sold to large organizations with data teams and enterprise budgets. Entity resolver software at an SMB price brings that matching engine down to a business that has the same problem at a smaller scale and no team to throw at it. It is often most useful bundled underneath reconciliation and bookkeeping tools, acting as the engine that keeps their records consistent. To see how loading, matching, and the master map fit together, visit the entity resolver product page and walk through a sample run. For a business drowning in slightly different versions of the same names, one clean map is worth a great deal. Fragmented records are not a cosmetic problem, they are a source of real errors that compound with every new tool you add to the stack. One clean map of who and what you deal with is the foundation everything else rests on, from accurate billing to reliable reconciliation. Entity resolver software exists to build that foundation for a business that has never had the team or the budget to do it by hand.
How does one master list of clients and vendors help me protect the data I hold?
It helps in a way that sounds indirect but is fundamental. You cannot protect information you cannot even see clearly, and duplicated, scattered records make your data impossible to see clearly. When the same client exists as four inconsistent entries across tools, you have four partial pictures instead of one accurate one. Entity resolver software consolidates those into a single resolved record, which is the honest first step toward knowing exactly what customer and vendor information your business is actually holding.
Knowing what you hold is the opening move in every serious data-security guide. The Federal Trade Commission’s FTC Safeguards Rule requires a covered business to maintain a security program with administrative, technical, and physical safeguards to protect customer information, and the very first thing such a program demands is an accurate inventory of the sensitive data you keep. A pile of duplicate records with conflicting details is the enemy of that inventory. The tool gives you the clean map that a real security program has to start from.
A resolved master list also reduces the ways sensitive data can leak by accident. Every stray duplicate is a copy of personal or financial detail that someone might export, email, or forget to secure. When a client’s information is spread across five records, keeping all five consistent and protected is harder than protecting one. Entity resolver software shrinks that surface by collapsing duplicates into single, linked entities, so there are fewer scattered copies of the same sensitive record to lose track of.
There is a compliance benefit in accuracy itself. When a client asks what information you hold about them, or an auditor asks how your records are organized, a fragmented set of duplicates makes both questions painful to answer. A resolved master map lets you point to one authoritative record per entity. That is the difference between confidently describing your data and admitting you are not entirely sure how many versions of a given client exist in your systems.
The tool does not encrypt your data or write your security program, and it should not claim to do the whole job. Those remain your responsibilities. What it contributes is the clean, deduplicated foundation that makes the rest of the work possible, because protecting a tidy, well-understood set of records is far more achievable than protecting a sprawling mess. To see where a master data map fits alongside inventory, access control, and the rest of a small-business posture, the IT, operations, and compliance overview shows how clean data feeds everything else. For a business that has never quite known how many copies of its customers exist across its tools, resolving that into one map is a real security improvement, not just a tidiness one. You cannot inventory, secure, or answer questions about data you cannot see clearly, and duplicated records are the fastest way to lose that clarity. Resolving them into one authoritative record per entity is the unglamorous groundwork that makes every later security step realistic. It is far easier to protect a tidy set of records than a sprawling pile of near-duplicates that no one can fully account for.
Where does the resolved master list live, and who can reach it?
This deserves careful thought, because a resolved master list is a concentrated view of your most sensitive relationships. It links together your clients, vendors, and the identifying details attached to them, sometimes including tax identifiers or financial information for vendor records. A single, clean map of all of that is powerful for running your business and equally attractive to anyone who should not have it. So how the master list is stored and who can open it is a first-order question, not a detail to skip.
Access control over sensitive data is a formal requirement, not a preference. The U.S. National Institute of Standards and Technology treats it as a foundational control family. In NIST SP 800-171, the security requirements for protecting sensitive information in nonfederal systems begin with Access Control, meaning access is limited to authorized people and to the functions they actually need. A resolved master map of clients and vendors is exactly the kind of sensitive consolidation those requirements are meant to guard, and entity resolver software is built with that principle in mind.
In practice, that means the master list and the underlying records stay scoped to the people you authorize. The value of consolidating your data should never come at the price of making it easy for the wrong person to grab everything in one place. A tool that resolves entities has to be careful precisely because it creates a single high-value view, so access to that view is meant to be deliberate and limited rather than open by default. The convenience of one clean map does not have to mean convenient exposure.
Concentrating your data also raises the stakes of least privilege, and the tool is designed to respect that. The fewer people who can open the full master map, the smaller the target and the easier it is to account for who has seen it. That thinking runs directly through the access control requirements and applies with extra force to a resolved dataset, because the whole point of resolution is that everything about an entity is now in one connected record rather than scattered and hard to assemble.
You keep the decisions that matter. You choose which exports feed the resolver, who on your team can run matches and open the master map, and what happens to the results afterward. What the tool adds is a scoped process with a record of what it matched and merged, so the consolidation is auditable and the sensitive result stays contained. To see how storage, access, and the master map export are handled, the product page walks through where the data sits and how you keep control of it. For a business consolidating its client and vendor records for the first time, knowing that the resulting master view is guarded, not casually shared, is exactly the assurance to insist on before you build it. The value of consolidating your records should never make it easier for the wrong person to take everything at once, and entity resolver software is designed with exactly that tension in mind. A guarded master map is an asset, while an exposed one is a liability, and the difference comes down to who you let reach it.
How is this different from enterprise tools like Senzing, DataLadder, or WinPure?
The difference is scale, price, and who is expected to run it. Senzing, DataLadder, and WinPure are capable entity-resolution platforms, but they are built and priced for enterprises with data teams, large record volumes, and the staff to configure and maintain a matching pipeline. A small business has the same underlying problem, the same client showing up five ways across tools, but none of the team or budget those platforms assume. Entity resolver software at an SMB price brings the matching engine to that smaller business without the enterprise weight.
The design reflects the different buyer. Instead of a platform that expects a specialist to tune it, the tool is meant for an operations or bookkeeping lead who loads exports, runs the match, and reviews the results. It is often most useful bundled as the engine underneath reconciliation and bookkeeping tools, quietly keeping their records consistent rather than standing alone as a heavy system you have to administer. The goal is a clean master map with as little setup ceremony as possible, because the person running it has a dozen other jobs.
The purpose it serves fits recognized governance thinking regardless of scale. The NIST Cybersecurity Framework asks organizations to Identify their assets and data, and knowing your clients and vendors as clean, single records is part of that regardless of whether you are a large enterprise or a two-person shop. The enterprise tools deliver that identification for big organizations. Entity resolver software delivers the same clarity for a small one, at a size and price that actually fits, so the small business is not stuck choosing between an unaffordable platform and doing nothing.
Being honest about scope is part of the difference too. This tool is not trying to out-feature Senzing on a dataset of hundreds of millions of records, and it does not pretend to replace an enterprise data-management program. It is aimed at the volumes and the messiness a real SMB actually has, which is significant to that business but modest by enterprise standards. That focus is a feature, because it keeps the tool usable by a non-specialist instead of demanding the very data team the small business does not have.
So this is not a cheaper Senzing. It is a right-sized tool for a buyer the enterprise vendors do not serve, solving the same class of problem at a scale that matches a small operation. To see how the matching engine fits alongside inventory, access control, and reconciliation for a small team, the IT, operations, and compliance overview shows where a master data map belongs. For a business that knows its records are a duplicated mess but could never justify an enterprise data platform to fix it, that right-sized middle ground is exactly what has been missing. The gap in this market has always been the middle. Enterprises had powerful tools, tiny businesses had spreadsheets and manual matching, and the small operation in between had nothing that fit its size or its budget. Entity resolver software at an SMB price fills that gap, giving a real but modest business the matching engine it needs without the team, the setup, or the cost that the enterprise platforms take for granted.
When it merges duplicate records, what happens to the leftover sensitive copies?
This is the right question to ask about any cleanup that touches personal or financial data. When the resolver merges duplicates into one master record, the old redundant copies do not just stop mattering. Each of them was a copy of real client or vendor detail, sometimes including tax identifiers or bank information for vendor records. Cleaning up duplicate or inconsistent records is one of the tool’s core jobs, and doing it responsibly means treating those leftover copies as sensitive right up until they are properly gone, not casually discarding them.
There is a recognized standard for retiring data you no longer need. The U.S. National Institute of Standards and Technology publishes NIST SP 800-88, Guidelines for Media Sanitization, which explains how to render data unrecoverable when you dispose of it. The core idea is to make access to the target data infeasible for a realistic level of effort, so a deleted record is genuinely gone rather than merely hidden. That principle applies directly to the redundant copies a merge leaves behind, which should be handled deliberately instead of forgotten in a stale export.
In practice, the tool is built to keep the merge process visible and accountable, so you know which records were combined into a master and which duplicates were retired. That record matters, because the difference between a defensible cleanup and a careless one is whether you can say what happened to the extra copies of sensitive data. Entity resolver software is meant to reduce your scattered copies, not to quietly spread new ones through half-finished exports and forgotten temporary files.
The security payoff of doing this well is real. Every leftover duplicate is a copy of personal information that could be exported, mishandled, or exposed later. By resolving many records into one and retiring the redundant copies properly, you shrink the number of places a given client’s data lives, which is a direct reduction in your risk. A messy merge that leaves stray copies everywhere would defeat the purpose, turning a cleanup into a wider spread of the same sensitive detail.
The tool stays honest about the boundary of its job. It resolves and merges your records and gives you a clear view of what happened, but the disposal of exported files and the handling of source systems remain choices you make with the sanitization principle in mind. What it removes is the confusion that lets duplicate sensitive records pile up unmanaged in the first place. To see how merging, the master map, and record cleanup are structured, the entity resolver product page lays out the flow from scattered exports to one resolved list. For a business finally cleaning up years of duplicated client and vendor data, handling the leftover copies with care is what makes the cleanup a security win rather than a new liability. Handling the leftover copies with the same care as the master record is what separates a cleanup that reduces risk from one that quietly spreads it. Entity resolver software is meant to shrink the number of places your sensitive records live, and doing that well means the retired duplicates are genuinely gone, not just hidden in a forgotten export somewhere on a drive.
| Attributes | Value |
|---|---|
| Deployment |
Cloud |
| Platform |
Web |
| License Type |
Subscription |
| Billing Period |
Monthly |
| Target Customer |
IT, Ops & Compliance |
| Free Trial |
Yes |
Frequently bought together
-
AI Grant / Proposal Writer (local RAG)
$39.00 -
AI QA / Citation Layer for AI outputs
$39.00 -
AI Receptionist That Acts
$95.00 -
AI Support Inbox for Microteams
$39.00 -
Backup Restore Test Monitor
$39.00 -
Batch Image / Brand Asset Generator
$65.00 -
Batch Video/Photo Culler for Creators
$119.00 -
Bulk Document AI Processor / Batch PDF Splitter+Binder
$249.00








