Procurement Spend Sankey Diagram: Editable Template
Follow spend from business unit to category to supplier and see how concentrated it is. Replace the amounts with your spend cube data to find where the money goes.
A spend Sankey follows money from the part of the business that buys, through what it buys, to who it buys from. Concentration in a few categories or suppliers is visible at a glance.
Four business units spend 7.8 million euros across six categories and eleven suppliers. Reading left to right answers who spends, on what, and with whom.
It is a view of spend you have already compiled, usually from invoices or a purchasing system, not a source of savings by itself. The amounts are invented. Use the same period and currency throughout, and group very small suppliers into one node.
How to read this diagram
- Total spend is 7,800 k€; Operations accounts for 54% of it.
- Raw materials is the largest category at 3,000 k€ (38%), and Supplier A alone receives 1,800 k€ (23% of total spend).
- Software and cloud (1,600 k€) is bought by two units and concentrated in one cloud vendor.
- Facilities has a single supplier, which may be a concentration risk or a negotiating opportunity.
The data behind it
Invented spend for one year. Not data about any real company.
| From | To | Amount (k€) |
|---|---|---|
| Operations | Raw materials | 3000 |
| Operations | Logistics | 900 |
| Operations | Facilities | 300 |
| IT | Software and cloud | 1300 |
| IT | Hardware | 500 |
| Marketing | Professional services | 900 |
| Marketing | Software and cloud | 300 |
| HR | Professional services | 400 |
| HR | Facilities | 200 |
| Raw materials | Supplier A | 1800 |
| Raw materials | Supplier B | 900 |
| Raw materials | Other material suppliers | 300 |
| Logistics | Carrier X | 600 |
| Logistics | Carrier Y | 300 |
| Software and cloud | Cloud vendor | 1000 |
| Software and cloud | Other software vendors | 600 |
| Hardware | Hardware reseller | 500 |
| Professional services | Agency | 700 |
| Professional services | Consultancy | 600 |
| Facilities | Facilities provider | 500 |
The same data as CSV
source,target,value
Operations,Raw materials,3000
Operations,Logistics,900
Operations,Facilities,300
IT,Software and cloud,1300
IT,Hardware,500
Marketing,Professional services,900
Marketing,Software and cloud,300
HR,Professional services,400
HR,Facilities,200
Raw materials,Supplier A,1800
Raw materials,Supplier B,900
Raw materials,Other material suppliers,300
Logistics,Carrier X,600
Logistics,Carrier Y,300
Software and cloud,Cloud vendor,1000
Software and cloud,Other software vendors,600
Hardware,Hardware reseller,500
Professional services,Agency,700
Professional services,Consultancy,600
Facilities,Facilities provider,500How it works
Extract spend by unit, category and supplier
Use one year of invoices or purchase orders with consistent category and supplier names.
Group the long tail
Keep the largest suppliers by name and group the rest within each category.
Enter the three levels
Type the unit-to-category and category-to-supplier amounts.
Check totals
Each category should send out exactly what it received.
Frequently asked questions
Does the chart find savings?
It shows where the money goes. Savings come from analysing price, volume and contracts for the large flows it points to.
How many suppliers can I show?
Around ten to fifteen stay readable. Group smaller ones into an Other node per category.
Edit this spend Sankey
Open the example as your own chart and enter your spend by unit, category and supplier.