Systems
Making Perpetual Inventory Records Match the Floor
Goods receipt, returns, transfers, and adjustments — the transaction hygiene that keeps your system from becoming fiction.
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. Perpetual inventory only works when every movement that matters hits the system: receipts, picks, transfers, returns, and adjustments. When those transactions drift, the ERP becomes fiction — and cycle counts become whack-a-mole. Tighten the transaction layer before you buy another analytics module; see also stock reconciliation.
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
- perpetual inventory
- ERP
- stock records
- Systems
- Systems inventory operations
- Inventory accuracy
- Expiry risk management
- Working capital in stock
Perpetual inventory only works when every movement that matters hits the system: receipts, picks, transfers, returns, and adjustments. When those transactions drift, the ERP becomes fiction — and cycle counts become whack-a-mole. Tighten the transaction layer before you buy…
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 Goods in: where truth starts (in Systems inventory work)?
Line-level receiving against POs, with exception handling for shorts and substitutions, prevents silent quantity errors that propagate forever.
Line-level receiving against POs, with exception handling for shorts and substitutions, prevents silent quantity errors that propagate forever.
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
Batch and lot capture where regulation or recall risk exists — partial effort here costs more at audit than upfront discipline.
How to handle Movements and adjustments on the floor
Transfers between branches, inter-branch moves, and quarantine holds must flip system status when physical status changes.
Transfers between branches, inter-branch moves, and quarantine holds must flip system status when physical status changes.
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
Ad hoc adjustments without approval and reason codes are how perpetual records rot.
Spreadsheets age faster than stock — most people track this wrong. Here is the smarter way →
Why Rhythm and ownership matters for cash and service levels
Daily or weekly reconciliation between high-impact areas and the system catches drift while memory is fresh.
Daily or weekly reconciliation between high-impact areas and the system catches drift while memory is fresh.
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
Name owners for master data, receiving, and adjustments — ambiguous RACI guarantees ambiguous inventory.
How to operationalize this guide in your branch
Problem definition: Goods receipt, returns, transfers, and adjustments — the transaction hygiene that keeps your system from becoming fiction.
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
Maki K Malepe. (2025, August 6). Making Perpetual Inventory Records Match the Floor. ExpiryDesk. https://expirydesk.co.za/blog/perpetual-inventory-that-stays-accurate
- MLA
Maki K Malepe. "Making Perpetual Inventory Records Match the Floor." ExpiryDesk, August 6, 2025, https://expirydesk.co.za/blog/perpetual-inventory-that-stays-accurate.
- Chicago (web)
Maki K Malepe. "Making Perpetual Inventory Records Match the Floor." ExpiryDesk. August 6, 2025. https://expirydesk.co.za/blog/perpetual-inventory-that-stays-accurate.
Frequently asked questions
- What is Goods in: where truth starts (in Systems inventory work)?
- Line-level receiving against POs, with exception handling for shorts and substitutions, prevents silent quantity errors that propagate forever.
- How to handle Movements and adjustments on the floor?
- Transfers between branches, inter-branch moves, and quarantine holds must flip system status when physical status changes.
- Why Rhythm and ownership matters for cash and service levels?
- Daily or weekly reconciliation between high-impact areas and the system catches drift while memory is fresh.