Adjustments

Adjustments

Overview

Adjustments can increase or decrease your inventory.

You can use adjustments to manage stock discrepancies from a stocktake. You may have gained stock (for example, found stock that hadn't been counted in the last stocktake) or lost stock (for example, stolen or damaged)

Adjustments can also change the value of the inventory items in stock.

Create an Adjustment

  1. In the navigation, click Stock, then select Adjustments.

  2. In the Adjustments list page, select New Inventory Adjustment.

  3. Enter a line item into the Product Name.

  4. Enter the quantity.
    This can either be positive or negative. Positive will increase the inventory, negative will decrease the inventory.

  1. To finalize the transaction, enter a Completed Date.

  1. Enter a date in the Adjust to Xero box to alter the inventory balance in your accounting software if appropriate (see below).

  2. Select Save from the screen that arrives next to continue.

Adjust Batch/Serial items

Select into the Qty Adjusted column and add in the batch/serial numbers you want to receive into stock. If you are receiving out of stock, select them from the list and click the green arrow to remove them.

Adjust stock tracked by location

If you track stock by location you can receive stock into a specific location by clicking the Qty Adjusted cell and adding a location to Zone and Bin.

To receive stocks from a particular location, click into the Qty Adjusted cell and select the green arrow from the list of locations to remove stock from that location.

Change the stock value

It is sometimes necessary to change the value of stock in your inventory. Perhaps the value was input incorrectly during set up, or you have found another error.

  1. Reduce the inventory by creating an adjustment with a negative value.

  2. In a separate adjustment, create a positive adjustment to bring back in the stock at the new value.

  3. Complete and then Import both transactions to your accounting software if appropriate.

Adjustments and your accounting software

Adjustments can be imported to your accounting software.

If you’re using the periodic method of accounting, it is not necessary to import adjustments.

If you’re using the perpetual method, importing a positive adjustment will debit the inventory account and credit your allocated expenses account.

Importing a negative adjustment will credit your inventory account and debit your default expenses account. After this, you may choose to direct this from your default expense account to an alternative account that deals specifically with stock loss, theft, etc. if you have these set up.

FAQs

I can see some "auto-adjustments" in my Adjustments module. What are these?

For additional information on auto-adjustments, see the Auto-Adjustments Help article.

Is it possible to import Adjustments?

Yes, but it is far easier to complete a stocktake.

How do I adjust the stock that is in holding?

Holding Stock can be adjusted out just like any other negative adjustment, but you must first clear the holding group by clicking into the holding column and selecting Clear.

How do I adjust stock in and out for one product on the same adjustment?

You will need to use separate lines for the positive and negative quantities. Note that if the net total value of the adjustment is 0 you will not be able to import to your accounting system. In this case, you should navigate to the Review screen and set the Accounting Status to Do Not Import.

Was this article helpful?

Have more questions? Submit a request