Free procurement savings tracker template
Track forecast, realized and Finance-approved savings in one workbook. The template includes formulas, example initiatives, evidence checks and a ready-made dashboard.
No email required. Built for Excel. You can also import the workbook into Google Sheets, although some formatting or charts may change.
procsave-procurement-savings-tracker.xlsx
| Row | Initiative ID | Initiative Name | Category | Baseline Unit Price | New Unit Price | Forecast Savings | Net Realized Savings | Finance Approved Savings | Approval Status |
|---|---|---|---|---|---|---|---|---|---|
| 8 | PS-001 | Packaging RFP | Packaging | 12.5 | 11.4 | 132,000 | 125,350 | 123,000 | Approved |
| 9 | PS-002 | SaaS renewal | Software | 420,000 | 385,000 | 35,000 | 35,000 | 0 | Pending |
| 10 | PS-003 | Fleet fuel framework | Energy | 1.78 | 1.69 | 45,000 | 42,300 | 40,000 | Approved |
| 11 | PS-004 | Temporary labor rates | Labor | 48 | 45 | 60,000 | 59,000 | 59,000 | Approved |
| 12 | PS-005 | Office supply consolidation | Facilities | 8.5 | 7.9 | 12,000 | 10,800 | 10,000 | Approved |
| 13 | PS-006 | Telecom contract | Telecom | 29 | 25 | 4,000 | 3,120 | 3,000 | Approved |
| 14 | PS-007 | MRO parts framework | MRO | 27.5 | 26.4 | 110,000 | 113,000 | 100,000 | Needs Evidence |
| 15 | PS-008 | Agency retainer | Professional Services | 200,000 | 180,000 | 20,000 | 20,000 | 18,000 | Approved |
What is a procurement savings tracker?
A procurement savings tracker records each savings initiative from its original forecast through implementation and Finance review. It keeps the baseline, actual result, evidence and approval status together so lower spend is not automatically mistaken for procurement savings.
Everything needed to track a savings initiative
200 initiative rows
Record the owner, supplier, category, baseline method, reporting period and current status.
Forecast and realized savings
Built-in formulas separate expected price savings from the result on the quantity actually purchased.
Finance-approved value
Keep the value Finance accepts separate from the procurement forecast and calculated result.
Evidence and quality checks
Flag missing evidence, duplicate IDs, missing inputs, currency mismatches and approvals that exceed calculated savings.
Dashboard and charts
See forecast, net realized, Finance-approved savings, realization rate and review workload.
Editable methodology
Document baseline rules and show exactly how each savings figure is calculated.
How the template calculates procurement savings
The workbook uses readable formulas. AI does not decide the savings number.
| Metric | Formula | What it means |
|---|---|---|
| Forecast savings | MAX(0, (baseline unit price - new unit price) × baseline quantity) | The expected price benefit before implementation. |
| Realized price savings | MAX(0, (baseline unit price - new unit price) × actual quantity) | The price benefit on what was actually purchased. |
| Volume effect | (baseline quantity - actual quantity) × new unit price | Spend changed because the quantity changed. The workbook shows this separately and does not count it as procurement savings. |
| Net realized savings | MAX(0, realized price savings - one-time costs) | The calculated realized result after implementation costs. |
| Finance-approved savings | Entered after Finance review | The amount Finance accepts after reviewing the calculation and evidence. |
| Realization rate | Finance-approved savings ÷ forecast savings | The share of forecast savings accepted by Finance. |
Use one reporting currency in each workbook. Convert source values before combining them in the dashboard.
Checking a single initiative? The free procurement savings calculator runs these formulas in your browser and shows every substitution.
Forecast, realized and Finance-approved savings are not the same
| Stage | Question it answers | Typical evidence |
|---|---|---|
| Forecast savings | What do we expect the initiative to save? | Baseline, quote, bid or approved business case |
| Realized savings | What price benefit occurred on the actual quantity? | Purchase orders, invoices or payment data |
| Finance-approved savings | What value has Finance accepted for reporting? | Calculation, supporting rows and approval decision |
Keeping these values separate prevents an optimistic forecast from being reported as a completed result.
How to use the procurement savings tracker
- Choose the reporting currency on the Dashboard.
- Replace the example rows with your own initiatives.
- Enter baseline price, new price, baseline quantity and actual quantity.
- Record one-time implementation costs separately.
- Attach the calculation or source evidence.
- Let Finance enter or confirm the approved value.
- Resolve anything marked for review on the Checks sheet.
When should you move beyond a savings tracker spreadsheet?
A spreadsheet works well when one team controls a manageable list of initiatives and updates the source data manually. It becomes harder to trust when several people edit different versions, actual spend must be matched repeatedly, evidence is stored elsewhere or Finance cannot trace a number back to its source.
ProcSave is being built for that next step. It reads the tracker you already use, helps map actual spend and keeps the reconciliation, evidence and Finance decision together.
Questions about the template
Yes. The Excel workbook is free to download and does not require an email address.
The template is built as an Excel workbook. It can be imported into Google Sheets, but some formatting, validation rules or charts may change during import.
The workbook lets you label an initiative as cost avoidance, but it does not automatically turn avoided cost into realized hard savings. Agree the treatment and baseline with Finance before reporting it.
The calculated result and the value Finance accepts can differ because of timing, evidence, accounting treatment or baseline rules. Keeping both fields makes the difference visible.
No. The free workbook requires manual inputs. ProcSave is being built to help match tracker initiatives with actual spend and supporting evidence.
No. The spreadsheet uses visible formulas. In ProcSave, AI may help read files and suggest mappings, while rules calculate the result and Finance decides what is approved.
Yes. Edit the Lists sheet to match your business units, categories, savings types, baseline methods and approval statuses.
Use the source that supports the baseline and actual result, such as a prior contract, approved budget, bid sheet, purchase order, invoice or payment data.
Outgrowing the spreadsheet?
Tell us how your team tracks savings today. ProcSave will use your answers to shape the product and show whether the planned workflow fits your process.
One question at a time. No call required.
Or read what ProcSave does.