Free tool
Stock take variance calculator and inventory accuracy check
Paste your system quantities, counted quantities and unit costs to see what each difference is worth in rand and how accurate your stock records really are.
- From R4,500/month excl. VAT
- South African company
- WhatsApp-first support
- Try the product tour without signing up
Calculator
What the calculator measures
Paste one line per SKU in the format SKU, system quantity, counted quantity, unit cost (R). This stock take variance calculator then works out:
- Variance in units = counted quantity − system quantity. A positive number is a surplus, a negative number is a shortage.
- Variance in rand = variance in units × unit cost.
- Net variance = the sum of all line variances, with surpluses and shortages cancelling out. Shown in units and rand.
- Gross variance = the sum of the absolute size of every variance, ignoring direction. Shown in units and rand.
- Record accuracy % = lines where the count matches the system exactly ÷ lines counted × 100.
Net variance tells you what the count does to your stock value. Gross variance and record accuracy tell you how far your records are from reality, which is what drives stockouts, wrong picks and failed promises to customers. That is why this doubles as an inventory accuracy calculator.
Worked example
A Cape Town auto parts distributor cycle counts six SKUs. The system quantities and costs come from the stock report.
| SKU | System | Counted | Unit cost | Variance (units) | Variance (rand) |
|---|---|---|---|---|---|
| Oil filter OF-110 | 120 | 120 | R85 | 0 | R0 |
| Brake pad set BP-220 | 48 | 45 | R240 | −3 | −R720 |
| Fuse 15A F-015 | 300 | 310 | R12 | +10 | +R120 |
| Wiper blade WB-500 | 75 | 75 | R150 | 0 | R0 |
| Starter motor SM-900 | 20 | 18 | R1,100 | −2 | −R2,200 |
| Spark plug SP-040 | 60 | 60 | R35 | 0 | R0 |
- Net variance: −3 + 10 − 2 = +5 units; −R720 + R120 − R2,200 = −R2,800.
- Gross variance: 3 + 10 + 2 = 15 units; R720 + R120 + R2,200 = R3,040.
- Record accuracy: 3 matching lines ÷ 6 lines counted = 50%.
This example shows why one number is never enough. In units, the count looks like a small gain of 5. In rand, it is a loss of R2,800, because the surplus is on cheap fuses and the shortages are on brake pads and starter motors. And only half the lines are right, even though the net figures look modest. Two missing starter motors deserve far more attention than ten extra fuses.
Investigate before you adjust
A variance is a question, not an answer. Posting an adjustment before you know the cause can turn a paperwork error into a real one. Work through the largest rand variances first:
- Recount. Have a different person count the line again, ideally blind to the system quantity.
- Check timing. Look for goods receipts, dispatches, returns or transfers that happened during the count but were not yet captured.
- Check other locations. Stock is often in a neighbouring bin, an overflow area or another warehouse.
- Check units of measure. A box of 10 counted as one, or the reverse, creates large and easily fixed variances.
- Check the movement history. Look for duplicated or missing transactions since the last good count.
- Adjust and record the reason. Only once the cause is understood, post the adjustment with a clear reason so trends such as damage or theft show up over time.
Using the results
Track record accuracy and gross variance value from count to count rather than reading one result in isolation. If the same SKUs keep showing variances, look at the process around them: receiving, bin labelling, picking or security. Count high-value lines more often; our ABC analysis calculator helps you decide which ones. For the difference between a full count and a rolling programme, read cycle counting vs stock take, and for other measures worth watching see warehouse KPIs that matter.
How VasKem handles stock take variance
In VasKem WMS, a stock take records counted quantities against the system balance and calculates the variance automatically. The stock take then needs admin approval, so the count is reviewed by someone with the right permissions rather than accepted by the counter alone. Separate stock adjustments cover one-off corrections, and the audit log keeps a history of who did what. Barcode lookup and scanning help reduce miscounts of the wrong SKU.
See the stock screens with fictional sample data in the product tour, or browse the user manual.
Frequently asked questions
What is the difference between net and gross variance?
Net variance adds surpluses and shortages together, so they cancel each other out. Gross variance adds up the size of every difference regardless of direction. Net variance shows the effect on your stock value; gross variance shows how much your records actually disagree with the shelf.
What is a good inventory record accuracy?
It depends on your products and how you measure it, so set your own target and track the trend. Many warehouses aim for a high figure on A items and accept a little less on low-value lines. Measure it the same way every time, with the same tolerance, so the numbers are comparable.
Should I count a line within tolerance as accurate?
This calculator uses a strict rule: only lines where the counted quantity matches the system quantity exactly count as accurate. Some businesses allow a small tolerance for items counted by weight or in bulk. If you do, write the tolerance down and apply it consistently.
Should I adjust stock straight after the count?
Not before you have investigated the larger variances. Recount, check unposted receipts, dispatches and transfers, and look for unit-of-measure errors first. Many variances turn out to be timing or paperwork problems that would be made worse by an adjustment.
Is a stock take variance the same as shrinkage?
Not always. Shrinkage is genuine loss from theft, damage, expiry or admin error. A variance can also come from a receipt not yet captured, a product put in the wrong bin or a miscount, which disappears once the cause is fixed. Only confirmed losses should be reported as shrinkage.
See VasKem on your own stock and workflow
Send a WhatsApp with what you stock, how many locations you run and where things go wrong today. We’ll walk you through how VasKem would handle it and confirm your price in writing.