Article · Practical guides

An omnichannel inventory reconciliation template for stores

Start with one row per SKU and location at a shared cutoff time. Record the physical count, the system’s on-hand balance and the units committed to orders or held out of sale. Investigate the difference before changing the balance so you can trace the adjustment.

By The Skyline Project ·

Copy this worksheet

Scrollable table: swipe horizontally to see every column. You can also focus the table and use the arrow keys.

Cutoff · SKU · Location · System on hand · Physical count · Difference · Committed · Held · Available after reconciliation · Owner and reason
CutoffSKULocationSystem on handPhysical countDifferenceCommittedHeldAvailable after reconciliationOwner and reason
Nov. 19, 6 p.m.SHIRT-BLU-MStore A2322−14216Stock lead checks pending pickup

Illustrative row. Difference equals physical count minus system on-hand. Available here equals confirmed on-hand minus committed and held units, assuming those groups do not overlap. In the example, reconcile the missing unit before treating 22 as confirmed. Use the stock definitions in your own platforms when they differ. If you keep a safety buffer, record it separately and apply it consistently to channel availability. Shopify documents inventory states and locations. Shopify Help Center.

Put five events through the test

  1. Sell one unit in store and check the online availability.
  2. Create an online order and confirm the reservation at the correct location.
  3. Cancel it and check when the platform releases units.
  4. Return one item as resellable and one as damaged and check both states.
  5. Attempt a transfer between locations and confirm how in-transit units are shown.

Write expected and actual results next to the order reference. Use sample records and limit changes to a test setup or a controlled pilot. Track mismatched rows divided by total rows counted. Review the reason for each mismatch before widening scope. For product identifiers, GS1 US explains what a GTIN identifies. GS1 US GTIN guide.

Explore technology integration or tell us how your store tracks stock.

Contact

Let’s talk about your business

Tell us where operations get stuck using the existing contact form. The next step can be coordinating a video call, with no obligation.

Tell us about your business