What Inventory Variance Reports Actually Tell You
The gap between expected and actual stock is data. It points to theft, miscounts, or supplier problems — if you know how to read it.
Shrinkage, expired stock, and slow-moving SKUs are invisible until you count. Here's what integrated inventory tracking reveals.
Ask a sari-sari store owner how much they made last month, and most can give you a rough number. Ask them how much they lost, and you'll usually get a blank stare. But losses are happening — and unlike revenue, they're invisible.
"Shrinkage" is the retail industry term for inventory that disappears without a corresponding sale. In a sari-sari store, it comes from three main sources:
Unrecorded personal consumption
The family takes snacks from the stock. Kids grab a drink. It's your store, so it doesn't feel like a "sale" — but it is a cost. A bag of chips taken daily at ₱15 is ₱450/month unrecorded.
Staff pilferage
Small amounts, taken slowly. A cashier who drinks one Coke per shift at ₱25 is ₱750/month. Over 12 months, ₱9,000 — plus whatever else isn't counted. This isn't always malicious; sometimes staff assume it's a perk.
Expired goods
Items that expire before they sell are pure loss. The cost was paid to the supplier. The revenue was never collected. The expired product gets thrown away — and the loss gets absorbed silently into "lower than expected sales."
The average sari-sari store carries 200–400 distinct SKUs. A significant portion of those — often 20–30% — move fewer than 5 units per month. Every slow-moving SKU represents capital tied up on your shelf: you paid the supplier, the cash is gone, and it's sitting in a product that might expire before it sells.
The problem isn't stocking that item once. The problem is reordering it automatically on every supplier visit because it "looks low" — without ever checking how long it's been sitting there. Without inventory data, you can't distinguish between an item that sells fast and one that you just keep restocking out of habit.
A variance report compares what your system says you should have (based on opening stock minus recorded sales) against what you actually count on the shelf. The gap — positive or negative — is your variance. It tells you:
Nexus7's NexusStock module generates automatic variance reports with each physical count. Most store owners who run their first variance report find ₱2,000–₱5,000 in unexplained losses within the first month. The ₱3,000/month figure in the headline is conservative.
The gap between expected and actual stock is data. It points to theft, miscounts, or supplier problems — if you know how to read it.
1,800 SKUs, one store, and a 32% reduction in stockouts — here's how Flores Hardware turned inventory chaos into a competitive advantage using real-time reorder alerts.
Running a Philippine pharmacy means carrying two compliance burdens — BIR receipts and FDA batch/expiry tracking. Here's how to handle both without a second system.
BIR-compliant receipts, offline-first POS, GCash/Maya reconciliation, inventory tracking, and owner dashboards — all connected. Same-day onboarding. Training under 2 hours.