Stock & logistics
Does the physical stock count match our recorded movements?
Start with opening stock, add receipts and restocked returns, then subtract shipments. Subtract the expected closing balance from the physical count. A negative difference indicates fewer units on hand than the ledger predicts.
Use the free calculator Get the business edition · €29
Worked example
With the example inputs below, the calculator returns these results.
Expected closing balance 89
- Opening stock balance
- 100 units
- Units received from suppliers
- 25 units
- Units shipped out
- 40 units
- Returns put back into stock
- 4 units
- Physical count at period end
- 85 units
Other results
- Count minus expected balance
- -4
- Units to reconcile
- 4
Use your own figures
Identify the size and direction of a stock discrepancy for investigation. Open the worksheet, replace the example values, then copy or print the result.
Stock ledger reconciliation →