SCStock Count Studio

Stock Count Studio

A zero net variance can hide two problems

Understand exact-match rate, net value and absolute variance with one five-line example.

Prepared 2026-11-18 · Tradod Designs · Original educational guide

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.

LineCounted − recordedSigned reference value
A−2−$10
B+2+$10
C0$0
D−1−$20
E0$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.