cancel
Showing results for 
Search instead for 
Did you mean: 
bedwellelectric
Level 1

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

 
26 Comments 26
AlexV
QuickBooks Team

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Let me assist you in handling your items, bedwellelectric.

 

In QuickBooks Online, we're unable to change the Inventory items to a different item type. We can only change the Service and Non-inventory items from one type to another.

 

What I can suggest is to sell all the remaining inventory items. Once your quantity on hand is zero, you can make them inactive. Then, let's create another items but this time, let's set them up as non-inventory. Let's pull up first the Inventory Valuation Summary and make sure that the amount under QTY column is zero. This helps us determine which of the items has zero quantity

 

Once done, let's go to your product list so we can remove them. You can follow these steps:

  1. Go to the Sales tab and select Products and Services.
  2. Locate the item and click the drop-down arrow beside Edit.
  3. Select Make inactive, then Yes to confirm. 

Then, simply click the New button and select Non-inventory if you want to create a non-inventory already. You can also read this article for more details: Add product and service items to QuickBooks Online.

 

Please keep on posting if you need more guidance with this. Wishing you all the best!

Fiat Lux - ASIA
Level 15

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

@bedwellelectric 

Explore a 3rd party importer tool to modify it

https://transactionpro.grsm.io/qbo

 

The template should be like this

NameTypeUnitPriceSKUQtyOnHandInvStartDateInvAssetAccountSalesDescriptionTaxablePurchaseDescriptionPurchaseCostIncomeAccountExpenseAccount
Gift CertificateNonInventory25    $50 Gift CertificateY$50 Gift Certificate15Product SalesPurchases
Music TitlesNonInventory20    Artist CDsYArtist CDs12.5Product SalesPurchases
HandheldsNonInventory100    Portable Game PlayerYPortable Game Player50Product SalesPurchases
SoftwareService59.95    1 Year WarrantyY1 Year Warranty32.5Product SalesPurchases

 

Hope it helps.

Rockies
Level 2

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Hello!  I have hundreds of items I have set up as inventory items.  Technically, the inventory levels are negative...because we did not use this feature as we originally intended.    

 

Do I need to re-set up all of these accounts?  Is there a more efficient way?  Thank you!  

GB60
Level 1

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Rockies,

 

The short answer is, "NO." If you still want to track inventory in QBO, you will need to enter an ajdustment for each item according to your actual physical inventory levels. The process is laid out here: https://quickbooks.intuit.com/learn-support/en-us/inventory-quantity/adjust-inventory-quantity-on-ha... 

 

If you want to stop tracking your inventory, you can turn off that feature by following these steps:

 

  1. Go to the Gear icon.
  2. Under Your Company, select Accounts and Settings.
  3. Click Sales.
  4. Go to Products and services.
  5. Find Track inventory quantity on hand and slide the switch to the left (gray).
  6. Click Save and then Done.

If you turn off inventory tracking, you will lose some report functionality. 

ZeirnaV
Level 1

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Can we change this? I have items that i used to carry in stock but due to supply and demand I have had to change things in my ware house. Not that I can not receive the items, they just changed to special order vs inventory. I would have to re input 50 items if I follow your suggestion. 

MJoy_D
Moderator

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Let me show you how to update your inventory items, @ZeirnaV.

 

Yes, you can enter an inventory quantity adjustment without recording a purchase or sale to match what you have in stock.

 

This feature is available if you're subscribed to either QuickBooks Online Plus or Advanced.

 

You can follow the steps below on how to add an inventory quantity adjustment:

  1. Go to the + New button and tap Inventory Qty Adjustmentinv1.JPG
  2. On the Inventory Quantity Adjustment page that appears, set the Adjustment Date.
  3. Proceed to the Inventory adjustment account drop-down and select the appropriate account.
  4. Enter the products in the Product field drop-down. 
  5. Provide a new quantity or a change in quantity.
  6. Click Save and close once you're done. inv2.JPG

Here's the adjust inventory quantity on hand in QuickBooks Online article for more information. 

 

Also, here’s more information on how to enter product and service items you buy and sell: Add product and service items to QuickBooks Online.

 

I'm always here if you have follow-up questions about inventory management. Take care and have a wonderful day!

Rockies
Level 2

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Thank you for the assistance.  However, I am asking how to change the classification of an inventory item to a non inventory item.  Is there a way to accomplish this? Would like to do in a batch if possible.  I have over 2k of items.  I no longer wish to use the inventory feature.

 

Thank you!

Jovychris_A
Moderator

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Thanks for your prompt response, @Rockies.

 

Currently, we're unable to change the classification of an inventory item to a non-inventory type by batch in QuickBooks Online.

 

