Guide
How to track stock in a shop: six steps that work
Shop stock rarely goes wrong all at once. It usually starts with a delivery nobody wrote down, or a returned item put back on the shelf with a promise to note it later. Below is how to keep it under control, first with what you have to hand today and then with software.
Step 1: decide exactly what you count
Every item needs one name and one unit. If “Coffee 250 g” and “Ground coffee 0.25” are really the same item written down twice, both quantities will be wrong. So make the list once, with the name, unit and group of each item, plus the code on the packaging if it has one.
Step 2: the opening count
Pick a day when the shop is closed or quiet and count everything. Everything after that starts from this number, and without it each later entry rests on a guess. Count shelf by shelf and group by group so nothing gets counted twice.
Step 3: record everything that comes in
Record every delivery on the day it arrives, using the supplier's document: which goods, how many and at what price. Check the quantities against the document before you sign it, because a difference is far easier to sort out while the driver is still there.
Step 4: record everything that goes out, not only sales
Most stock leaves through sales, though there are other ways too. Goods that expire, get broken, are taken for the shop's own use or go back to the supplier all reduce stock, and each should be recorded with its reason. If they are not, the month ends with a shortfall that looks like theft when it isn't.
Step 5: a minimum for every item people ask for
For goods that must not run out, set a minimum quantity. Once stock falls below it, you reorder. That way you work from a list and do not have to rely on remembering what ran out last week.
Step 6: check stock in parts, not once a year
Rather than counting the whole shop in one go, count one group each week. Compare it with what is written down, and if something differs, look for the reason while you still remember what happened.
With a notebook or Excel: how to start today
The six steps work without software. What matters is that everything is written down in one place instead of spread over notebooks, notes and sheets.
- Notebook: a page per item or group; each line is date, in, out, reason and balance.
- Excel: one sheet “Items” (name, unit, minimum) and one sheet “Movements” (date, item, quantity, reason). Stock is worked out as the sum of the movements. Nobody should correct it by hand.
- Never delete or edit an old line. Add a new line that corrects it, so you can always see later what happened.
- If your till can export the day’s sales to a file, take it every evening instead of copying receipts.
When the notebook and the spreadsheet stop being enough
This usually happens when more than one or two people are writing things down, when you open a second location or an online shop next to the physical one, or when finding out how many you have left means phoning someone. We explain how to switch without stopping work in the guide How to stop using Excel for stock.
How the platform does it
You describe your shop in words and get a program with the six steps already built in: items, deliveries, outgoings with a reason, minimums and stock checks. It works on a phone and on a computer, and each person on the team has a role.
- The spreadsheet or list you use today is brought into the program as it is.
- You can see stock at any moment and get a reminder when an item falls below its minimum.
- Every movement is kept in a log that shows who did what and when.
- Sales from the till can come in from the file your till software exports. That connection is built as a separate task, and the fiscal receipt stays at the till.
- To read more: Software for a small shop, Warehouse software and Stock and sales software.
Frequently asked questions
How often should I do a stock count in the shop?
Do a full count when your accountant asks for one. For day-to-day control it is better to count one group every week, because you catch differences while you still remember what caused them.
Do I need software if the shop is small?
Not necessarily. If one person keeps the records and there are only a few items, a notebook or spreadsheet following the steps above will do. Software starts to make sense once people, locations or items grow beyond what a spreadsheet can cope with.
How much does stock software cost?
You can try it for free without entering a bank card. After that you pay with prepaid credits for what you actually use, with no monthly subscription, plus a daily hosting fee for each active project. The Pricing page shows what each credit pack costs.
Describe your shop
Sign up and describe how goods come in and go out at your shop. If the program you get does not fit your shop, you will not have paid anything for it.