How to Run a Spend Analysis: A Step-by-Step Guide for Procurement Teams

Your CFO just asked why supplier costs rose 12% this year, and you don't have a clear answer. You're not alone. Most procurement teams sit on a mountain of messy data—spreadsheets, ERP exports, and invoice PDFs—but can't turn it into decisions. A spend analysis is the first step to fixing that. In this guide, I'll walk you through a practical, step-by-step method to run a spend analysis that uncovers savings, reduces risk, and strengthens supplier relationships. Whether you're a category manager at a Fortune 500 or a sourcing director, this process works—if you follow it rigorously.

Why Spend Analysis Matters (and What It Really Costs to Skip It)

Spend analysis is the process of collecting, cleansing, classifying, and analyzing your organization's procurement spend to identify savings opportunities, consolidate suppliers, and mitigate risk. Without it, you're flying blind. A typical enterprise spends 50–70% of its revenue on external goods and services, yet most can't tell you what they buy from whom, at what price, and under what terms. That lack of visibility costs money—studies show that companies with mature spend analysis capabilities save 3–8% annually on procurement costs. For a $1B company, that's $30–80M in savings. Skipping it means leaving that money on the table.

But spend analysis isn't just about savings. It's about risk. Without a clear view of your spend, you might be overly dependent on a single supplier in a high-risk region, or paying for duplicate software licenses you don't use. A thorough analysis reveals these issues before they become crises. The process takes time—typically 4–8 weeks for a mid-size company, longer for global enterprises—but the payoff is immediate and compounding.

Step 1: Define Your Objectives and Scope

Before you pull a single report, decide what you're trying to achieve. Are you focusing on cost reduction, supplier consolidation, compliance, or risk mitigation? Your objective determines the data you need and the analysis you'll perform. For example, if you're targeting cost savings, you'll need detailed line-item data. If you're focusing on risk, you'll need supplier location and financial health data.

Cost savings: identify spend categories with high price variance or maverick spend.
Supplier consolidation: find categories with multiple suppliers for the same product or service.
Compliance: check for spend with non-contracted suppliers or off-contract pricing.
Risk mitigation: map spend by supplier location, financial stability, and criticality.
Budgeting: forecast future spend based on historical patterns and contract renewals.

Define your scope: which entities, geographies, and time period? For a global enterprise, start with the top 80% of spend—usually the top 20% of suppliers. For a first-time analysis, limit yourself to 12–24 months of data. Don't try to boil the ocean; you can expand later.

Step 2: Collect and Cleanse Your Data

This is the least glamorous but most critical step. Your data lives in multiple systems: ERP (SAP, Oracle), procurement platforms (Coupa, Ariba), expense management tools (Concur), and maybe even spreadsheets. Pull everything you can: purchase orders, invoices, expense reports, and procurement card transactions. Aim for at least 90% of your total spend—anything less and your analysis will be skewed.

Once collected, you'll need to cleanse the data. Expect duplicates, missing fields, inconsistent supplier names (e.g., 'IBM' vs 'International Business Machines'), and currency mismatches. A typical dataset has 10–20% errors. Use a data cleansing tool or a dedicated spend analysis software like SpendHQ, Sievo, or Zycus. If you're doing it manually in Excel, allocate at least 2–3 weeks for this step alone.

Remove duplicates: merge records with the same invoice number or purchase order.
Standardize supplier names: create a master supplier list with a unique ID for each.
Normalize currencies: convert all spend to a single base currency using average monthly exchange rates.
Fill missing categories: use commodity codes (e.g., UNSPSC) or manual review to classify uncategorized items.
Validate dates: ensure transaction dates fall within your analysis period.

Step 3: Classify Your Spend by Category and Supplier

Now that your data is clean, you need to classify each transaction into a spend category. This is where the real insight begins. Use a standard taxonomy like UNSPSC (United Nations Standard Products and Services Code) or a custom hierarchy that matches your business. For example, you might have categories like 'IT Hardware', 'Professional Services', 'Raw Materials', and 'Logistics'. Each transaction should map to a leaf-level category, not just a high-level bucket.

Next, assign each supplier to a parent company. This is crucial for consolidation. For instance, if you buy from 'Acme Corp' and 'Acme Ltd', they might be the same parent. Use tools like D&B Hoovers or Bloomberg to map subsidiaries. You'll often discover that you have 50 suppliers that are all part of the same parent, hiding your true spend concentration.

Use a mix of automated classification (based on supplier industry codes) and manual review for accuracy.
Create a supplier hierarchy: parent company → subsidiary → legal entity.
Tag spend with additional attributes: business unit, cost center, region, contract vs. non-contract.
Aim for at least 95% classification accuracy; the remaining 5% is acceptable if it's low-value spend.

