cancel
Showing results for 
Search instead for 
Did you mean: 
LaterWhen
Level 3

Remove % and Average from Sales by Product/Service Summary Report

I would like to get a Sales by Product/Service Summary report without the "% of Sales" and "Avg Price" columns.  I don't need this data and while it is tolerable when only reporting the total for a period, it creates quite a mess when reporting by month over a period of time. I just want to know the total sales of each product by month.  Even the "Quantity" isn't really needed for my purposes. 

Solved
Best answer April 05, 2022

Best Answers
AlexV
QuickBooks Team

Remove % and Average from Sales by Product/Service Summary Report

Good day, LaterWhen!


I understand that you don't need the other columns in the Sales by Product/Service Summary report. Allow me to help you in removing them.


Although we can customize the reports in QuickBooks Online, there are others that have default columns and we're unable to remove them. One of them is the Sales by Product/Service Summary report.


What you'll want to do is export the report to an Excel file. From there, you can remove the % OF SALES, AVG PRICE, and QUANTITY. Simply click the Export button next to Print, and select Export to Excel.


I included this article if you need detailed steps on how to run, customize, save reports, and learn more about report features: Run reports in QuickBooks Online.


I'd like to help you out again if you have more questions about financial reports. If you have something else to do in QuickBooks, let me know and I'll lend a hand. 

View solution in original post

2 Comments 2
AlexV
QuickBooks Team

Remove % and Average from Sales by Product/Service Summary Report

Good day, LaterWhen!


I understand that you don't need the other columns in the Sales by Product/Service Summary report. Allow me to help you in removing them.


Although we can customize the reports in QuickBooks Online, there are others that have default columns and we're unable to remove them. One of them is the Sales by Product/Service Summary report.


What you'll want to do is export the report to an Excel file. From there, you can remove the % OF SALES, AVG PRICE, and QUANTITY. Simply click the Export button next to Print, and select Export to Excel.


I included this article if you need detailed steps on how to run, customize, save reports, and learn more about report features: Run reports in QuickBooks Online.


I'd like to help you out again if you have more questions about financial reports. If you have something else to do in QuickBooks, let me know and I'll lend a hand. 

LaterWhen
Level 3

Remove % and Average from Sales by Product/Service Summary Report

Sadly - I knew that would be the answer.  

 

Thank you. 

Need to get in touch?

Contact us