Skip to main content
Apragya AIFree quotation builderQuotation builderQuote builderno signup
Problem solved

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.

Two store staff counting boxed auto parts on a steel rack

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.

  1. Freeze movement for the items being counted.
  2. Count by bin and record the quantities.
  3. Trace differences to entries that are missing.
  4. Post the missing entries first.
  5. 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
Most of the gap had a cause, and only the small remainder was written off.

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.

A tray of neat bins with a few boxes set apart on coloured sheets
Most of the gap was traced to missing entries; only the few set apart were true variances.

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.

  1. Plan a cycle count: Count everything, only items that moved in a period, or one item group.
  2. Freeze while counting: Items in the count are held from movement until it is done.
  3. System quantity kept: What the books said is snapshotted when the count is created.
  4. Count by bin: Enter physical quantities by item and bin, with barcodes where you use them.
  5. 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

FeatureOverwrite in a sheetApragya cycle count
Expected quantityLost once overwrittenKept on the count line
Movement during countGoes onFrozen for items in scope
ReasonRarely recordedReason code per line
AccountsAdjusted separatelyAdjustment entry posted with the count
FrequencyOnce a yearCycles 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

  1. Pick your twenty fastest items.
  2. Create a cycle count for them and freeze movement.
  3. Count by bin and enter the quantities.
  4. Trace each large difference to a cause.
  5. Post the rest with reason codes.

Counting a small group every month usually beats one big count a year.

What it costs to start

INR 3,999
Starter, a month
Up to 10 users, CRM and HR plus Inventory and Warehousing
2,000
AI Credits a month
Included on Starter
Free
Up to 3 users
CRM, HR and Vendor Onboarding

Physical stock verification, answered

Do we have to stop the godown to count?
No. Only the items in the count are frozen, so the rest keep moving.
Can we count only items that moved?
Yes. A count can cover everything, items moved in a period, or one item group.
How is the difference valued?
Each line carries a valuation rate, and the difference posts to an inventory adjustment entry.
Can a posted adjustment be reversed?
A reconciliation can be cancelled with a reason, and the audit log records who did it.
What does it cost to start?
Inventory and Warehousing is available from the Starter plan, INR 3,999 a month for up to 10 users, which includes CRM and HR plus a choice of enterprise apps and 2,000 AI Credits a month. Pro, at INR 7,999 a month, covers 25 users and every enterprise app.

Count a small group this week

Run a cycle count on your fastest items and see where the gaps come from.