cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
Hesham73
Level 1

Why COS values for non-inventory items not showing in SALES BY PRODUCT/SERVICE SUMMARY Report?

Why COS values for non-inventory items not showing in SALES BY PRODUCT/SERVICE SUMMARY Report?

5 Comments 5
GebelAlainaM
QuickBooks Team

Why COS values for non-inventory items not showing in SALES BY PRODUCT/SERVICE SUMMARY Report?

It's nice to see you here in the Community space, @Hesham73. I can provide information that will clarify things for you and help you resolve your concern.

The Sales by Product or Service Summary report displays the total sales, quantity, amount, percentage (%) of sales, and average price of your product or service.

I recommend you pull up the Purchases by Product/Service Detail report instead to view the cost.

Here's how:
 

  1. Go to the Reports menu.
  2. Type Product/Service Detail in the search box, then enter. You can also browse in the Expenses and vendors list.
  3. Customise the Report period and click on Run report
     

If you want to learn more about customising reports in QuickBooks Online, you can click here.

I've also added this article for your future reference on how to use inventory in QuickBooks Online: Set Up And Track Your Inventory.

Please keep me posted if you need any further assistance with managing your inventory and how to pull up different types of reports for your business. I'll get back to you as soon as possible. Have a good one!

Hesham73
Level 1

Why COS values for non-inventory items not showing in SALES BY PRODUCT/SERVICE SUMMARY Report?

I need a report that show COS for non-inventory items in summary? is it available or not?

 if not how I supposed to get the COS for non-inventory items?  

LeizylM
QuickBooks Team

Why COS values for non-inventory items not showing in SALES BY PRODUCT/SERVICE SUMMARY Report?

Thanks for getting back to us, Hesham73. 

 

Allow me to share additional information on how to show the non-inventory item in QuickBooks Online. 

 

To achieve this task, you'll have to run the Purchases by Product/Service Detail report.  Set your desired date in the Report period field and filter to non-inventory item. This way, you'll be able to pull up the information you're looking for in your report. 

 

Here's how:

 

  1. Go to the Reports menu.
  2. Type Product/Service Detail in the search box, then enter. You can also browse in the Expenses and vendors list.
  3. Customise the Report period and filter to the non-inventory item.
  4. Once done, click on Run reportCapture.PNG

 

Aside from the Purchases by Product/Service Detail report, you can pull up the Product/Service List report. 1.PNGYou'll also want to get a personalized format for your reports. Feel free to customize it in QuickBooks Online. This article will give you details on how: How to customize reports in QBO?.

 

Fill me in if you have more queries about running your reports in QBO. I'd be glad to assist you further. Take care always 

Hesham73
Level 1

Why COS values for non-inventory items not showing in SALES BY PRODUCT/SERVICE SUMMARY Report?

Thank you guys for your help so far.

Unfortunately, I did not get what I need, Lets make it very simple

 

Your suggested solution is not practical when have hundreds of items. It should be one report shows the sales and COS for non-inventory and services in ONE REPORT

 


 

I need a report shows my sales and COS/Purchase

for

  1. non-inventory items
  2. Service Items

in ONE REPORT ? do you have it or not? 

MadelynC
Moderator

Why COS values for non-inventory items not showing in SALES BY PRODUCT/SERVICE SUMMARY Report?

I recognize how convenient it is to have your sales and COS details in just one report, @Hesham73. Let me provide some information to obtain this.

 

At the moment, you’ll want to generate more than one report to see the sales and Cost of Sales (COS) or purchase of your items. You may consider using a third-party app to get these details in a single report.

 

If you have the Apps menu in your QuickBooks Online account, you can look for a tool from there. Here’s how:

 

  1. Open your QuickBooks account.
  2. Go to your Apps menu.
  3. Enter a keyword on the Search field, then select the app.
  4. You can click the Overview, Pricing, Reviews, and FAQs to view the details.
  5. Select Get app now.
    Capture.PNG

 

I’ve attached a reference in case you want to keep the same report settings for future use: Memorise reports in QuickBooks Online. It helps you access the information quickly to save time.

 

If you have any other questions or concerns about reports, please don’t hesitate to reach out. The Community is always here to help.