Stock roll-forward gap
|Actual − expected end| ÷ (beginning + receipts); expected end = beginning + receipts − sales + returns − transfers − write-offs + adjustments at one date
- Formula
|Actual − expected end| ÷ (beginning + receipts); expected end = beginning + receipts − sales + returns − transfers − write-offs + adjustments at one date- Unit
- %
- Aggregation rule
- Ratio of sums
- Source system
- ERP and accounting system; Warehouse and stock system
- Owning role
- Chief operating officer
- Frequency
- Monthly
Passport
- Grain
- SKU or warehouse × period; sums in units at one date
- Numerator
- The modulus of the gap: |actual − expected end| from the stock movement
- Denominator
- Beginning stock plus receipts for the period
- At zero or no data
- Beginning plus receipts equal 0: show “—”, not 0.
- Limits
- Expected end = beginning + receipts − sales + returns − transfers − write-offs + adjustments; stocks at one date; the tolerance is set by the data owner. Not to be confused with stock accuracy by lines.
- Check example
- Gap against the actual, units: 250; Beginning plus receipts, units: 17500.
a/b*100. Result: 1.43% - Related metrics
Version 1.0 · valid from 2026-11-16 · checked 2026-11-16
Related pages
- Term: Stock roll-forward
- Calculation: Stock roll-forward reconciliation: beginning + receipts − outflows = end
Definition
A check that the beginning stock plus receipts minus outflows and plus adjustments equals the ending stock.
Compare stocks at one date.