Finance
Stock Reconciliation That Survives Month-End Scrutiny
Cut-offs, unmatched receipts, and intercompany transfers — a playbook that ties the floor to the ledger on purpose.
One slow aisle, one skipped check, one promo that landed heavy: suddenly the back room holds risk the spreadsheet never warned you about. Stock reconciliation aligns physical counts with system records and explains every material gap — not only adjusting numbers. A playbook defines frequency, tolerance, escalation, and how findings feed accuracy metrics and purchasing. It is the bridge between cycle counting and finance close.
Key terms in this guide: MOQ, Working capital, Write-off.
Dense packs and mixed strengths are where hand counts lie — unless you are using a camera to count them for you →
Related reading in this library
Topics covered
- reconciliation
- inventory accuracy
- finance
- Finance inventory operations
- Expiry risk management
- Working capital in stock
Stock reconciliation aligns physical counts with system records and explains every material gap — not only adjusting numbers. A playbook defines frequency, tolerance, escalation, and how findings feed accuracy metrics and purchasing. It is the bridge between cycle counting and…
Referenced signals — spot-check sources as data ages
Amplifies
Forecast error compounds up the supply chain (bullwhip): ordering policies and lead times inflate swings vs end demand.
Cash tied up
Inventory often represents 20–35%+ of total current assets for product companies — small % improvements move real cash.
1.6%
US retail shrink as % of sales in NRF’s 2023 survey (FY 2022) — industry benchmark; methodology & definitions vary by retailer.
What is Scope and frequency (in Finance inventory work)?
Reconcile high-risk bins more often; use statistical sampling for low-risk — but document the method.
Reconcile high-risk bins more often; use statistical sampling for low-risk — but document the method.
Spreadsheets age faster than stock — most people track this wrong. Here is the smarter way →
What this means on the floor
Include in-transit and quarantine stock in scope definitions so nobody optimises one bucket by ignoring another.
How to handle Investigation on the floor
Recount rules before adjustment; capture reason codes that point to process fixes.
Recount rules before adjustment; capture reason codes that point to process fixes.
Rotation only works when the soonest date is visible before the truck arrives — here is how teams close that gap →
How to validate this in your next stock review
Correlate spikes with new suppliers, new staff, or system releases — timing often tells the story.
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 Closing the loop matters for cash and service levels
Feed recurring errors into training, layout changes, or labelling fixes.
Feed recurring errors into training, layout changes, or labelling fixes.
Knowing the rule is not the same as seeing the next risk date in one place — which is exactly what Expiry Desk tracks automatically →
Why this signal should reach finance the same week
Share summary dashboards with buyers — reconciliation is not only finance’s problem.
How to operationalize this guide in your branch
Problem definition: Cut-offs, unmatched receipts, and intercompany transfers — a playbook that ties the floor to the ledger on purpose.
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.
- Wikipedia — Bullwhip effect (primer) — Forecast error compounds up the supply chain (bullwhip): ordering policies and lead times …
- McKinsey — Working capital — Inventory often represents 20–35%+ of total current assets for product companies — small %…
- 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
Holiday Malepe. (2025, December 3). Stock Reconciliation That Survives Month-End Scrutiny. ExpiryDesk. https://expirydesk.co.za/blog/stock-reconciliation-playbook
- MLA
Holiday Malepe. "Stock Reconciliation That Survives Month-End Scrutiny." ExpiryDesk, December 3, 2025, https://expirydesk.co.za/blog/stock-reconciliation-playbook.
- Chicago (web)
Holiday Malepe. "Stock Reconciliation That Survives Month-End Scrutiny." ExpiryDesk. December 3, 2025. https://expirydesk.co.za/blog/stock-reconciliation-playbook.
Frequently asked questions
- What is Scope and frequency (in Finance inventory work)?
- Reconcile high-risk bins more often; use statistical sampling for low-risk — but document the method.
- How to handle Investigation on the floor?
- Recount rules before adjustment; capture reason codes that point to process fixes.
- Why Closing the loop matters for cash and service levels?
- Feed recurring errors into training, layout changes, or labelling fixes.