Where do stock discrepancies come from? Counting, movements and authority

Why does system stock not match shelf stock? Six common sources of stock discrepancies, how to count correctly and a practical checklist for authority rules.

FUFerhat UğurluYazSis TeamPublished: November 5, 20265 min read

The count is finished; the item that showed twelve in the system turns out to be nine on the shelf. The first reaction is usually to look for someone to blame, yet most of the discrepancy comes from the way records are kept, not from a person. A stock discrepancy is the difference between the quantity recorded in the system and the quantity actually counted on the shelf, and its source lies in a movement that happened before the count and was recorded wrongly or not at all.

In this article we explain the common sources of stock discrepancies, how to set up a count and how the authority structure affects the difference. In this frame we also cover the transfer, count, lot/serial, barcode and location topics that YazSis ERP includes on the stock and warehouse side.

Six common sources of discrepancy

  1. An unrecorded movement. Goods have been received but not booked in; a sample was given out, set aside as scrap or returned, but no record was opened. The gap quietly builds up until count day.
  2. A wrong unit or a duplicate card. The same product was entered as cartons in one place and as pieces in another; or two separate stock cards were opened for the same product. Movements are spread across two cards and both look “wrong”.
  3. Goods lost in a transfer. The issue from one warehouse was recorded but the receipt in the other warehouse has not yet been made. On paper the goods are in transit; but because nobody tracks this, they can stay in transit for months.
  4. Lot or serial mix-up. Even when the total is right, different batches have been mixed. The total matches at the count, but the difference appears when you look by lot.
  5. An unexplained issue. Material taken without a record, or an item that is not on the shipment slip, is the hardest kind of discrepancy to trace. It mostly stems from authority limits being set too wide.
  6. The count itself. If movement continues during the count, an item may have been both counted and shipped. An item in the wrong location is also written down as “missing”.

Looking at the list carefully, you can see that most of the sources have to do with record-keeping and authority, and only one with the counting method. In other words, however meticulously you count, the discrepancy will return until the movement discipline is in place.

Setting up the count correctly

A count should be a tool for understanding the cause of a discrepancy, not just for finding it. Counting the whole warehouse once a year on the same day and correcting the resulting difference in bulk does not close the problem; it only postpones it. This calls for counting regularly and closing every discrepancy found with a cause.

  • Stop receipts and issues in the area being counted, or mark the movements made after the count separately.
  • Count by location; counting by shelf, zone or warehouse narrows down where the discrepancy appears.
  • For items tracked by lot and serial, verify not only the total but also the quantity per lot.
  • If you use barcodes or RFID, scanning replaces the handwritten count sheet; scanning reduces typing errors.
  • When correcting a discrepancy, record its cause: counting error, unrecorded issue, goods waiting in a transfer and so on.

The order to follow when a discrepancy appears

Entering a correction right away when a discrepancy is found is the easiest but most harmful path, because the cause is lost and the same discrepancy shows up again in the next count. Instead, working in the following order narrows down the source of the discrepancy:

  1. Look at all the receipt and issue movements of the item since the last count; is there a missing or duplicate record?
  2. Check open transfers, pending shipments and incomplete goods-receipt records.
  3. Search whether the same item is recorded under another card, unit or location.
  4. If an unexplained discrepancy remains, correct it by tying it to an authorized approval together with its cause.

Authority: who can change what?

A stock discrepancy is often a question of authority. If anyone can make a stock correction, the discrepancy becomes a number that can be adjusted and its cause disappears. That is why operations such as stock corrections, transfer approvals and closing a count should be tied to different roles: the warehouse clerk enters the movement, the person in charge approves the discrepancy, management sees the report. YazSis ERP adapts this approval structure to the business’s rules; who approves what is decided in the process analysis.

Ask about the movement first, then the person. Most stock discrepancies are the trace of work that was never recorded.

The goal is not to zero the discrepancy but to make it visible

No software makes the goods on the shelf match the system on their own. The software’s job is to make it traceable where and why a discrepancy appears. When an open transfer record, a stock correction without rules or a difference showing up by lot becomes visible in reports, the correction also turns into a systematic job that does not depend on one person. The sales team hears sooner about promising an item that is not in stock, and the finance team hears sooner about an inflated or understated stock value.

If you are thinking of bringing your stock and warehouse processes into a single data flow, you can look at the stock and warehouse area on the YazSis ERP page.

Frequently asked questions

What is a stock discrepancy?

It is the difference between the stock quantity recorded in the system and the actual quantity found on the shelf at the count.

Where do stock discrepancies come from most often?

Mostly from movements that were not recorded or were recorded wrongly: a delivery that was not booked in, a record left open in a transfer, a wrong unit and unauthorized corrections.

What does YazSis ERP cover on the stock side?

In the stock and warehouse area it covers transfer, count, lot/serial, barcode, RFID and location topics.

How often should a count be done?

This depends on the business’s product structure and how much movement there is. Counting more often in high-movement or valuable product groups and less often in the others is a common approach.

FU
Ferhat Uğurlu · YazSis Team

Builds enterprise software, AI and digital transformation products together with the YazSis team.