E-Commerce & Web Shops, Financial Model, General Excel Financial Models, Online Businesses

Cost Calculation, Dashboard, Excel, KPIs (Key Performance Indicators), Pricing, Tracking

A negotiation is won with the numbers in hand, and the numbers need to be kept. This tracker records what you pay, what you negotiated, what the agreement says and when it is time to go back to the table.

What is inside (5 sheets): Suppliers (per supplier and product: current and negotiated price, discount %, monthly volume, estimated saving, date of last negotiation, next deadline with countdown and 30-day alert) · Commercial Terms (base discount, minimum order, free shipping threshold and transport cost below it, delivery time, payment terms, year-end bonus thresholds and percentages; the file compares annual purchases with the thresholds and tells you which bonus you have earned) · Price History (every change with date and reason) · Dashboard (monthly and annual savings, bonuses earned, average delivery and payment days, negotiations due in 30 days, 4 charts) · Home.

Who it is for: online stores and small retailers buying from several suppliers; purchasing managers; anyone who has ever been told “we already gave you the maximum discount”.

How to use it: one row per supplier/product, update prices after every negotiation. Described in chapter 16 of the guide Level Up Your E-commerce, with the list of what to put in a supply agreement.

How to work with the template, step by step

Every price, discount, commercial term and year-end bonus agreed with your suppliers, in one file that tells you when to renegotiate and how far you are from the next bonus tier.

Add one row per supplier/product. In Suppliers enter list price, current price, negotiated price, annual volume and the next renegotiation deadline: discount and savings are calculated automatically, and negotiations due in the next 30 days are flagged.
Record the commercial terms. In Commercial Terms enter, for each supplier, base discount, minimum order, free-shipping threshold, delivery time, payment method and days, and the year-end bonus thresholds: the sheet calculates the bonus earned and the gap to the next tier. Use the same supplier name in both sheets.
Track price changes in Price History. Every change of price gets a row with date and reason: the trend is your best argument at the next negotiation.
Read the Dashboard. Savings obtained, bonuses, average delivery and payment times and the negotiations to schedule.

Chapter 16 of the guide (Optimise your supplier costs) explains what to ask for and when; this file keeps the answers. This edition comes without sheet protection: edit the input cells and leave the formula cells as they are.

What you get

Excel workbook in English and the same workbook in Italian (.xlsx), fully editable, no sheet protection, no macros.
User Guide in PDF (English and Italian) with a KPI dictionary.
Demo data to replace with your own; USD / EUR / GBP currency switch.

This edition comes without sheet protection, as requested by this marketplace: edit the input cells and leave the formula cells as they are (keep a copy of the original before you start). Works in Microsoft Excel 2016 or later, Excel 365 and Google Sheets; no macros, no add-ins. Demo data included: replace it with your own and every KPI, chart and alert updates automatically. Italian version of the file included in the download. Version 1.0 (September 2026) · Free updates for buyers · Part of the Level Up Your E-commerce toolkit. I am Andrea Ladisa, e-commerce entrepreneur selling in 20+ countries: I built this file for my own stores before packaging it for you.

You must log in to submit a review.