Solved

Item list

5 replies
0 views

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?

QuickBooks Desktop

FishingForAnswersAnswer

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

R

RhoiceW

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:

On the menu bar, click Inventory.
Uncheck the box for Include inactive.
Select the Item list. Then, click the dropdown button beside Excel.
Click Export all items, then select Export.
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.

KathyP1964Author

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