Inventory Reconciliation & Risk Review

Inventory differences are rarely just inventory differences.

A variance between system records and physical stock can point to very different underlying issues: counting errors, timing differences, unrecorded movements, cut-off problems, incorrect master data, shrinkage, obsolete inventory, process failures, or even fraud.

That is why a good inventory reconciliation should not stop at:

Book Quantity – Physical Quantity = Variance

The more important question is:

What does the variance tell us about the underlying process and risk?

A structured Inventory Reconciliation & Risk Review connects five things:

Obtain the Data

Start with reliable inventory information.

Obtain the inventory listing, physical count results, ERP or general ledger records, and relevant supporting transaction data.

Before performing any analysis, make sure the population itself is complete and reliable.

Because sophisticated analysis performed on incomplete data still produces unreliable conclusions.

Reconcile the Records

Compare book quantities and values against physical count results.

Identify differences by SKU, location, category, quantity, value, and other relevant dimensions.

But not every difference deserves the same level of attention.

A variance should be assessed not only based on its amount, but also its nature, frequency, pattern, and potential risk.

Analyze and Investigate

Significant or unusual differences should be investigated to understand what actually happened.

Possible explanations may include:

• Counting errors
• Timing differences
• Unrecorded inventory movements
• Receiving or dispatch errors
• Cut-off issues
• Incorrect unit of measure
• Master-data issues
• Damaged or obsolete inventory
• Shrinkage
• Process failures
• Control failures
• Potential fraud

But receiving an explanation is not the same as resolving a variance.

The explanation should be supported by evidence.

Where necessary, trace the difference back to transactions, documents, system records, physical movements, or other independent evidence.

Assess the Related Risks

Once the cause is understood, ask what the difference means for the business.

Inventory variances can create risks related to:

• Existence
• Completeness
• Valuation
• Cut-off
• Obsolescence
• Shrinkage
• Financial misstatement
• Operational efficiency
• Internal control effectiveness

A small quantity variance can still represent significant exposure when it involves high-value, sensitive, fast-moving, or fraud-prone inventory.

This is where reconciliation moves beyond accounting.

The objective is no longer simply to make two numbers agree.

The objective is to understand whether the difference indicates a broader risk.

Document and Conclude

A strong working paper should clearly document:

• What was reconciled
• What differences were identified
• Which differences were investigated
• What caused the differences
• What evidence supports the explanation
• What risks were identified
• Whether additional procedures are required
• What conclusion was reached

A reconciliation is complete only when the difference has been understood — not merely when the numbers have been matched.

Inside Assurance Toolkit #03 — Inventory Reconciliation & Risk Review

This practical working paper is designed to help assurance professionals move systematically from:

Difference → Investigation → Root Cause → Risk → Conclusion

Because reconciliation should not only tell us:

“Where do the numbers differ?”

It should help us answer the more important question:

“What does the difference tell us about the business?”

Beyond the numbers. Inside the business.

Inside Assurance