# Supplier Cost Savings Tracker Worksheet

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

## Short answer

Track negotiated savings by item and initiative, with annual value, percent saved and a hard versus soft split, ready to export to Excel.

## Category

cost-finance

## Audience

- Buyer
- Procurement director
- Category manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Item / part number

**Key:** part

**Type:** text

#### Supplier

**Key:** supplier

**Type:** text

#### Savings lever

**Key:** lever

**Type:** select

**Options:**

- Renegotiation
- Re-source
- Specification change
- Volume consolidation
- Payment terms
- Cost avoidance

#### Savings type

**Key:** kind

**Type:** select

**Options:**

- Hard
- Soft

#### Baseline unit price

**Key:** base

**Type:** number

**Format:** currency

#### New unit price

**Key:** new_price

**Type:** number

**Format:** currency

#### Annual quantity

**Key:** qty

**Type:** number

**Format:** integer

#### Annual saving

**Key:** saving

**Type:** number

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

**Format:** currency

#### Percent saved

**Key:** pct

**Type:** number

**Expr:** (base - new_price) / base * 100

**Format:** percent

#### Effective date

**Key:** effective

**Type:** date

**Rows:**

**Part:** BRK-1001 bracket

**Supplier:** Northfield Metals

**Lever:** Renegotiation

**Kind:** Hard

**Base:** 4.15

**New price:** 3.92

**Qty:** 36000

**Effective:** 2026-07-01

**Part:** HSG-2240 housing

**Supplier:** Delta Castings

**Lever:** Re-source

**Kind:** Hard

**Base:** 21.6

**New price:** 19.85

**Qty:** 8400

**Effective:** 2026-09-15

**Part:** FST-0310 fastener kit

**Supplier:** Prime Fasteners

**Lever:** Volume consolidation

**Kind:** Hard

**Base:** 0.78

**New price:** 0.71

**Qty:** 240000

**Effective:** 2026-08-01

**Part:** PKG-0075 carton

**Supplier:** BoxWorks

**Lever:** Specification change

**Kind:** Hard

**Base:** 1.34

**New price:** 1.22

**Qty:** 52000

**Effective:** 2026-10-01

**Part:** CBL-5512 harness

**Supplier:** Meridian Wire

**Lever:** Cost avoidance

**Kind:** Soft

**Base:** 14.2

**New price:** 14.2

**Qty:** 6000

**Effective:** 2026-11-01

**Totals:**

#### Total annual saving

**Key:** saving

**Agg:** sum

**Format:** currency

#### Total quantity

**Key:** qty

**Agg:** sum

**Format:** integer

#### Average percent saved

**Key:** pct

**Agg:** avg

**Format:** percent

**Summary:**

#### Average saving per line

**Key:** avg_saving

**Expr:** sum_saving / count

**Format:** currency

#### Average percent saved across lines

**Key:** avg_pct_saved

**Expr:** avg_pct

**Format:** percent

**Notes:** Report hard savings (actual price reductions against a documented baseline) separately from soft savings and cost avoidance, which finance often excludes. Set the baseline as the last paid price or an agreed benchmark, and keep it fixed. For cost avoidance, enter the avoided increase as the baseline and the new price as the accepted price, and mark it Soft.

## Content

**Intro:** Procurement teams are asked to prove their savings, and the proof is only as good as the baseline. This worksheet records the baseline, the new price and the volume for every line so the number holds up in a review with finance.

**Sections:**

#### How to use it

**Body:** Add one row for each item and initiative. Enter the baseline unit price, the new unit price and the annual quantity. The sheet calculates annual saving and percent saved, and totals the column. Tag each line with a savings lever and mark it Hard or Soft. Export to Excel to filter by supplier or lever, or to share with finance as the supporting schedule for your savings claim.

#### The formula and definitions

**Body:** Annual saving is baseline price minus new price, multiplied by annual quantity. Percent saved is the price difference divided by the baseline. Hard savings are actual reductions in what you pay against a stated baseline. Soft savings and cost avoidance, such as a negotiated reduction of a proposed increase, are real but are normally reported separately because they do not reduce the previous year's spend.

**Bullets:**

- Saving = (baseline - new price) x quantity
- Percent = (baseline - new) / baseline
- Hard = lower price against paid baseline
- Soft = avoided or non-price benefit

#### Reading the result

**Body:** Look at the total and at how it divides by lever. A tracker dominated by cost avoidance will not show up in the income statement, while one dominated by renegotiation of high-volume items usually will. Check the quantity column against last year's actuals, since savings on forecast volume that never arrives are paper savings. Review the tracker monthly so volume shifts are caught early.

#### Common mistakes

**Body:** Teams often use a stale or inflated baseline, such as a list price nobody paid. Others count the full annual saving in the month the deal is signed instead of prorating from the effective date. If your finance team requires in-year figures, multiply the annual saving by the share of the year remaining. In your ERP, pull the baseline from the last purchase order price or the standard cost, and the new price from the updated info record.

**Cta:** If you want savings measured automatically from purchase order price changes in your ERP, Netray can build that as a read-only report.

**Faq:**

#### What is the right baseline?

**Answer:** The last price actually paid, or an agreed benchmark documented before the negotiation. Avoid list prices or quotes you never accepted, since they inflate savings and fail audits.

#### How do I treat cost avoidance?

**Answer:** Record it, mark it Soft, and report it separately from hard savings. It shows negotiation value but should not be added to the reduction in spend that finance will look for.

#### Should I prorate savings?

**Answer:** For in-year reporting, yes. Multiply the annualized saving by the fraction of the year after the effective date. For annualized run-rate reporting, use the full annual number and say so.

#### Can I track multiple currencies?

**Answer:** Convert to one currency at a fixed budget rate for the tracker, and note the rate. Mixing live exchange rates makes savings look like they come from currency movement.

## Search terms

procurement savings tracker excel, cost savings tracking template purchasing, negotiated savings log, hard savings vs soft savings procurement, purchase price savings calculation, procurement cost reduction tracker, buyer savings report template

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