Series · Tool #1 of 6 · Phase 1 — Strategic Analysis

Spend Analysis : The foundation of every category strategy

How to identify where your money really goes — and discover the 20 to 40% of "phantom spending" that your ERP doesn't see.

● 13 min read● Tool #1 — Spend Analysis● Level: Junior → Intermediate

Most category managers think they know their spend. Really. You have your SAP reports, your Ariba extractions, your monthly departure sheets. You have the numbers.

Except the reality is this: you're underestimating your real spend by 20 to 40%. Shadow spending lingering on corporate cards. Decentralized purchases by business units directly from local suppliers. Tail spend hidden in 300 small suppliers. Expense reports that never make it back to the ERP. Unmatched POs hiding real purchases. And sometimes entire categories you "forget" because they're not in the procurement budget.

You can't optimize what you don't measure. And you can't negotiate effectively when you're off on real volumes by 20%.— Principle #1 of Category Management

Spend Analysis is step zero. Not the attention-grabbing title of your category strategy, not the quick win, not the tool that shines. It's the foundation on which every subsequent strategic decision rests. You get this wrong, everything that comes after collapses.

01

What is Spend Analysis?

Spend Analysis is a systematic and structured analysis of procurement spending. Its objective: answer one single question that determines everything. Where does the money go?

It works at three nested levels:

1

Descriptive level (What?)

Simply map: how much you spend, with whom, in which categories, when. This is the raw snapshot.

2

Diagnostic level (Why?)

Understand the patterns: why you have 300 small suppliers instead of 5 large ones. Why 40% of your spend escapes contracts. Why the France BU negotiates differently than the Germany BU.

3

Predictive level (What if?)

Anticipate: if we consolidate suppliers, how much do we save. If we increase contract coverage, what do we save. If we standardize references, how much do we reduce administrative costs.

Most analyses stop at level 1. They produce a report "we spend 47M€" with no action. The real work — the work that changes results — happens at levels 2 and 3.

02

The 6 key analysis dimensions

A Spend Analysis is only complete if it explores the 6 fundamental dimensions of your spending. Each one reveals different opportunities.

Dimension 1

By category

Breakdown by type of purchase: IT, Marketing, Facilities, Maintenance, HR, etc.

What is our largest spend? Where should we focus efforts?

Dimension 2

By supplier

Identification of concentrations. Top 10, Top 20. Critical dependencies. Tail spend (suppliers < 10k€/year).

How many suppliers? What do the top 10 represent?

Dimension 3

By Business Unit

Distribution of purchases by entity: subsidiaries, divisions, regions. Detection of disparities and decentralization.

Who spends what? Can we consolidate volumes?

Dimension 4

By geography

Location of purchases and suppliers. Regional consolidation opportunities, local sourcing, currency arbitrage.

Do we have the same suppliers in each country?

Dimension 5

Over time

YoY trends, seasonality, order peaks. Identification of purchase patterns, volatility, growth.

Growth or stability? Is there seasonality?

Dimension 6

By type of purchase

Distribution between contracted vs off-contract purchases, formalized POs vs non-PO, maverick buying, corporate cards.

What % of spend is covered by a contract?

Each of these 6 dimensions generates different insights. Together, they create a 360° view of your procurement reality.

03

The 5 steps for a complete Spend Analysis

Step 1: Data collection

This is the foundation. Without complete data, everything collapses. Typical sources are:

• ERP (SAP, Oracle, IFS): raw extraction of invoices and payment entries
• P2P Modules (Ariba, Coupa): purchase orders, contracts, validations
• Corporate cards (American Express, Visa): decentralized purchases
• Expense reports: spending that bypasses formal procedures
• Off-ERP contracts: those you forgot or never entered

Critical timeframe: minimum 12 months, ideally 24-36 months to capture seasonal variations and see trends. A single quarter extraction is distortion.

Format: raw extraction with ALL relevant fields. Date, amount, supplier, category, Business Unit, cost center, purchase order number, currency. No pre-aggregation. Data cleaning is your job.

Step 2: Data cleaning

Essential operations:

• Supplier normalization: "IBM", "IBM France", "I.B.M. SARL" = single record in your database
• Deduplication: removal of duplicate entries
• Currency conversion: use the average rate for the period, not the day's rate
• Scope exclusion: salaries, taxes, irrelevant purchases based on your scope
• Outlier correction: obviously wrong amounts to validate manually

