Syntha Lab RU

Stock roll-forward reconciliation: beginning + receipts − outflows = end

Checks the stock movement invariant: the beginning stock plus receipts, minus sales, plus returns, minus transfers and write-offs, plus adjustments must give the ending stock. Counts the gap against the actual in units, in percent of turnover and in rubles, compares it with the tolerance and hints at which line and sign to look at first.

Data quality and data owners For whom: Warehouse accountants, IT and data quality analysts.

Calculate on your data →

At a glance

What question does it answer?
Whether the stock movement adds up and where to look if not.
What data is needed?
Beginning, receipts, sales, returns, transfers, write-offs, adjustments, actual.
How to read the result?
The gap against the tolerance, then the sign and a match with a line. Example on the default values: Expected ending stock: 10,650 pcs; Gap against the actual: −250 pcs; Gap, % of beginning plus receipts: 1.43%; Tolerance in units: 87.5. The figures are illustrative: enter your own to see your result.

Why and how to reason

The stock movement must add up: 12,000 + 5,500 − 6,200 + 300 − 800 − 150 = 10,650 pcs, but the actual is 10,400. The gap is −250 pcs (1.43% of turnover), −RUB 275,000 at a cost of RUB 1,100, above the tolerance of 0.5%.

When to use it

At period closing and when reconciling the ledger, the warehouse and the till.

How to read the result

The gap against the tolerance, then the sign and a match with a line.

Common mistakes

Stocks of different dates, skipped adjustments, a reversed sign of a line.

What data is needed?

  • Beginning, receipts, sales, returns, transfers, write-offs, adjustments, actual.

Inputs

FieldUnitValue in the exampleMeaning
Beginning stockpcs12,000The stock in the record at the start of the period. The example value is illustrative.
Receiptspcs5,500Receipts for the period by receiving. The example value is illustrative.
Salespcs6,200Sold at the till and online over the period. The example value is illustrative.
Customer returnspcs300What came back to stock. Empty = 0. The example value is illustrative.
Transfers out of the pointpcs800What went to other warehouses and stores. Empty = 0. The example value is illustrative.
Write-offspcs150Defects, scrap, damage. Empty = 0. The example value is illustrative.
Inventory adjustmentspcs0With a plus the surpluses, with a minus the shortages, already posted in the record. Empty = 0. The example value is illustrative.
Actual ending stockpcs10,400The stock from a count at the same date as the period end: stocks of different dates cannot be compared. The example value is illustrative.
Tolerance%0.5The allowed gap in percent of beginning plus receipts: your rule. Empty = 0 (any gap is flagged). The example value is illustrative.
Unit cost₽1,100For the gap in rubles. Empty = 0 (rubles are not counted). The example value is illustrative.

How it is calculated

StepFormula
Expected end12,000 + 5,500 − 6,200 + 300 − 800 − 150 + 0 = 10,650
Gap10,400 − 10,650 = −250
Tolerancetolerance, % × (beginning + receipts)
Costgap × unit cost

Worked numbers

Default values from the app; in the interactive version you enter your own.

Expected ending stock
10,650 pcsBeginning + receipts − sales + returns − transfers − write-offs + adjustments.
Gap against the actual
−250 pcsActual − expected: a minus means the actual is below the record.
Gap, % of beginning plus receipts
1.43 %
Tolerance in units
87.5
Gap in rubles
−275,000 ₽
Stock accuracy
97.6 %1 − |gap| ÷ the actual.
From the beginning to the expected end, pcs
Waterfall: Beginning +12k, Receipts +5,500, Sales −6,200, Returns +300, Transfers −800, Write-offs −150, Adjustments 0, Expected end 11k05,00010k15k20kBeginningBeginningBeginning: +12k+12kReceiptsReceiptsReceipts: +5,500+5,500SalesSalesSales: −6,200−6,200ReturnsReturnsReturns: +300+300TransfersTransfersTransfers: −800−800Write-offsWrite-offsWrite-offs: −150−150AdjustmentsAdjustmentsAdjustments: 00Expected endExpected endExpected end: 11k11kpcs
  • positive
  • negative
  • total
Data as a table
StepChangeLevel
Beginning+12k12k
Receipts+5,50018k
Sales−6,20011k
Returns+30012k
Transfers−80011k
Write-offs−15011k
Adjustments011k
Expected end—11k

Stock movement

LineQuantitySign
Beginning12,000+
Receipts5,500+
Sales6,200−
Returns300+
Transfers800−
Write-offs150−
Adjustments0±
Expected end10,650=
Actual10,400
Gap−250

A gap of 250 pcs is above the tolerance of 87.5 pcs: the reconciliation does not hold.

The actual is below the record: unposted write-offs or sales, short receipt, losses, a transfer without receipt. Check transfers and write-offs first.

What to do with the result: split the gap by lines and by dates; reconcile the record, the warehouse and the till at one date, and the electronic documents and labeling with the movements.

A typical mistake: comparing stocks of different dates and skipping adjustments. For a set of articles stock accuracy is counted per line (“Stock accuracy”), here the check runs on the total movement.

Nuances and limits

  • Comparing stocks of different dates.
  • Skipping adjustments.
  • Mixing up the sign of a line.

Terms used

Calculate on your data →