Available stock differs from on-hand stock: build the quantity bridge

A storefront's available quantity answers how many units it can offer for sale under its current rules. A physical count answers how many units staff found in specified locations. An accounting valuation needs ownership, quantity, cost and condition evidence. Establish which question the report answers before treating different totals as a shortage or writing an adjustment.

Shopify defines on-hand inventory as the sum of available, committed and unavailable units at a location. Incoming units are separate. Those definitions help explain why stock reserved for customer orders or held for inspection can remain physically present while unavailable for a new purchase. Confirm the equivalent definitions in every connected warehouse or planning system.

Export quantities by SKU, location and state using a shared cutoff. Keep the timestamp and time zone with the files. A report generated before the warehouse confirms dispatch can disagree with one generated minutes later without either containing a permanent error. Reconcile those movements before changing the opening quantity.

For a hypothetical warehouse, 80 available units, 25 committed units and 15 unavailable units produce 120 on-hand units. An additional 40 incoming units do not increase that location's physical count to 160. Whether goods traveling to the warehouse belong in an accounting stock-in-transit balance is a separate ownership question for the reviewer.

Review committed stock attached to canceled, expired or completed orders. Find which system created the reservation and which event should release it. A stale reservation can make replenishment planning look urgent even though usable stock sits in the building. Correct the underlying reservation through its supported process, then verify that availability changes in connected channels.

Review unavailable units by reason and age. Safety stock, quality inspection and damage require different decisions. Ask the operating owner to confirm whether the hold still applies and whether the goods remain in their recorded location. Do not release a quality hold solely to improve available inventory. Finance should receive the condition evidence needed for its valuation assessment.

Correcting a reservation can change availability without changing total inventory value. A damaged unit may remain on hand while requiring a value review. A missing unit may change both quantity and value. Identify the actual event before selecting the accounting correction, and retain the adjustment reason and approval.

Provide the accountant with the reconciled quantity bridge and the populations requiring cost or recoverability review. Preserve exceptions by SKU and location rather than netting shortages in one warehouse against excesses in another. The final record should explain why available stock differs from counted stock and show which differences affect financial inventory, customer fulfillment or only planning controls.