Worked case · Illustrative scenario
Reconcile ERP and WMS stock
The interface completed. ERP shows 10,000 units and WMS shows 9,500. Work through the 500-unit gap before drawing a conclusion.
| Record | Amount / quantity |
|---|---|
| ERP extract | 10,000 |
| WMS extract | 9,500 |
| Difference to investigate | 500 |
1. Make the balances comparable
Retain extracts at the same cut-off. Match item, location, stock status and unit of measure. A total alone can conceal offsetting differences.
2. Trace the exception
For each unmatched item, inspect receipts, dispatches, transfers, interface message IDs, rejected messages and mapping changes. Record the evidence for each explanation.
3. Test the explanation
A receipt of 500 units posted after one extract is a timing explanation only if the matched transaction and subsequent posting support it. A conversion error needs the source quantity and mapping rule.
4. Resolve and verify
Correct the supported source error under authorised procedures, rerun both extracts and retain the reconciliation. Assign unexplained items an owner and due date; do not insert a balancing adjustment.
Test your reasoning
A later WMS receipt is for 500 units. Is the difference resolved?
Compare your reasoning
Not yet. Match the item, location, status, UOM, source transaction and cut-off. Then rerun the reconciliation. An equal quantity alone does not establish that the receipt explains the gap.
Keep learning
Follow the full discipline case →Working tools to adapt
Inside Assurance Toolkit #08 — Audit Finding Working Paper →
Data Analytics Exception Review: Keep the Reasoning Behind the Result →
Original teaching example. Adapt tests to your evidence, systems and approval procedures.
