Kpiloom

Google Sheets Procurement Dashboard Templates

A procurement dashboard shows where money is spent, which suppliers deliver and where you can save. Pick your industry below to see a live preview of the Google Sheets version.

Choose your industry

KPIs in every procurement dashboard

KPIWhat it tells youFormula
Total spendMoney spent with suppliers in the period.SUM of purchase order value
Active suppliersSuppliers with at least one order in the period.COUNT DISTINCT of suppliers
PO cycle timeAverage days from purchase request to purchase order.AVERAGE of (PO date − Request date)
Savings achievedMoney saved against the first quoted price.(Quoted price − Paid price) ÷ Quoted price
Supplier on-time rateShare of deliveries that arrived on time.On-time receipts ÷ All receipts
Cost varianceDifference between planned and actual purchase cost.(Actual cost − Planned cost) ÷ Planned cost
Invoices pendingSupplier invoices not yet paid.COUNT of unpaid invoices
Contract complianceShare of spend placed under agreed contracts.Spend on contract ÷ Total spend