Method
How to build a count sheet that is actually usable
A useful inventory sheet fits in 4 columns: product, reference (SKU or EAN), expected quantity, counted quantity. Add a fifth gap column to spot errors instantly and a sixth note column for damage, expiry or doubts. Beyond 6 columns, the sheet becomes unreadable and counters scribble in the margins.
- Sort products by storage zone, not alphabetically
- Pre-fill the expected quantity: blind counters err 3× more often
- Use A4 landscape if you exceed 7 columns