Use Excel or a data cleaning tool (OpenRefine, Trifacta, or a Python script if you're comfortable). Document each transformation. You'll need to justify why you changed the data.

Step 3: Categorization

A recommended taxonomy on 3 levels:

• Level 1 (Category): IT, Marketing, Facilities, Maintenance, Production, Services, etc.
• Level 2 (Subcategory): IT Hardware, IT Software, IT Services
• Level 3 (Product/Service): Laptops, Servers, SaaS Licenses

Partial automation is possible with AI (classification algorithms on invoice descriptions), but manual validation is mandatory for all amounts > 100k€. Large amounts miscategorized skew everything.

Step 4: Analysis

Now that the data is clean, the analysis. Key calculations:

• 80/20 rule: 20% of suppliers represent what % of spend?
• Supplier concentration: Top 10 = ? % of total
• Maverick spend: % of off-contract purchases
• Tail spend: Number of suppliers < 10k€/year (warning: often 60-70% of total number, but 2-5% of spend)
• Contract coverage: % of spend covered by a formalized agreement
• YoY evolution: Growth or reduction in spend by category

These 6 metrics give you 80% of real understanding. Stop. Don't get lost in 200 graphs.

Step 5: Actionable insights

Not an 80-slide report. Five priority opportunities with estimated impact in euros. One executive page for your director.

Format: Opportunity | Initial situation | Action | Potential savings | Timeline.

04

Typical opportunities revealed (with real numbers)

Here's what we systematically find. The numbers are realistic and come from real consolidation projects.

These opportunities aren't "maybes". These are patterns we find in 90% of companies. The question isn't "will we have one?", it's "which one do we attack first?"

05

The Spend Analysis dashboard (what it must contain)

Forget 100-page reports. A good Spend Analysis dashboard contains exactly these KPIs. Nothing less, nothing more.

Total Spend Analyzed

47.2M€

Total amount in scope + % vs budget

Number of suppliers

847

Active suppliers in the period

Top 10 suppliers

67%

% of total spend

Maverick Spend

34%

% of off-contract purchases

Tail Spend

631 suppliers

< 10k€/year = 2.8% of spend

Contract Coverage

58%

% of spend under formalized contract

These 6 numbers are enough to guide 90% of your category strategy. Update the dashboard quarterly. Track trends.

06

Common mistakes (to absolutely avoid)

07

The place of Spend Analysis in your complete strategy

Spend Analysis alone changes nothing. It's what you do with it that matters. Here's how this tool feeds all your other category management tools:

🔗 The logical sequence

Spend Analysis → identifies where the money goes and what the real issues are

Porter's Five Forces (Article #2) → evaluates your negotiation position on these categories

Kraljic Matrix (Article #3) → prioritizes where to pursue aggressive vs collaborative strategy

Supplier Segmentation (Article #4) → determines which suppliers to work with in depth

Cost Breakdown / Should-Cost (Article #5) → provides numbered arguments for negotiation

Category Strategy Canvas (Article #6) → synthesizes everything in a 2-3 year plan

Skipping Spend Analysis is building on sand. You analyze the wrong categories, you prioritize poorly, your strategy fails. All the following tools lose their relevance.

A good Spend Analysis prevents 10 bad strategies. It's the cheapest investment you can make.— The Reality of Project Management in Procurement

In summary

Spend Analysis is the foundation. Here's what it gives you:

• Visibility: you finally know where your money really goes (beyond what the ERP says)
• Fact-base: your category decisions rest on data, not impressions
• Opportunities: you systematically identify where to create leverage (consolidation, contracts, standardization)
• Baseline: a reference point to measure your savings in 6 months
• Alignment: you have shared numbers with the CFO, operations, and the business

Next time a supplier announces a price increase, you'll have numbers. You'll know exactly how much you buy from him per year, at what current price, with what alternatives, in what market context. And that changes everything in negotiation.

Now that you know where the money goes, the next step is understanding your negotiation position on each market. That's the subject of Article #2: Porter's Five Forces.

Next article in the series

Article #2: Porter's Five Forces — Evaluate your negotiation position on each supplier market.

Read article #2 →