Get 50% OFF QuickBooks for 3 months*
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
SondraF
Level 2

SALES REPORT

Is there a way (in QBO) to run a sales report that does NOT include the product/service detail.  I need sales reports that include only the total invoiced amount - not broken out by all the products and services included in the invoice.

 

Thanks!

5 Comments 5
Shania_C
QuickBooks Team

SALES REPORT

Thank you for reaching out to the Community, @SondraF. I'm here to give you steps to generate a sales report that only includes the total invoiced amount without the product/service details.

 

Step 1: Run a report.

 

  1. Go to Reports.
  2. Find and open the specific Sales Report you want to access.
  3. Select Customize 

This opens the customization window.

 

Step 2: Customize a report.

 

You can apply multiple filters to customize your report. Most reports have the same set of filters. Some filters are only available on certain reports.

  1. Rows/Columns section: Choose which rows and columns appear on the report.
  2. Select Change columns.
  3. After that, check only the box that states amount and uncheck the Product/Service.
  4. Then, Run Report.
  5. Save custom report.

Once you have the perfect set of filters, save them so you can run the same report in the future.

  1. After you customize a report, select Save Customization.
  2. Give your report a name.
  3. Select Save.

 

For more details, please see this article, Customize Report in QuickBooks Online.

 

Additionally, I will share some resources to help you get the necessary details from your reports: 

 

 

Feel free to reach out if you have further questions or concerns regarding your Sales Report. Have a great day and Keep Safe!

SondraF
Level 2

SALES REPORT

Unfortunately, this did not work.

Clark_B
QuickBooks Team

SALES REPORT

Hello there, @SondraF.

 

Allow me to chime in and clarify the steps given by my colleague regarding how to run a sales report without a product/service in QuickBooks Online (QBO).

 

To generate a report of the total invoiced amount, start by using the Sales by Customer Detail. To filter the report and show only the invoice details, customize it by filtering the date and setting the transaction type to "Invoice" only.

 

Here's how:

 

  1. Go to the left navigation panel, and select Reports.
  2. Type Sales by Customer Detail, and click it.
  3. Click the Customize beside the Save customization.
  4. Click the drop-down button under the Report period, and Filter the date.
  5. Select the Rows/Columns, and uncheck the Product/Service
  6. Select the Filter, and click the drop-down button of the Transaction Type section.
  7. Type Invoice, and click Run Report.

 

In addition, you can reorder the columns by clicking the Gear Icon of the reports.

 

I will also include a helpful article that guides you in memorizing reports: Memorize reports in QuickBooks Online.

 

Please feel free to leave a comment below if you have further concerns about running sales reports or other QBO-related issues. I'll be here to assist you.

SondraF
Level 2

SALES REPORT

@Clark_B  Thank you, that worked.  However, it took me some time to figure out that I must switch to "classic view" to find the "Customize" button.

MorganB
Content Leader

SALES REPORT

So glad to hear this worked for you, SondraF.

 

You know where to come if you ever need a hand again in the future. Take care!

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

Need to get in touch?

Contact us