Stock Not Matching Physical Count? Fix the Gap at Its Source
For store managers, owners and accountants who find the shelf and the system disagreeing: find why, correct it properly, and keep it from drifting again.
With stock not matching physical count, fix the process before you fix the number. Overwriting the book figure with the count makes this month's report look right, but the cause stays and the gap returns by the next count.
In Indian SMEs the usual pattern is familiar. Material is issued to the floor without an entry, a return sits in a corner unrecorded, a carton is booked as pieces, or goods on a tempo between godowns are counted nowhere.
This page covers the causes, how to check each, an illustrative example, and how Apragya runs cycle counts and posts the difference with a reason.
Why stock does not match the count, and how to check each cause
Seven causes explain most gaps: goods issued without an entry; receipts booked before goods arrived, or the reverse; the wrong unit of measure; customer or supplier returns not entered; stock in transit between locations; the wrong item or variant picked; and loss, damage or theft.
Check them in that order. Compare unbilled deliveries and open issue slips with the gap, look at recent receipts for unit errors, walk the returns area, and check transfers dated around the count. Whatever is left after these checks is genuine loss.
Correct each cause with the missing entry, not a blanket adjustment. Post only the true remainder as a variance, with a reason, and count fast items more often.
- Freeze movement for the items being counted.
- Count by bin and record the quantities.
- Trace differences to entries that are missing.
- Post the missing entries first.
- Adjust the remainder with a reason.
What a stock mismatch in inventory costs
Wrong orders
Buyers reorder items that are on the shelf, and miss ones that are not.
Promises broken
Sales commits stock that does not exist.
Wrong profit
Closing stock value, and so profit, is misstated.
Audit questions
Unexplained write-offs draw questions from auditors.
An example: an auto parts distributor in Ludhiana
Take an illustrative distributor holding around three thousand items in one godown with bins. The year-end count showed large gaps on fast items, and the owner wanted to know why before writing anything off.
What the gap on brake pads turned out to be
- Unposted issuesCounter sales given out before the bill was made.Mismatch
- Unit of measureOne receipt booked in sets instead of pieces.Mismatch
- ReturnsTwo customer returns kept aside, never entered.Missing
- Transit stockNothing was on the road on count day.Checked
- Wrong binThe loose cartons were found in the next bin.Matched
- Count reasonEach remaining difference posted with a reason code.Done
The owner changed three habits: bills before goods leave the counter, returns entered on the day, and one unit per item. The remainder was posted as an adjustment with reasons, and the next monthly cycle count on fast items showed only small differences.
How physical stock verification works in Apragya
Step 1 of 5
Plan a cycle count
Count everything, only items that moved in a period, or one item group.
- Plan a cycle count: Count everything, only items that moved in a period, or one item group.
- Freeze while counting: Items in the count are held from movement until it is done.
- System quantity kept: What the books said is snapshotted when the count is created.
- Count by bin: Enter physical quantities by item and bin, with barcodes where you use them.
- Post with a reason: Differences post to the stock ledger and an inventory adjustment entry.
Inventory variance: overwriting against reconciling
Overwriting the book figure hides the cause. Reconciling keeps the expected and counted quantities, the difference, its value and the reason, so a repeated cause shows up.
Overwriting stock, against Apragya
| Feature | Overwrite in a sheet | Apragya cycle count |
|---|---|---|
| Expected quantity | Lost once overwritten | Kept on the count line |
| Movement during count | Goes on | Frozen for items in scope |
| Reason | Rarely recorded | Reason code per line |
| Accounts | Adjusted separately | Adjustment entry posted with the count |
| Frequency | Once a year | Cycles by group or movement |
Checked against public information on 16 September 2026.
What keeps stock accurate after the fix
Transit tracked
Goods between locations are held in transit, not lost.
Batches and expiry
Counts can be recorded by batch and serial.
One record
Sales, purchase and production post to the same stock ledger.
AI you can put to work
An agent can flag items with repeated variances.
Roles for counting
Counting and posting can be given to different roles.
Audit log
Who posted each adjustment is recorded.
Read about the stock ledger, barcodes and inventory period close.
Getting started with a count
- Pick your twenty fastest items.
- Create a cycle count for them and freeze movement.
- Count by bin and enter the quantities.
- Trace each large difference to a cause.
- Post the rest with reason codes.
Counting a small group every month usually beats one big count a year.
What it costs to start
Physical stock verification, answered
Do we have to stop the godown to count?
Can we count only items that moved?
How is the difference valued?
Can a posted adjustment be reversed?
What does it cost to start?
Count a small group this week
Run a cycle count on your fastest items and see where the gaps come from.