- Created by RonT, last modified on Oct 11, 2022
How satisfied are you with our online help?*
Just these help pages, not phone support or the product itself
Why did you give this rating?
Anything else you want to tell us about the help?
From time to time you may need to adjust inventory item quantities and values. For example, if your inventory gets damaged, you may have to write off some of your inventory or revalue it. See below for some examples of inventory adjustments.
This topic explains how to make an adjustment to a single item or a few items.
To make an inventory adjustment
Go to the Inventory menu > Create inventory adjustment.
Enter details of the adjustment.
A The Inventory journal number appears by default. You can change this is if you want, as well as the date of the adjustment. You can also enter a description of the inventory adjustment transaction.
Select whether you want this adjustment to be allocated as an end-of-financial-year adjustment. EOFY adjustments can be excluded from your financial reports.
Choose the Item ID of the item you want to adjust (inventoried items only). The name and the current on-hand quantity of the item appear. To find an item, you can start typing the item number or item name into this field.
Entering a new item?
Click the dropdown arrow in the Item ID column and choose + Create Item. Enter the item details and click Save. Learn more about Creating items.
Once you choose an item, its Current quantity is shown.
In the Adjustment column, enter the quantity by which you want to increase or decrease the quantity held. Only enter the quantity variation. Enter the quantity in inventory units, not buying or selling units. If you enter a positive number, that number is added to your on-hand inventory. If you enter a negative number, that number is subtracted from your on-hand inventory.
When you enter the adjustment:
- the New on hand column displays what the on-hand quantity of the item will be after recording the adjustment
- the Unit cost of the item appears by default. This is calculated as the total cost of the item divided by the number of units on hand. If these are new items, enter their purchase cost
- the Amount field displays the value of the adjustment.
D Choose the account you want to assign the adjustment amount to. If you’re reducing the inventory value, this account is usually a cost of sales or expense account. E If the item is related to a job, choose the Job. F You can add a description of the adjustment line in the Memo field.
- Click Save to save the inventory adjustment.
To view, edit or delete inventory adjustments
You can view, change or delete inventory adjustments from the Find transactions page (accessible via the Inventory menu or, the Banking menu, or the Accounting menu > General journals).
You can't delete an inventory adjustment if it results in a negative on hand quantity or item values.
- Go to the Inventory menu > Inventory transactions to open the Find transactions page.
- Choose the Period you want to view inventory adjustments for.
- If necessary, choose Inventory journal as the Source journal.
- (Optional) If you're on the Debits and credits tab, you can choose the Account you assign your inventory adjustments to.
- Click the Reference no to open an inventory adjustment. If you want to
- edit it, make any changes you want and click Save
delete it, click Delete.
Examples of inventory adjustments
The following are some examples of inventory adjustments.
This inventory adjustment increases the number of items on hand by two and the total value of the items on hand by $700.
This inventory adjustment decreases the number of items on hand by one but does not change the value of the items. The average cost of the items will increase as a result of this adjustment.
This inventory adjustment increases the total value of the items on hand by $120 but does not change the number of items on hand. The average cost of the items will increase as a result of this adjustment.
This inventory adjustment decreases the total value of the items on hand by $20 but does not change the number of items on hand. The average cost of the items will decrease as a result of this adjustment.