Goods on Hand (GOH) on the Inventory Insights page is the value of the stock you have right now.
The formula
For every location (bin) that has stock, SKULabs multiplies the on-hand quantity by the item's cost, then adds everything up:
Goods on Hand = sum of (on hand x cost) for every bin with stock
Cost is the item's cost. If an item has no cost set, SKULabs uses its wholesale price, then its retail price, then 0.
An item with a cost of 0 adds nothing. A blank cost falls back to wholesale or retail; a cost of 0 does not.
Bins with zero or negative on-hand are skipped. Negative stock does not lower the total.
Stock in Amazon FBA, Lightspeed and Shopify warehouses is included. Hover over the Goods on Hand number to see how much of it comes from those warehouses.
The two cards next to it use the same on-hand quantities: Potential sales uses each item's retail price, and Potential wholesale uses its wholesale price.
Filters
Goods on Hand only counts the warehouses and item tags selected in the Inventory Insights filters. The date range and store filters don't change it. To see Goods on Hand for everything, reset the filters.
Why the number can look too high
Wholesale and retail prices are usually higher than cost. If in-stock items have no cost, the fallback to wholesale or retail makes Goods on Hand look higher than it really is. Make sure all in-stock items have cost data.
On Hand accuracy
For maximum accuracy of GOH, ensure that each item has a correct on-hand count by performing periodic cycle counts for in stock items as well as items with negative inventory to ensure that physical inventory in your warehouse matches on-hand stock in SKULabs.
Please let us know if you have additional questions on this or need help importing your costs from other software.
