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
Retail Procurement DashboardGoogle Sheets · $29E-commerce Procurement DashboardGoogle Sheets · $29SaaS Procurement DashboardGoogle Sheets · $29Restaurant Procurement DashboardGoogle Sheets · $29Café & Bakery Procurement DashboardGoogle Sheets · $29Hotel Procurement DashboardGoogle Sheets · $29Real Estate Procurement DashboardGoogle Sheets · $29Construction Procurement DashboardGoogle Sheets · $29Manufacturing Procurement DashboardGoogle Sheets · $29Logistics Procurement DashboardGoogle Sheets · $29Clinic Procurement DashboardGoogle Sheets · $29Hospital Procurement DashboardGoogle Sheets · $29Dental Practice Procurement DashboardGoogle Sheets · $29Pharmacy Procurement DashboardGoogle Sheets · $29Gym & Fitness Procurement DashboardGoogle Sheets · $29Salon & Spa Procurement DashboardGoogle Sheets · $29Coaching Institute Procurement DashboardGoogle Sheets · $29School Procurement DashboardGoogle Sheets · $29University Procurement DashboardGoogle Sheets · $29Marketing Agency Procurement DashboardGoogle Sheets · $29Consulting Procurement DashboardGoogle Sheets · $29Law Firm Procurement DashboardGoogle Sheets · $29Accounting Firm Procurement DashboardGoogle Sheets · $29Insurance Procurement DashboardGoogle Sheets · $29Banking Procurement DashboardGoogle Sheets · $29Fintech Procurement DashboardGoogle Sheets · $29Automotive Procurement DashboardGoogle Sheets · $29Car Dealership Procurement DashboardGoogle Sheets · $29Agriculture Procurement DashboardGoogle Sheets · $29Food Processing Procurement DashboardGoogle Sheets · $29FMCG Distribution Procurement DashboardGoogle Sheets · $29Wholesale Procurement DashboardGoogle Sheets · $29Kirana Store Procurement DashboardGoogle Sheets · $29Fashion & Apparel Procurement DashboardGoogle Sheets · $29Jewellery Procurement DashboardGoogle Sheets · $29Electronics Store Procurement DashboardGoogle Sheets · $29Furniture Procurement DashboardGoogle Sheets · $29Pharma Procurement DashboardGoogle Sheets · $29Telecom Procurement DashboardGoogle Sheets · $29Solar & Energy Procurement DashboardGoogle Sheets · $29Non-profit Procurement DashboardGoogle Sheets · $29Events Procurement DashboardGoogle Sheets · $29Travel Agency Procurement DashboardGoogle Sheets · $29Media & Publishing Procurement DashboardGoogle Sheets · $29Gaming Procurement DashboardGoogle Sheets · $29Creator Business Procurement DashboardGoogle Sheets · $29Freelancer Procurement DashboardGoogle Sheets · $29Startup Procurement DashboardGoogle Sheets · $29IT Services Procurement DashboardGoogle Sheets · $29Security Services Procurement DashboardGoogle Sheets · $29Cleaning Services Procurement DashboardGoogle Sheets · $29Printing & Packaging Procurement DashboardGoogle Sheets · $29Pet Care Procurement DashboardGoogle Sheets · $29
KPIs in every procurement dashboard
| 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 |