Skip to main content
B
bedwellelectric
March 11, 2020
Question

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

  • March 11, 2020
  • 4 replies
  • 0 views
Original commenter did not share additional details

    4 replies

    AlexV
    AlexV
    March 11, 2020

    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!

    R
    Rockies
    August 3, 2020

    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!  

      G
      GB60
      August 13, 2020

      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-hand-in-quickbooks-online/00/186407 

       

      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. 

      Fiat Lux - ASIA
      Fiat Lux - ASIA
      March 11, 2020

      @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.

      B
      bclark21
      May 18, 2022

      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.

      M
      mikeK24
      December 21, 2023

      I converted a non inventory item to a inventory item and my COGS when down. What did i change that would change my COGS and how do I go and fix this?  

      JoesemM
      JoesemM
      December 21, 2023

      Hello there, mikeK24.

       

      I'd love to help you achieve your goal, but would you mind sharing more details about it? Like adding a screenshot of your concern? It can help us get on the same page and provide accurate resolution.

       

      I'll wait for your reply, or if you have any other questions, please let us know. We're always here to help.

      Terms & ConditionsAccessibility statement