Stock count sheet: what to include and how to run a count with it

A stock count sheet is the list you carry while you count: every item you expect to find, where it should be, the quantity your records say is there, and an empty space for the number you actually see. If you are about to run a stocktake and want a sheet that works, the short answer is this: keep it to the columns people will really fill in, sort it in the order you walk, and pre-fill everything except the counted number.

That sounds simple, and it is. Most count sheets fail not because they are missing a clever column, but because they have too many, are sorted alphabetically instead of by shelf, or leave counters guessing which box they are looking at. This article covers what to put on the sheet, how to run the count, and what to do with the numbers afterwards.

What a stock count sheet is for

A stock count sheet exists to compare two numbers: what your records say you have and what is physically on the shelf. Everything else on the sheet supports that comparison.

It also answers a few quieter questions along the way. Who counted this shelf? When? Is anything below the level where you should reorder? Did the same item turn up in two places? A good sheet makes these answers fall out of the count without extra work.

It is worth separating the count sheet from your everyday stock list. The stock list is the record you keep up to date between counts. The count sheet is a snapshot you print or open for one stocktake, fill in, and then use to correct the record. Mixing the two, for example by overwriting quantities on your master spreadsheet as you walk, makes it hard to see what changed and why.

The columns worth keeping

A useful count sheet has a small set of columns, and each one has a clear job. This table is a template you can copy into a spreadsheet or rule onto paper.

Column	What goes in it	Why it helps
Location	Site or building, if you have more than one	Splits the count between people and places
Storage	The shelf, box, room or vehicle	Tells the counter exactly where to look
Item	The name everyone uses for it	Identifies what to count
Item ID or barcode	A code, if you have one	Separates items with similar names
Unit	Each, box, pack, roll	Stops “one box” being counted as “one”
Expected quantity	What the records say	The number you are checking against
Counted quantity	Left blank; filled in on the shelf	The number you actually found
Difference	Counted minus expected	Shows at a glance what needs a look
Reorder level	The quantity where you restock	Flags what to order while you are there
Counted by / date	Initials and the day	Lets you ask the right person later
Notes	Damaged, expired, found elsewhere	Captures the reason behind a difference

You do not need every column. A small office counting supplies can drop the ID and the location. A team with several sites will want both. The test for any column is simple: will someone fill it in, and will someone use it afterwards? If not, leave it off.

Sort the sheet the way you walk

The single most useful change you can make to a count sheet is to sort it by location and storage, not by item name. Counters work through a room shelf by shelf. An alphabetical list sends them back and forth, and that is where items get skipped or counted twice.

Put each storage on its own block of rows, in the order you would walk past them. If an item lives in two places, it appears twice, once under each storage, each with its own expected and counted quantity. That is the only way to spot the classic problem of stock that exists but sits in the wrong place.

Should you show the expected quantity?

There are two schools of thought, and both are reasonable. Showing the expected number makes counting faster: the counter sees “12 boxes of gloves”, looks, confirms, and moves on. Hiding it gives you a more honest count, because nobody is tempted to write down the number they were told to expect.

A practical middle ground: hide the expected quantity for high-value or frequently wrong items, and show it for cheap, stable things like packing tape or pens. Or show it, but ask counters to write the counted number in full every time, never a tick. A tick tells you someone looked; a number tells you what they found.

How to run a count with the sheet

A stocktake goes smoothly when it is prepared the day before, not on the morning. These steps work for a single shelf of cleaning supplies and for a stockroom alike.

1. Choose a quiet moment. Pick a time when stock is not moving, or agree to pause taking and receiving items during the count.
2. Print or open a fresh sheet. Generate it from your current records so the expected quantities are up to date.
3. Split the work by storage. Give each person a set of shelves or rooms, not a set of items. Two people should never count the same shelf at the same time.
4. Count what is there, not what is listed. If you find an item that is not on the sheet, add a row. Unlisted stock is a finding, not a nuisance.
5. Write numbers, not ticks. Record the counted quantity in the unit shown on the sheet.
6. Recount the big differences. Before anyone leaves the room, have a second person check any line where the difference looks large or surprising.
7. Note the reason. Broken, used without recording, moved to another shelf: a short note now saves a long investigation later.
8. Update the records the same day. A count sheet sitting in a drawer for a week is already out of date.

What to do with the differences

The count is only half the job; the other half is deciding what the differences mean. Some are simple: stock was used and nobody wrote it down. Some are placement problems: the item is fine, it is just on the wrong shelf. A few point at something that needs a process change, such as a supply cupboard anyone can take from without recording it.

Correct the records to match what you found, then look for patterns. If the same items are wrong every time, count them more often, give them a clear home, or make recording easier at the moment they are taken. High-value items and fast movers deserve more frequent counts; slow, cheap items can wait.

When paper and spreadsheets are still fine

Paper count sheets and spreadsheets work well for a lot of teams, and there is no need to replace them for the sake of it. If one person manages a small cupboard, counts a few times a year, and nobody else needs the numbers in between, a printed sheet and a spreadsheet are perfectly adequate.

The trouble starts when several people count at once, when the sheet has to be retyped into a spreadsheet afterwards, or when the master file has been copied so often that nobody is sure which version is current. Retyping is where numbers get transposed. Multiple copies are where counts get lost. At that point the sheet itself is no longer the problem; the gap between the sheet and the record is.

Where Tana fits

Tana is a shared inventory for a team. Items are recorded per storage (a shelf, box, room or vehicle), and storages can be grouped by location, so the structure of a good count sheet is already the structure of your data.

When you want a paper sheet, the CSV export gives you one: it lists each item with its storage, location, quantity and alert threshold, and opens in any spreadsheet. Sort it by location and storage, add a “counted” column, and print. If you prefer to count on a device, open a storage on an iPhone, iPad or in the web app, and use the = button to set the exact quantity you counted. Tana records who changed which quantity, when and in which storage, so the “counted by / date” column fills itself in. Printed QR labels on shelves take you straight to the right storage when scanned, and low-stock alerts use each item’s threshold, so the reorder column keeps working between counts.

Frequently asked questions

What should a stock count sheet include?

At minimum: storage, item, unit, expected quantity and counted quantity. Add location, an item code, reorder level, who counted and notes when you will actually use them.

Should I sort an inventory count sheet by item or by location?

By location and storage. Counters move shelf by shelf, so a sheet in walking order means fewer skipped or double-counted items.

How often should I do a stock count?

It depends on how fast stock moves and what it is worth. Many teams run a full count occasionally and count high-value or fast-moving items more often in between.

Is it better to show or hide the expected quantity on a stocktake sheet?

Showing it is faster; hiding it gives a more honest count. A common approach is to hide it for items that are often wrong or valuable, and show it for the rest.

Can I use a spreadsheet as a stock count sheet template?

Yes. A spreadsheet with the columns above, sorted by storage, works well. The main risk is retyping counts back into the master file, so update the records straight from the sheet the same day.