QuickBooks Inventory Tracking: How to Add, Set up, Enable, Adjust, & Turn off Inventory

QuickBooks Inventory Tracking: How to Add, Set up, Enable, Adjust, & Turn off Inventory

QuickBooks is a software product loaded with useful accounting features. Along with accounting features, this software enables you to keep a track of the inventory. Those of you who are new to QuickBooks inventory tracking, you may be looking for procedures explained in easy language. In this blog, you can go through simply explained procedures and methods to add inventory in QB and set up the inventory in QuickBooks Online and QuickBooks Desktop. What more can you expect from this blog? Here, you can learn to enable the advanced inventory in QuickBooks Desktop Pro.

And for some reason, if you wish to turn off the inventory or advanced inventory, then you can read till the end of this blog.

In this part, you can quickly go through the topics covered in this blog.

Please Note: Prior to adding the inventory, you will be required to go through your subscription. You may be unable to add the investor to QuickBooks in case your subscription has expired. For checking the subscription, first press the Gear icon. Then select “Accounts and Settings”. Click on “Billing and Subscription”. This will help you in seeing your plan. Now, if you wish to upgrade the plan, click on “Plus” and do the needful.

How to Add Inventory in QuickBooks?

Prior to learning how to use QuickBooks to track inventory, you should know how to add it. Certain QB users may not be very clear with the method to add items, services, and products to the inventory. All the help you need for doing has been given here.

This can be done by accessing the Settings and selecting Sales. From the section of Products and Services, you can choose to add a new product or service. The steps that you require for doing the further procedure have been shown below.

Must Read: How to Take QuickBooks Remote Access

  1. Begin with turning on inventory tracking.

Please Note: For enabling inventory tracking, you can refer to the section authored above.

  1. Then click on the “Settings”.
  2. Open “Sales” and tap on “Products and Services”.
  3. Click on “New”/”Add a Product or Service”.
  4. Tap on “Inventory”.
  5. Enter the “Name”, “HSN Code”, or “SKU” for the item you wish to track.
  6. From the dropdown of “Unit”, you can enter the unit.
  7. For specifying a category, press the “Category” dropdown.

Please Note: By setting a “Category”, the services and products can be grouped. This will enable you to easily search them.

  1. For adding the quantity of products, alert for low stock, and an account for the inventory asset, you can follow this step. Add the quantity of products on hand and enter it while tracking via the field named “As of Date”.
  2. In “Low Stock Alert”, you can set the alert for reordering.
  3. Press the dropdown for “Inventory Asset Account”. Then choose “Inventory Asset”.

How to Set up Inventory in QuickBooks Online?

For setting up the QuickBooks inventory tracking, you can visit the Settings, first of all. Then in the Account and Settings, you can opt for clicking on Sales. You can open Edit in the Products and Services section. From there, you can easily set up the inventory and start tracking it.

  1. Press the “Gear” icon to open the “Settings”.
  2. Then click on “Account and Settings”.
  3. Go to “Sales”.
  4. From the section of “Products and Services”, click on “Edit”.
  5. Locate the option of “Show Product/Service Column on Sales Forms”. Then turn it on.
  6. Next, turn on “Track Quantity and Price/Rate”.
  7. Then turn on “Track Inventory Quantity on Hand”.
  8. Press “Save”.
  9. Lastly, press “Done”.

How to Set up Inventory in QuickBooks Desktop?

For the users of QuickBooks Desktop, reading this section is essential. From turning on the inventory to setting it up in QuickBooks Desktop, you will find the complete information here. You can open the Menu and click on Edit. From the Preferences, you can click on Items & Inventory. In the Company Preferences, you can select Inventory as well as the Purchase Orders. Once these have been set as active, you can press Ok.

