How to Reconcile Inventory to a Physical Count

Prepare before anyone starts counting

Clean counting begins with a clear scope and cutoff. Decide which items and locations are included, assign count responsibilities, and choose how movements will be handled while the count is in progress.

Tidy and label stock, separate damaged or quarantined items, and resolve obvious duplicate item codes. Poor preparation creates differences that are difficult to explain later.

Control the movement cutoff

The recorded balance and physical count must refer to the same point in time. Pause receipts and issues when practical. If activity must continue, record every movement during the count in a separate controlled log and include it in the reconciliation.

Note the last movement reference included before counting. This small step prevents a late delivery or issue from appearing as a mysterious variance.

Count independently and consistently

Use a count sheet with item code, description, unit, and count field. Hiding the expected quantity from the first counter reduces the temptation to make the physical number match the record.

Use the same unit as the inventory record. Mark completed areas and require a second count for high-value items, large differences, or uncertain units.

Calculate and classify each variance

Subtract the recorded quantity from the physical quantity. A result of minus three means three fewer units were found than the record expected. Keep both the quantity difference and, when relevant, its value impact.

Classify the likely cause before adjusting: timing, unrecorded receipt or issue, wrong item, unit conversion, damage, duplicate entry, counting error, or unexplained difference.

Investigate the largest and riskiest differences first

Recount before assuming the record is wrong. Then review recent movements, delivery evidence, issues, adjustments, and nearby items that may have been confused.

Prioritize by value, operational importance, repeated variance, and size of difference. A low-value one-unit difference may need less work than a small quantity variance in a critical or expensive item.

Approve, adjust, and learn

Once the difference is understood or the investigation limit is reached, record an approved adjustment rather than silently overwriting the balance. Preserve the count, recorded quantity, variance, reason, approver, and adjustment reference.

Finish by looking for patterns. Repeated differences may point to delayed recording, unclear units, poor item labels, uncontrolled access, or a movement process that needs attention.

• Post adjustments only after approval.
• Keep count evidence and investigation notes together.
• Confirm that the adjustment produces the counted closing balance.
• Assign an owner and due date for recurring control problems.