Your Inventory Spreadsheet Says 500. The Shelf Has 350.
The spreadsheet says you have 500 units of raw material X. You walk to the shelf and count 350. Production was supposed to start this morning, and now it can't — because you ran out of something your own records swore was in stock. If you've lived this, you know the feeling isn't confusion. It's betrayal. The sheet lied to you, and it's been lying for a while.
Search this problem and you'll find two kinds of pages: an hour-long YouTube video on building a fancier Excel template, and inventory-software vendors telling you to buy their $200–500/month platform. The desperation in those YouTube comments is real — people are willing to watch a 60-minute tutorial to make a spreadsheet that won't betray them. The truth is in between: most inventory drift is a discipline problem, not a software problem, and you can fix the bulk of it this week for free.
The 5 reasons your counts drift
Inventory spreadsheets don't fail randomly. They fail in five specific, predictable ways:
- Late entry. Material gets used or received, but the log happens hours or days later — if at all. Every delay is a window where the sheet is wrong.
- Wrong unit. Someone records boxes when the sheet tracks pieces, or feet when it tracks linear yards. One unit mismatch poisons the count.
- Location blindness. The sheet knows how many, not where. People can't find stock, assume it's gone, and order more — now you have a count error and an overstock.
- No cycle counting. Errors are never caught, so they compound silently until the annual count reveals a number nobody can explain.
- Invisible WIP. Material pulled into production still shows as on-hand. The shelf is empty; the sheet hasn't noticed the job started.
The reframe: every one of these is a manual-entry failure, not a formula failure. The spreadsheet assumes every person logs every movement perfectly and instantly. They don't, and they never will. The fix is to reduce how much accuracy depends on flawless human entry — first with discipline, then with automation.
The minimum viable inventory system
Four habits. No new software. This alone closes most of the gap:
- One person owns counts. Not "everyone updates the sheet" — that's why it drifts. One owner, accountable for accuracy, with the authority to set the process.
- Weekly cycle counts on the top 20 items. About 20% of your SKUs usually drive 80% of your value (ABC logic). Count those every week. You don't need to count everything — just what matters to cash and production.
- Bin locations in the sheet. Aisle-rack-shelf, dead simple. When people can find stock, they stop assuming it's gone and re-ordering phantom shortages.
- Minimum-stock triggers with color. A reorder point per item; conditional formatting turns the row red at the threshold. Red means order now — no judgment call, no forgotten part.
The automation ladder
Rung 1 — Disciplined Google Sheets (free)
The four habits above, in a plain shared sheet with an owner, ABC cycle-count rotation, bin locations, and color-coded reorder points. Most shops never actually try the disciplined version before reaching for software — do this first and measure the drift after a month.
Rung 2 — Sheets + Google Forms for receiving/shipping ($0)
Replace freehand edits with a structured form. Receiving and pulling stock happens through a Google Form on a phone or tablet at the dock; entries timestamp automatically into the sheet. You've removed the "I'll log it later" gap — the most common source of late-entry drift — without spending anything.
Rung 3 — Barcode app ($50–100/month)
Tools like Sortly or inFlow let you scan items in and out. Scanning kills wrong-unit and late-entry errors because the count updates at the moment of movement, not from memory. The right rung when transaction volume has outgrown forms but you don't need a full WMS.
Rung 4 — Custom glue (built to scope)
Connect the moments inventory changes to your records automatically: a receiving scan updates on-hand instantly; starting a production run auto-deducts materials and tracks WIP; hitting a minimum drafts a purchase order for approval. It runs alongside QuickBooks and your existing tools rather than replacing them — automating the exact points where your counts drift today.
Comparison at a glance
| Disciplined Sheets |
Sheets + Forms |
Barcode app |
Custom glue |
|
|---|---|---|---|---|
| Cost | $0 | $0 | $50–100/mo | Built to scope |
| Kills late entry | Partial | Yes | Yes | Yes |
| Kills wrong unit | No | Partial | Yes | Yes |
| Tracks WIP | Manual | Manual | Partial | Automatic |
| Auto-reorder | No | No | Alerts | Drafts PO |
Do this week: close the gap
5 moves to stop the drift
- Name one count owner. One person, accountable. Tell the team edits go through them or through a form — not freehand.
- Find your top 20 by value. Quantity × unit cost, sorted descending. Those are your weekly cycle-count list.
- Add bin locations. Walk the floor, label aisle-rack-shelf, put it in the sheet. Findable stock stops phantom reorders.
- Set reorder points + red formatting. A minimum per item; conditional formatting turns the row red when it's time to buy.
- Run one cycle count Friday. Count the top 20, compare to the sheet, log the variance. That variance number is the lie you've been producing from — and the baseline you'll improve.
Rung 1, running by Friday, before you price a single piece of software.
Frequently asked questions
Why is my inventory spreadsheet always wrong?
Inventory spreadsheets drift for five predictable reasons: late entry (a part gets used or received but isn't logged until hours or days later), wrong unit (someone records boxes when the sheet tracks pieces), location blindness (the sheet knows the quantity but not where it physically is, so people can't find it and assume it's gone), no cycle counting (errors never get caught and compound), and invisible work-in-progress (material that's been pulled into production still shows as on-hand). The common thread is that the spreadsheet depends on every human entering every movement perfectly and immediately — which never happens. The fix isn't a better spreadsheet formula; it's reducing how much depends on flawless manual entry.
What's the minimum viable inventory system for a small manufacturer?
Four habits, no new software required. First, one person owns counts — not "everyone updates the sheet," which is why it drifts. Second, weekly cycle counts on your top 20 items, since about 20% of your SKUs usually represent 80% of your value; you don't need to count everything, just what matters. Third, bin locations in the sheet (aisle-rack-shelf) so people can actually find stock instead of assuming it's out. Fourth, minimum-stock triggers with color — red means order now. That's a system that holds in plain Google Sheets, and it fixes most of the drift before you spend a dollar on tools.
What is cycle counting and why does it beat an annual count?
Cycle counting means counting a small subset of inventory on a regular rhythm — say your top 20 items every week — instead of shutting down once a year to count everything. It beats the annual count for two reasons: errors get caught while they're small and traceable, instead of compounding for twelve months, and you never have to halt production for a full physical inventory. Focus the rotation on high-value and fast-moving items using ABC logic (the roughly 20% of SKUs that drive 80% of value), and your counts stay accurate where accuracy actually matters to cash and production.
When should I move from a spreadsheet to inventory software?
Move when manual entry has become the bottleneck despite good habits — when even a disciplined weekly cycle count can't keep up with transaction volume, or when stockouts and overstock are costing you real money every month. The next rung is usually a barcode-driven app like Sortly or inFlow at $50–100/month, which removes the hand-entry that causes most drift. Below that volume, a well-run spreadsheet with an owner, cycle counts, locations, and reorder triggers is genuinely fine and far cheaper. Don't buy a warehouse management system to fix a discipline problem — fix the discipline first, then automate what's left.
How can automation keep inventory accurate without a full WMS?
You connect the moments inventory changes to the record automatically, instead of relying on someone to remember to type it. A typical build: a receiving form or scan updates on-hand the instant material arrives; starting a production run auto-deducts the materials it consumes and tracks work-in-progress; and when an item hits its minimum, the system drafts a purchase order for approval. It works alongside your existing QuickBooks and spreadsheets rather than replacing them. Jobs Done Labs builds this glue during a free audit — we map where your counts drift and automate those exact points, covered by the $30K-recovered-in-90-days guarantee. If documented recovery doesn't reach $30K, you pay nothing.
Related reading: what comes after your whiteboard production schedule breaks.
Find out what inventory drift is costing you in stockouts and overstock
Book a free 15-minute audit. We'll map where your counts go wrong — receiving, WIP, reorder — and what automation would recover, working with the tools you already have. No pitch, no pressure. You keep the map either way.
Book your free audit →