As you read ahead, the remaining steps will be uncovered.

  1. Start “QuickBooks Desktop” and open the “Menu”.
  2. Tap “Edit”.
  3. Pick “Preferences”.
  4. Choose “Items & Inventory”.
  5. Open the tab named “Company Preferences”.
  6. Tick “Inventory” as well as “Purchase Orders” for activating.
  7. Then press “Ok”.
  8. After receiving the warning message “QuickBooks Must Close All its Open Windows to Change this Preference”, press “Ok”.
  9. For adding the items to the inventory, open the “Home Page” of QuickBooks.
  10. Click on the icon of “Items & Services”.
  11. In “Item List”, select “Item and press “New”.
  12. From the dropdown of “Type”, select the “Inventory Part”.
  13. In the “Type” window, enter the following information.
    (i) Enter “Item Name” or “Number”.
    (ii) Ensure “Unit of Measure” is left blank, except if you are a user of QuickBooks Premier or an above version.
    (iii) Type “Purchase Information”.
    (iv) Provide “Sales Information”.
    (v) The “Cost of Goods Sold” account will be auto-detected by QB. Then in “Income Account”, provide the income account for tracking the income from the item.
  14. After all the above-required information has been correctly filled in, you can press “Ok”.

Now, this method is complete. We hope you found no complex issues in learning how to set up the inventory in QuickBooks Desktop.

How to Enable Advanced Inventory in QuickBooks?

The users of QuickBooks Desktop Enterprise get the option of subscribing to or purchasing the Advanced Inventory. If you too have access to this feature, you can enable it from the Edit menu. Heading on to the Preferences, you can turn on the option of Inventory and Purchase Orders are Active. Lastly, you can hit the button for the Advanced Inventory Settings.

  1. Begin with opening the “Edit” menu.
  2. Now, you have to choose the “Preferences” option.
  3. From the left, click on “Inventory and Purchase Orders are Active” to select it.
  4. Press the button for the “Advanced Inventory Settings”.

Please Note: In case the button for the “Advanced Inventory Settings” seems to be grayed out despite buying the feature, you can prefer syncing the license data online to enable QuickBooks for recognizing it. To do so, please follow the steps shown below.

  1. Open “Help” in QuickBooks.
  2. Click on “Manage My License”.
  3. Now, tap on “Sync License Data Online”.
  4. Ensure that the “Advanced Inventory Settings” is not grayed out any longer.
  5. Close “QuickBooks”.
  6. Then open “QuickBooks” again.

Once the Advanced Inventory has been enabled, you can go ahead with QuickBooks inventory tracking.

How to Adjust Inventory in QuickBooks Desktop Pro?

Let us now move on to learn how the inventory can be adjusted in QuickBooks Desktop Pro. This can be initiated by checking the Menu Bar for the option of opening the Adjust Quantity window. In this window, you can pick the Adjustment Type. You can also adjust the Total Value and Quantity. In the option of Adjustment account, you can fill in the date of the adjustment. Thereafter, you can add the Reference Number.

For learning the exact steps, Let’s read these 14 steps.

  1. The “Menu Bar” carries the option of “Vendors| Inventory Activities| Adjust Quantity/Value on Hand”. Select it.
  2. The window of “Adjust Quantity/Value on Hand” will open. Click on the dropdown for “Adjustment Type” for choosing the kind of inventory adjustment that has to be made.
  3. The “Quantity” and “Total Value” can be adjusted now.
  4. Provide the adjustment date in the field of “Adjustment Account”.
  5. Click on the dropdown menu for “Adjustment Account”.
  6. In the field of “Reference No.” on the right, provide the reference number of the adjustment.
  7. In case required, you can enter the “Class” or “Customer Job”.
  8. In the “Memo” field, please specify the reason for which the QuickBooks inventory has to be adjusted.
  9. In the first row, choose the column of “Item”.
  10. Using the dropdown list, choose the first item for adjusting.
  11. For making an adjustment of quantity, enter the “New Quantity”/”Quantity Difference” in the column.
  12. In the column of “Quantity Difference”, for mentioning the loss of the items, enter a negative number.
  13. In the column of “New Value”, the new value of the total can be added in case the adjustment has to be made on the total value.
  14. After the inventory has been adjusted, click on “Save & Close”.

How to Turn off Inventory Tracking in QuickBooks?

For any reason, you may wish to disable the inventory tracking in QuickBooks. Turning it off has been explained very well in this part. You can, firstly, visit the Settings and then choose the Account and Settings. From Sales, you can open the Purchase and Services. Next, you can deselect Track Inventory Quantity on Hand and save it.

