What is calculated
For each row, quantity difference = counted quantity − recorded quantity. Signed reference-value difference = quantity difference × entered reference unit cost. Net reference-value difference is the sum of signed row values. Absolute reference-value variance is the sum of their absolute values. Exact-match rate = rows with an exact quantity match ÷ all five entered rows × 100.
Read the worked example
Rows A and B have −2 and +2 units at $5, row D has −1 at $20, and C and E match. That gives −$20 net reference value, $40 absolute reference-value variance and two exact matches out of five (40%). The measure describes the selected sample; it is not a claim about the whole store.
Important boundaries
All five rows are included, including a zero-versus-zero row. Use actual selected stock lines rather than blank zero rows if you want a meaningful exact-match rate. Fractional quantities are allowed for businesses whose counting units permit them. Use the same unit on both sides of each comparison. Costs are user-supplied reference values, not independently verified valuations. The tool does not identify theft, authorize adjustments, update stock or provide accounting records.
Use with the review workflow
Define scope and cutoff, record first observations, independently recount exceptions, document evidence and obtain approval through your own system. The downloadable sheets support those steps. Refreshing or closing the page discards entries unless you download the scenario.
Testing and corrections
The publication includes constructed examples designed to be reproducible. If a result looks wrong, note the inputs, the result and the outcome you expected, then contact the publisher. Avoid emailing confidential records. We update material when we identify a supported correction.