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

In the navigation, click Stock, then select Adjustments.
In the Adjustments list page, select New Inventory Adjustment.
Enter a line item into the Product Name.
Enter the quantity.
This can either be positive or negative. Positive will increase the inventory, negative will decrease the inventory.

To finalize the transaction, enter a Completed Date.

Enter a date in the Adjust to Xero box to alter the inventory balance in your accounting software if appropriate (see below).
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.

Reduce the inventory by creating an adjustment with a negative value.
In a separate adjustment, create a positive adjustment to bring back in the stock at the new value.
Complete and then Import both transactions to your accounting software if appropriate.

Adjustments and your accounting software

Adjustments must be synced to your accounting integration if:

You integrate with QuickBooks Online, or
You integration Xero and use the perpetual method.

Positive adjustments will debit your stock on hand account and credit an expense account. Negative adjustments will credit your stock on hand account and debit an expense account.

Find out more about syncing adjustments to QuickBooks Online and syncing adjustments to Xero.

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.