6 min read Inventory control

Why inventory never matches

The gap between the system and the shelf is hardly ever theft: it's six specific, fixable causes, and none of them throws an error message.

It's hardly ever theft

When the physical count doesn't match the system, the first suspicion is usually that stock is missing. Sometimes that's true. But in most cases we've seen, the stock is there: what fails is the record.

And the record fails for specific, repeated reasons, not bad luck. What follows are the six that show up again and again.

The six causes

  • The goods arrived before the paperwork. The truck came, it was unloaded and it went on the shelf. The supplier's invoice was entered three days later. In between, the system says one thing and the warehouse another — and those days' sales come out of stock the system doesn't know exists.
  • Sold without deducting. A sale that generates no stock movement. It happens with invoices raised outside the system and with modules that aren't connected to each other.
  • The unit of measure changed along the way. You buy by the case and sell by the unit. If the conversion isn't set up right, the error literally multiplies: a case of 24 deducted as one unit leaves 23 phantoms.
  • Returns don't come back. The customer returns something, the credit note is raised, and the goods sit in a corner without re-entering the system.
  • Shrinkage isn't recorded. What breaks, what expires, what's used internally. If it isn't written off, the system keeps counting it for months.
  • Transfers are left half done. It left one warehouse and the receipt at the other never got recorded. It's in the company, but for the system it's nowhere.

And then there's cost, which is the real problem

Being out on quantities is annoying. Being out on cost is what takes the margin with it, and it's far less visible.

If an item's cost is wrong, every sale of that item reports a wrong margin. No error, no warning: the profitability report says something untrue. Decisions get made on it — what to promote, what to drop, who to buy from — and they're made wrongly. We go into it in average cost or FIFO.

A stock adjustment corrects the QUANTITY, not the cost. If you bring in 10 missing units, they come in at the cost the system already had. When it's the cost that's wrong, adjusting quantities doesn't fix it and covers it up as well.

How to fix it, in order

The usual mistake is to start with the count. Counting a warehouse whose processes are still broken gives an exact number that's wrong again in two weeks. The order that works is:

  • First, close off unrecorded movements in and out. So nothing leaves without a document and receipts get recorded on receipt, not on invoicing.
  • Second, fix the unit conversions. It's a short job and it eliminates a whole class of errors.
  • Third, count. Now yes, and the count is what you adjust from.
  • Fourth, cycle counts. Not one full stocktake a year, which also means shutting down. A few items every week, starting with the fastest-moving and most valuable.

What doesn't work is the reverse: count first and promise that from now on everything will be recorded. That was already promised last year.

Inventory and supply

On the same topic

An inventory that does match

Zyntello's Inventory module records every movement with its source, carries the cost and shares the same database as Purchasing, Invoicing and Accounting. There's no integration that can be left half done.