Get 50% OFF QuickBooks for 3 months*

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.
pablo_austin
Level 1

Sales by item summary report - units only - no amount, no % of sales, no average price

I want to create a report showing sales by item but units only for specific time periods - monthly for several years.

 

I cannot edit this report to not include "Amount", "% of sales" and "Avg Price"

 

Because I am running this for several years when converting to an excel file I don't want to delete column after column.

 

 

1 Comment 1
RoxanneB
QuickBooks Team

Sales by item summary report - units only - no amount, no % of sales, no average price

Let me help you customize your reports the way you want, Pablo.

 

I can see the importance of generating the sales by item summary specifically showing the units for your business needs. However, the feature you're looking for is currently unavailable in QuickBooks Online. I suggest providing feedback to our product development team so they can review adding this feature in future improvements.

 

Here's how to send feedback:

 

  1. Head to the gear icon.
  2. Under Profile, select Feedback.
  3. Enter your product suggestions.
  4. Click Next to submit.

 

As a workaround, you can pull up Sales by Product/Service Detail for you to be able to customize and remove the columns that you don't need.

 

Here's how:

  1. Navigate to Reports.
  2. In the Find report by name field, look for Sales by Product/Service Detail.
  3. Select the specific period for your report.
  4. Hit Customize, then click Change columns.
  5. Untick the check for the unnecessary details for your report.
  6. Then, Run Report.

 

 Also, I've included an article that shows the complete list of reports in QBO: Reports included in your QuickBooks Online subscription.

 

I'm always here to assist you, especially with pulling up reports in QuickBooks. It's always a pleasure to help. Take care.

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

Need to get in touch?

Contact us