Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowIs there a way to make a report of specific items from my item list. I have a very large item list and I want to only print certain things from it to transfer to an excel spreadsheet.
@KathyP1964 Theoretically, yes.
Within the Item Listing report, you can apply filters to narrow down the Items included in the report.
There are a few dozen filters ranging from 'Includes such and such in the name' to 'Active or Inactive' to manually picking the accounts you want, so if you want specific recommendations on which to use, you may want to describe the data set you want to end up with.
Yes, you can run the Item List report and modify its filter to show specific items from your overall lists, Kathy.
In your QuickBooks Desktop file, go to Reports and select Item List from the List dropdown. Then, refer to these steps for guidance:
Once done, select Print from the report's menu options. You may also choose Excel to download the report to a spreadsheet.
Moreover, you can utilize this guide to help you save all the customizations made on your reports: Create, access, and modify memorized reports.
Reach out to us in the comments below if there's anything else you need assistance with.
Thanks for the replies, I much appreciate them. Unfortunately like I said I have a very large item list and picking each item is going to be long and tedious. When this list was originally set up (before me) they didn't take any consideration to listing properly and all of my items are bunched together. They aren't even in alphabetical order. I guess I will try to sort but that doesn't do anything helpful. Again, thanks for the help.
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