A hardware store owner I consulted with told me something that stuck with me: “I don’t have an inventory problem, I have a spreadsheet problem that’s pretending to be an inventory system.” He’d been tracking roughly 3,000 SKUs across a shared spreadsheet that he and two employees updated manually after every shift. It worked, technically, in the sense that numbers existed in cells. But it hadn’t matched physical stock in over a year, and he’d just discovered during a slow-season count that he had almost $18,000 tied up in overstocked slow-movers while simultaneously running out of his three best-selling items nearly every week.
This is the pattern I see constantly with small businesses carrying physical inventory: the system isn’t actually broken, it’s just never been asked to do the one job that matters — tell you, accurately and in real time, what you have and what you need before it becomes a crisis. Most owners treat inventory tracking as bookkeeping busywork instead of the operational nerve center it actually is.
Key Takeaways
- Spreadsheet-based inventory almost always drifts from physical reality within months; the gap shows up as both stockouts and dead stock simultaneously.
- Reorder points should be based on actual sell-through velocity per item, not a single flat “reorder at 10 units” rule across your whole catalog.
- Cycle counting small sections weekly catches discrepancies far earlier than one dreaded annual full count.
- The right inventory tool depends on your SKU count and complexity, not your budget — an under-powered system costs more in stockouts than the software would have cost.
The Spreadsheet Trap: Why Manual Tracking Always Drifts
Every spreadsheet inventory system starts accurate and degrades. Someone forgets to log a sale during a busy Saturday. A return gets put back on the shelf without an entry. A vendor delivery gets counted in but a partial short-ship never gets corrected. None of these individual mistakes is a big deal, but they compound, and nobody notices the drift until a physical count reveals a number wildly different from what the spreadsheet says.
The hardware store owner I mentioned above eventually had employees doing quick manual counts on his top 20 items every Friday, comparing them against the spreadsheet. The gap was rarely zero — usually 2 to 5 units off on at least a third of those items, every single week. Multiply that drift across 3,000 SKUs and you understand why his year-end count was such a shock.
What actually works: Move off spreadsheets the moment you’re carrying more than a few hundred SKUs or have more than one person touching stock. A dedicated inventory system — even a lightweight one bundled into your point-of-sale platform — updates counts automatically at the moment of sale rather than relying on someone remembering to log it later. The upfront setup cost is real, but it’s smaller than the cost of the stockouts and dead stock a drifting spreadsheet causes.
Flat Reorder Rules Waste Capital and Cause Stockouts at the Same Time
The most common inventory mistake I see isn’t having no system — it’s having one flat rule applied to everything. “Reorder when we hit 10 units” sounds simple and reasonable, but it treats a slow-moving specialty item the same as your fastest seller. The result is predictable: you’re sitting on excess stock of things that sell twice a month, while running out of things that sell twice a day, because both hit the same “10 units” trigger at wildly different points in their actual sales cycle.
I worked with a specialty food shop that had exactly this problem. Their best-selling local honey sold roughly 40 units a week; a niche imported vinegar sold about 3 units a month. Both were reordered at “under 10 units left.” The honey stocked out almost weekly, losing sales to customers who’d just walk out empty-handed. The vinegar sat at 8-9 units for months, tying up shelf space and cash. We switched to velocity-based reorder points — each item’s reorder threshold calculated from its actual trailing 8-week sell-through rate plus supplier lead time — and stockouts on the honey dropped to essentially zero within six weeks, while they freed up almost $2,200 in cash previously parked in slow-moving vinegar and similar items.
What actually works: Calculate reorder points per item (or per category, at minimum) based on how fast that specific item actually sells and how long your supplier takes to deliver. Most modern inventory tools calculate this automatically once you feed them a few months of sales history — you don’t need to do the math by hand.
Cycle Counting Beats the Dreaded Annual Count
Most small businesses that do count inventory do it once a year, usually around tax time, as a miserable all-hands event that shuts down operations for a day. The problem with annual counts is that by the time you find a discrepancy, it’s been silently accumulating for up to twelve months — you have no idea when it happened, why, or how to prevent it happening again.
Cycle counting flips this: instead of counting everything once a year, you count a small rotating slice of your inventory — say, one section or category — every week, so your entire catalog gets counted every couple of months, in small manageable bites. The boutique retailer I mentioned in a previous post adopted this after her shrinkage discovery, counting one section of her store every Monday morning before opening, roughly 15 minutes of work. Within the first full rotation she caught a fitting-room theft pattern within two weeks of it starting, instead of finding the cumulative damage eight months later at her annual count.
What actually works: Break your inventory into 6-10 sections and count one section per week on a fixed schedule. It takes far less time in aggregate than one giant annual count, and it catches problems while they’re still small and traceable to a specific window of time.
Matching the Tool to Your Actual Complexity, Not Your Budget Fears
Owners routinely under-invest in inventory tools because the sticker price feels like an unnecessary expense for “just tracking boxes.” But the real cost comparison isn’t software price versus zero — it’s software price versus the stockouts, overstock, and shrinkage a weak system quietly causes every month. A $40-a-month inventory add-on that prevents even one repeat stockout on a top seller usually pays for itself many times over.
The right level of tooling depends on complexity, not revenue. A shop with 200 SKUs and one location can often get by with a solid point-of-sale system’s built-in inventory module. A business with multiple locations, variants (sizes, colors), or supplier-side purchase order tracking usually needs a dedicated inventory management platform that syncs with the POS rather than trying to force the POS’s basic module to do more than it’s built for.
What actually works: Match your inventory tooling to your actual SKU count, number of locations, and whether you need purchase-order-level tracking — not to what feels affordable. Undersized inventory tools cost more in the mistakes they cause than the upgrade would have cost in subscription fees.
Frequently Asked Questions
Q: How do I know if my business has outgrown a spreadsheet for inventory?
A: If you have more than one person updating stock counts, more than a few hundred SKUs, or you’ve had a physical count come back meaningfully different from your records in the last year, you’ve outgrown it. The drift only gets worse as SKU count and staff count grow.
Q: How often should I actually be counting inventory if I switch to cycle counting?
A: Break your catalog into 6-10 roughly equal sections and count one section per week on a fixed day. That gets your full inventory counted every 6-10 weeks without ever requiring a full-day shutdown.
Q: My inventory system already calculates reorder points — why do I still get stockouts?
A: Check whether it’s using a flat threshold or actual per-item velocity. Many basic systems default to simple rules unless you specifically configure velocity-based reordering using your sales history. It’s usually a settings problem, not a capability problem.
Q: Is it worth paying for a dedicated inventory platform if I only have one location?
A: It depends on SKU count and complexity more than location count. A single location with 150 simple SKUs might be fine on a POS system’s built-in module. A single location with 2,000 SKUs, size/color variants, and multiple suppliers usually benefits from a dedicated system regardless of how many locations you run.
Q: How much shrinkage is “normal” for a small retailer?
A: Industry benchmarks generally put shrinkage around 1-2% of inventory value as typical for small retail. If your counts are showing meaningfully more than that, or you can’t explain the gap, it’s worth tightening cycle counts and checking for either process errors or theft.
Inventory tracking isn’t glamorous, and it’s easy to let it run on inertia until a bad count forces the issue. But the businesses that treat it as core operating infrastructure — not bookkeeping busywork — consistently free up cash, cut stockouts, and catch problems while they’re still small. Start with cycle counting this week; it’s the cheapest fix on this list and the one that pays off fastest.
