cancel
Showing results for 
Search instead for 
Did you mean: 
j.vonstetten
Level 3

HOW CAN I SORT BY QUANTITY

How can I sort by quantity on Sales by Product/Service Summary? 
I need it to show best to least seller by quantity and nothing I do will work. 
I've even tried to export it and do it manually on an excel sheet and I can't do it on that either because of an error about merged cells. Nothing works. 

Any Suggestions?
1 Comment 1
Ivan_G
QuickBooks Team

HOW CAN I SORT BY QUANTITY

Hello there, j.von. Allow me to provide you with some information on how the Product/Service Summary Report works.

 

The Product/Service Summary Report provides a sales percentage column that we can use to determine the best-selling item/product.

 

This said, we can tick the Total in descending order on the Sort by ▼ of the Product/Service Summary Report page to sort them from best to least. You can check the screenshot below for your visual reference:

 

Sales by product service ss.png

 

 

However, sorting it from the best to least-selling item by quantity isn't an option. Thus, I recommend sending feedback directly to our engineering team so they can consider adding this feature in future updates.

 

Here's How:

 

  1. Log in with your QuickBooks Online (QBO) account.
  2. On the Gear Icon (), click Feedback.
  3. Enter your product comments and suggestions, then select Next to submit.

 

Furthermore, you can still consider exporting your report from QuickBooks to Excel. Then, manually sort the items accurately. You can reach out to the Excel support team or someone who can assist you in sorting the items in Excel.

 

In addition, you may also review this article to learn more about how to personalize your reports in QuickBooks: Customize reports in QuickBooks Online.

 

Feel free to reply to this thread should you need further assistance with your sales reports in QuickBooks. We'll be here to lend a hand.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us