How to Reconcile Inventory

Taking inventory? The Reconcile Inventory action allows you to true up your inventory after doing a physical count. It sets the absolute quantity of an inventory line item as of a point in time in order to reset your SUPPLY inventory. It can be accessed: 

  • From the ‘Record inventory action’ dropdown menu in the top navigation bar 
  • From the ‘Record inventory action’ dropdown menu in the Inventory by Location widget on the SKU Details Page

How to use the Reconcile Inventory action

  1. Select the inventory line items in the Inventory Picker.
    1. If a Reconcile inventory action is recorded from the Inventory by Location action menu then both the inventory line item and its location will be pre-selected.
  2. Enter the quantity of inventory. The amount entered should be the total quantity you physically counted, and must be a positive whole number (you may leave a field blank). 
    1. Use the “New Quantity” bulk dropdown menu to enter the current inventory quantity, clear all quantities or apply the same number of groups and items across all inventory. 
    2. It is possible to record a "new" quantity that is the same as the existing quantity in inventory. 
  3. Click the green ‘Reconcile Inventory’ button.

How to Reconcile Inventory_Annotated

💡 We recommend accessing the Reconcile Inventory action from the ‘Record inventory action’ dropdown menu in the top navigation bar when performing your routine physical counts (i.e. monthly, quarterly, etc). This will allow you to view all of your inventory line items at all locations, and therefore quickly true up your inventory across multiple SKUs and Locations at once. 

FAQ

Q: How does the Reconcile inventory action work with my C7 inventory?

A: When your C7 integration is setup, the Reconcile inventory action will post as a "Manual Reset" in your C7 inventory transactions for properly linked inventory. 

C7 integrations - Manual Reset

Q: I edited an Add inventory action that occurred before my last Reconcile inventory action, but the final on-hand inventory hasn't updated - what gives?

A: The quantity recorded in the Reconcile inventory action is "absolute" as of that point in time, based on the physical count that took place. Any action edit or deletion that may have occurred prior to that will not change the absolute quantity updated on the Reconcile inventory action. 

Q: Can I edit or delete my Reconcile inventory action?

A: Yes. Learn more about editing and deleting actions here

Q: How does the Reconcile inventory action impact my TTB export?

SUPPLY will apply the quantity/volume to either Inventory Shortage, or Inventory Gains in Section B, depending on whether the net inventory increases or decreases in the action. This table describes the potential outcomes for your Reconcile inventory action:

Reconcile Inventory - TTB