Please Note: When the inventory tracking has been turned off, the transactions including the purchases and sales which are linked to the inventory items will not be able to affect the on-hand quantity.

  1. Press the “Gear” icon.
  2. The second step is to click on “Account and Settings”.
  3. Now, open the “Sales” tab.
  4. Then visit the section of “Purchase and Services”.
  5. Locate the checkbox for “Track Inventory Quantity on Hand”. Then untick the box for it.
  6. Press the “Save” option.
  7. Then click on “Done”.

Please Note: After above steps have been performed, you can track the price/rate and quantity even now, if you wish to do so. All you have to do is ensure that the box for “Track Quantity and Price/Rate” has been ticked.

How to Turn off Advanced Inventory in QuickBooks?

Each one of you who has opted for the Advanced Inventory feature in QuickBooks, you can turn it off with ease. From the Edit menu, you can pick Preferences. Then you can select the Items & Inventory. From the Company Preferences, you can hit the Advanced Inventory Settings button. Then you can deselect several options as per your preference. And you will be able to turn off the Advanced Inventory in QuickBooks.

  1. The basic step is to click on the “Edit” menu.
  2. Now, pick the “Preferences” option.
  3. The third step is to click on “Items & Inventory”.
  4. Then open the tab of “Company Preferences”.
  5. Press the button for “Advanced Inventory Settings”.
  6. Untick “Multiple Location Inventory”.
  7. From the “Serial”/”Lot Numbers” tab, you can untick “Enable Lot or Serial Numbers”.
  8. In the “FIFO” tab, you can untick the “Enable Barcode Scanning”.

Please Note: When the barcode scanning option has been turned off, the QuickBooks software can still retain each of the barcodes in the company file. On the other hand, if you enable this option once again, the barcodes will appear again in the company file.

  1. Open the window of “Advanced Inventory Settings”.
  2. Then press “Ok”.
  3. Press “Ok” in the “Preferences” window.
  4. When a warning window is seen, press “Ok” once again.

Please Note: For starting the QuickBooks Inventory tracking once again, you can enable the option to do so.

Frequently Asked Questions

In each of the sections above, we attempted our best to give you every piece of information with respect to QuickBooks inventory tracking. In case you still have certain unanswered questions, you can read below.

Q1. Can I track inventory in QuickBooks?

The QBDT versions of this software come with the option of QuickBooks inventory tracking. In case you happen to be a user of QuickBooks Desktop Enterprise, then you will have to get access to the Advanced Inventory and Advanced Pricing features. These features are subscription-based. Using them, you can get help for tracking the inventory in QuickBooks.

Q2. How can I keep a track of what the QuickBooks inventory is selling?

After you have set up the inventory products, you can track what is being sold. For this purpose, you can either make an invoice or opt for adding a cash memo. In case the payment will be received later, you can make an invoice. If the customer has already submitted the payment on the spot, then you can enter a cash memo.

Q3. How can I categorize inventory in QuickBooks?

Learning how to categorize inventory in QuickBooks is not complex at all. For categorizing the inventory in QuickBooks, you can go to the Sales menu and choose the services and products. Then you can pick the service or product that has to be categorized. From the column of Action, you can click on edit and then you will find the Category dropdown. After selecting the Category, you can press Save & Close.

Q4. Does QuickBooks keep track of inventory?

Using the QuickBooks software, you can perform a short procedure to set up your inventory on it. Once the inventory has been turned on and the setting up is complete, you can start tracking it.

Q5. What is the difference between the non-inventory items and inventory items in QuickBooks?

On the balance sheet, the inventory gets tracked like an asset. For as long as the inventory items are not sold, their cost will not be recorded. On the other hand, the non-inventory items are tracked as Cost of Goods Sold. These items get recorded on the statement of profit and loss when they have been purchased.

What is the inventory part in QuickBooks?

In QuickBooks, the inventory part refers to the type of an item. The inventory part can be found in Lists. Here, you can click on the Item List menu. The basic purpose of the inventory part is to show an item which is kept by your firm on hand for selling to the customers.

In Closing

QuickBooks inventory tracking requires you to perform several methods for going ahead with this purpose. From adding the inventory to turning it off, each crucial method was outlined in this blog. Should you need more help with Inventory tracking on QuickBooks, please convey it to us via the comment section.

Meanwhile, here are more important blogs you should prefer reading for your improved knowledge of QuickBooks. Check out how to add an account to QuickBooks in just a tap.