Stocktake Variance Calculator

What stocktake variance tells you

Stocktake variance is the difference between what your system says you have and what you physically count. In retail, this variance is often called shrinkage when stock goes missing: theft (internal and external), supplier fraud, receiving errors, administrative mistakes, or damage. The Australian Retailers Association estimates shrinkage costs Australian retailers over AU$9 billion annually, representing 3-4% of revenue for the average retailer.

For most businesses, an acceptable variance threshold is 1-2% of total inventory value. Variances within this range are typically attributed to minor counting errors or unrecorded damage. Variances exceeding 2% warrant investigation. Variances above 5% indicate systemic issues in receiving, POS accuracy, or security.

Worked example: hardware wholesale distributor, quarterly stocktake

A Sydney hardware wholesaler conducts a quarterly stocktake across their top 20 SKUs (representing 60% of inventory value). Results for four high-variance items:

The cordless drill sets show -7.1% variance, well above the 2% threshold. At AU$189 per unit, 6 missing units represent AU$1,134 in lost inventory. Investigation reveals two likely causes: 2 units damaged in transit but not written off in the system, and 4 units dispatched to a customer but booked against the wrong SKU code. The safety glasses show a positive variance (+25 units) because a supplier delivered an extra carton that was received into stock but never invoiced. Without the stocktake, the business would have 25 units of unreceived (and unpaid) stock in the warehouse.

ATO stock valuation requirements

The ATO requires businesses to value trading stock at the end of each income year. You can choose cost, market selling value, or replacement value, but must apply the method consistently. When stocktake reveals variances, you must adjust your records to reflect actual quantities.

Stock write-downs due to theft, damage, or obsolescence are tax-deductible but must be supported by documentation: the stocktake count sheets, investigation notes, and the stock adjustment journal entry. Regular stocktakes provide the evidence the ATO requires if your returns are reviewed. For businesses with inventory values above AU$500,000, the ATO expects stocktakes at least annually.

Best practices for reducing variance

• Cycle counting: Count a portion of inventory each week rather than relying solely on annual stocktakes. Focus cycle counts on high-value and high-turnover items.
• Goods receipt verification: Train receiving staff to check deliveries against purchase orders immediately. Short deliveries caught at receiving prevent variances from entering the system.
• Barcode scanning: Manual counting errors are the largest source of false variances. Barcode or RFID scanning reduces counting errors to near zero.
• 48-hour investigation window: Investigate all variances above your tolerance threshold within 48 hours while the trail is fresh. After a week, root cause analysis becomes guesswork.
• Stock adjustment audit trail: Every stock adjustment must be documented with a reason code, approved by a supervisor, and linked to the stocktake that identified the variance.

How to use this calculator

1. Single item mode: Enter the item name, system quantity, physical count, and unit cost. The calculator shows variance in units, percentage, and dollar value.
2. Batch mode: Add multiple items for a full stocktake analysis. See total positive and negative variances, net variance, shrinkage rate, and top variance items by dollar value.
3. Use the quick-fill presets to see example scenarios.

Frequently asked questions

What is an acceptable stocktake variance?

1-2% of total inventory value is considered acceptable for most wholesale and retail businesses. Variances above 2% should be investigated. Variances above 5% indicate systemic process failures that need immediate attention.

How does the ATO treat stock write-offs?

Stock write-offs for theft, damage, or obsolescence are tax-deductible, but must be supported by documentation: stocktake count sheets, investigation notes, and the journal entry recording the adjustment. The ATO can disallow unsupported write-offs on review.

How does AP automation help with inventory accuracy?

When supplier invoices are matched to purchase orders and goods receipts automatically, discrepancies between what was ordered, received, and invoiced surface at the point of invoice processing rather than weeks later at stocktake. AP automation also keeps cost prices current, so variance dollar values reflect actual supplier charges.