Ask three people in most growing businesses how much of a fast-moving item is in stock and you will often get three answers. The store register says one figure, the accounts system another, and the storekeeper, after a walk to the rack, a third. Everyone has learned to live with it: sales confirms orders "subject to availability", purchasing buys a little extra just in case, and month-end closes with an adjustment nobody can fully explain.
Real-time stock is not about fancy technology. It is about one figure that everyone trusts, because it is updated at the moment goods physically move. This article explains why registers drift, what a trustworthy inventory system needs, and how to get there in stages.
Why stock registers drift
Stock figures rarely go wrong because of one big mistake. They drift through many small, ordinary gaps:
- Late entry. Goods are received or issued in the morning and written up in the evening, or on Saturday, from memory and chits.
- Unrecorded movements. Items borrowed between departments, samples taken by sales, returns left at the gate.
- Unit confusion. Bought in cartons, stored in boxes, issued in pieces or metres, with conversions done in someone's head.
- No location. The system knows you have the item, but not which store, rack or bin. Stock that cannot be found is, in practice, stock you do not have.
- Duplicate codes. The same item entered twice under slightly different names, so one code shows plenty and the other shows nothing.
- Adjustments without reasons. Differences are corrected to match the count, but nobody records why, so the same problem repeats.
Each of these is a process problem first. Software can make the right behaviour easier, but it cannot fix a process nobody has defined.
Stock you can trust is not counted into existence at month-end. It is recorded at the moment it moves.
What "real-time" actually requires
A trustworthy inventory system rests on five foundations. Get these right and the technology choice becomes much simpler.
1. A clean item master
One code per item, with a clear description, a base unit, approved conversion units, a category and, where relevant, attributes such as colour, size, grade or shelf life. Cleaning the item master is tedious and essential. Most failed inventory projects skipped it.
2. Defined locations
Decide the level of detail you need: warehouse, store, zone, rack, bin. A trading business with one godown may only need zones. A factory store with thousands of trims may need bins. Label every location physically, so a scan or a selection on screen matches a real place.
3. Every movement has a document
Receipts against purchase orders, issues against requisitions or production orders, transfers between locations, returns, write-offs. If a movement has no document type, it will happen off the books. List the movements in your business and make sure each has a simple form in the system.
4. Capture at the point of movement
The person who moves the goods records the movement, at that moment, on a phone, a tablet or a scanner. Barcodes or QR labels on items, cartons or locations remove typing and most errors. This one change does more for accuracy than any report.
5. Reasons for every adjustment
When a count differs from the system, the adjustment should require a reason (damage, theft, unit error, unrecorded issue) and an approver. Over a few months, the reasons tell you exactly where your process leaks.
Counting: stop relying on the annual stock-take
A full annual count is disruptive and, by the time differences are found, too late to trace. Cycle counting works better: count a small set of items every day or week, so that every item is counted several times a year and the most valuable or fast-moving items most often.
- Rank items by value and movement, and count the top group most frequently.
- Count without showing the counter the system figure, so the count is independent.
- Investigate large differences the same day, while people still remember what happened.
- Track accuracy by location and by storekeeper, as a guide to where training or process changes are needed, not as a stick.
Questions to ask before choosing a system
Whether you buy a product, extend your accounting software or build something specific, test it against your real situations:
- Can it handle our units of measure and conversions without workarounds?
- Does it support batches, lots, expiry dates or serial numbers if we need them?
- Can storekeepers record movements on a phone or scanner, including when the connection is weak?
- Can it show stock by location, and reserved stock against open orders, separately from free stock?
- How does it post stock value to accounts, and which valuation method does it use?
- Does every adjustment keep a full history of who, when and why?
- Can we set reorder levels and get alerts, rather than discovering shortages on the day?
A phased path
Trying to switch every store and every item at once is the most common way to lose confidence in a new system. A phased approach is safer:
- Clean the item master for one store or category and agree the units and codes.
- Label locations and items in that store.
- Do an opening count and load it as the starting balance.
- Go live with receipts and issues only, recorded at the point of movement.
- Start cycle counts after the first two weeks and fix the process gaps they reveal.
- Add transfers, returns and reorder alerts, then connect to purchasing and accounts.
- Roll out to the next store using what you learned.
Run the old register in parallel for a short, fixed period only. Parallel running that drifts on for months tells staff the new system is optional.
What changes when stock is trusted
The benefits show up in conversations rather than reports. Sales can confirm delivery dates without phoning the store. Purchasing buys what is needed instead of what feels safe. Production planners know whether trims are actually on the shelf before a line is loaded. Month-end closes without a mystery adjustment. And the storekeeper, often blamed for differences they did not cause, has a clear record of what happened.
Where RAED fits
We design and build inventory and warehouse systems around how goods actually move in your business, including scanning, locations and links to purchasing, production and accounts. Where a packaged product fits well, we will help you configure and connect it instead.
