Skip to main content
J
j.vonstetten
February 28, 2024
Question

HOW CAN I SORT BY QUANTITY

  • February 28, 2024
  • 1 reply
  • 0 views
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 reply

I
Ivan_G
February 28, 2024

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:

 

 

 

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.

Terms & ConditionsAccessibility statement