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

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

2 Comments 2
FishingForAnswers
Level 10

Item List

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

FateCandylaneT
QuickBooks Team

Item List

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:

 

  1. Once the Item List report is ready, navigate to the Customize Report option.
  2. Navigate to the Filters tab and enter Item from the Choose Filter section.
  3. Under the Item dropdown, choose a specific product and service.
  4. Then, to modify several items, select the Multiple accounts option, then add all items.

 

Screenshot 2025-05-21 041315.png

 

Once done, select Print from the report's menu options. You may also choose Excel to download the report to a spreadsheet.

 

Screenshot 2025-05-21 041555.png

 

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.

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

Need to get in touch?

Contact us