Spend Analysis: How to Find Money Already Sitting in Your Purchasing Data
If you want to lower what your organization pays for goods and services, you rarely have to look far. The opportunity is usually hiding in data you already own: every invoice, purchase order, and credit-card charge from the last year or two. Spend analysis is the disciplined practice of gathering that information, cleaning it up, and looking at it as one picture rather than a thousand separate transactions. It is the least glamorous and most reliably profitable thing a procurement team can do.
Coming out of the first year of the pandemic, this matters more than usual. Budgets were re-cut on the fly, emergency purchases were made outside normal channels, and many teams scattered to remote work without a shared view of who was buying what. The result, for a lot of organizations, is a year of messy records and a strong suspicion that money leaked out. Spend analysis is how you find out where.
What spend analysis actually answers
At its core, spend analysis answers three simple questions: How much are we spending? With whom? On what? Those sound obvious, but most organizations cannot answer them cleanly. Purchases are recorded in different systems, suppliers are named three different ways, and categories are inconsistent. Until you can answer those three questions with confidence, every "savings initiative" is really a guess.
How much: total spend, and how it is trending against budget.
With whom: which suppliers receive the most money, and how many suppliers you actually use.
On what: spend grouped into sensible categories like IT, professional services, facilities, or travel.
A first pass you can run this quarter
Pull the data. Export 12 to 24 months of accounts-payable and purchasing records. Don't wait for it to be perfect — get it all into one spreadsheet or table first.
Clean the supplier names. "Acme Inc.", "ACME INCORPORATED", and "Acme" are one vendor. Merging these duplicates is tedious but it is where the picture first comes into focus.
Group into categories. Assign each line to a category. Even a rough first pass reveals where the real money goes — often a handful of categories account for most of the spend.
Find the patterns. Look for the same item bought from several suppliers at different prices, many small purchases that should be one contract, and spend that bypassed agreed suppliers entirely.
Pick two or three actions. Don't try to fix everything. Consolidate one fragmented category, renegotiate one large supplier, or set up a contract for something currently bought ad hoc.
Where the savings usually hide
The recurring culprits are familiar. Tail spend — the long list of tiny, one-off purchases — quietly adds up and is almost never managed. Maverick buying, where staff purchase outside negotiated contracts, erodes the discounts you already earned. And duplicate suppliers mean you are splitting your volume and your leverage across vendors who would each sharpen their pricing if they had all of it. None of this requires fancy tools to spot. It requires clean data and the willingness to look.
Treat spend analysis as a habit, not a one-time project. Refresh it each quarter, and the same view that found savings this time becomes an early-warning system for the next disruption — so a price spike or a supplier failure shows up in your numbers before it shows up as a crisis.
When you want a clear-eyed read on where your money goes and a practical plan to recover it, XNM's procurement, sourcing & contract management can help you turn your purchasing data into savings.