Classifying Variances: Timing, Counting, Paperwork or Real Loss

A count finishes and the report says that 62 pieces of one item are missing against the books. Many readers hear one word: theft. But most differences are not losses. They are the ordinary noise of a business that moves goods, writes documents and counts by hand. The task of a good report is to separate that noise from real shrinkage, and the simplest way is to sort every difference into one of four classes: timing, counting, paperwork and real loss. Each class has its own kind of evidence.

Timing

A timing difference exists because the books and the shelf were looked at at different moments. Goods were dispatched on the last day but posted the next morning, a delivery stood on the dock and had not been entered, or a pallet was between two zones when it was counted. The evidence is a dated document set against the cut-off: a delivery note, a dispatch order or a line in the movement log. If the document is dated before the cut-off and the posting after it, the difference is timing and it closes itself. Keep the written cut-off next to the worksheet, because every timing judgment rests on it.

Counting

A counting difference is the counter's mistake: a missed location, a double count, the wrong item, the wrong unit. The evidence is a recount, ideally by another person, together with a photograph of the location. These are best caught on the day, which is why every difference above an agreed size should be recounted before the team leaves the site. Record who recounted and when, so that the row leaves a trail that can be followed later.

Paperwork

A paperwork difference means the goods are real but the record is wrong. A delivery was entered under a similar code, a quantity was keyed with a slip of the finger, a return was never registered, or goods were posted to another warehouse or owner. The evidence is a pair: the original document and the posting made from it. The mapping of item names and codes helps a great deal here.

Real loss

Only what remains after the first three classes have been checked can be called a possible real loss: theft, unrecorded damage, spoilage, expiry, or goods used or given away without a record. The evidence is the absence of any other explanation, plus supporting facts such as damaged goods photographed, an incident report, a broken seal or a pattern across several counts. Even then, call it "unexplained after checks" unless the cause is actually established.

A worksheet and an example (conditional figures)

Use one row per difference, with these columns:

• Item, and location or batch.
• Books, count and difference.
• Class: timing, counting, paperwork or real loss.
• Evidence reference: the document number, the recount sheet or the photograph.
• Owner: the person who will close the row.
• Status: open or closed.

Every class needs evidence; without it the row stays "open".

For one item the books show 1,200 pieces and the first count gives 1,138, a difference of 62. The worksheet resolves it as follows: 6 pieces on a pallet missed in the first pass (counting, closed by recount, so the count becomes 1,144); 20 pieces dispatched on the last day and posted the next morning (timing, closed with the dispatch order); 16 pieces posted to this item by mistake, because the delivery note shows another item (paperwork, closed with the document). That accounts for 42, and 20 pieces remain open. The owner now has a precise question about 20 pieces instead of an alarming total of 62.

Report gross differences as well as the net. If one item is 30 pieces over and another 30 under, the net is zero but there are two problems, and opposite differences like these often point to paperwork, such as a delivery posted to the wrong code. State the value of the open amount separately from its quantity, and say at which price it was valued.

In short

Not every difference is a loss, and a report that cannot tell the difference is of little use to an investor. WarehouseDepo matches your balances to the physical count and explains each difference by item and batch, separating what is timing, counting or paperwork from what remains open.