However, we can change non-inventory and service items by batch to another item type. I know accomplishing this by batch will make it more convenient to change the types of products/services. I'm taking note of this one.

 

In the meantime, in changing the classification of the inventory type item, you'll have to do it one at a time by making a quantity adjustment to zero it out. I also suggest consulting your accountant in adjusting the inventory items for professional advice. Then make the items inactive and create a new non-inventory to replace it.

 

I'll add this article as your reference for the detailed steps in changing inventory items to non-inventory type: Change product and service item types in QuickBooks Online. It includes the steps on how to account for the adjusted inventory using a journal entry.

 

Feel free to add a comment below if you have more questions about managing products and services in QuickBooks. I'm always here to help. Stay safe and well!

NStorrs
Level 1

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

If I adjust the quantity like this will those Items that I purchased as Inventory Items then report to my P&L Sheet as expenses? As I understand it, inventory items don't report to the P&L until they are sold. 

IamjuViel
QuickBooks Team

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Hello there, @NStorrs.

 

I'm here to share with you the impact of updating the inventory items' quantity to your Profit and Loss report.

 

The change in your inventory items or any adjustments on it is a component in the calculation of your Cost of Goods Sold. This is reported in your company's Profit and Loss report.  Just a heads-up, an increase in inventory will be subtracted from a company's purchases of goods. However, a decrease in inventory will be added to a company's purchase of goods to arrive at the cost of goods sold. You can read through this article for more insights: Adjust inventory quantity on hand in QuickBooks Online.

 

Also, I'd recommend consulting with an accountant when making the necessary adjustments in your inventory entries. This way, you can make sure that it is properly recorded. 

 

Let me know if you have other questions about managing your inventory items. I'm always here to help.

courtajohns
Level 1

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

I messed up an accidently added products as inventory when we actually make everything to order. 
How can I zero out the inventory and help get my books balanced

Jen_D
Moderator

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Thanks for joining this discussion, @courtajohns,

 

Allow me to join and share some insights on how to resolve this item concern.

 

At the moment, the option to change inventory to other item type is unavailable. Since you're not going to track stocks, you can create a new item for the products.

 

  1. To do that, tap the Gear icon the choose Products and Services.
  2. Click New then pick the type you want to use moving forward.
  3. Fill out all the information about the item then press Save and close.

 

Then, you can replace the items on the sales transactions with the new item one by one. Here's how:

 

  1. Go to the Gear icon again then Products and Services.
  2. Find the inventory item then head to the Action column.
  3. Tap the drop-down beside Edit then pick Run report.
  4. All the entries related to the inventory are displayed on the report.
  5. Click the entry to open, then change the item manually with the new one.
  6. Make sure the amount is correct before saving.

 

Once everything is cleared, you can make an inventory adjustment to zero out the inventory quantity. This article will help you with the steps: Adjust inventory quantity on hand in QuickBooks Online

 

You can also make it inactive to remove it from the list of products. Just go to the Products and Services page then select Make inactive in the Action column.

 

Let me know if you have any questions or concerns with QuickBooks. I'll be right here to help you. Have a nice day!

Quihgley
Level 1

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

I tried to just turn of tracking functionality, and QB still prompted me to change the quantity on hand to 0 and make the items inactive.  I have 400+ items, and I'm absolutely trying to avoid having to do all that manual data entry all over again.

SarahannC
Moderator

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Hello there, Quihgley. Looks like you've got an error the same with the screenshot below.

 

The message appears when you're trying to disable the Track inventory quantity on hand feature and haven't adjusted the quantity on hand of the inventory items 0 in QuickBooks Online. hyhy.PNG

 

What we can do is to generate the inventory items details including the Qty on hand and other information needed and download the inventory lists. This helps you work smooth and easier. Here's how:

 

  1. Go to Sales on the left panel.
  2. In the Product and Services tab, click the Funnel icon.
  3. Then, select Inventory. 
  4. Click Apply.
  5. If you don't see the Qty column, go to the small Gear icon. Then, tick the Qty option.
  6. Then, you can export it to Excel. Click the Download icon next to the Print icon.

 

Once you have all the inventory items, you can now utilize the Inventory Qty Adjustment feature. Then, enter them manually. Note: QuickBooks will automatically show the items once you start typing the name of items. 

 

  1. Go to the + New button.
  2. Select Inventory Qty Adjustment
  3. On the Inventory Quantity Adjustment page that appears, set the Adjustment Date.
  4. Proceed to the Inventory adjustment account drop-down and select the appropriate account.
  5. Enter the products in the Product field drop-down. 
  6. Provide a new quantity or a change in quantity.
  7. Click Save and close once you're done. 

 