Step 4: Analyze the Data—Identify Patterns and Opportunities

With clean, classified data, you can now run the actual analysis. Start with high-level summaries: total spend by category, by supplier, by business unit. Then drill down to find anomalies. For example, you might see that your marketing category has 30 different agencies, when 3 could handle the workload. Or that your IT hardware spend is split across 5 distributors, each with different pricing.

Key analyses to run: spend concentration (top 10 suppliers as % of total), maverick spend (purchases outside contracts), price variance (same SKU at different prices from different suppliers), and supplier risk (financial health, geographic concentration). You can use pivot tables in Excel or specialized analytics in your spend analysis tool. The goal is to surface actionable insights, not just pretty charts.

Top 20% of suppliers often account for 80% of spend—focus your effort there.
Maverick spend typically ranges from 10–30% of total spend; each percentage point represents potential savings.
Price variance of 10–20% for the same product across suppliers is common—negotiate or consolidate.
Supplier concentration risk: if one supplier is >20% of spend, have a contingency plan.
Look for tail spend (the long tail of low-value suppliers)—it may be 20% of spend but 80% of invoices.

Step 5: Develop Actionable Recommendations and Prioritize

Analysis without action is just a report. Turn your findings into a prioritized list of initiatives. Use a simple framework: impact (potential savings or risk reduction) vs. effort (time, resources, political capital). High-impact, low-effort items are quick wins—do those first. For example, consolidating two similar suppliers into one might save $500K with minimal disruption. Low-impact, high-effort items can wait or be dropped.

For each recommendation, quantify the potential benefit and the cost to implement. Be realistic: a supplier consolidation might take 6–12 months and require legal review. A renegotiation of a contract might take 3–6 months. Include risks: what if the new supplier can't deliver? Have a mitigation plan. Present your recommendations to stakeholders with a clear business case, and get their buy-in before proceeding.

Create a list of 10–15 potential initiatives from your analysis.
Score each on a 1–5 scale for impact and effort.
Plot them on a 2x2 matrix (impact vs. effort) to prioritize.
For the top 5, develop a one-page business case with savings, timeline, and risks.
Review with your CFO and key stakeholders, then select the top 3 to execute this quarter.

Step 6: Implement and Track Results

The final step is execution. Assign an owner for each initiative, set a timeline, and define KPIs. For example, if you're consolidating suppliers, track the number of suppliers in that category monthly. If you're renegotiating a contract, track the new pricing vs. old. Use a simple dashboard in Excel or your procurement system to monitor progress. Review monthly with your team to ensure you're on track.

Don't expect immediate results. Supplier consolidation takes time to transition volumes. Price renegotiations might take effect only after the current contract expires. But within 6–12 months, you should see measurable savings. Track both hard savings (price reductions, contract compliance) and soft savings (time saved, risk avoided). Report these to leadership to build credibility for future spend analysis projects.

Set up a monthly spend review meeting with your team.
Use a scorecard: track spend by category, % maverick spend, supplier count, and savings realized.
Celebrate wins—even small ones—to maintain momentum.
Re-run the spend analysis annually to update your data and identify new opportunities.

Common Mistakes to Avoid

Even experienced teams stumble. Here are the most common pitfalls I've seen in spend analysis projects—and how to avoid them.

Garbage in, garbage out: skipping data cleansing leads to misleading insights. Invest time in cleansing or use a tool—it's worth it.
Scope creep: trying to analyze 100% of spend across all entities can paralyze the project. Start with 80% of spend and expand later.
Ignoring tail spend: it's easy to focus on top suppliers, but tail spend often hides 10–15% savings. Use automation to manage it.
Analysis paralysis: spending months on perfect data instead of making decisions. Accept 90% accuracy and move forward.
Lack of stakeholder buy-in: if you don't involve budget owners early, they'll resist changes. Communicate findings and involve them in prioritization.
Not tracking results: without follow-up, your recommendations gather dust. Assign owners and hold them accountable.

Conclusion: Your Next Steps

A spend analysis is not a one-time project—it's a discipline. The key takeaways: start with clear objectives, invest in data quality, classify meticulously, and turn insights into action. Don't let perfectionism delay you. Pull your data this week, even if it's messy—just start. Within a month, you'll have a clearer picture of your spend than 90% of your peers. That visibility is the first step to becoming a strategic procurement leader.

Your next move: schedule a 90-minute working session with your team to scope the first iteration. Use the steps above as your agenda. Then, commit to running a full analysis within the next 8 weeks. The savings you uncover will fund the effort many times over.