SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
KathyP1964
Level 4

Item list

I want to export my active item list to excel. When I do export it also sends my inactive items. Is there a way to only export my active items?

Solved
Best answer January 08, 2025

Best Answers
FishingForAnswers
Level 10

Item list

@KathyP1964  Go to the Reports menu.

 

From there, go to the Lists submenu.

 

Then, select the Item Listing report.

 

You can use the Customize Report button in the upper left to filter by active or inactive status, as well as selecting which columns you want to be present.

 

Then, click on the Excel button and Create New Worksheet.

 

If you expect to need this often, I suggest memorizing it once you have it customized to suit your needs.

View solution in original post

5 Comments 5
RhoiceW
QuickBooks Team

Item list

When exporting your item list in QuickBooks Desktop (QBDT), the inactive items will still be included, Kathy. Let me provide you with some workaround to remove the inactive items.

 

I'd recommend manually removing the inactive items on the Excel file since it'll indicate if they are active or not.

 

Here's how:

 

  1. On the menu bar, click Inventory.
  2. Uncheck the box for Include inactive.
  3. Select the Item list. Then, click the dropdown button beside Excel.
  4. Click Export all items, then select Export.
  5. Remove the inactive items manually on the file you've downloaded.

 

Also, you can run a item list report and customize it by only viewing the active items. This way, you can filter the active status of your items and export it to Excel file.

 

Furthermore, you can also edit your item list and delete them if they're no longer needed. Feel free to visit this article: Add, edit, and delete items in QuickBooks Desktop.

 

Additionally, you may refer to this article to learn how to run inventory reports in QBDT: Run reports in QBDT.

 

I'm confident these steps will help you in exporting and removing the inactive items. If you need more concerns and questions, feel free to reply. I'm here to help.

KathyP1964
Level 4

Item list

The box was always unchecked and it still exports the entire list including inactive.

FishingForAnswers
Level 10

Item list

@KathyP1964  Go to the Reports menu.

 

From there, go to the Lists submenu.

 

Then, select the Item Listing report.

 

You can use the Customize Report button in the upper left to filter by active or inactive status, as well as selecting which columns you want to be present.

 

Then, click on the Excel button and Create New Worksheet.

 

If you expect to need this often, I suggest memorizing it once you have it customized to suit your needs.

Kurt_M
QuickBooks Team

Item list

I appreciate you for trying out the recommendation provided by my colleague, @KathyP1964. I'll share a way to help address this situation and have a copy of the item list available outside QuickBooks Desktop (QBDT).

 

You can consider using the Item Listing report and exporting it to an Excel file. This approach provides a more comprehensive overview of the active items in your inventory. I'll write down the steps and provide screenshot below:

 

  1. Access your QuickBooks Desktop company.
  2. Go to the Reports menu and select Report Center.
  3. Select List and then locate Item Listing.
  4. Click on it and then Customize button. You can filter it to show the active items only.
  5. in the Columns, select Active Status and then go to the Filter section.
  6. Select Active Status and toggle the Radio button beside Active.
  7. Once done, click the OK button.

 

For visual reference, see the screenshot below.

 

 

Additionally, check out this article to help you on handling inventory items in QBDT: Add, edit, and delete items in QuickBooks Desktop.

 

To help you overcome any challenges you face while using the program, I invite you to leave a comment below. Your feedback is invaluable, and I’m here to assist you. Take care! 

KathyP1964
Level 4

Item list

Thanks that worked perfectly!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us