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.
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.
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.
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.
