Stock Count Studio
Inventory variance workbench
Compare five stock lines and separate net differences from the discrepancies hiding underneath.
Your scenario result
Change the prefilled example or use it as written, then select Calculate scenario.
Inputs are processed on this page and not saved to browser storage. Downloading creates a local file. Refreshing can discard your entries.
Understand the example before using your own numbers.
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.