A balanced total is not the same thing as an accurate stock record. One item can be short while another is over, leaving a small or even zero net difference. Reviewing only the final amount can hide both discrepancies. Our workbench displays signed and absolute differences separately so you can decide which lines need attention.
The five-line example
All figures here are constructed. Item A records 20 units but has 18 counted, at a reference cost of $5. Item B records 10 and has 12, also at $5. Item C records 8 and has 8 at $12. Item D records 5 and has 4 at $20. Item E records 6 and has 6 at $3. The example does not describe a real retailer.
| Line | Counted − recorded | Signed reference value |
|---|---|---|
| A | −2 | −$10 |
| B | +2 | +$10 |
| C | 0 | $0 |
| D | −1 | −$20 |
| E | 0 | $0 |
Read three different questions
The net reference-value difference is −$20. Absolute reference-value variance is $10 + $10 + $0 + $20 + $0 = $40. These amounts answer different questions: the first describes the signed balance, and the second describes discrepancy magnitude without offsetting one row against another. Neither establishes the cause or authorizes an accounting entry.
Two of five lines match exactly, so this sample’s exact-match rate is 40%. This is a line-based measure, not a unit-based or storewide inventory accuracy score. Changing the selected items changes the sample. Comparing rates between weeks requires a similar scope and the same definition.
A smaller counterexample
If you count only A and B, their net reference-value variance is zero while their absolute variance is $20. Both lines still need review. One possible explanation might be a variant mix-up, but the numbers alone cannot prove it. Do not relabel an overage as a correction for a shortage without evidence.
What to review next
Inspect the largest absolute-value lines, repeated mismatches and unresolved unit conversions. Keep the complete row-level record so small offsets do not disappear. Use the variance log to document a recount and the evidence for any explanation, then obtain approval through your normal process.