Stock count variance rate
Stock count variance rate is the absolute sum of negative and positive differences between the physical count and recorded stock, divided by the value of stock counted; it shows the financial size of record error.
Also calledinventory variance rate, stock variance, count variance, inventory discrepancy rate, stock loss rate
Formula
(|Negative variance| + |Positive variance|) ÷ Value of stock counted × 100- Negative variance
- Cost value of goods on the record but not on the shelf.
- Positive variance
- Cost value of goods on the shelf but not on the record.
- Value of stock counted
- The value at cost of stock within the count scope.
- Net variance rate
- (Positive variance − Negative variance) ÷ Value of stock counted × 100; never used on its own.
Calculator
Enter your own figures and the result updates instantly. The defaults are the figures from the worked example below.
Result%2
Worked example
How to read it, and what good looks like
Net variance can look small because negatives and positives cancel; the real size is their absolute sum. Positive variance is not good news: goods on the shelf but not on the record show that receiving, returns or barcodes are not being processed correctly. The order for finding causes, the accounting entry and the process fixes that stop recurrence are in the stock count variance guide; this page is for the quick calculation.
Variance feeds straight into gross margin: negative variance lowers closing stock and raises cost of goods sold. According to Migros's 2025 Integrated Annual Report, its loss rate fell by 30 basis points in 2025; the report names this fall, together with logistics efficiency, as the main drivers of a 20 basis point improvement in gross profit excluding interest on credit purchases and the inflation adjustment on inventories. The Turkish data available on the causes of loss is old: according to the Sensormatic index cited by TPF (the Turkish Retailers Federation) in 2018, 34.34% of losses came from external theft, 24.28% from suppliers, 22.95% from employees and 18.43% from administrative error.
Build the target from your own count history and track two measures alongside the rate: the positive share of total variance and the share of variance with no cause found. Tying store bonuses to the size of the variance leads to it being hidden; the right measure is the rate at which causes are found. In Mindpera, Mind Stock gives unit variance, value variance and variance rate in the count closing report; approved variance is posted as an accounting voucher mapped to the Tekdüzen Hesap Planı, Turkey's uniform chart of accounts.
Where it misleads
- Reporting only net variance lets negatives and positives cancel, so a serious record problem looks acceptable.
- Valuing variance at selling price inflates it by the margin; calculate both variance and stock value at cost.
- If stock movements are not frozen during the count, sales and dispatches during counting look like variance; freeze the balance when the count opens.
- Posting variance to a single account without a cause code does not separate shrinkage, theft and record error; the same variance reappears at the next count.
Data you need
- System balance frozen when the count opens
- Count result: product, location, quantity, count team
- Unit cost (for variance and stock value)
- Variance cause code: count error, record error, shrinkage, loss, transfer error, unknown
Mindpera products that calculate this KPI
Frequently asked questions
- Is count variance rate calculated at cost or at retail?
- At cost. The variance and the stock counted are built on the same basis, at cost; a variance at retail looks larger by the margin and does not reconcile with the stock record in the accounts. A retail view can be added separately, only to show the sales value of the loss.
- How do you calculate stock count variance rate?
- Divide the absolute sum of negative and positive count variances by the value of stock counted, and multiply by 100. With ₺42,000 of negative and ₺18,000 of positive variance on ₺3,000,000 of stock, the rate is (42,000 + 18,000) ÷ 3,000,000 × 100 = 2.0%. Calculate at cost. Report the net variance rate too, but never use it alone.