Step-by-Step Stock Audit & Inventory Variance Guide for Kirana & Supermarket Owners
How to conduct physical stock counts, identify stock shrinkage/theft, calculate inventory variance percentage, and establish ABC cycle counting in your retail store.
Stock variance—the difference between the inventory listed in your POS books and the actual physical stock sitting on your shop shelves—costs Indian retail stores between 1.5% and 3.8% of total revenue annually.
Whether caused by cashier scanning errors, supplier short-deliveries, damage, expired stock, or shoplifting, conducting regular stock audits is the single most effective way to protect your profit margins.
### Step 1: Establish an ABC Inventory Classification
Instead of shutting down your shop to count 5,000 items at once, categorize your stock using the ABC principle:
- Category A (High Value, Fast Moving): Top 20% items generating 80% revenue (e.g., Cooking oils, premium rice, expensive cosmetics, baby food). Audit every 15 days.
- Category B (Medium Value): 30% of items contributing 15% revenue (e.g., Soaps, detergents, packaged snacks). Audit once a month.
- Category C (Low Value, Slow Moving): Remaining 50% of items accounting for 5% revenue (e.g., Matches, small stationery, scrubbers). Audit quarterly.
### Step 2: Use Wireless Barcode Scanners for Cycle Counting
Never perform stock audits with pen and paper. Equipping store staff with handheld Bluetooth barcode scanners or EdgeRetail's mobile scanning app lets you scan items directly on the shelf. The app compares scanned quantity against current system stock instantly.
### Step 3: Calculate Stock Variance Percentage
Use this formula to measure your store audit accuracy:
Inventory Variance % = [(Physical Stock Count - POS System Stock Count) / POS System Stock Count] * 100
- Example: POS shows 100 packets of biscuits, physical count reveals 96.
- Variance = [(96 - 100) / 100] * 100 = -4% (Negative variance indicates stock leakage/damage).
### Step 4: Batch & Expiry Auditing
For pharmacies and supermarkets selling perishable packaged goods, track batch numbers and manufacturing dates during audits. EdgeRetail flags items approaching expiry 60 days in advance, allowing you to run discount sales or return goods to distributors before total write-off.
### Step 5: Post-Audit Reconciliation in EdgeRetail
Once physical counts are logged, perform an 'Inventory Adjustment' in EdgeRetail with reasons (e.g., 'Damaged in Transit', 'Expired Write-off', 'Theft'). The system updates stock levels and posts adjustment entries to your financial profit and loss ledger.