How to count inventory in a small online business
A physical count compared against your records tells you what you really own, and this guide shows how to do it with a notebook or spreadsheet and no accounting knowledge.
If your catalogue says you have 14 of something and the shelf says 11, someone is going to get a "sorry, out of stock" message after paying. Counting your inventory is how you find those gaps before customers do. You do not need accounting software for this. You need a calm hour, a pen and your records.
What an inventory count actually is
It is two lists compared with each other. The first is what your records say you have, which is your store's stock numbers or your spreadsheet. The second is what you physically find when you open the boxes and count. The difference between them is what you are hunting for.
Prepare before you count
A little setup avoids a messy count.
- Pick a quiet time with no packing in progress, so stock is not moving while you count.
- Print or open your stock list, with product names and variants in the same order as your shelves.
- Tidy the shelves first. Pull stray items back to their bins.
- Keep a separate spot for damaged or returned items so they are not mixed in. More on that in why you should keep damaged and returned stock separate.
Count in a fixed order
Walk your shelves in one direction, shelf by shelf, so nothing is skipped or counted twice. For each product and variant, count the units and write the number next to the recorded number. Do not look at the recorded number first and nudge your count towards it. Count honestly, then compare.
If a bin holds many small items, count in groups of five or ten and tally. For boxes you have not opened, note them as sealed and count the units per box from the label, but open one occasionally to check the label is right.
Compare and mark differences
Once the count is done, go down the list and mark each line.
- Match, where physical and records agree.
- Short, where you found fewer than the records say.
- Extra, where you found more.
Do not fix anything yet. First list all differences. A pattern may appear, such as one size always short, which points to a labelling or packing issue rather than random loss. If you find mismatches, what to do when your stock count does not match orders explains how to trace them.
Update your records
After you have looked into the gaps, correct your stock numbers to match what is physically there. Write the date of the count and any reason you found. If you sell variants such as sizes and colours, each variant needs its own number, as covered in how to track stock per variant in your catalogue.
Keep it simple and repeatable
A full count of everything can be heavy, so many sellers count a few categories each week and rotate. Whichever way you do it, the key is consistency. Use the same sheet, the same order and the same habit each time.
What a count teaches you
Beyond catching errors, counting shows you things your orders do not. You will see slow movers gathering dust, items stacked in the wrong bin, and products close to running out. Those observations feed your reorder decisions and help you spot what is tying up your cash. For that side of the picture, see inventory turnover for a small store.
You do not need to be perfect. You just need to look at the shelf regularly and keep your numbers honest. A stock count is the cheapest way to stop overselling, and the earlier you start, the smaller the surprises.