Spend Analysis in Procurement: A Step-by-Step Guide

What is spend analysis?

Spend analysis means collecting, cleaning and grouping your company’s purchase data. It shows what you buy, who you buy it from, who in the company buys it and what you pay. You use it to decide which categories to source again, which suppliers to consolidate and where buying rules are not being followed.

Spend analysis does not save money by itself. It shows you where to look. The saving comes later, when you run a sourcing event, change a contract or stop off-contract buying. A good spend analysis ends with a short list of actions, each with an owner. A long report with no actions is a weak spend analysis.

Short answer. Do spend analysis in six steps:

  1. Decide the question you want to answer
  2. Collect invoice, purchase order and contract data
  3. Clean the data, especially supplier names
  4. Classify each line by what was bought, not by GL code
  5. Analyse by supplier, category and business unit
  6. Act on the findings and track the results with finance

Key takeaways

TopicKey point
PurposeSpend analysis shows where to act. The saving comes from what you do next
DataStart with accounts payable data, because it shows what was actually paid
CleaningGroup all names and codes of the same supplier first, or totals will be wrong
ClassificationClassify by what was bought. GL codes are made for accounting, not sourcing
ActionEach finding needs an action, an owner and a way to measure the result
FrequencyRefresh large categories quarterly and do a full review once a year

What data do you need for spend analysis?

You need data from several systems. Each one tells you something different, and each one has a common problem.

SourceWhat it tells youWhat to watch for
Accounts payable (invoices paid)What was actually paid, to whom and whenItem detail is often missing or vague
Purchase order linesWhat was ordered, the item, quantity and unit priceSpend without a purchase order does not appear
ContractsThe agreed prices and termsContracts are often stored outside any system
Supplier master fileSupplier names, codes, tax numbers and payment termsThe same supplier is often set up more than once
Company cards and expense claimsSmall purchases made outside the purchase order processSupplier names are short and hard to read

Start with accounts payable data, because it covers almost all spend. Then add purchase order lines to get item detail. Use 12 months of data at least, so that seasonal buying evens out.

How do you do spend analysis, step by step?

1. Decide the question you want to answer

Start with a business question, not with the data. For example: “Which categories should we source again next year?” or “How much do we spend outside our contracts?” The question decides which data you need and how far you need to clean it.

2. Collect the data

Pull data from every system and every site that buys. Large companies often have more than one ERP, or a separate system in each country. If one site is missing, its spend will look like zero, and you may wrongly conclude there is nothing to source there.

3. Clean the data

Most of the work is here. The biggest task is grouping all the names and codes of the same supplier. “ABC Ltd”, “ABC Limited” and “A.B.C. Ltd” are one supplier. If you leave them separate, the supplier looks smaller than it is, and you lose your bargaining position.

In India, one supplier often has a separate GSTIN in each state where it is registered. Characters 3 to 12 of the 15-character GSTIN are the supplier’s PAN (TaxGuru). Group suppliers by PAN to see your total spend with each company across all states.

Also check for:

  • Duplicate invoices paid twice
  • Credit notes and returns, so you count net spend
  • Different currencies, converted at one agreed rate
  • Prices with and without GST, freight and other charges mixed together

4. Classify each line by what was bought

Put each line into a category, such as packaging, logistics or IT hardware. Classify by what was actually bought, not by the GL code. GL codes are chosen by accounts staff for accounting. The same item is often booked to different GL codes at different sites.

Use one category list across the whole company. You can build your own, or start from a standard such as UNSPSC, which groups goods and services into four levels from broad to narrow. Keep the list short enough that buyers can use it. For most companies, two or three levels are enough.

Classify distributors carefully. A distributor may sell you cables, tools and safety gear. If you put all of that spend under one category, the category totals will be wrong.

5. Analyse the data

Look at spend by supplier, by category and by business unit. The next section lists the analyses that most often lead to action.

6. Act on the findings and track the results

Turn each finding into an action with an owner and a date. Before you start, agree with finance how savings will be measured. For example, a lower price does not always mean a lower total cost if you also buy more. Track savings that reach the budget, not only savings you identified on paper.

What is a spend cube?

A spend cube is a way to look at spend from three sides at once:

  • Who you buy from: the supplier
  • What you buy: the category
  • Who buys it: the business unit, site or cost centre

