Ready-to-use Excel template with the 10 critical procurement KPIs: savings, contract spend, OTD, lead time, defects and more. Automatic dashboard with traffic lights and world-class benchmarks.
100% free · Instant download with your corporate email
Procurement KPIs are quantitative metrics that allow the purchasing function to measure efficiency, spend control, supplier quality and financial value contribution. Without them, procurement operates blind and loses credibility with the CFO and the C-suite.
This template gathers the 10 must-have procurement KPIs for mid-size and large companies in Latin America, with definition, formula, world-class benchmark and an automatic dashboard that recalculates as you load monthly data.
Designed for CPOs, procurement managers and analysts who need to report objective results, justify digital transformation investments and benchmark their operation against international standards.
Σ (reference price − negotiated price) × volume. Benchmark: 5–8% of managed spend.
Spend under contract / Total spend. Measures contract discipline. Target ≥ 85%.
Off-process spend / Total spend. Inverse discipline indicator. Target ≤ 5%.
POs delivered on time / Total POs. Measures supplier compliance. Target ≥ 95%.
POs with non-conformances / Total POs. Supplier quality. Target ≤ 2%.
Average days from request to delivery. Operational speed. Target ≤ 5 days (indirect).
Evaluated suppliers / Active suppliers. SRM program maturity. Target ≥ 90%.
Critical / Active suppliers. Risk concentration. Target ≤ 10%.
Invoices matched first time (3-way match) / Invoices received. AP efficiency. Target ≥ 92%.
POs processed per buyer FTE / month. Benchmark: 120–180 POs/month.
The Dashboard reads the last row in Operations Data and calculates the 10 KPIs without intervention.
Sheet with definition, formula and world-class benchmark — ready to present to the executive committee.
Green/yellow/red status against an editable target. Instant visibility of critical KPIs.
6 months of realistic pre-loaded data to explore dashboard behavior instantly.
The 10 most important procurement KPIs are: savings achieved, % contract spend, maverick spend, OTD (on-time delivery), defect rate, average lead time, supplier evaluation coverage, % critical suppliers, first-pass match rate and buyer productivity. This template calculates them all automatically.
Savings are calculated as the sum of (reference price − negotiated price) × purchased volume over a given period. The reference price can be the historical price, the market price or the baseline approved by finance.
In mature procurement organizations the world-class benchmark is ≥ 85% of total spend executed under negotiated contracts. Below 70% signals weak contract discipline and significant lost savings opportunities.
Yes. Egixia's entire resource library is 100% free, no forms and no email chain. We believe practical procurement tools should be accessible to every LATAM professional.
Leave your corporate email and download the template instantly — 100% free, no spam. Compatible with Excel and Google Sheets. Includes 6 months of sample data, automatic dashboard, 10-KPI catalog and a usage guide.
🙏 Found it useful? Help us reach more procurement professionals by following us on LinkedIn.
Follow Egixia on LinkedInEgixia integrates with your ERP and calculates procurement KPIs automatically every day — no Excel, no waiting for month-end. Book a 30-minute demo.
Schedule strategic demo