Your Supplier Master Data Is a Mess: How Duplicate Vendor Records Quietly Inflate Your Spend

Fourteen Records for One Factory

A sourcing director pulled up his ERP one Monday to check spend with his largest lighting supplier. He found fourteen vendor records for what he knew was a single factory in Zhongshan. Four names. Three currencies. One record still carried a dormant bank account from an acquisition six years earlier.

He wasn't unusual. He was normal.

Every buyer I talk to has a version of this story. Master data is the part of procurement nobody owns and everybody touches, so it rots quietly until a negotiation or a risk audit forces someone to look at it.

How the Duplicates Get There

Nobody sets out to create five records for one supplier. It just happens. A supplier registers a subsidiary to sell through a new market, and the account gets entered under the subsidiary name. A sales rep emails an order with a slightly different legal name. An acquisition imports a whole vendor file without matching it against the existing one. A sourcing agent in the field types the name in pinyin while the HQ system uses English.

Add a merger or a factory moving to a new legal entity, and you've got a mess that compounds every quarter. The scary part is that it looks fine from a distance. Invoices get paid. Orders ship. The mess only shows up when you try to answer a simple question: how much do we actually spend with this supplier?

What Dirty Master Data Costs You

The cost isn't obvious because it's distributed. It shows up as leverage you never had, rebates you never claimed, and risk you never saw. Here's the clearest example. If one factory sits behind three records, your spend reports show three small suppliers instead of one big one. You negotiate with each "supplier" from a position that looks a third of its real size, so you leave volume pricing on the table.

Risk scoring breaks the same way. A supplier with two aliases gets screened under one name while the other alias slips past your denied-party check. Spend taxonomy is the last casualty: without normalized categories, you can't see that 70 percent of your spend sits in one component family you thought was a minor line item.

Symptom and Cost, Side by Side

The Fix: Golden Record and Taxonomy

You don't need a data-science team. You need a matching pass, a golden record, and a rule that says who owns it. The matching pass groups records that are the same legal entity by name, tax ID, address, and bank details. The golden record is the single canonical entry each group points to. The rule is the part most companies skip: one named owner, usually in procurement, with authority to merge records and freeze new ones without sign-off.

Spend taxonomy comes second. Give every supplier one category and every category one owner. That's it. Once you've done this, the spend cube stops lying to you, and the rebates and leverage become visible enough to act on.

The exercise is boring. It pays for itself in one negotiation cycle, because you finally know how much you spend and with whom.

The Payoff You Can't See Yet

Clean master data changes three things at once. Negotiating power: a supplier who knows you can see the full picture stops treating you like three small accounts. Risk: your denied-party and sanctions screening finally covers every alias. And category strategy: you can concentrate spend, run a real supplier scorecard, and spot a single-source risk before it bites. None of that is possible when your data is a pile of fourteen records.

Common Questions from Buyers