I regularly talk to procurement managers who run a tight operation but can't tell you how much they spend on what category. Not roughly, not in an organized way, not in a way that's comparable to last year.
That's not a criticism. It's the logical consequence of data scattered across an ERP system, spreadsheets, email inboxes, and paper invoices.
Spend analysis answers a simple question. Who spends how much on what, and does that make sense? The question sounds simple. The answer usually isn't.
Without a spend overview, you can't systematically optimize procurement. That sounds dramatic, but it's structurally true.
Setting savings targets without knowing actual spend is guessing. Consolidating suppliers without spend analysis means duplicate relationships go unnoticed. Negotiating prices without knowing annual volume means sitting at the table without leverage.
Spend analysis isn't the goal. It's the precondition for every other procurement goal being achievable.
Many procurement teams only experience this once they build a structured overview for the first time and suddenly see where the money is actually going. That's regularly surprising. And usually highly actionable.
The most common situation looks like this. Invoices get booked in the ERP by cost center and account, not by category. Orders run through different systems or straight through email. Procurement only sees what flows through it. Direct orders from other departments, maverick buying, stay invisible.
The result is predictable. Three departments buy from the same supplier, uncoordinated, with no volume consolidation. IT procures software that procurement could have gotten cheaper. A framework agreement for office supplies exists, but 40 percent of office supply spend runs around it.
This isn't sloppiness. It's the natural consequence of missing transparency.
A complete spend analysis needs three steps.
Step one is building the data foundation. The goal is all of last year's spend in one dataset. Sources are the ERP system, meaning accounts payable, the procurement platform if one exists, credit card statements for decentralized purchases, and, if possible, direct supplier queries for framework agreements that aren't captured elsewhere.
This sounds more elaborate than it is. In many companies, a CSV export from accounting is enough as a starting point.
Step two is category classification. Accounting accounts don't map to procurement categories. A translation has to happen, either manually for small data volumes, semi-automatically with Excel or Power BI, or system-supported.
Typical categories for a mid-market manufacturer are raw materials, packaging, production materials, tooling, IT and software, logistics, services, maintenance, office and infrastructure.
Step three is analysis and prioritization. What's the annual spend per category? Which suppliers cover what share? Where are the opportunities for consolidation, RFQs, or negotiation?
The Pareto rule holds almost every time. Twenty percent of categories make up 80 percent of volume. That's the starting point for action.
From conversations with mid-market procurement teams, I know that the findings from a first spend analysis are almost always surprising.
Common findings include significantly more active suppliers than expected, and a considerable share of them with tiny volumes that cost more to administer than they deliver. Multiple suppliers for the same category with no coordination. High-volume categories that were never put out to tender because "it always just worked." And purchasing volume in other departments that completely bypassed procurement.
Each of these findings is a concrete starting point. Supplier consolidation. RFQ planning. Enforcing purchasing policy. Volume bundling.
Without the spend analysis, these are all guesses. With it, they're facts.
Spend analysis is often associated with big-system projects. That's not true. Whoever waits for the perfect system never starts.
Starting with Excel works like this. A CSV export from accounting, manually categorized by product group, produces a usable foundation within two days. Not perfect, but enough for a first pass at prioritization.
Starting through the procurement platform is another route. If you run RFQs digitally, you already have structured data there, suppliers, categories, volumes. That's a starting point that gets better every year.
Starting through supplier data helps too. Request an annual statement from your top 10 suppliers. Which orders, what volumes, which products? That closes part of the blind spot.
The goal is that spend data gets generated automatically, not through elaborate after-the-fact work.
When RFQs run digitally, the relevant information is already stored in a structured way. Supplier, category, volume, outcome, price. Over time, a data foundation builds up that's analyzable, without an annual spreadsheet sprint.
cusoso Target stores all RFQ data and makes it filterable by category, supplier, and time period. It's not a BI tool, but it's the starting point for spend transparency in everything that runs through procurement.
How much spend typically sits outside procurement? Depending on the company, between 20 and 50 percent. In decentralized structures, the share is higher. That's not a procurement failure, it's a governance issue that needs to become visible.
How often should a spend analysis be done? Once a year as a full analysis, quarterly as an update for critical categories. If you use a digital procurement platform, the core data stays current on an ongoing basis.
What's the first concrete step? Ask accounting if they can give you an export of all supplier payments from last year. That usually takes a day. What you do with it is the next step.
Do we need a consultant for this? Not for the first analysis. Procurement can do the data exports and categorization itself. For deriving actions from a complex spend structure, an outside perspective can help, but that's step three, not step one.
Spend analysis starts with an export from accounting, not a BI project. Two days of categorization deliver a starting position that didn't exist before.
cusoso Target keeps RFQ data continuously analyzable, by category, supplier, and time period, without an annual spreadsheet sprint. Whether it fits your procurement organization is something our quick check shows in 3 minutes.
→ To the quick check
That's not a criticism. It's the logical consequence of data scattered across an ERP system, spreadsheets, email inboxes, and paper invoices.
Spend analysis answers a simple question. Who spends how much on what, and does that make sense? The question sounds simple. The answer usually isn't.
Why spend transparency is the foundation for everything else
Without a spend overview, you can't systematically optimize procurement. That sounds dramatic, but it's structurally true.
Setting savings targets without knowing actual spend is guessing. Consolidating suppliers without spend analysis means duplicate relationships go unnoticed. Negotiating prices without knowing annual volume means sitting at the table without leverage.
Spend analysis isn't the goal. It's the precondition for every other procurement goal being achievable.
Many procurement teams only experience this once they build a structured overview for the first time and suddenly see where the money is actually going. That's regularly surprising. And usually highly actionable.
The typical spend chaos in mid-market companies
The most common situation looks like this. Invoices get booked in the ERP by cost center and account, not by category. Orders run through different systems or straight through email. Procurement only sees what flows through it. Direct orders from other departments, maverick buying, stay invisible.
The result is predictable. Three departments buy from the same supplier, uncoordinated, with no volume consolidation. IT procures software that procurement could have gotten cheaper. A framework agreement for office supplies exists, but 40 percent of office supply spend runs around it.
This isn't sloppiness. It's the natural consequence of missing transparency.
How a spend analysis is actually built
A complete spend analysis needs three steps.
Step one is building the data foundation. The goal is all of last year's spend in one dataset. Sources are the ERP system, meaning accounts payable, the procurement platform if one exists, credit card statements for decentralized purchases, and, if possible, direct supplier queries for framework agreements that aren't captured elsewhere.
This sounds more elaborate than it is. In many companies, a CSV export from accounting is enough as a starting point.
Step two is category classification. Accounting accounts don't map to procurement categories. A translation has to happen, either manually for small data volumes, semi-automatically with Excel or Power BI, or system-supported.
Typical categories for a mid-market manufacturer are raw materials, packaging, production materials, tooling, IT and software, logistics, services, maintenance, office and infrastructure.
Step three is analysis and prioritization. What's the annual spend per category? Which suppliers cover what share? Where are the opportunities for consolidation, RFQs, or negotiation?
The Pareto rule holds almost every time. Twenty percent of categories make up 80 percent of volume. That's the starting point for action.
What you typically find
From conversations with mid-market procurement teams, I know that the findings from a first spend analysis are almost always surprising.
Common findings include significantly more active suppliers than expected, and a considerable share of them with tiny volumes that cost more to administer than they deliver. Multiple suppliers for the same category with no coordination. High-volume categories that were never put out to tender because "it always just worked." And purchasing volume in other departments that completely bypassed procurement.
Each of these findings is a concrete starting point. Supplier consolidation. RFQ planning. Enforcing purchasing policy. Volume bundling.
Without the spend analysis, these are all guesses. With it, they're facts.
The pragmatic starting point without SAP
Spend analysis is often associated with big-system projects. That's not true. Whoever waits for the perfect system never starts.
Starting with Excel works like this. A CSV export from accounting, manually categorized by product group, produces a usable foundation within two days. Not perfect, but enough for a first pass at prioritization.
Starting through the procurement platform is another route. If you run RFQs digitally, you already have structured data there, suppliers, categories, volumes. That's a starting point that gets better every year.
Starting through supplier data helps too. Request an annual statement from your top 10 suppliers. Which orders, what volumes, which products? That closes part of the blind spot.
How procurement platforms make spend analysis easier
The goal is that spend data gets generated automatically, not through elaborate after-the-fact work.
When RFQs run digitally, the relevant information is already stored in a structured way. Supplier, category, volume, outcome, price. Over time, a data foundation builds up that's analyzable, without an annual spreadsheet sprint.
cusoso Target stores all RFQ data and makes it filterable by category, supplier, and time period. It's not a BI tool, but it's the starting point for spend transparency in everything that runs through procurement.
Frequently asked questions
How much spend typically sits outside procurement? Depending on the company, between 20 and 50 percent. In decentralized structures, the share is higher. That's not a procurement failure, it's a governance issue that needs to become visible.
How often should a spend analysis be done? Once a year as a full analysis, quarterly as an update for critical categories. If you use a digital procurement platform, the core data stays current on an ongoing basis.
What's the first concrete step? Ask accounting if they can give you an export of all supplier payments from last year. That usually takes a day. What you do with it is the next step.
Do we need a consultant for this? Not for the first analysis. Procurement can do the data exports and categorization itself. For deriving actions from a complex spend structure, an outside perspective can help, but that's step three, not step one.
The next step
Spend analysis starts with an export from accounting, not a BI project. Two days of categorization deliver a starting position that didn't exist before.
cusoso Target keeps RFQ data continuously analyzable, by category, supplier, and time period, without an annual spreadsheet sprint. Whether it fits your procurement organization is something our quick check shows in 3 minutes.
→ To the quick check