Guide
How to keep track of stock in a shop, step by step
Good stock records start with a few habits, and the software comes later. The steps below work just as well with a notebook or an Excel sheet. At the end we show what changes once a program does them for you.
1. Make the item list
Each product gets its own row with the name, a code you choose, the unit, the purchase price and the selling price. Variants sold separately (size, colour, weight) get a row each. Without the list, none of the numbers you write later has anything to stand on.
2. Count everything once
Pick a day when the shop is closed, or a quiet evening, and count everything on the shelves and in the back room. That is your starting point. From then on you work stock out on paper instead of counting it: what there was, plus what came in, minus what went out.
3. Record every delivery on arrival
Write the goods down the moment they come through the door, using the supplier’s document. Doing it from memory in the evening is how things get missed. Check that the document matches what actually arrived, and sort out any difference with the supplier that same day so it doesn’t surface at stocktaking.
4. Take off every sale
This is the step where most records fall apart. With a notebook, take off the day’s sales at closing time using the cash register report. In Excel, keep one sheet for goods in and one for goods out, and get stock from the difference between them rather than from a column somebody rewrites by hand.
5. Record the outgoings that are not sales
This means goods that expired, broke, came back or were taken for the shop’s own use. If nobody writes them down, they turn up at stocktaking as “missing” and nobody can say why.
6. Set a minimum for each item
For items that sell often, decide the quantity at which you reorder. If you check that column each morning, you order in time and there is no need for big orders placed on a hunch.
7. Do short, frequent stock counts
Counting a few shelves every week works better than one big count a year. A difference you find quickly can usually be explained, while one discovered a year later mostly stays a mystery.
When the notebook and Excel are no longer enough
The warning signs repeat in almost every shop. The figures in the sheet stop matching the shelf, several people are editing the same file, or, if you also sell online, the same item gets sold twice. What you can do at that point is explained in How to stop using Excel for stock.
How a program made for your shop does it
On the platform you explain in plain language how you work, and it builds the program around the steps above and takes over the repetitive part on its own.
- You import the item list from the spreadsheet you already have, without redoing it.
- Deliveries and sales change the stock in one place, so nobody rewrites it by hand.
- The online shop shows the same quantity that is on the shelf.
- You get a reminder when an item drops below the minimum you set.
- At stocktaking you just count, and the program shows you where the records differ.
- Ask what hasn’t sold for three months and the list comes straight back.
Frequently asked questions
Can I keep track of stock in Excel alone?
Yes. In a small shop with few items and one person working in the file, Excel is enough. The important thing is to keep goods in and goods out apart and to work stock out from them.
How often should stock be counted?
No single frequency suits everyone. If you count a few shelves a week, you catch differences while you still remember where they came from.
How much does stock software for a shop cost?
You open the account for free and without giving card details. After that you pay from credits bought in advance as you use the program, with no subscription, plus a daily hosting fee while the project is active. The exact rates are on Pricing.
Describe your shop
Your account is free and needs no card. Describe how goods come in and go out at your shop and see what program comes out of it.