# Procurement Savings Tracker Worksheet

> Source: https://netray.co/tools/procurement-savings-tracker-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable table that computes hard savings per line from baseline and new price and rolls up total and percent saved.

## Category

cost-finance

## Audience

- Buyer
- Purchasing manager
- Finance partner

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Initiative

**Key:** initiative

**Type:** text

#### Supplier

**Key:** supplier

**Type:** text

#### Savings type

**Key:** type

**Type:** select

**Options:**

- Hard saving
- Cost avoidance
- Rebate
- Payment terms

#### Annual qty

**Key:** qty

**Type:** number

#### Baseline unit price

**Key:** baseline

**Type:** number

**Format:** currency

#### New unit price

**Key:** new_price

**Type:** number

**Format:** currency

#### Baseline spend

**Key:** base_spend

**Type:** number

**Expr:** qty * baseline

**Format:** currency

#### Annual saving

**Key:** saving

**Type:** number

**Expr:** (baseline - new_price) * qty

**Format:** currency

#### Saving percent

**Key:** pct

**Type:** number

**Expr:** if(gt(baseline,0),(baseline - new_price) / baseline * 100,0)

**Format:** percent

#### Effective date

**Key:** start

**Type:** date

**Rows:**

**Initiative:** Re-quote bearing family

**Supplier:** Valdor Bearings

**Type:** Hard saving

**Qty:** 24000

**Baseline:** 6.4

**New price:** 5.95

**Start:** 2026-07-01

**Initiative:** Consolidate fasteners to one distributor

**Supplier:** FastenPro

**Type:** Hard saving

**Qty:** 180000

**Baseline:** 0.082

**New price:** 0.071

**Start:** 2026-08-15

**Initiative:** Hold packaging price vs index rise

**Supplier:** BoxWorks

**Type:** Cost avoidance

**Qty:** 50000

**Baseline:** 1.32

**New price:** 1.25

**Start:** 2026-09-01

**Initiative:** Annual volume rebate

**Supplier:** CastRight

**Type:** Rebate

**Qty:** 9000

**Baseline:** 18.5

**New price:** 18.1

**Start:** 2026-01-01

**Totals:**

#### Total baseline spend

**Key:** base_spend

**Agg:** sum

**Format:** currency

#### Total annual saving

**Key:** saving

**Agg:** sum

**Format:** currency

**Summary:**

#### Blended saving percent

**Key:** blended

**Expr:** if(gt(sum_base_spend,0),sum_saving / sum_base_spend * 100,0)

**Format:** percent

**Primary:** true

#### Average saving per initiative

**Key:** avg_line

**Expr:** if(gt(count,0),sum_saving / count,0)

**Format:** currency

**Notes:** Report hard savings (a real price drop on a real purchase) separately from cost avoidance (a rise you prevented). Filter the exported Excel by savings type before sending totals to finance.

## Content

**Intro:** Savings numbers lose credibility when nobody can say how they were calculated. This worksheet fixes the method: baseline price minus new price, multiplied by annual quantity, tagged by savings type.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per initiative. Enter the annual quantity, the baseline price you can prove from the last purchase order or contract, and the new price. The saving, baseline spend and percent compute automatically. Pick the savings type so hard savings and cost avoidance are never mixed in one total. Export to Excel for your monthly report.

**Bullets:**

- Use last paid price as baseline, not the first quote.
- Use forecast quantity, not hoped-for quantity.
- Record the effective date for in-year effect.

#### Savings definitions that survive finance review

**Body:** Hard savings reduce spend against a baseline and show up in the ledger. Cost avoidance is a prevented increase and does not reduce the budget. Rebates and payment terms benefits are real but belong in their own lines. Agree these definitions with finance once and write them on the first page of the report so the numbers are never contested later.

#### In-year versus annualized

**Body:** The saving column is annualized. If an initiative starts in August, only part of it lands in the current year. Multiply by remaining months over twelve when you report in-year impact, and keep the annualized figure for the run-rate view. Reconcile a sample of lines against actual invoices after three months.

#### Common mistakes

**Body:** Counting a price drop twice when volume also changed, using list price as baseline, claiming savings on items never bought and including one-time freight in the unit price. Track price and volume effects separately: a lower price on a higher quantity is not a saving on the extra units.

**Cta:** Netray can compare PO and invoice prices from your ERP against baselines automatically so savings are verified, not estimated.

**Faq:**

#### What counts as a hard saving?

**Answer:** A price reduction on goods or services you actually buy, measured against a documented baseline and visible in actual spend. It lowers cost in the ledger and should be reconcilable to invoices.

#### Is cost avoidance real savings?

**Answer:** It has value because it prevents a loss, but it does not reduce spend. Report it separately and never add it to hard savings in a total shown to finance.

#### How do I pick a baseline?

**Answer:** Use the last price paid in the prior twelve months, or the contract price in force before the change. Document the source. Avoid using a supplier's opening quote or list price.

#### Should savings be annualized?

**Answer:** Show both. Annualized savings show the run rate, while in-year savings show the budget effect. Label which one each report figure uses.

## Search terms

procurement savings tracker excel, cost savings tracking template, purchasing savings log, buyer savings report template, cost reduction tracker, hard savings vs cost avoidance, procurement savings template

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json