Update unit costs and adjust quantity

Who is this article for?
This article is for business owners who want to view historical adjustments of their stocks, including identifying missing unit costs. This is a feature available with Square for Retail Plus.

About updating unit costs and quantity

You can apply filters on your stock History log to view stock intake with an associated unit cost, without a unit cost, or all historical adjustments.

Before you begin

Keep in mind that stock adjustments that deduct from your inventory levels will credit or debit your Cost of Goods Sold and Inventory Value (depending on the type of adjustment) based on a first in, first out (FIFO) accounting method. If the cost appears to be inaccurate, you can edit the cost of the original stock intake. As a result, you are unable to update the unit costs for adjustments that deduct from your stock levels — such as re-counts that adjust down, loss, damage, or theft stock adjustments. Learn more about Square Inventory Management.

Identify missing unit costs

To identify missing unit costs:

  1. Log in to your Square Dashboard.

  2. Navigate to Items & Orders > Items > Inventory Management > History.

  3. On the All Costs drop-down menu, select Missing Cost.

The Missing Cost filter will display a list of items that are not associated with a unit cost.

Add a unit cost

To add a unit cost:

  1. Log in to your Square Dashboard > Item library.

  2. Tap Add Cost next to one of your items, or select your item > Edit.

  3. Enter the unit cost > tap Save.

If the original stock intake was with a purchase order, click the link listed in the historical adjustment details page to update the associated unit cost.

Bulk resolve missing unit costs

For items with a cost associated at the variation level, you’ll see the option to Resolve Unit Costs for adjustments in the History tab of your Square Dashboard.

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.

To bulk resolve missing unit costs:

  1. Log into your online Square Dashboard, go to Items & Orders > Items > Item library to confirm each item variation has an associated unit cost.

  2. Navigate to Inventory Management and click History.

  3. Select Resolve Unit Costs > Resolve Costs.

Select See Stock Actions to 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.

You are not able to bulk update the unit cost for item variations you’ve deleted from your item library. To update historical adjustments for a deleted variation, you’ll need to update each variation unit cost from your History Log.

Related articles

Can't find what you need?