Spend analysis is the discipline of understanding what your organisation actually buys, from whom, and where the money goes. It's the foundation of every savings programme: you can't consolidate suppliers, tackle tail spend or negotiate better rates until you can see the picture clearly. This free Excel template turns a list of transactions into an instant breakdown by category and department using built-in formulas, so you can find your biggest opportunities without building a pivot table from scratch.
Why spend analysis is the first step to savings
Most organisations underestimate how fragmented their buying is. Spend analysis reveals the truth: how much goes to each category, how many suppliers you use for the same thing, and how much sits in low-value 'tail' spend that quietly consumes admin time.
With that visibility, savings become obvious. You can consolidate overlapping suppliers, move tail spend onto a marketplace, negotiate from a position of knowledge, and target the categories where a small percentage saving is worth the most money.
How to use this spend analysis template
Turn your purchase data into insight in a few steps:
- Export your purchase transactions and paste them into the 'Spend data' sheet.
- Keep the column order — date, supplier, category, department, amount.
- List your real categories and departments in the 'Summary' sheet tables.
- Read the automatic totals, percentages and grand total.
- Focus on the largest categories and the longest tail for savings.
Spend analysis best practices
Consistent categorisation is everything — the same item should always land in the same category, or your totals mislead you. Analyse a full 12 months to smooth out seasonality, and combine category and supplier views to spot where you're buying the same thing from many suppliers. Re-run the analysis regularly to track whether your savings actions are working.
Download the Spend Analysis Template
Free, editable Excel (.xlsx). Complete the form above and your download starts instantly.
Common questions
What is a spend analysis template?
A spend analysis template is a spreadsheet that aggregates your purchase transactions by category, supplier and department so you can see where money is spent and identify savings and consolidation opportunities.
How does the spend analysis template work?
You paste your transactions into the data sheet; the summary sheet uses SUMIF formulas to total spend by category and department and shows each category's share of total spend automatically.
Is this spend analysis template free?
Yes. Enter your work email above and the editable Excel file downloads immediately, at no cost.
What is tail spend?
Tail spend is the large number of small, low-value purchases — often from many suppliers — that together add up to a meaningful amount and a disproportionate admin burden. The '% of total' column helps you spot it.
More free procurement tools
Supplier Evaluation Template
A weighted, criteria-based Excel scorecard to compare and select suppliers objectively.
Procurement KPI Dashboard Template
An Excel dashboard that tracks your procurement KPIs against target with automatic RAG status.
All free tools & templates
Browse every Lapasar procurement calculator and template.