Afterward, go back to the Product and Services tab and make them inactive.

 

  1. Still, within the Product and Services tab, click the Funnel icon.
  2. Then, select Inventory.
  3. Under the Action column, click the drop-down arrow.
  4. Select Make inactive.

 

You can then turn off the tracking functionality in the settings without getting an error. In you free time, you can check about managing items in QuickBooks Online

 

Let me know if you have other questions. I'll help you in any way that I can. Take care always.

Quihgley
Level 1

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Unfortunately, this isn't helpful because what is being overlooked here is that NO ONE wants to have to inactivate a product listing in order to stop inventory tracking.

 

Can you respond to that specifically?

MarsStephanieL
QuickBooks Team

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Hi there, @Quihgley. I understand that you want to disable the inventory tracking feature in QuickBooks Online. However, the only way to disable it is to make the inventory to 0 and make the items inactive.

 

I suggest passing this feedback to our Product Developers through the QuickBooks Online platform. They will assess it and may include this idea in future product enhancements. To do that, you can go to Settings and select Feedback under the Profile column. This is what it looks like:

 

 

Furthermore, you can visit our blog site to see the recent software updates: The QuickBooks Blog.

 

Please know we strive to better our products through each update. Let me know if you have additional questions or concerns. I'll be here to help you every step of the way. Take care.

ira1
Level 2

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Has this basic feature been addressed by Quickbooks yet? It is utterly insane that inventory items can't be changed to non-inventory items...

SarahannC
Moderator

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Hello there, ira1.

 

We're not given any time as to when this feature request will be added. At this time, the functionality to change the inventory type of item to another option isn't available yet. I'd still recommend sending feedback or forwarding this request to our product engineers. This might be considered for future updates.

 

Still, click the Gear icon and choose FeedbackIn the meantime, you may want to look for a third-party application that can help change the inventory type of the item within QBO.

 

I appreciate your time today. Please don’t hesitate to reach out to the Community if you have other questions about products/services or other QuickBooks concerns. Stay safe, ira1.

bclark21
Level 3

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

I found a work around:

1. Change the COST of all inventory items to $0. (Products & Services- Filter by type=inventory - edit cost to $0) 

2. THEN, make the inventory adjust to get all quantities to zero. (Products & Services - Filter by Type=inventory - check all boxes on page, change all to zero, date as 12/31/20xx and save)

3. THEN disable inventory tracking.

 

Still takes forever, but better than editing every single invoice the items appear on or making each item inactive and re-adding. 

 

EDIT: Nevermind. You still have to inactivate each item before you can disable inventory tracking. But at least this was it can be done without messing up your books.

AccountQs
Level 1

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Do you know when we can change inventory to non-inventory items?  We have been doing business for five months and I have five months of service items that need to be changed.  I cannot just inactivate and create new.  Our profits are not being calculated correctly.

BhamPro
Level 2

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

The only "quick" work around I found is the following:

1. Go to products and services. Filter by type "Inventory". Download your inventory list, change all of the Type column from "Inventory" to "Noninventory" (one word), deleting quantity from Quantity On hand, Inventory Asset and Quantity as-of date columns. Save spreadsheet as .xlsx or .csv

2. Go back to inventory in QBO and make all items that you are moving to non-inventory to inactive. This can be done as a batch action by selecting all check boxes then the batch actions box will appear.

3. Follow product upload procedures from here: https://quickbooks.intuit.com/learn-support/en-us/help-article/list-management/import-products-servi...

DO NOT SELECT the "track" checkbox when uploading - that will put them into inventory.

4. All items that were marked inactive should be re-uploaded as non-inventory with the same costs/price/SKU

Locklearm
Level 3

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Thank you BhamPro

 

Question, I am not following step #4.  Can you elaborate?

 

Also, it would seem the new NONinventory items would need a distinctive name difference? 

BhamPro
Level 2

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

As long as you make the inventory items inactive before you re-upload as non-inventory, you shouldn’t need a name change.

 

Also Id like to note that QBO appears to have corrected the issue where the column for non-inventory will now recognize the -in the word without having to rename to “noninventory”.

Locklearm
Level 3

Can I change inventory items to non inventory items with quickbooks online? I do not want to use inventory anymore.

Okay, I just tried this and changed all the items to noninventory. I went to do the upload and it converted the columns to Inventory!! I made sure there was no asset account (no data in the column)

 

I called support and got someone who told me I can't export inventory items. I told her to have a nice day. LOL

 

Let me know if you have any other thoughts.  My client has almost 1,000 items.

 

Need to get in touch?

Contact us