Skip to content

Stock count does not match your system? Start here.

The shelf says one thing. Your system says another. Before you order more stock or change the number on screen, work out where the difference came from. Start with one item and follow the records.

QITECH · Published · 4 min read
Sources checked

First, make sure you are comparing the same thing

A stocktake compares a physical count with the inventory record. Australian Government guidance also recommends keeping records of sales and returns up to date. Those two checks give you a starting point: what is actually there, and what the record says happened. [1]

Choose one product with a clear difference. Write down its code, location, count time and the unit you counted. Ask whether the screen shows individual items, cartons or another unit. A correct count entered in the wrong unit can send you looking for stock that was never missing.

Check which locations are included in the screen you are reading. Does it show just this shelf, the whole warehouse or stock across several sites? Also check how your software treats reserved stock. Ask the person responsible for the system to explain any number whose meaning is unclear.

Follow one movement at a time

Start with the last count you trust. Look at receipts, sales, transfers, returns and adjustments since then. Put the records in time order. Keep your question narrow: which movement would explain this particular difference? This is usually easier to discuss with staff than a general request to check everything.

If stock was moving during the count, note what arrived or left and when. Compare that timing with the system entries. Avoid quietly changing the count to make it agree. Keep the original observation, then record the explanation separately so someone else can follow your reasoning.

The government stocktake guide recommends planning the count, giving staff the tools and instructions they need, and considering a supervisor at each location. It also notes that counting during trading hours can disrupt normal work. These are useful points to address before the next count. [2]

A simple example: cartons and individual items

For example, imagine a hypothetical shop that receives four cartons with six bottles in each. The physical delivery is 24 bottles. If someone records a receipt of four individual bottles, the system and the shelf will differ by 20 bottles. That does not, by itself, mean 20 bottles were lost.

In that situation, compare the purchase order, delivery paperwork and receipt entry. Confirm the pack size instead of assuming it. Once the cause is established, use your agreed correction process and keep the supporting record. Then check whether the receiving screen makes the unit clear enough for the next delivery.

Make a correction that somebody else can understand

Use a short investigation note: item, location, expected quantity, actual quantity, unit, difference and explanation. Add the records you checked and the person responsible for the correction. If the cause is still unknown, say so. An unexplained adjustment is not evidence that the underlying problem has been solved.

Before changing a live balance, check your business approval process. Some adjustments may affect stock value or other records. Ask the person responsible for those records when you are unsure. This guide is about investigating an operational difference, not choosing an accounting or tax treatment.

Fix the repeated cause, not just today’s number

Keep a small list of recurring causes. You might find that unclear pack sizes need a better item description, or that transfers need a clearer handover. Choose one change and check it on the next few relevant transactions. Give the people doing the work a chance to explain what makes the current step awkward.

The inventory guide recommends reviewing stocktake findings and updating inventory records after changes. It also describes using stock records to understand what sells and what needs ordering. A count is more useful when the team follows through on what it reveals. [1]

You do not need to start by replacing your software. First, find out whether the problem is the data, the timing, the way the screen is used or a missing connection between systems. That gives you a clearer brief if you decide you need technical help.

Sources & further reading

  1. business.gov.au — Manage your inventory
  2. business.gov.au — Prepare for stocktake

Found something that needs updating? Let us know. We welcome corrections.

← More practical guides · Our editorial approach