Anyone whose supplier prices move
Price list with effective dates
What each product costs and sells for, and from which day.
7 columnsCSV
Anyone buying from suppliers
Supplier price tracker
What this file is
A supplier price tracker keeps one row per quote per supplier per date, with the quantity it applies to and how long it stands. Kept over a year it shows cost drift a single cost field can never show, and turns a renegotiation into a conversation about evidence.
What is inside
One header row, one filled example.
One row per quote per supplier per date: the file that answers how much a product's cost has moved this year, and which supplier is quietly repricing you.
Rows 1 and 2 are the file. Click any cell to read it; the foot of the sheet says what its column is for.
A22026-08-15
| Row | A | B | C | D | E | F | G | H | I | J | K |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | quote_date | supplier | sku | moq | unit_price | currency | lead_time_days | incoterm | valid_until | ||
| 2 | 2026-08-15 | Supplier A | AW-TEE-BLK-M | 500 | 16.00 | EUR | 45 | FCA | 2026-11-15 | ||
| 3 | |||||||||||
| 4 | |||||||||||
| 5 | |||||||||||
| 6 | |||||||||||
| 7 |
nouz-supplier-cogs-tracker
A · quote_dateThe day the price was quoted.
Every column, explained.
In the order they sit in the file. Point at one and it is outlined in the sheet.
Behind the file
Why it is built this way.
Supplier prices creep one product at a time, and a store that keeps only its current cost cannot see it happening. A dated quote history can: the same SKU at €14,80 in January and €16,00 in August is an 8% margin problem that arrived in stages, none of which was big enough to notice on its own.
The quantity and lead time columns are what make the file negotiable. A price is only comparable against the order size and the delivery time it assumes, and a supplier who is cheaper but a fortnight slower is asking you to hold more safety stock, which has a cost of its own that the reorder point calculator prices.
Two columns save real money. Validity, because a quote with an expiry is a deadline you can plan a purchase around. And incoterm, because who pays for the freight and the duty decides whether two prices are actually comparable at all: an ex-works price and a delivered one can differ by the whole landed uplift. Whichever quote wins, record it in the price list with effective dates rather than overwriting the old cost, so the history survives.
More templates
More free files, same format.
Planning next month's spend
Marketing budget planner
A budget built from the margin that has to pay for it.
9 columnsCSV
Planning stock and cash
Ecommerce cash flow forecast
Thirteen weeks and twelve months of cash, with the VAT return and supplier terms on their own dates.
14 columnsCSV
Your daily P&L, without the spreadsheet.
nouz works out your real profit every night, after product costs, shipping, payment fees, ad spend and running costs, and sends it to your inbox each morning.
Your trialToday
14 days of nouz, every feature€0,00
Card needed to startNone
Access to your storeRead-only
Due today€0,00