The Quiet $400,000: What a Spend Analysis Found That Nobody Was Looking For
By the autumn of the pandemic recovery, a community-services organization we'll call Northpoint had a problem it could not name. Budgets were tight, supply disruptions had pushed prices up, and the finance lead kept saying the numbers "felt high." Nobody could point to where the money was actually going. Purchasing was spread across four departments, three card programs, and a tangle of vendors nobody had counted. So they did the unglamorous thing first: they pulled twelve months of accounts-payable data into one place and looked at it honestly. That exercise — a spend analysis — is where the story really starts.
A spend analysis is not an audit and it is not a cost-cutting campaign. It is simply the discipline of cleaning, categorizing, and summarizing what your organization actually buys, from whom, and how often. The value is almost never in any single transaction. It is in the patterns that only appear once everything sits on one screen.
What the data refused to hide
Northpoint's first surprise was duplication. The same office supplier appeared under three slightly different names, so its true annual volume had never been visible — and never negotiated. Once combined, that supplier represented enough volume to justify a standing-order discount the organization had simply never asked for.
Fragmented vendors: 22 separate cleaning-product suppliers, most buying the same five items at retail-style prices.
Maverick spend: roughly 18% of purchases happened outside any contract, often on procurement cards for convenience.
Tail spend: hundreds of one-off vendors under $2,000 each, consuming disproportionate administrative time.
Price drift: identical items bought at three different unit prices in the same quarter, depending on who ordered them.
None of this was fraud or even carelessness. It was the natural result of a busy year where everyone improvised to keep services running. But added together, the recoverable amount came to roughly $400,000 — a number that startled the leadership team precisely because no one had been hiding it.
How to run one without drowning
The biggest mistake organizations make is treating spend analysis as a giant data-science project. It does not need to be. A focused, repeatable pass works far better than a perfect one that never finishes.
Consolidate the sources. Pull AP, card programs, and any departmental spreadsheets into a single export. Messy is fine; complete is what matters.
Normalize the vendors. Merge the same supplier under one master name. This step alone usually reveals your top concentrations.
Categorize the spend. Group purchases into clear categories like facilities, IT, professional services. Aim for useful, not exhaustive.
Find the few that matter. Apply the 80/20 lens. A small handful of categories almost always drives most of the dollars and most of the opportunity.
Turn findings into actions. Each insight should map to a decision: consolidate vendors, renegotiate, put a contract in place, or set a purchasing policy.
The real payoff is repeatability
Northpoint did not chase every dollar. They consolidated three categories, renegotiated two key contracts, and set a simple rule that purchases above a threshold had to go through a preferred-vendor list. The savings were real, but the more durable win was that they could now run the same analysis every quarter in an afternoon. Spend analysis stops being a rescue mission and becomes a habit — the cheapest control any organization can build.
If your numbers "feel high" but you cannot say why, that feeling is data trying to get your attention. The first honest look is usually the most valuable one.
When you want a clear view of where the money really goes — and a plan to recover it — XNM's procurement, sourcing & contract management can help you turn scattered purchasing into measurable savings.