Practical guide
Managing your stock without a spreadsheet
A stock spreadsheet always starts well, then one day it no longer matches what is in the storeroom. For a shop or a hospitality business, here is how to keep reliable stock without spending your evenings on it.
Why the spreadsheet always falls behind
The problem with a spreadsheet is not the tool, it is that it depends on someone remembering to update it. A delivery put away in a hurry on a Saturday, a breakage not recorded, a bottle taken out for service without being counted: within a few weeks, the figures no longer mean anything. And stock figures you no longer trust are figures you stop checking.
Reliable stock rests on a simple idea: every movement must be recorded when it happens, ideally with no extra effort.
Stock out: let the till do the work
In a shop, most stock leaving is sold. If your till and your stock are linked, each sale automatically deducts the items. No more counting what went out during the day.
In hospitality it is a little more subtle: you sell a dish, but you use ingredients. A recipe card (the recipe with its quantities) lets you deduct raw materials each time a dish is sold. It is never accurate to the gram, but it is more than enough to know when to reorder.
That leaves stock that does not go through the till: breakages, losses, staff consumption, items given away. Have a quick way of recording them, for example from a phone, with a reason. That is also what will help you spot leaks.
Stock in: receiving deliveries properly
On delivery, you check and record. The most efficient way is to start from the purchase order: tick what has arrived, correct missing quantities, and the stock is updated. Scanning barcodes speeds things up a lot when products have them.
If your suppliers send you electronic invoices, part of the data entry can even be picked up automatically. That is one of the useful side effects of Peppol invoicing.
Reorder alerts: the real time saver
For each important item, set an alert threshold: the quantity below which you need to reorder, taking your supplier’s delivery time into account. The software warns you or, better still, prepares a proposed order per supplier that you simply have to check.
These thresholds are not set once and for all. A terrace in summer, the festive season, a product on promotion: review them as the seasons change, using your sales history.
Use-by dates and traceability
For food, you need to distinguish between the use-by date, which must be strictly respected, and the best-before date. A good tool records the date of each batch on receipt and flags products nearing their date, so you can sell them, cook them or remove them in time.
The rule to apply in the storeroom is simple: first expired, first out. The software can tell you which batch to use first.
Recording batches also helps with the traceability required in the food sector: knowing where a product comes from and, in the event of a recall, quickly finding the batches concerned. The exact obligations depend on your business; the FASFC (AFSCA) publishes self-checking guides for each sector.
Stocktaking: less often, but better
Even with stock kept up to date continuously, a physical count is still needed, at least once a year for the accounts. With reliable stock, the stocktake becomes a check: you count, compare with the theoretical figures and analyse the differences. Many shopkeepers also do rolling counts, a few shelves at a time, to avoid closing for a day.
Where to start
- List your items with a clear unit (piece, bottle, kilo).
- Link the till to the stock so that sales are deducted automatically.
- Set thresholds for your twenty or thirty most important items only.
- Get into the habit of recording breakages and losses from your phone.
- Then expand, once the routine is in place.
Ouibel installs POS systems and develops custom management tools that link the till, stock, supplier orders and use-by dates.
Frequently asked questions
In brief
Do all products need barcodes?
No. They speed up receiving and selling, but stock management works very well with items chosen on screen for products without a code.
Can stock be updated from the till?
Yes, if the till and the stock software are linked: each sale deducts the items, or the ingredients for a dish with a recipe card.
How do I manage several outlets?
With stock per location and recorded transfers between them. You can see where each product is and avoid running out in one shop when the other has too much.
Can Ouibel link my current till to a stock system?
It depends on the till and what it can export. Contact us with the model: we will tell you honestly what is feasible.
Going further
Also worth reading
A question about your project?
We'll answer it, free of charge.
Tell us about your situation: we will get back to you within 24 working hours.