Blog

Why does workshop stock never match? 6 causes and their fixes

5 min read

Count day comes and the system figure does not match the shelf. Loss or theft is the first suspicion, yet in most workshops the bulk of the difference comes from recording habits. Here are the six most common causes and a practical fix for each.

1. Issues are recorded later

Material is taken from the store and the entry is postponed until "this evening". The evening is busy, the next day it is forgotten. The system still thinks the material is on the shelf.

Solution: Record the movement where and when it happens. Terminals in the store and on the shop floor, plus barcode or QR scanning, stop recording from being a separate task.

2. Production consumption is not booked from the BOM

The finished product goes into stock, but the raw materials and semi-finished items used are not deducted, or are deducted by hand and by guesswork. After a few months raw material stock is inflated with material that does not exist.

Solution: When a work order is completed, book consumption automatically from the quantities in the bill of materials. If the BOM is wrong, fix it first; stock accuracy starts with BOM accuracy.

3. Scrap is never recorded

Cutting offcuts, set-up scrap, defective parts: all of it leaves stock, none of it is recorded. A large share of what looks "missing" at count time is simply unrecorded scrap.

Solution: Record scrap as a separate movement and define the expected scrap rate in the BOM. Stock then matches and you can see where scrap is rising.

4. Units get mixed up

Material is bought in kilograms, used in metres and sold in pieces. When the conversion is done in someone's head each time, small differences add up.

Solution: Define unit conversions once on the item card so purchasing, consumption and sales are all calculated in the right unit from the same card.

5. Nobody knows where the material is

The material is in the warehouse, but no one knows where. When it cannot be found it is ordered again; at count time there is double the stock, or none at all.

Solution: Track stock by warehouse, shelf and pallet, and record transfers between warehouses so "I put it over there" lives in the system, not in someone's memory.

6. Count differences are quietly corrected

The difference found at count time is entered as a "correction" and the matter is closed. Because the cause is never found, the same difference appears at the next count.

Solution: Use approved stock counts: the difference report goes to a manager and who approved what is recorded. Investigate large differences; most lead back to one of the five causes above.

Stock accuracy does not come from buying software but from building recording discipline. A good ERP makes that discipline easier: it moves recording to where the work is done, calculates consumption from the BOM and makes differences visible.

Related pages

Let's find out together where your business should start.

Request a Demo