Skip to main content
November 27, 2023
Question

How can I create a report (sales by product/service) that includes our labor costs under each service item?

  • November 27, 2023
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

November 27, 2023

Welcome to the Community, @sharonm. We are glad to have you here!

 

Let me guide you in creating a report that includes your labor costs under each service item. Since labor costs aren't included in the Sales by Product/Service Detail Report, comparing it to Product/Item Profitability by Customer will show the cost of the item/services you need. 

 

Furthermore, if this relates to projects, we can search for the Project Profitability Report since it compares actual project revenue and costs to show each project's total profitability. To pull up this account, here's how: 

 

  1. Go to Projects. 
  2. Open an existing Projects.
  3. After opening, choose Project Reports.
  4. Hit View to view the report.

 

By following the steps mentioned above, we can witness the labor costs we need.

 

You can also check this article if you want more information on how to use projects: Track hourly labor costs and profitability by project in QuickBooks Online.

 

I'm all ears if you need help in creating reports in QBO. We're just one reply away. 

November 29, 2023

Thank you for the response.  The Project Profitability Report just gives me a total for costs of goods sold and labor.  How do I find the Product/Item Profitability by Customer report, or do I customize another report to get it?

November 29, 2023

Good to see you back, sharonm6677.

 

The Project Profitability and Product/Item Profitability by Customer reports are different. To find the Product/Item Profitability by Customer report, you can search it from the Reports page. Let me guide you through the steps.

 

  1. Click the Reports from the left menu.
  2. Search for Product/Item Profitability by Customer report.
  3. Customize it to view the information you need.

 

Just in case you want to save its current customization settings, you can check out this article for more guidance: Memorize reports in QuickBooks Online.

 

Come back to this post if you have other concerns or follow-up questions about running reports in QuickBooks Online. I'll be around to help.