Definition
Stock reconciliation is the systematic process of comparing inventory recorded in the ERP or stock ledger with the physically verified quantity and investigating the causes of any difference. A professional reconciliation does not simply adjust the ERP balance to match the physical count.
Objectives
- Maintain accurate inventory records.
- Identify physical versus system differences.
- Detect transaction errors and process weaknesses.
- Protect inventory value and working capital.
- Maintain reliable material availability information.
- Improve ERP and master-data accuracy.
- Provide an auditable basis for authorized adjustments.
- Prevent recurring stock discrepancies.
Basic Stock Reconciliation Equation
Reconciliation Workflow
- Freeze or establish a clear transaction cut-off.
- Obtain ERP/book balance.
- Obtain physical count.
- Match item, location, batch and status.
- Calculate quantity and value variance.
- Review receipts, issues, transfers, returns and adjustments.
- Identify timing differences.
- Investigate root cause.
- Obtain approval for valid adjustment.
- Post adjustment and verify final balance.
- Record corrective and preventive action.
Variance Categories
| Category | Typical Cause |
|---|---|
| Timing | Transaction occurred physically but ERP posting is pending |
| Quantity | Count, receipt or issue error |
| Location | Stock physically held in a different location |
| UOM | Incorrect unit or conversion |
| Status | Quarantine/rejected/blocked stock treated incorrectly |
| Duplicate | Repeated transaction or duplicate record |
| Loss/Damage | Physical loss, deterioration or unauthorized removal |
Decision Rules
- Investigate material discrepancies before adjustment.
- Use tolerance limits appropriate to material risk.
- Escalate high-value and critical-item variances.
- Review recurring variance by root cause, not only by item.
- Do not net unrelated discrepancies to hide individual problems.
KPIs
Reconciliation Accuracy
Percentage of reconciled records without unexplained variance.
Variance Value
Total quantity/value discrepancy requiring investigation.
Unexplained Variance
Variance remaining after documented investigation.
Repeat Variance Rate
Recurring discrepancy for the same item/location/process.
Common Errors
- Adjusting first and investigating later.
- Ignoring transaction cut-off.
- Comparing only total store value instead of item-level differences.
- Failing to reconcile status and location.
- Not tracking corrective action after repeated variance.
Excel / MIS Application
A reconciliation sheet should include Item Code, Description, Location, Opening, Receipts, Issues, Transfers, Returns, Adjustments, Expected Closing, Physical Closing, Variance Qty, Unit Rate, Variance Value, Reason, Action and Approval.
Related Areas
Stores Management · Inventory Management · Purchase Management · Material Planning · ERP & MIS