No signup. A blank worksheet, not an app import file. Keep any completed copy private.
Compare one lot and period
Choose one period and avoid mixing quantities from several lots. Keep each adjustment explainable through its source.
Balance review columns
- Lot reference
- Period start
- Period end
- Opening quantity
- Quantity added
- Recorded use
- Expected closing quantity
- Counted closing quantity
- Difference and notes
An invented quantity difference
Lot A opens at 200, adds 100, and records 80 used. Expected closing quantity is 220. A count of 218 leaves a difference of minus 2.
Investigate before correcting the holding
Use the balance calculator for arithmetic. Investigate a difference before changing the recorded holding. The worksheet cannot count physical stock.
Reviewed October 2, 2026.
Sources Coldbore on the App Store