Systems
Why Spreadsheets Break When Inventory Gets Serious
Concurrency, formula drift, and hidden rows — the structural limits that turn “temporary” workbooks into operational risk.
A branch manager found dated stock tucked behind a fast-moving SKU last Tuesday — the write-off hit before anyone had time to argue about whose count was right. Spreadsheets are brilliant for prototypes and one-off analysis — and fragile as a system of record when multiple people edit, formulas drift, and nobody owns versioning. At scale you need concurrency, audit trails, and integrations — the reasons teams eventually adopt purpose-built tools. See moving to systems when the pain is chronic.
Key terms in this guide: Lot / batch traceability, SKU, Perpetual inventory.
If your reminder lives on a sticky note, it does not survive a busy service — this is what an expiry reminder looks like when it scales →
Related reading in this library
Topics covered
- spreadsheets
- inventory data
- risk
- Systems
- Systems inventory operations
- Inventory accuracy
- Expiry risk management
- Working capital in stock
Spreadsheets are brilliant for prototypes and one-off analysis — and fragile as a system of record when multiple people edit, formulas drift, and nobody owns versioning. At scale you need concurrency, audit trails, and integrations — the reasons teams eventually adopt…
Referenced signals — spot-check sources as data ages
1.6%
US retail shrink as % of sales in NRF’s 2023 survey (FY 2022) — industry benchmark; methodology & definitions vary by retailer.
Cash tied up
Inventory often represents 20–35%+ of total current assets for product companies — small % improvements move real cash.
Recall speed
Regulators expect rapid lot traceback — hours to days, not weeks — when lots are mixed or records are partial.
What is Failure modes you have seen (in Systems inventory work)?
Copied tabs, broken links, and “the master file is on someone’s laptop” — inventory truth splits into branches.
Copied tabs, broken links, and “the master file is on someone’s laptop” — inventory truth splits into branches.
Knowing the rule is not the same as seeing the next risk date in one place — which is exactly what Expiry Desk tracks automatically →
What this means on the floor
Concurrent edits silently overwrite each other; there is no transaction log worth the name.
What breaks first?
Receiving and returns — high-volume events that need structured capture, not weekend reconciliation marathons.
Receiving and returns — high-volume events that need structured capture, not weekend reconciliation marathons.
Dense packs and mixed strengths are where hand counts lie — unless you are using a camera to count them for you →
How to validate this in your next stock review
Multi-site visibility — spreadsheets do not make cross-site truth inevitable.
Spreadsheets age faster than stock — most people track this wrong. Here is the smarter way →
What “good enough” looks like?
A single source of truth with roles, approvals, and exports finance trusts — even if the UI is boring.
A single source of truth with roles, approvals, and exports finance trusts — even if the UI is boring.
Rotation only works when the soonest date is visible before the truck arrives — here is how teams close that gap →
Why this signal should reach finance the same week
Keep spreadsheets for analysis; stop using them as the warehouse’s memory.
How to operationalize this guide in your branch
Problem definition: Concurrency, formula drift, and hidden rows — the structural limits that turn “temporary” workbooks into operational risk.
Operational playbook:
Metrics to watch:
Implementation checklist:
Research & further reading
We cite institutional and industry sources so you can verify claims — numbers shift with methodology and year.
- NRF — National Retail Security Survey 2023 — US retail shrink as % of sales in NRF’s 2023 survey (FY 2022) — industry benchmark; method…
- McKinsey — Working capital — Inventory often represents 20–35%+ of total current assets for product companies — small %…
- FDA — FSMA traceability (US context) — Regulators expect rapid lot traceback — hours to days, not weeks — when lots are mixed or …
Cite this article
Auto-generated from title, author, and publication date.
- APA
Desiree Moeng. (2025, November 19). Why Spreadsheets Break When Inventory Gets Serious. ExpiryDesk. https://expirydesk.co.za/blog/why-spreadsheets-break-at-scale
- MLA
Desiree Moeng. "Why Spreadsheets Break When Inventory Gets Serious." ExpiryDesk, November 19, 2025, https://expirydesk.co.za/blog/why-spreadsheets-break-at-scale.
- Chicago (web)
Desiree Moeng. "Why Spreadsheets Break When Inventory Gets Serious." ExpiryDesk. November 19, 2025. https://expirydesk.co.za/blog/why-spreadsheets-break-at-scale.
Frequently asked questions
- What is Failure modes you have seen (in Systems inventory work)?
- Copied tabs, broken links, and “the master file is on someone’s laptop” — inventory truth splits into branches.
- What breaks first?
- Receiving and returns — high-volume events that need structured capture, not weekend reconciliation marathons.
- What “good enough” looks like?
- A single source of truth with roles, approvals, and exports finance trusts — even if the UI is boring.