Field operations
Does my parts count agree with receipts and recorded usage?
Add receipts to opening stock and subtract recorded usage. Compare with the physical count, then multiply the absolute difference by unit cost. A negative expected quantity flags recorded issues above recorded availability.
Use the free calculator Get the business edition · €29
Worked example
With the example inputs below, the calculator returns these results.
Expected closing quantity 46
- Opening recorded stock
- 64 pieces
- Receipts and stock returned
- 20 pieces
- Usage and transfers out
- 38 pieces
- Physical closing count
- 43 pieces
- Cost per piece
- 2.8 €
Other results
- Pieces below record
- 3
- Value of discrepancy
- €8.40
Use your own figures
Put a quantity and value on the discrepancy before updating a stock record. Open the worksheet, replace the example values, then copy or print the result.
Van parts stock check →