Books vs Shelves: A Method for Tracing Stock Differences

When a count comes back at 8,150 units and the accounting balance says 8,400, many people jump to the easy conclusion: 250 units are "missing". But a gap is not a verdict. It is a question, and how you handle it decides whether you reach the cause or settle for an expensive guess. Gaps that are traced with a method usually reveal their cause within a few days. Gaps that are only argued about stay open for months.

First, check the yardstick

Before you look for the goods, check that the comparison is fair. Is the book balance taken at the same moment at which the count was fixed? Is the unit the same on both sides, pieces against pieces and not cartons against pieces? Is the item in the ledger the same as the item on the shelf, even if the name or the code differs? These three questions alone explain a large share of apparent differences, and they take minutes, not days. Write the answers on the same worksheet so that they are not forgotten or asked a second time.

Narrow the field with three filters

Do not chase every difference at once. Rank them, then sift them in three passes:

• By item. Most of the gap usually sits in a handful of items. Start with the largest by value, then the largest by quantity.
• By period. Compare the balance with the last count you trust. If the gap was already there two months ago, there is no point in searching last week's movements.
• By document. Take the suspect item and follow its movements one by one, each receipt, dispatch, transfer and write-off, until you find the point where the figures stop agreeing.

One simple rule applies throughout: do not jump to a conclusion before you hold a document that supports it. "Perhaps it was stolen" and "perhaps it was posted wrongly" are both guesses until a delivery note, a receiving record or a photograph backs one of them.

A worked example (conditional figures)

The net difference across the whole count is 250 units short. When the table is opened, item A is short by 400 units and item B is over by 150. The net figure of 250 hides two gross differences that add up to 550. Then the tracing begins:

• Item A: there is a delivery note to a customer for 400 units. The truck left before the cut-off, but the note was entered in the system only on the following day.
• Item B: a customer returned 150 units, which were put on the shelf, but the receipt has not yet been recorded.

No genuine shortage has been established in either item. Both are errors of timing and recording, and two entries put them right. Had you looked at the net figure alone, it would have seemed a loss of 250 units, and you would have searched for it in the wrong place.

Make each difference a reviewable line

Do not write "various differences" in a report. Give each difference its own line with the item and location, the book balance, the counted quantity, the difference in units and in value, the document relied on, and the status of the explanation. There are three statuses. Confirmed means a document proves it. Probable means the evidence points that way but no complete document exists. Open means the cause is not known. Every open line is given a named person and a deadline. In this form your accountant or adviser can re-check any line without having to ask anyone.

When to stop tracing

Tracing has a cost, and not every small difference deserves a day of work. Agree a threshold in advance with whoever commissions the work: for example, differences above 200 dollars per item are traced, and anything below is listed in one table as small and unexplained. This figure is conditional, and it should change with the value of the goods and the importance of the decision. Agreeing it beforehand saves argument later.

In short

A gap between books and shelves is explained by method, not by instinct: check the yardstick, narrow the field by item, period and document, and record each difference with its status. WarehouseDepo carries out this tracing on site after the count: it counts the goods, sets the result against your books, follows differences back to their documents and shows you which are confirmed and which remain open.