Inventory Adjustments in AccountEdge

Inventory Adjustments

There are three possible reasons to create inventory adjustments. The value of the item is wrong, the quantity of the item is wrong, or both the value and the quantity of the item are wrong.

 

Effecting Both Quantity and Value
Effecting Value Not Quantity
Effecting Quantity Not Value

Adjusting Item Quantity – Effecting Value

1. Choose Index to Reports from the Reports menu. Select Items List (Summary) from the report list and click Display. Verify the current quantity of the item you want to change and the current value of that item.
2. In the Inventory Command Center, click the *Adjust Inventory* button.
3. Enter the item’s number in the Item # column. In the Quantity column, enter the quantity of the adjustment, not the new quantity. For example: if your Items List (Summary) Report currently shows 10 units on hand, and you want to change it to 15, enter 5 in the Quantity column. Or, if the Items List (Summary) Report shows 10 units on hand and you want to change it to 8, enter -2 in the Quantity column.
4. Enter either the cost per item in Unit Cost or the total cost of all items you are adding or subtracting in the Amount columns.
5. Enter the correct Location, if you use Locations
6. In the Account # column, enter the account that you would like to assign the expense (or income) to.
7. Click Record.
8. Display an Item List (Summary) Report to verify the change to your items quantity.

Adjusting Item Quantity – Not Effecting Value

1. Choose Index to Reports from the Reports menu. Select Items List (Summary) from the report list and click Display. Verify the current quantity of the item you want to change.
2. In the Inventory Command Center, click the Inventory Adjustments button.
3. Enter the item’s number in the Item # column. In the Quantity column, enter the quantity of the adjustment, not the new quantity. For example: if your Items List (Summary) Report currently shows 10 units on hand, and you want to change it to 15, enter 5 in the Quantity column. Or, if the Items List (Summary) Report shows 10 units on hand and you want to change it to 8, enter -2 in the Quantity column.
4. Enter $0 in the Unit Cost and Amount columns.
5. In the Account # column, enter the item’s asset account number. It was assigned to the item when you created it.
6. Click Record.
7. Display an Item List (Summary) Report to verify the change to your items quantity. You’ll also notice that the average cost of the item has changed – since we’ve updated the quantity but not updated the cost.

Adjusting Item Value – Not Effecting Quantity

To adjust the Current Value and Average Cost of an inventoried item without affecting its Quantity on Hand requires two separate adjustments.

First Adjustment:

1. In the Inventory Command Center, open the Item List, and select the Item to be adjusted.
2. In that Item’s Card select the Profile tab and take note of:
   • Quantity on Hand
   • Current Value
   • Average Cost
   • Asset Account for Item Inventory
3. In the Inventory Command Center, click the Adjust Inventory button
4. Enter the Item’s Number into the Item Number Column
5. Enter the Item’s Quantity on Hand into the Quantity Column as a negative value
6. Enter the Item’s Current Value in the Amount Column (it will calculate as negative based on negative quantity)
7. Check that Unit Cost (on adjustment) is equal to Average cost (on item card)
8. Enter the account you would like to assign the expense to in the Account Column
9. Enter any Notes or Memos for your records and click Record
10. Check the Item Card again by following steps 1 & 2; Quantity on Hand, Current Value, and Average Cost should all be 0

Second Adjustment:

1. In the Inventory Command Center, click the Adjust Inventory button
2. Enter the Item’s Number into the Item Number Column
3. Enter the Item’s original Quantity on Hand into the Amount Column as a positive value
4. Enter the correct Current Value of the Item in the Unit Column
5. Check that Amount calculates what the correct value of that item should be.
6. Enter the same account as entered in the previous set of instructions in the Account Column
7. Enter any Notes or Memos for your records and click Record
8. Check the Item Card again by following steps 1 & 2; Quantity on Hand, Current Value, and Average Cost should be the original Quantity on Hand, with updated Current Value and Average Cost

If Multiple Locations are being used and affected by these adjustments, then each location needs to be recorded on a separate line in the adjustment, and the Quantities on Hand must properly match the amounts at each location. To find out more about the distribution of Inventory between locations, in the Item Card click the Locations tab towards the right.