The cube lets you answer questions such as “How many suppliers does each plant use for packaging?” or “Which sites buy IT hardware outside our contract?” You do not need special software to start. A spreadsheet pivot table with these three fields is enough for a first look.

Which analyses find the most opportunities?

AnalysisQuestion it answersTypical action
Pareto (80/20)Which few categories and suppliers make up most of the spend?Focus sourcing effort on these first
Supplier count per categoryDo we use too many suppliers for the same thing?Consolidate, then compete through an RFQ or a reverse auction
Price comparison for the same itemDo different sites pay different prices for the same item?Agree one price or one contract for all sites
Off-contract spendHow much do we buy outside agreed contracts?Fix the buying process and remind buyers of the contract
Tail spendHow many suppliers get very little of our spend?Move small purchases to catalogues or fewer suppliers
Payment termsDo suppliers have different payment terms for similar work?Bring terms in line at the next renewal
Duplicate paymentsWas the same invoice paid twice?Recover the money and fix the check in accounts payable

When you compare prices, compare like with like. Compare prices before GST if your company claims GST back as input tax credit. Make sure freight, packing and delivery terms are the same in both prices. A supplier that looks cheaper may simply have left freight out.

What should you do with the findings?

Not every category should be handled the same way. Before you act, place each category in a supplier segmentation model such as the Kraljic matrix. It sorts categories by how much they affect profit and how hard they are to buy.

  • Leverage categories (high spend, many suppliers): compete through an RFQ or a reverse auction.
  • Strategic categories (high spend, few suppliers): build long-term agreements and work with the supplier on cost.
  • Bottleneck categories (low spend, few suppliers): protect supply first, and look for a second supplier.
  • Non-critical categories (low spend, many suppliers): make buying simple, for example with catalogues.

Then plan the sourcing work. A strategic sourcing process takes each priority category from research to contract.

What are the common spend analysis mistakes?

  • Classifying by GL code. The categories look tidy, but they do not match what was actually bought.
  • Not grouping supplier names. Your spend with each supplier looks smaller than it is.
  • Comparing prices on different terms. GST, freight and delivery terms must be the same in both prices.
  • Doing it once. Prices and suppliers change. Data that is a year old leads to the wrong priorities.
  • Counting savings on paper. A lower price agreed is not a saving until it shows in the budget. Agree the method with finance first.
  • Producing a report with no actions. Every finding needs an owner and a date.

How often should you do spend analysis?

Refresh your largest categories every quarter. Do a full review once a year, before you plan the next year’s sourcing. If you clean and classify new data every month as it comes in, each review takes days instead of weeks.

How does Krinati support spend analysis?

Spend analysis tells you which categories to source. Krinati’s eSourcing platform runs the sourcing events that follow, including RFIs, RFQs, RFPs and reverse auctions. Every invitation, bid and award decision is recorded. That record gives you clean price and supplier data for your next spend analysis. For more on using purchase data, see our guide to procurement analytics.

Frequently asked questions about spend analysis

What is spend analysis?

Spend analysis means collecting, cleaning and grouping your company's purchase data so you can see what you buy, who you buy it from, who in the company buys it, and what you pay. You use the results to decide which categories to source again, which suppliers to consolidate and where buying rules are not followed.

What are the steps in spend analysis?

There are six steps. Decide the question you want to answer. Collect the data. Clean it, especially supplier names. Classify each line by what was bought. Analyse it. Then act on the findings and track the results.

What is a spend cube?

A spend cube is a way to look at spend from three sides at once: the supplier, the category of goods or services, and the business unit or site that bought it. It lets you answer questions such as how many suppliers each plant uses for the same category.

What data do you need for spend analysis?

Start with accounts payable invoice data, because it shows what was actually paid. Add purchase order lines for item detail, contract data to check prices against agreed rates, and the supplier master file to group suppliers. Card and expense data cover small purchases.

Why should you not classify spend by GL code?

GL codes are chosen by accounts staff for accounting, not for sourcing. The same item is often booked to different GL codes in different sites, and one GL code can hold many kinds of purchase. Classify each line by what was actually bought instead.

How often should you do spend analysis?

Refresh your largest categories every quarter, and do a full review once a year before you plan the next year's sourcing. A one-time exercise goes out of date quickly, because suppliers, prices and buying patterns change.