When Stock Counts Don't Reconcile, the Problem Isn't the Warehouse

When the year-end count shows a variance, the warehouse is the first place people look. Yet most of the gap is not in the warehouse — it is in the recording discipline. The physical goods are where they should be; the number in the system is wrong. That gap opens between the moment goods move and the moment the movement is recorded.

Where Variances Actually Come From

Unrecorded issues. Goods given as samples, sent to an exhibition, consumed in a production trial, or used internally. They are physically gone but still on the books. In most companies this is the single largest component.

Delayed dispatch notes. Goods shipped but the note issued the next day. Count that night and a variance appears. The reverse also happens: the note is issued but the goods are still on the loading bay.

Unit confusion. The same product handled sometimes in cases, sometimes in pieces. Without a defined conversion factor, the error compounds.

Similar products mixed up. Different colours, sizes or dimensions of the same item counted in place of one another. The total reconciles but line items do not — and that is the more dangerous case.

Returns and scrap. Customer returns never booked in, or damaged goods never written off.

First Fix: Record at the Point of Movement

• Handheld or mobile barcode capture. Warehouse staff scan as they handle goods. Anything entered later from an office desk is by definition delayed.
  
• Mandatory movement types. Define separate types for samples, scrap and internal use. An issue with no defined type becomes an unrecorded issue.
  
• Bin locations. Knowing which shelf an item sits on speeds up picking and makes counting far easier.
  

Second Fix: Cycle Counting

• Classify by value. The items making up roughly 80 per cent of turnover or value form your A group.
  
• Set frequency by class. A items monthly, B items quarterly, C items annually.
  
• Count small batches daily. Twenty to thirty lines a day can be counted without stopping the warehouse.
  
[*]Investigate variances the same day. While a variance is fresh its cause can be found; three months later it cannot.

Lot and Serial Tracking

In food, chemicals, pharmaceuticals, cosmetics and spare parts, lot tracking is needed not only for accuracy but for recall obligations. Expect the system to enforce lot numbers and expiry dates at receipt, propose lots automatically on issue by FIFO or expiry, list in one click which customers received a given lot, and warn on approaching expiry dates.

Inventory Cost

Even an accurate count produces wrong profitability if cost is wrong. Choose a costing method deliberately and stay with it: weighted average is enough for most businesses and easy to run; FIFO gives a more realistic picture when prices move quickly.

The items most often left out of cost: freight, customs duty, insurance and any assembly cost. Excluded, they make gross margin look better than it is.

Reorder Points

The aim is not only to count correctly but to hold the right quantity. A reorder point needs three inputs: average daily consumption, lead time and safety stock. With those defined, purchase suggestions generate themselves and the "we've run out, order urgently" scramble disappears.

In Short

A count variance is a recording-timing problem, not a warehouse problem. Record movements at source and at the moment they happen, define movement types for non-sales issues, and move to cycle counting. With those three in place, the year-end count stops being a surprise.

We can shape an inventory setup that fits your warehouse with Mekjoy Inventory & Warehouse Management.