Anyone counting stock

Inventory count sheet

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

One header row, one filled example.

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.

nouz-inventory-count-sheet.csv10 columns
A2AW-TEE-BLK-M
nouz-inventory-count-sheet.csv: 10 columns, the header in row 1 and one example in row 2
RowABCDEFGHIJK
1skuproductlocationexpected_unitscounted_unitsvariance_unitsunit_costvariance_valuecounted_bycount_date
2AW-TEE-BLK-MEssential tee, black, MMain warehouse420414-619.15-114.90warehouse team2026-08-31
3
4
5
6
7
nouz-inventory-count-sheet

A · skuThe variant counted.

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.

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

More free files, same format.

All 15 templates

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