Procurement Dashboard Templates
Ready-made procurement dashboards that shows where money is spent, which suppliers deliver and where you can save. Choose your platform, then your industry.
Choose your platform
Excel
Works offline, opens on any office computer and keeps every formula visible, so you can audit and change it.
Google Sheets
Lives in the cloud, so your whole team sees the same live numbers and you can share it with one link.
Power BI
Handles large data, refreshes from many sources and lets people drill from a yearly total down to a single week.
Looker Studio
Is free, connects straight to Google Sheets, GA4, Google Ads and BigQuery, and shares as a live web link.
The 8 KPIs every procurement dashboard should track
| KPI | What it tells you | Formula |
|---|---|---|
| Total spend | Money spent with suppliers in the period. | SUM of purchase order value |
| Active suppliers | Suppliers with at least one order in the period. | COUNT DISTINCT of suppliers |
| PO cycle time | Average days from purchase request to purchase order. | AVERAGE of (PO date − Request date) |
| Savings achieved | Money saved against the first quoted price. | (Quoted price − Paid price) ÷ Quoted price |
| Supplier on-time rate | Share of deliveries that arrived on time. | On-time receipts ÷ All receipts |
| Cost variance | Difference between planned and actual purchase cost. | (Actual cost − Planned cost) ÷ Planned cost |
| Invoices pending | Supplier invoices not yet paid. | COUNT of unpaid invoices |
| Contract compliance | Share of spend placed under agreed contracts. | Spend on contract ÷ Total spend |
Procurement dashboards by industry
Questions
What is a procurement dashboard?
A procurement dashboard is a single page that shows where money is spent, which suppliers deliver and where you can save. It pulls the key procurement KPIs, such as total spend, active suppliers, pO cycle time and savings achieved, into charts and tables that update when your data changes.
Which tool is best for a procurement dashboard?
Excel suits offline work and small teams. Google Sheets is best for sharing and live collaboration. Power BI handles large data and drill-down. Looker Studio is free and great with Google data. Every Kpiloom procurement dashboard comes in all four.
Which KPIs should a procurement dashboard track?
Start with total spend, active suppliers, pO cycle time, savings achieved, supplier on-time rate, cost variance, invoices pending and contract compliance. The table on this page explains each one and how it is calculated.