Track missing unit costs from your Square Dashboard
About reporting history
Your History log is a detailed record of every stock adjustment — helping track and account for the stock levels for each item. When you manually adjust your stock, accept a purchase order, or make a sale, your History log will reflect each adjustment.
Use the History log in your Square Dashboard to add or update unit costs and access a detailed record of every stock adjustment.
Before you begin
To identify missing costs, view stock intake with and without an associated unit cost, or all historical adjustments, apply filters on your inventory history log. Stock adjustments that deduct from your inventory levels will credit or debit your Cost of Goods Sold (COGS) and Inventory Value (depending on the type of adjustment) based on a first in, first out (FIFO) accounting method. While you can edit any inaccurate cost of original stock intake, it isn’t possible to update the unit costs for stock adjustments that deduct from your inventory levels, such as re-counts that adjust down, loss, damage, or theft.
Track missing unit costs
To identify missing unit costs:
- Go to Items from your Square Dashboard.
- Click Inventory Management > History.
- From the All Costs drop-down menu, select Missing Cost.
Once you identified the missing unit costs, if you need to update inventory without an associated unit cost, apply the filter Missing Cost. This filter will display a list of items that are not associated with a unit cost.
To add a unit cost:
- Tap Add Cost next to one of your items.
- Enter the unit cost > tap Save.
If the original stock intake was with a purchase order, click the link listed on the historical adjustment details page to update the associated unit cost.
For items with a cost associated at the variation level, you’ll see the option to Review Missing Costs for adjustments in your History. Keep in mind, if an item in your library is missing a unit cost, you’ll need to update each variation before you can bulk resolve missing costs from your History log.
You can add default costs by importing your item library or manually editing the cost of each item variation. Apply default costs to past actions for accurate reporting and margin calculations.
To get started:
- Go to Items from your Square Dashboard.
- Click Inventory Management > History.
- Confirm each item variation has an associated unit cost.
- If there are missing items or vendors, click Bulk Actions > Review Missing Costs or Review Missing Vendors.
When you select See Stock Actions, you’ll see each historical adjustment missing an associated unit cost.
When you update one historical adjustment, the unit cost for every other adjustment will reflect the new unit cost for that particular item.