A procurement dashboard template is a spreadsheet that turns purchase and contract data into one page of headline numbers: spend, savings, cycle time and compliance. It shows procurement leaders where money goes and where buying slows down.
It is a ready-built workbook where you paste raw purchasing data on one tab and read the results on another. Formulas roll every purchase order up into totals, percentages and averages, so the headline page updates when the data does.
Procurement leads use it for the monthly review with finance, and to answer the questions a CFO asks most: how much did we spend, how much did we save, and how much of it went through the agreed process. Read more on what belongs on a procurement dashboard.
Teams without a reporting tool often run procurement reporting entirely from a template like this. Larger teams keep one as a sandbox for testing new KPIs before they build them into a business intelligence tool.
Total spend for the period, split by category, department and supplier.
Five to ten measures, each with a target, last month's figure and a status.
Negotiated savings against an agreed baseline, split into cost reduction and cost avoidance.
Spend under management, PO compliance and spend outside policy.
Approval and request-to-PO cycle times, plus the open request pipeline by stage.
Ready to use in Excel and Google Sheets. Fill it in, save it, reuse it.
Export every PO raised in the month from your ERP or purchasing tool and paste it onto the Data tab.
Map each line to a category and fix supplier names, so one supplier never appears under two spellings.
Formulas work out spend, compliance, cycle times and savings. Nothing on the dashboard is typed by hand.
Walk through the dashboard with finance each month, starting with the KPIs marked Off track.
Give each off-track KPI one owner and one fix, then check next month whether it moved.
The simplest usable version is one tab with Supplier, Category, PO date, Amount and On contract (Y/N), plus two totals: monthly spend and the share of it on contract.
Keep the dashboard to one screen. Six KPIs is enough for a monthly review, and anything more belongs on the KPI tracker tab. Put the reporting month in cell B1 as the first day of the month and every formula filters on it.
| KPI | Target | This month | Last month | Status |
|---|---|---|---|---|
| Spend under management | 85% | 78% | 76% | Watch |
| PO compliance | 95% | 96% | 91% | On track |
| Spend outside policy | 5.0% | 4.2% | 6.1% | On track |
| Approval cycle time (days) | 3.0 | 3.2 | 4.1 | Watch |
| Request-to-PO time (days) | 5.0 | 6.2 | 6.8 | Off track |
| Savings, quarter to date | 45,000 | 52,800 | 31,400 | On track |
Illustrative figures for a fictional company, September 2026. Status rules are in Part 2.
Works in Excel and Google Sheets. One row per purchase order, headers in row 1, formulas copied down.
| Col | Header | Entry or formula | What it does |
|---|---|---|---|
| A | Request ID | Text | Links the PO back to the original request |
| B | Department | Drop-down | Who asked for the purchase |
| C | Supplier | Text, one spelling per supplier | Who you are buying from |
| D | Category | Drop-down from your category list | Feeds the spend view |
| E | Request date | Date | When the request was raised |
| F | Approval date | Date | When the final approver signed off |
| G | PO date | Date | When the PO went to the supplier |
| H | Amount | Currency | Committed value of the PO |
| I | On contract | Y or N | Y if bought under an agreed contract or price list |
| J | PO before invoice | Y or N | N if the invoice arrived before the PO |
| K | Approval days | =IF(F2='', | Request to approval |
| L | Request-to-PO days | =IF(G2='', | Request to PO issued |
| M | Month | =IF(G2='', | First day of the PO month, used by every dashboard filter |
B1 on the Dashboard tab holds the reporting month, entered as the first of the month.
| KPI | Formula |
|---|---|
| Total spend this month | =SUMIFS(Data!H:H, |
| Spend under management | =SUMIFS(Data!H:H, |
| PO compliance | =COUNTIFS(Data!M:M, |
| Approval cycle time | =AVERAGEIFS(Data!K:K, |
| Request-to-PO time | =AVERAGEIFS(Data!L:L, |
| Savings, quarter to date | =SUMIFS(Savings!F:F, |
Pick KPIs that match what leadership already asks about, rather than the longest list you can find. Spend under management and request-to-PO time are good first choices, because one shows control and the other shows how fast the business gets what it needs. For definitions of more measures, see these procurement KPIs.
| KPI | Formula | What it tells you |
|---|---|---|
| Spend under management | Spend on contract ÷ total spend | How much spend follows agreed terms and prices |
| PO compliance | POs raised before the invoice ÷ all POs | Whether people buy first and ask later |
| Spend outside policy | Spend with no approval or contract ÷ total spend | Leakage that bypasses procurement |
| Approval cycle time | Average days, request to final approval | Where requests wait for sign-off |
| Request-to-PO time | Average days, request to PO issued | How long the business waits overall |
| Savings achieved | Baseline cost minus negotiated cost | The value procurement adds in money |
| Savings rate | Savings ÷ baseline of negotiated spend | How hard each negotiation pushed |
| Renewals decided on time | Renewals decided before notice date ÷ renewals due | Whether auto-renewals slip through |
| Top-20 supplier share | Spend with top 20 suppliers ÷ total spend | How much buying power sits with a few suppliers |
| Cost per PO | Procurement running cost ÷ POs issued | Efficiency of the team itself |
Column B says whether higher or lower is better, C holds the target and D this month's value.
| Col | Header | Entry or formula | What it does |
|---|---|---|---|
| A | KPI | Text | Name exactly as on the dashboard |
| B | Direction | Drop-down: Higher, Lower | Which way is good |
| C | Target | Number or % | Agreed with finance for the year |
| D | This month | Formula from the Dashboard tab | Current value |
| E | Last month | Number | Pasted as a value at each month-end |
| F | Change | =D2-E2 | Movement since last month |
| G | Status | =IF(B2='Higher', | Within 10% of target is Watch, beyond that is Off track |
Savings are the number most likely to be challenged, so the tracker separates the two kinds. Cost reduction lowers what you paid last time and shows up in the budget, while cost avoidance beats a higher quote or list price and does not. The difference is explained in cost savings vs cost avoidance.
| Supplier | Type | Baseline | Negotiated | Savings | Savings % |
|---|---|---|---|---|---|
| Brightline Software | Cost reduction | 48,000.00 | 40,800.00 | 7,200.00 | 15.0% |
| Kestrel Data | Cost avoidance | 36,000.00 | 30,600.00 | 5,400.00 | 15.0% |
| Northwind Logistics | Cost reduction | 120,000.00 | 112,800.00 | 7,200.00 | 6.0% |
| Harbour Facilities | Cost avoidance | 22,000.00 | 19,800.00 | 2,200.00 | 10.0% |
| Acme Office Supply | Cost reduction | 9,600.00 | 8,640.00 | 960.00 | 10.0% |
| Total | 235,600.00 | 212,640.00 | 22,960.00 | 9.7% |
Illustrative data. Brightline's baseline is last year's contract; Kestrel's is the vendor's first quote.
One row per negotiation, headers in row 1, formulas copied down.
| Col | Header | Entry or formula | What it does |
|---|---|---|---|
| A | Supplier | Text | Same spelling as the Data tab |
| B | Category | Drop-down | For savings by category |
| C | Savings type | Drop-down: Cost reduction, Cost avoidance | Budget impact or not |
| D | Baseline | Currency | Last price paid, or first quote for new purchases |
| E | Negotiated | Currency | Final agreed annual cost |
| F | Savings | =D2-E2 | Money saved against the baseline |
| G | Savings % | =IF(D2=0, | Savings as a share of the baseline |
| H | Date signed | Date | Used by the quarter-to-date total |
| I | Validated | Y or N | Y once finance agrees the baseline |
| Summary | Formula |
|---|---|
| Total savings | =SUM(F2:F500) |
| Cost reduction only | =SUMIFS(F2:F500, |
| Cost avoidance only | =SUMIFS(F2:F500, |
| Overall savings rate | =SUM(F2:F500)/SUM(D2:D500) |
| Savings validated by finance | =SUMIFS(F2:F500, |
Categories only work if every PO line carries one, so lock the Category column to a drop-down list. The same SUMIFS pattern answers most follow-up questions from finance, from one department's spend to one supplier's year to date.
Illustrative September spend of 438,900.00 by category.
| View | Formula |
|---|---|
| Spend in one category | =SUMIFS(Data!H:H, |
| Category share of the month | =SUMIFS(Data!H:H, |
| Spend for one department | =SUMIFS(Data!H:H, |
| One supplier, all months | =SUMIF(Data!C:C, |
| Off-contract spend this month | =SUMIFS(Data!H:H, |
Cycle time tells you that buying is slow; the pipeline tells you where. Paste your open request list onto a Pipeline tab with the current stage and the date each request entered it.
| Stage | Open requests | Longest wait (days) | Value | Status |
|---|---|---|---|---|
| Submitted | 6 | 3 | 41,200.00 | Moving |
| Budget approval | 4 | 9 | 88,500.00 | Slow |
| Security and legal review | 3 | 14 | 126,000.00 | Stuck |
| Negotiation | 2 | 8 | 210,000.00 | Slow |
| Total open | 15 | 465,700.00 |
Illustrative pipeline as at 30 Sep 2026. Slow means 7-10 days in one stage; stuck means over 10.
| Measure | Formula |
|---|---|
| Days in current stage | =TODAY()-F2 |
| Open requests in one stage | =COUNTIFS(Pipeline!D:D, |
| Value waiting in one stage | =SUMIFS(Pipeline!C:C, |
| Requests over 10 days in a stage | =COUNTIFS(Pipeline!G:G, |
Pipeline tab columns: A Request ID, B Department, C Value, D Stage, E Open or Closed, F Date entered stage, G Days in stage.
Clean dashboard data starts at intake. Spendflo routes every purchase through approvals first.
See how it worksSpend that goes through procurement's process or an agreed contract, as a share of all spend.
Purchases made outside policy, such as buying from an unapproved supplier or skipping approval.
Paying less than last time for the same thing. It lowers next year's budget.
Paying less than a quote or list price. Real value, but the budget does not fall.
The price savings are measured from: last price paid, or the first quote for new purchases.
Days between two points in the process, such as request to approval or request to PO.
A one-line formula and data source per KPI stops arguments in the review.
Settle the baseline rule and the reduction or avoidance split before reporting any savings.
Clean names in the vendor master, not in the dashboard, so the fix sticks.
Someone who explains the number and proposes the fix when it goes off track.
Keep at least six months on the KPI tracker, because one month alone can mislead.
Nobody acts on a page that long, so keep the dashboard to six.
Reporting cost avoidance as budget savings is the fastest way to lose finance's trust.
Any number keyed in by hand will drift from the data, so formulas only.
If an off-track KPI has no owner and no fix, the review was just a reading.
Pull every PO from your ERP or purchasing tool and paste it onto the Data tab.
Assign each supplier a category once, then use a lookup so new POs fill in automatically.
Use last year's average as the starting point and agree a realistic improvement with finance.
Walk through the six KPIs, assign owners to anything off track and paste values into Last month.
In September, Lumen Retail's dashboard shows request-to-PO time at 6.2 days against a 5-day target, marked Off track. The pipeline view shows three software requests waiting 14 days in security and legal review. Procurement adds a data-processing questionnaire to the intake form, and October's figure falls to 4.8 days. Illustrative figures.
Every part on this page, in Excel and Google Sheets, with the examples filled in.
Track total spend, spend under management and savings. A finance lead can run it in an hour a month.
Use all six dashboard KPIs and the pipeline view, and send each department its own spend line before the review.
Keep one Data tab per entity and a group dashboard that adds them up. Convert currencies on the Data tab, never on the dashboard.
Best for most teams and for charts.
Best for sharing a live view with budget owners.
Best when the data will move into a BI tool later.
$3.7B in software spend processed through Spendflo, at 30% average savings.
See your savingsA good procurement dashboard shows spend, savings, compliance and speed on one page, every month, from one clean data tab. When the numbers keep pointing at the same delays, the fix usually sits in how requests come in and get approved.
Six KPIs with targets and status, all calculated from your PO data.
Open the dashboard →2Baseline, final price and type for every negotiation.
Open the savings tracker →3Open requests by stage, with the longest waits flagged.
Open the pipeline →Quick answers to what people ask most about the procurement dashboard template.
It should include total spend by category, spend under management, PO compliance, cycle times and savings, each with a target and a status. The template you can download on this page has all of them on one dashboard tab.
Spend under management, PO compliance, request-to-PO time and savings achieved are the four most teams report first. The KPI tracker in the download adds six more, with a formula and a status rule for each.
Paste a year of purchase orders onto a data tab, add columns for cycle days and month, then build each KPI with SUMIFS, COUNTIFS and AVERAGEIFS. To skip the setup, download the free Excel template and paste your data in.
Log each negotiation with its baseline, negotiated price and savings type, then subtract the negotiated price from the baseline to get the saving. The savings tracker in the download does this and totals cost reduction and cost avoidance separately.
You can download it free from the buttons at the top of this page, for Excel or Google Sheets. The KPI tracker comes inside the full procurement dashboard workbook, with ten KPIs and status formulas ready to use.
Procurement
Purchase orders
Contracts
Vendor management
Sourcing and RFx
Budgets and business cases
Accounts payable
Purchasing
Software buying
Supply chain
Spendflo runs intake, approvals, contracts and renewals before money is committed, so every purchase arrives tagged and approved. Reporting dashboards are coming soon.
Enter your work email and we'll unlock every format.
Didn't start, or need another format? Pick one below.
Google Sheets: upload the file to Google Drive, then open it with Google Sheets.
