How to Adjust Inventory in QuickBooks

Seatami

Editor

posted on 14 years ago — updated on 1 second ago

2
views

If your business involves any type of inventory, whether a huge amount or just a few items, the inventory needs to be tracked. You or your bookkeeper can use QuickBooks for storing inventory information and also for adjusting inventory counts and values based on the current market. You most likely count your inventory on a regular basis and any changes should be recorded in your financial records. You don't want to have to pay taxes on inventory that you don't have; therefore, you should always take a regular count and adjust your records as necessary. With QuickBooks, it is a very simple process to make these adjustments.

Steps

Select "Lists" or "Vendors."

Select "Items" under Lists or "Inventory Activities" under Vendors.

Select "Adjust Quantity/Value on Hand" in the drop-down list under either Lists or Vendors.

Enter the date that you made your physical count of your inventory.

Select an expense account (an inventory item) from the adjustment list you opened up. This is the account you selected to track your inventory decline.

Identify the customer job and class, if applicable, from the drop-down list.

Type in the new physical count in the column named "New Qty" or enter a new value in the "Qty Difference" column and QuickBooks will calculate the adjusted quantity for you.

Check the box named "Value Adjustment" if you want to see an expanded version of the open window; however, this is not necessary to change or adjust your inventory.

Enter the new count in the "New Qty" column if using the expanded method for value adjustments. This allows you to mark down the items as the market value decreases.

Use the "Memo" text box to write a short description or note to describe what you've done, who was involved in counting inventory or other notes, if necessary.