Skip to main content
C
Cellist
February 3, 2019
Question

"Sales by Product Service/Detail" gives me number of each item sold. With over different 200 inventory items, is there any way to get a grand total of all items sold?

  • February 3, 2019
  • 3 replies
  • 0 views
I am looking for a report of all of my items sold within a year without having to manually total up sales of each item to get a grand total from the "Sales by Product Service/Detail" report. Is there any way to get this?

3 replies

Rustler
Rustler
February 3, 2019

export to excel and have excel total the column

C
CellistAuthor
February 4, 2019

Yes, I tried that originally but the column in the Excel spreadsheet included all the subtotals from each individual item so I wasn't able to make that work. 

 

Item 1: 2

             2

_________

            4

Item 2: 3

              2

________

            5

 

etc.

 

 

 

 

Angelyn_T
Angelyn_T
February 4, 2019

Hi there, @Cellist.

 

Thank you for getting back to us here in the Community. Allow me to join the thread and help share additional information about running/opening reports in QuickBooks Online (QBO).

 

Yes, Rustler is correct, you can export the report to Excel and get the grand total of all the items sold from there. To add the items, you need to select the range of the cells you wanted to include instead of summing up the whole column.

 

However, if you need further assistance with the process, you may get in touch with our QuickBooks Support. For the support's contact information:

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose QuickBooks Online.
  3. On the Contact Us page, click a topic.
  4. Click on the Get Phone Number button to see the support number.

Let me know if you have any other questions by adding a comment below, I'm always here to help. Have a good day ahead!

K
KhimG
February 4, 2019

Hello, @Cellist.


Allow me to join the conversation and share a few details about the report. 


You don’t have to select a range of cells to get the grand total of all items sold. It should be available at the bottom of the Sales by Product Service/Detail Report.


I’m including a screenshot of where it should be after exporting it to Excel.

 


That should do it. Please let me know if you need anything else. I’ll be more than happy to help. Have a good one!

F
feelingsmitten
December 26, 2019

When you have over 200 SKUS and need this info this still does not work.  QB says the date range is too long for one month. 

D
durridge
April 29, 2020

How to run this report and only see the Totals not each item?

Re: "Sales by Product Service/Summary"

MariaSoledadG
MariaSoledadG
April 29, 2020

Hi, durridge

 


As mentioned by KhimG, you'll be able to see the grand total of the items at the bottom of the report. Let me guide you with the steps.

  1. Click Reports on the left menu.
  2. In the search bar, type Sales by Product/Service Detail.
  3. Under the QTY column, go at the bottom part to see the grand total of the item. 
     

For future reference, you can customize your report on how you want it to show. Please check this article for the detailed steps: Customize Reports In QuickBooks Online.

M
mike141113
May 15, 2020

What version of QuickBooks do you need to have for this report to show? When I search for that report, it is not coming up. I am trying to run a report that will give me totals based on line item dates in each invoice, not just the totals based on the invoice date.

 

Terms & ConditionsAccessibility statement