Systems
Upgrading from Spreadsheets: A Pragmatic Path
Pilot scope, master data cleanup, and the change management that gets floor adoption — without a six-month science project.
The system said ninety-four percent accuracy until a spot-check turned up cartons nobody had rotated in weeks. Margin did not wait for the next stocktake. Moving from spreadsheets to an inventory system is as much about behaviour and data migration as software features. Pilot with one site or category, fix master data first, and define success metrics — accuracy, time to count, stock-out rate — before you customise screens forever. Related: reconciliation playbook and perpetual hygiene.
Key terms in this guide: SKU, Perpetual inventory, Lot / batch traceability.
Knowing the rule is not the same as seeing the next risk date in one place — which is exactly what Expiry Desk tracks automatically →
Related reading in this library
Topics covered
- inventory software
- digital transformation
- SMB
- Systems
- Systems inventory operations
- Inventory accuracy
- Expiry risk management
- Working capital in stock
Moving from spreadsheets to an inventory system is as much about behaviour and data migration as software features. Pilot with one site or category, fix master data first, and define success metrics — accuracy, time to count, stock-out rate — before you customise screens…
Referenced signals — spot-check sources as data ages
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.
1.6%
US retail shrink as % of sales in NRF’s 2023 survey (FY 2022) — industry benchmark; methodology & definitions vary by retailer.
What is Readiness checklist (in Systems inventory work)?
Clean SKU list, units of measure, suppliers, and locations — garbage in survives any go-live date.
Clean SKU list, units of measure, suppliers, and locations — garbage in survives any go-live date.
Dense packs and mixed strengths are where hand counts lie — unless you are using a camera to count them for you →
What this means on the floor
Name executive sponsor and floor champions; systems without owners become expensive filing cabinets.
How to handle Phased rollout on the floor
Start with receiving and on-hand truth; add advanced planning after transactions stabilise.
Start with receiving and on-hand truth; add advanced planning after transactions stabilise.
Spreadsheets age faster than stock — most people track this wrong. Here is the smarter way →
How to validate this in your next stock review
Parallel-run only where necessary — long parallels exhaust teams and hide which system is wrong.
Rotation only works when the soonest date is visible before the truck arrives — here is how teams close that gap →
Why Change management matters for cash and service levels
Train for workflows, not button order: “when stock moves, this is how we record it.”
Train for workflows, not button order: “when stock moves, this is how we record it.”
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 →
Why this signal should reach finance the same week
Celebrate early wins: first clean month-end, first successful cycle count — momentum beats slide decks.
How to operationalize this guide in your branch
Problem definition: Pilot scope, master data cleanup, and the change management that gets floor adoption — without a six-month science project.
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.
- 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 …
- NRF — National Retail Security Survey 2023 — US retail shrink as % of sales in NRF’s 2023 survey (FY 2022) — industry benchmark; method…
Cite this article
Auto-generated from title, author, and publication date.
- APA
Maki K Malepe. (2025, November 26). Upgrading from Spreadsheets: A Pragmatic Path. ExpiryDesk. https://expirydesk.co.za/blog/upgrading-from-spreadsheets-to-systems
- MLA
Maki K Malepe. "Upgrading from Spreadsheets: A Pragmatic Path." ExpiryDesk, November 26, 2025, https://expirydesk.co.za/blog/upgrading-from-spreadsheets-to-systems.
- Chicago (web)
Maki K Malepe. "Upgrading from Spreadsheets: A Pragmatic Path." ExpiryDesk. November 26, 2025. https://expirydesk.co.za/blog/upgrading-from-spreadsheets-to-systems.
Frequently asked questions
- What is Readiness checklist (in Systems inventory work)?
- Clean SKU list, units of measure, suppliers, and locations — garbage in survives any go-live date.
- How to handle Phased rollout on the floor?
- Start with receiving and on-hand truth; add advanced planning after transactions stabilise.
- Why Change management matters for cash and service levels?
- Train for workflows, not button order: “when stock moves, this is how we record it.”