Stock management

How to investigate a stock-count difference in a small shop

When counted stock differs from the record, use a simple variance log to check units, missed sales, damage and supplier deliveries before correcting anything.

By ReceiptPro NG Editorial · Published

A stock-count difference is the gap between the quantity a record says should be available and the quantity physically counted. It is a reason to investigate, not automatic proof of theft or a reason to change the count without explanation.

Start with a clean, consistent count

Choose a time when the product is not moving, or pause transactions in the area being counted. Count the same unit used in the catalogue: pieces, packs, cartons or kilograms. If one record says “carton” and another says “piece”, convert using the actual pack size and write down the conversion.

Record the item, SKU or description, location, expected quantity, counted quantity, count date and the people who counted. For example, if a shelf record says 24 phone chargers and the count finds 20, the difference is −4 chargers. Keep that arithmetic visible while you investigate.

Check common causes before deciding what happened

  • Was a sale completed but not entered, or entered twice?
  • Did a customer return an item that was not put back into sellable stock?
  • Were damaged, expired or demonstration items removed without a note?
  • Did a supplier delivery arrive in a different quantity from the invoice?
  • Did someone use a different pack size or product variant?
  • Was stock moved to a back room, another shelf or another location?

Compare the last count, purchase paperwork and transaction references. A brief note such as “two units damaged on Tuesday; approved by manager” is more useful than silently changing 24 to 20.

Keep a traceable adjustment record

If the software you use supports stock adjustments, record the reason, quantity, date and approver in that workflow. If it does not, keep a separate variance log and have an authorised person review it. Never create a false sale or supplier purchase simply to force the stock balance to match.

Repeat counts for valuable or fast-moving items more often than for slow-moving low-risk goods. Use findings to improve receiving, staff handover or item naming. The small-shop stocktaking guide explains a routine count, while the reorder-point guide uses reliable counts to inform purchasing.

ReceiptPro supports product and stock records for goods. Review the actions available in your account before relying on a particular adjustment or audit feature.

← More business guides