Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27
Buy nowI 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! Go to Solution.
@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.
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:
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.
The box was always unchecked and it still exports the entire list including inactive.
@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.
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:
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!
Thanks that worked perfectly!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here