Guide
How to keep track of shop stock, step by step
You do not need expensive software to know what is on your shelves; a few rules, kept every day, will do. Below are the steps you can start on today with a notebook or a spreadsheet, and at the end how a stock system handles it once the notebook is no longer enough.
1. Make one list of items
This is where it starts. Each item gets its own line and always the same name, so it is never “blue top” one day and “blue T-shirt M” the next. If you sell different sizes or colours, every variant has a line of its own.
- A short code for every item, even just a running number.
- The supplier and the purchase price next to the name.
- One list for the whole shop, not one per shop assistant.
2. Count once, properly
Use a day when the shop is closed, or a quiet hour, and count all the stock. That figure is your starting point; from then on you only record what moves, without counting everything again.
3. Record every movement in and out
Incoming goods are written down as they arrive, with the supplier’s delivery note in your hand. Anything that leaves, whether sold, returned, broken or given away, is written down as it leaves. The stock figure is only right if nothing is left “to write up later”.
- Goods in: date, supplier, item, quantity.
- Goods out: sale, return to supplier, damaged stock.
- Who recorded the movement, so you know whom to ask.
4. Set a minimum stock for the items that matter
For items that must never run out, set the quantity at which you reorder from the supplier. There is no need to do it for the whole shop; begin with the twenty items you sell most.
5. Count in rotation instead of once a year
Each week count a single group of items, such as one shelf or one category, and check it against the list. The gaps show you where stock goes missing, and you no longer have to shut the shop for the year-end stocktake.
6. Look at what sells and what stands still
Once a month pull out two lists: the items that sell out fastest and the ones that have sat there for months. The first shows what to reorder sooner, the second what you should stop buying.
When the notebook and the spreadsheet are no longer enough
You usually notice it like this: the online shop sells things you no longer have, or only one person keeps the sheet up to date and the counts never agree. To move to a proper system without stopping work, read How to stop using Excel for stock.
How our platform does it
You explain how your shop works and the platform builds a system that follows these same steps: stock by item updated with every movement, minimum stock, supplier orders starting from what is missing, counts without stopping work, and questions in plain language such as which items have not sold for three months. Your spreadsheet is imported as it is. See Software for a small shop, Inventory management and Stock and sales.
- The fiscal receipt stays with the electronic register you already use: the platform does not replace it.
- There are no monthly fees or per-user charges; you work with credits topped up in advance. See Pricing.
Frequently asked questions
Is a spreadsheet enough for a small shop?
Often yes, if one person updates it every day and there is no online shop reading the same stock. When those three things stop holding, it is worth thinking about a system.
How often should we do a stocktake?
With rolling counts, one part each week, the full stocktake becomes a check rather than a lost day. The tax deadlines for it are for your accountant to confirm.
Does the system issue fiscal receipts too?
No. The receipt and the transmission of the daily takings stay with the electronic register. The system keeps the goods, the sales and the orders.
Describe your shop
Signing up is free and you will not be asked for a card. Tell us how goods come in and go out of your shop, and look at the result before you spend a thing.