How many IT vendors do you really have?

Ask your ERP a simple question — how much did we spend on IT last year, and with how many suppliers — and you get silence. It isn’t you. It’s the system.

Try it right now. Open your ERP and answer this: how much did your company spend on IT last year, and how many vendors did that go to? If you can do it in under a minute, you’re the exception. Most procurement and finance teams can’t — not because they’re disorganized, but because the question was never one their ERP was built to answer.

Your ERP is a system of record, not a system of understanding

An ERP records transactions. It knows, to the cent, every dollar that went out the door and the account it hit. What it doesn’t carry is meaning: it has no idea that the payment to “CDW” and the payment to “CDW LLC” are the same supplier, that both are IT resellers, or that “IT” is even a category you care about. The vendor record has a name and a number. It rarely has an industry, almost never a usable category, and the classification fields — if they exist — are blank or inconsistent.

So the moment you ask a question that crosses vendors — a category total, a commodity view, a concentration number — you’re on your own. The data is technically all there. The answers aren’t.

Why the spreadsheet workaround quietly fails

The usual fix is to export everything and tag it by hand in a spreadsheet. It works once, badly, and then it rots. The tagging is subjective, it’s never finished, and the second a new period of data lands you start over. Worse, it hides the duplicates: “W.W. Grainger Inc,” “Grainger Industrial Supply,” and “WW Grainger” sit on three different rows, so your “top suppliers” list is wrong and you never notice.

The data is already in your ERP. The answers aren’t — because nothing in there is classified, deduped, or connected.

What it takes to actually answer the question

Three things have to happen to your raw exports before “what do we spend on IT” becomes a one-click answer:

• Classification. Every vendor gets an industry and a category — a standard code like NAICS, and your own taxonomy on top of it.
• Deduplication. The same supplier under different names, across different systems, rolls up into one true vendor so your counts and totals are right.
• Enrichment. The gaps your ERP never filled — industry, domain, context — get filled in, so classification has something to work with.

Do those three things and the unanswerable question becomes trivial. That’s the whole job SpendAware does: you upload your vendor master and your spend file, and in minutes every vendor is classified, deduped, and enriched — so “how much on IT, with how many suppliers” is a number you can read off the screen, not a week of spreadsheet archaeology.