Inventory Reconciliation: How to Find and Fix Stock Discrepancies

Inventory reconciliation is the process of comparing recorded inventory with physical inventory, investigating the differences, and correcting both the records and the process that caused the discrepancy.

It is more than changing a number after a stock count. Good reconciliation explains why the system and the shelf disagree so the same error does not keep returning.

What is inventory reconciliation?

Inventory reconciliation checks whether the quantity and value recorded in an inventory system match what the business actually has. It often follows a physical inventory count or cycle count.

The basic workflow is:

1. Count physical inventory.
2. Compare it with the system quantity.
3. Identify meaningful variances.
4. Investigate the cause.
5. Approve any required adjustment.
6. Correct the underlying process where possible.

Inventory reconciliation example

Suppose the inventory system shows 120 units of a product, but a count finds 113.

The variance is:

Inventory Variance = Recorded Quantity − Physical Quantity

120 − 113 = 7 units

The reconciliation is not complete after subtracting seven units from the system. The business should review receiving, sales, transfers, damage, returns, and adjustments to determine what created the shortage.

What causes inventory discrepancies?

• Supplier deliveries recorded at the ordered quantity instead of the received quantity
• Unrecorded or incomplete stock transfers
• Returns processed incorrectly
• Damage, spoilage, or waste not recorded
• Theft or other inventory shrinkage
• Cases counted as individual units or vice versa
• Duplicate SKUs and barcode errors
• Sales or consumption not reflected correctly
• Manual adjustments without clear reason codes
• Counting mistakes

How to reconcile inventory step by step

1. Freeze or document inventory movement

Count during a controlled period when possible. If sales, receiving, or transfers continue during the count, record them clearly so the same movement is not counted twice.

2. Count independently

Use the SKU, location, and unit of measure defined in the system. For important discrepancies, perform a second count before changing the record.

3. Compare physical and system quantities

Flag differences above the tolerance defined by the business. For critical or high-value stock, the tolerance may be zero.

4. Review recent transactions

Check purchase-order receipts, transfers, returns, waste, stock adjustments, and sales activity. The goal is to reconstruct the movement that should explain the current quantity.

5. Classify the cause

Use consistent variance reasons such as receiving error, count error, transfer error, damage, spoilage, return error, theft, or unknown. Over time, this creates a useful operational dataset.

6. Approve the adjustment

Once the physical quantity and cause are reasonably understood, update the inventory record according to the business's approval controls.

7. Fix recurring causes

If receiving errors cause most discrepancies, improve receiving. If transfers cause them, improve transfer confirmation. Reconciliation should lead to process changes rather than an endless cycle of corrections.

Inventory reconciliation vs. inventory adjustment

An adjustment changes the recorded quantity. Reconciliation is the broader process of validating the physical quantity, explaining the difference, and deciding whether an adjustment is appropriate.

Inventory reconciliation vs. shrinkage

Shrinkage is one reason records may be lower than expected physically. Reconciliation also identifies non-shrinkage causes such as receiving errors, transfers, returns, and unit mistakes.

How often should inventory be reconciled?

Frequency should follow inventory risk. High-value, high-velocity, high-shrinkage, and operationally critical items should be reconciled more often than low-impact inventory. ABC analysis can help prioritize the count schedule.

Reconciliation for multiple locations

Analyze discrepancies by location rather than only company-wide. One location may have strong accuracy while another has repeated transfer or receiving problems.

For inter-store movements, reconcile the shipped quantity and received quantity separately so inventory does not remain permanently in transit or get duplicated across locations.

How reconciliation improves replenishment

Reorder points, safety stock, forecasting, and purchase orders all depend on the starting inventory quantity. If stock records are wrong, even a mathematically correct replenishment process can create stockouts or unnecessary purchases.

Inventory reconciliation checklist

• Define count scope and timing
• Confirm SKU and unit definitions
• Record inventory movements during the count
• Count physical stock
• Recount material differences
• Review receiving, sales, transfers, returns, and adjustments
• Assign a variance reason
• Approve and post corrections
• Review repeat causes by SKU and location

How Stash fits

Stash gives physical businesses a central inventory record across stock, locations, suppliers, purchasing, and movements. That makes it easier to compare physical counts with expected inventory and investigate where discrepancies entered the workflow.

Reconciling Square inventory

Square users should diagnose inventory counts that do not match physical stock through history before adjusting, and use the Square sync troubleshooting checklist when a sale or channel is not updating the expected record.

Frequently asked questions

What does reconciling inventory mean?

It means comparing the inventory in business records with the physical inventory, investigating differences, and correcting the record and underlying process where necessary.

Should every discrepancy be adjusted immediately?

Not necessarily. Large or recurring discrepancies should usually be recounted and investigated before an adjustment is approved.

Is inventory reconciliation part of cycle counting?

Yes. A cycle count becomes much more useful when differences are reconciled rather than simply overwritten.