Retail cycle counting while sales and transfers continue

A shelf count starts at 10:00. Three units sell and five arrive before the counter finishes. The closing physical count differs from the opening book quantity. Posting that difference immediately would turn normal movements into a stock adjustment.

A cycle count needs a defined location, item, unit and observation time. Compare physical and book quantities at the same cutoff, using a controlled movement record or a temporary freeze. If different parts of a shelf were observed at different times, first establish a coherent observation; arithmetic cannot make an uncontrolled mixed-time count reliable.

Reconcile one shelf at 10:15

Assume the book shows 84 units at 10:00. The counter follows a controlled sweep: counted units are marked, and a movement marshal records and reconciles every item entering or leaving the scope. At 10:15 the final physical observation, including the controlled movements, is 85.

Expected book quantity at the cutoff is 84 − 3 + 5 = 86. The observed variance is 85 − 86 = −1. If a recount and movement investigation confirm the shortage, the proposed adjustment is minus one, subject to the inventory controller's approval.

A backward check reaches the same result. Bring the physical count back to 10:00 by reversing movements: 85 + 3 − 5 = 83, compared with the opening book balance of 84. Both methods identify one unit; do not apply both as separate adjustments.

If the five-unit receipt is physically complete at 10:10 but the integration posts it at 10:18, the cutoff ledger still needs that movement. Store both effective and recorded times. A late posting should not cause the next reconciliation to add the receipt twice.

Decide whether the shelf can keep moving

A short freeze is simpler when a store can isolate a small location without disrupting service. Stop physical movement, record the start and end, count all units in scope and reconcile transactions at the boundary. A system lock alone does not freeze a person carrying stock away.

Continuous counting can work when every movement has a reliable identity and the team can prevent unrecorded handling. It requires more than a transaction export: counters need a method for handling units they have already counted, new receipts and picking during the sweep.

Microsoft's cycle-counting workflow allows open counting work without automatically blocking stock reservation and outbound processing, and provides review of differences. Verify the actual configuration. Do not assume that creating a counting task has stopped the warehouse.

1. Define the scopeOne SKU, shelf and unit; opening book quantity 84 at 10:00.
2. Control movementsRecord sale −3 and receipt +5 with physical effective times.
3. Compare at 10:15Expected 86; controlled physical observation 85; variance −1.
4. Investigate and approveRecount, resolve movements, then post one authorised adjustment.

Exception: An untracked movement or mixed-time observation requires a controlled recount; do not force the ledger to balance.

Count the right state as well as the right unit

A sealed pack of six is not one loose unit. Record the conversion and confirm whether the item is stocked as individual units or a separate pack SKU. Check adjacent shelves, returns areas, damaged stock and goods staged for dispatch before calling a variance shrinkage.

Shopify's stock-state definitions distinguish on-hand from available and other states. Count physical on-hand within the stated scope; reconcile reservation and availability separately. Finding a reserved unit on a shelf does not make it available for another sale.

Preserve the first count, recount, movement evidence, proposed adjustment and final approval. Record why the variance occurred where evidence supports it. “Other” may be a temporary investigation status, but repeated unexplained adjustments should create a process review rather than become routine balancing entries.

Make the pilot expose timing errors

Choose a small, active location and test a sale during counting, a late-posted receipt, a transfer out, an unrecognised unit and a rejected adjustment. Include a movement whose physical time is unknown. The correct outcome for that last case is unresolved scope or a recount, not an invented timestamp.

Measure how many counts can be explained at a consistent cutoff, how long exceptions remain open and whether duplicate postings occur. Counting speed alone can reward an unreliable process. A reviewer should reproduce the minus-one result from preserved inputs without asking the counter to remember what happened.

Keep automated adjustments disabled for the pilot. If later automation is justified, define its limits by value, item risk and evidence quality. Those are local control choices, not universal tolerances supplied by a software product.

Adjust only the residual difference

The stock discrepancy is what remains after valid movements are aligned to the observation. The process is ready when that residual can be explained, approved and posted once.

1. Select a small scope and define the physical cutoff method.
2. Capture effective times, posting times and movement identities.
3. Reproduce the forward and backward calculations on a controlled example.
4. Approve only the supported residual and review recurring causes.