What is spend analysis?
Spend analysis is the process of collecting, cleaning and grouping a company's purchase data to see what it buys, from whom and at what price. The goal is to find where money can be saved and where supply risk sits.
Most companies can tell you what they spent last year. Far fewer can tell you how much of it went on packaging, how many vendors they bought it from, and whether two plants paid different prices for the same thing. Spend analysis is the work of answering those questions from your own data.
The four steps
- Collect. Pull purchase data from wherever it lives: vendor bills, purchase orders, the general ledger, expense claims and card statements.
- Clean. Merge duplicate vendors ('ABC Traders', 'A.B.C. Traders Pvt Ltd') and fix obvious errors such as wrong units or missing dates.
- Classify. Put each line into a category, such as raw materials, packaging, freight, IT or facilities, so like can be compared with like.
- Analyse. Look at spend by category, vendor, site and month, and at price differences for the same item.
A worked example
Say a manufacturer spent ₹6 crore on packaging last year. After cleaning the vendor list, it turns out that money went to 23 vendors. Three of them account for ₹4.5 crore. The other 20 share ₹1.5 crore, mostly in small orders placed by different plants, at prices up to 18% higher than the main contract rate for the same cartons.
That picture points to two actions. Put the main cartons out to a competitive reverse auction among the capable vendors, and move the small plant-level orders onto a rate contract so they stop paying the higher price.
What spend analysis usually turns up
- The same item bought at different prices by different sites or buyers.
- Too many vendors for one category, each getting too little volume to offer a good price.
- Heavy reliance on one supplier for something critical.
- Tail spend: lots of small, unmanaged purchases that add up.
- Spend that bypasses purchase orders, also known as maverick spend.
Spreadsheet or tool
A first spend analysis can be done in a spreadsheet, and many teams start that way. It gets hard to repeat, because every export needs the same cleaning each time. Tools help by remembering how columns and vendors were mapped and by rerunning the analysis on new data. Procupy Lens does this from ledger, bill and budget exports, and flags categories spread across many vendors as sourcing opportunities.
Frequently asked questions
What is the purpose of spend analysis?
To see clearly what the company buys, from whom and at what price, so procurement can decide where to negotiate, consolidate vendors or run a sourcing event first.
How often should spend analysis be done?
A full analysis once a year is common, with a lighter monthly or quarterly refresh of the main categories so changes in price or vendor mix are caught early.
What data do you need for spend analysis?
Vendor bills or accounts payable data at minimum. Purchase orders, the general ledger and expense claims fill in the gaps and make it easier to classify spend correctly.