The quick answer
Stock mismatch happens when a goods movement is not recorded, recorded late, or recorded wrongly. The most common causes are goods received without a proper GRN, items put in the wrong rack, issues to production not entered, wrong units of measure and dispatch errors. The lasting fix is to scan every movement at the moment it happens, and to count a few racks every week instead of once a year.
Theft is rarely the main reason. In most stores, the gap comes from small process misses that add up every day. The good news: process misses can be fixed.
What is a stock mismatch?
A stock mismatch (also called an inventory discrepancy or stock variance) is the difference between what your system says you have and what is really on the rack.
- System stock — the quantity in your ERP, Tally, SAP or Excel sheet
- Physical stock — the quantity you count on the rack, bin or floor
- Variance — physical stock minus system stock (it can be a shortage or an excess)
A mismatch hurts in three ways. Production stops because a part “in stock” is not there. Money is locked in extra stock you did not know you had. And at year end, the books need write-offs that nobody can explain.
How to measure stock accuracy
Do not guess. Measure. The simplest measure is location accuracy:
Stock accuracy % = (locations where count matches system ÷ locations counted) × 100
| Step | Example |
|---|---|
| Racks or bins counted this week | 200 |
| Locations where count = system | 184 |
| Stock accuracy | 184 ÷ 200 × 100 = 92% |
| Value of the gap | Add up (variance qty × unit cost) for the 16 wrong locations |
Example only. Sample numbers.
Track two numbers every week: accuracy % and the value of the gap. Many industry guides treat 99% or above as a strong target for barcode-run warehouses. If you are far below that, the causes below are where to look.
10 common causes of stock mismatch
| Cause | What you see | Fix |
|---|---|---|
| 1. Goods received without GRN | Stock on the rack, not in the system | No unloading without a gate entry and GRN |
| 2. GRN quantity copied from the invoice | Short supply recorded as full | Count or scan what really came, then match to the order |
| 3. Wrong rack at put-away | System has stock, team cannot find it | System suggests the rack; scan the rack to confirm |
| 4. Issues to production not entered | System higher than rack | Issue only against a material request, scanned at the counter |
| 5. Unit of measure mix-up | Boxes entered as pieces, kg as numbers | One base unit per item, with fixed conversions |
| 6. Duplicate or wrong item codes | Same part under two codes | Clean the item master; block new codes without approval |
| 7. Dispatch errors | Customer gets wrong item or quantity | Scan-to-pick and scan-to-load before the gate pass |
| 8. Returns mixed with good stock | Rejected items issued again | Keep returns and quality-hold stock in a separate location |
| 9. Late data entry | Numbers right on Monday, wrong by Wednesday | Record at the moment of movement, not at shift end |
| 10. Damage, scrap and loss not booked | Slow, steady shortage | Simple scrap entry with a reason and a photo |
Swipe sideways to see all columns.
How to investigate a mismatch: 7 steps
- Freeze the item. Stop issues and receipts for that item for a short time, so the count is clean.
- Recount. A different person counts again. Many “mismatches” are just counting mistakes.
- Search nearby locations. Check the racks next to it, the overflow area, the quality-hold area and the dispatch bay.
- Check open documents. Look for GRNs not posted, issues not entered, pending dispatches and returns not booked.
- Check the unit of measure. Compare the purchase unit, the stock unit and the issue unit.
- Trace the movement history. Go back to the last date the count was right, and check every movement since then.
- Fix the cause, then adjust. Post the stock adjustment with a reason code, and write down the root cause so it does not repeat.
Step 6 is where most stores get stuck. If movements are written on paper or entered at shift end, there is no reliable history to trace. That is why the long-term fix is about recording, not counting.
How to stop stock mismatch coming back
- Every truck gets a gate entry before unloading
- Every GRN is based on what was really received, not the invoice
- Every rack and bin has a barcode or QR label
- Put-away, issue, pick and load are scanned at the moment they happen
- Returns, rejects and quality-hold stock have their own location
- One clean item master with one base unit per item
- Weekly cycle count of a few locations, with accuracy % tracked
- Every stock adjustment needs a reason and an approver
- The gate pass is issued only after the load is scanned
Cycle count or yearly count?
| Point | Yearly full count | Cycle count |
|---|---|---|
| How often | Once a year | A few locations every week |
| Store shutdown | Often one or more days | Not needed |
| Finds the cause | Hard — the error may be months old | Easier — the error is recent |
| Best for | Year-end books | Day-to-day accuracy |
Swipe sideways to see all columns.
A simple rule: count fast-moving and high-value items more often (for example monthly), and slow, low-value items less often. Most plants still do a year-end count for the books, but cycle counts keep the numbers right in between.
Excel or a warehouse management system?
Excel works when one person handles a few hundred items. It starts to fail when several people move stock across shifts, gates and racks. Excel cannot tell you who moved what, from where, and when.
A warehouse management system (WMS) records each movement with a scan, a person, a place and a time. That gives you the movement history you need in step 6 above, and it stops many causes before they happen.
How DinMind WIMS helps: WIMS is a barcode-based warehouse management system for factory stores and warehouses. It covers gate check-in, GRN, guided put-away, live stock by rack and bin, stock counts with reasons, scan-to-load with photos, the QR gate pass and returns kept apart from good stock. It connects to your ERP, and most DinMind modules go live in 4–8 weeks.
Country notes
The causes are the same everywhere. But tax and audit rules decide which stock records you must keep.
- India: Under CARO 2020, company auditors report whether physical stock was verified at reasonable intervals, and whether discrepancies of 10% or more in total for a class of inventory were found and properly dealt with. GST also requires stock records, and moving goods usually needs an e-way bill.
- Gulf (UAE, Saudi Arabia, Qatar): Businesses registered for VAT must keep proper records. Stores with free-zone or customs-bonded stock need clear location-wise records.
- South-East Asia: Singapore, Malaysia, Thailand, Vietnam and Indonesia each have their own tax and audit record rules. Multi-site plants should use the same counting method at every site.
- USA, UK and Australia: Year-end audits usually include attending or testing a physical stock count, so a clean count history and movement record make audits faster.
General information only, not legal, tax or audit advice. Rules change — always check with a local advisor.
More guides: What is a warehouse management system? · How to choose warehouse management software · all DinMind guides