Supplier price tracker
Every quoted price, dated, so drift becomes visible.
Anyone counting stock
What this file is
An inventory count sheet compares the units a system says you hold against the units actually on the shelf, per SKU and per location, and prices the difference at landed cost. The variance column is the point: unpriced shrinkage is invisible, and priced shrinkage is a decision.
What is inside
A stocktake sheet that ends in money: expected units against counted units, the variance in units and in euros, so shrinkage stops being a rounding error nobody prices.
Rows 1 and 2 are the file. Click any cell to read it; the foot of the sheet says what its column is for.
| Row | A | B | C | D | E | F | G | H | I | J | K |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | product | location | expected_units | counted_units | variance_units | unit_cost | variance_value | counted_by | count_date | |
| 2 | AW-TEE-BLK-M | Essential tee, black, M | Main warehouse | 420 | 414 | -6 | 19.15 | -114.90 | warehouse team | 2026-08-31 | |
| 3 | |||||||||||
| 4 | |||||||||||
| 5 | |||||||||||
| 6 | |||||||||||
| 7 |
A · skuThe variant counted.
In the order they sit in the file. Point at one and it is outlined in the sheet.
Behind the file
Count in cost, not in units. Six missing shirts is a shrug; €114,90 of missing stock, repeated across a catalogue, is a real line in a real month. Value the variance at cost rather than at retail, because stock is money spent, not revenue lost, and pricing it that way puts it in the same units as everything else on the statement.
Locations matter more than most stores expect. Stock reserved for a wholesale order, units sitting on the returns bench and anything in a second warehouse are all real and none of them can be sold to the next customer, so counting them into one number is how a well-stocked product goes out of stock. The same logic underlies stock coverage, which is only honest when it counts saleable units.
Count often and narrowly rather than annually and completely. A rolling count of the fastest twenty SKUs every month finds problems while they are still small and costs an hour; a full annual count finds them a year late. Price each variance at the landed cost of the unit, not at what it would have sold for, and whatever the count says, the counted number wins: an inventory system that disagrees with the shelf is wrong by definition.
More templates
Every quoted price, dated, so drift becomes visible.
A budget built from the margin that has to pay for it.
Thirteen weeks and twelve months of cash, with the VAT return and supplier terms on their own dates.
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.