INVENTORY INSIGHTS / WHOLESALE & TRADING

Inventory Discrepancy:
System Shows Stock,
Warehouse Can’t Find It

When the system says 50 units but the shelf is empty, the stock rarely vanished. A delivery, transfer or return was usually not recorded on time. Here are 6 causes of inventory discrepancy, 5 fixes and a checklist to use before you adjust stock.

Malaysian storekeeper in tudung holding a tablet while a warehouse supervisor points at an empty pallet bay, showing an inventory discrepancy

Goods, documents and data must move together.

01 / 6 causes

Where records and the shelf drift apart.

02 / 5 fixes

Process changes that keep stock accurate.

03 / Checklist

What to check before you adjust stock.

01 / THE REAL PROBLEM

What Is an Inventory Discrepancy?

An inventory discrepancy is a gap between the stock your system records and the stock on the shelf. Your system calculates stock from posted transactions, so a late, skipped or wrong posting leaves the balance out of step.

50In the system

Based on posted documents.

0On the shelf

What the warehouse can find.

1Waiting order

What Sales has already promised.

Data flow

Most gaps start at the desk, not the rack

Goods often leave before the Delivery Order is posted. Until it is, the old balance stays and Sales keeps selling it.

Malaysian warehouse admin clerk posting a delivery order on a computer while a driver waits with cartons on a trolley

02 / SIX COMMON CAUSES

6 Common Causes of Inventory Discrepancy

Missing stock is rarely theft. Check these process gaps first.

01Late posting

Goods leave before the Delivery Order is posted. Watch for unposted DOs at day end.

02Manual entry

Paper, spreadsheets and chat messages add handovers. Watch for data typed twice.

03Skipped scans

Scanners only help when every movement is scanned. Watch for rush jobs.

04Unsynced transfers

Stock moves between warehouses but is recorded days later.

05Negative stock

Selling past the balance to “fix later” distorts cost and reorder data.

06Unclear documents

Staff are unsure whether the SO, DO or invoice moves stock.

Moving goods between locations? Follow the AutoCount stock transfer guide.

03 / BUSINESS IMPACT

How Inventory Discrepancy Hurts the Business

01Customer orders

Sales confirms stock that is not on the shelf.

02Delivery

Staff search for goods or rush emergency transfers.

03Customer trust

Delays and cancelled orders.

04Operating costs

Urgent buying, transport and overtime.

05Purchasing

Reordering stock you have, or missing real shortages.

06Reports

Wrong stock valuation and delayed billing.

04 / FIVE FIXES

5 Ways to Fix Inventory Discrepancy and Improve Accuracy

FIX 1One system

Sales, purchasing, warehouse and accounts share the same stock records.

FIX 2Post promptly

Post deliveries by day end and transfers before goods leave.

FIX 3Scan every move

Set rules for wrong scans, damaged labels and quantity differences.

FIX 4Sync locations

Show stock as in transit, received, reserved or quarantined.

FIX 5Count regularly

Cycle-count fast-moving and high-value items. Investigate before adjusting.

Barcode scanning

Scan at receiving, not just at dispatch

Scanning confirms the item, quantity and location as goods arrive. It only helps when it is a required step, not an optional one.

Malaysian warehouse worker scanning a carton barcode at the receiving bay while a colleague checks quantities on a clipboard

05 / CYCLE COUNTING

How to Run a Cycle Count That Catches Inventory Discrepancy Early

A cycle count checks a small group of items often, instead of counting the whole warehouse once a year. It finds gaps while the cause is still easy to trace.

STEP 1Pick the items

Start with fast-moving, high-value and frequently adjusted items.

STEP 2Freeze movement

Post pending DOs, receipts and transfers for those items before counting.

STEP 3Count blind

Counters record what they find without seeing the system quantity.

STEP 4Investigate, then adjust

Trace each gap to a document or location before posting an adjustment with a reason.

On the warehouse floor

Count by location, not just by item

Record the rack or bin with every count. A gap that appears in one location usually points to a transfer or put-away that was never posted.

For a full count, see our stock take guide for Malaysian businesses.

Malaysian warehouse supervisor pointing at shelved cartons while a colleague in tudung records a cycle count on a Kiraan Stok stock count sheet

06 / TROUBLESHOOTING CHECKLIST

Inventory Discrepancy Checklist Before You Adjust Stock

Ask where the data stopped flowing, not only where the goods went. Fix that workflow step, then post the adjustment with a reason.

Malaysian wholesale warehouse supervisor and storekeeper checking stock records with a clipboard and barcode scanner
CheckWhat to look for
Unposted documentsDelivery orders, goods received, returns, transfers and adjustments
LocationBranch, warehouse, bin or temporary storage area
Reserved stockQuantities already committed to Sales Orders
TransfersBoth sending and receiving sides are complete
Negative stockItems issued before receiving was posted
Unit of measurePiece, box or carton conversions
Returns & damagePosted to the correct stock status
TimingReport time compared with movement time

Keep the paper trail. LHDN Public Ruling 5/2000 says a physical stock-take should be made at the end of the accounting period, and Public Ruling 4/2000 (Revised) expects companies to keep sufficient records for 7 years. Recording why each adjustment was made helps at audit time.

07 / WHERE AUTOCOUNT FITS

Keep Orders, Deliveries and Stock in One System

The AutoCount inventory system links sales, purchases, transfers and stock by location. Use AutoCount Stock Take for counts and the Stock Availability Report plugin to see stock by location.

Results still depend on a consistent workflow. Software records what your team posts.

Inventory Discrepancy: Common Questions

01What causes an inventory discrepancy?

Usually a delivery, transfer, return or adjustment that was posted late, skipped or entered wrongly, so the recorded balance no longer matches the shelf.

02Should I adjust stock as soon as it does not match?

Not yet. Check unposted documents, locations, reserved stock, transfers, returns and units first. Then adjust and record why.

03Can barcode scanning stop every inventory discrepancy?

No. It reduces entry errors, but only when scanning is required at receiving, picking, transfer, delivery and stocktaking.

04How often should we count stock?

It depends on item count, volume and value. Many businesses add regular cycle counts of fast-moving or high-value items to the year-end stock-take.

05Is negative stock a problem?

Yes. Selling past the recorded balance distorts cost and reorder data. Post goods received before issuing stock.

06How can AutoCount help with inventory accuracy?

AutoCount links orders, deliveries, purchases, transfers, returns and stock by location in one system. Accuracy still depends on posting promptly.

Need Better Inventory Accuracy With AutoCount?

Tell SL Software how your sales, warehouse and stock records work today. We can help you set up an AutoCount workflow that keeps them aligned.

Prefer to read first? See the wholesale inventory management guide.