Skip to content
Back to the retail blog

Inventory

Why your retail stock count does not match your records

Find the cause of a mismatch before another adjustment hides it.

Inventix report rows used to review transaction dates and references
Inventix report rows used to review transaction dates and references

The short answer

Check the location, unit and variant first, then reconcile purchases, sales, returns and transfers since the last reliable count. Only record a correction after you understand the difference; another unexplained adjustment can hide the original problem.

Check the store and unit first

The right product in the wrong store is still the wrong quantity. Confirm the location, variant and unit before comparing a physical count with the product record.

If the product list shows stock across all stores, apply a location filter before comparing it with one physical shelf. Check whether staff counted individual items or boxes, and whether two similar products have been confused.

A difference is a reason to investigate, not proof of theft or a software failure. Start with records and timing before making that judgement.

Check recent movements

Review sales, purchases, transfers, returns and adjustments since the last known correct count. A held cart is not proof of a completed sale, and a quotation is not a stock movement.

Inventix report rows for checking the documents behind totals

Understand held orders and stock transfers.

Reconcile one product all the way through

Here is an illustrative sequence for one store with no other movements:

Movement Quantity change Quantity afterwards
Starting quantity 10 10
Received supplier purchase +5 15
Completed sale -3 12
Customer return to stock +1 13
Transfer to another location -2 11

If the physical count is 11, the movements explain it. If it is 9, inspect the references, actual delivery and counted units before recording a two-unit loss. The receiving store should show the transferred 2; the business has not lost them merely because they left this location.

Use the records behind totals, not only a dashboard summary. Review reports and received purchases.

Check when the count was taken

A physical count can become stale while staff are selling or receiving stock. The current count workflow rejects a stale snapshot rather than overwriting newer movements. Reconcile what changed and use a fresh count when needed.

Complete a stock count.

Coordinate the count with staff. If they sell while you are counting, a perfectly counted shelf can still be compared with the wrong moment in the records. Keep the original file and references when investigating a stale-count warning.

Record the correction you can explain

Use an adjustment for an identified loss or correction. Enter a reference and details that another team member can understand later. Do not repeatedly adjust the same unexplained gap without investigating its source.

Record a stock adjustment.

Prevent the same mismatch tomorrow

Use individual staff accounts, clear store names and a stable product code. Record physical transfers with one shared reference. Save only the quantities actually received from suppliers and avoid importing starting stock again to reset an existing product.

Make small spot checks on frequently moved items instead of waiting for a full-store count to expose the problem. When you ask support for help, include the store, product code, approximate time and safe references, not your full customer export or passwords.

Continue with staff access, spreadsheet imports, or support.

Use a few of your own products before you decide.

No card required. Setup guidance is included during the trial.

Start free trial