cancel
Showing results for 
Search instead for 
Did you mean: 
kmouris
Level 1

Job Profitability Report

I cannot create a report in QB Online that is similar to the Job Profitability Detail report from QB Desktop. I've been playing around with what QB Online offers and it just doesn't provide the data like the Job Profitability report from QB Desktop. Currently I'm running both online and desktop parallel for the sole purpose of the Job Profitability report and being able to see all my products/services laid out. The work around for the Project Profitability report just gives me a ton of columns (versus rows) that's difficult to navigate. I don't understand how a report that was so easy to run and so useful is now gone with nothing comparable. 

1 Comment 1
KayePe
QuickBooks Team

Job Profitability Report

I understand the importance of being able to view the same transaction details in QuickBooks Desktop (QBDT) when running the Job Profitability report using QuickBooks Online (QBO). I have insights about this.


It's important to note that while both are accounting software that processes data, due to the uniqueness and complexity of QBDT, QBO reports may not pull up the same data. Currently, we are unable to see a project profitability report that shows the products/services used in a project, but we can pull up two different reports. In your case, you can run a Project Profitability summary in QBO to show the customer, revenue, costs, profit, and profit margin of a specific project, and you can run a Sales by Customer Detail report to show the product/service being utilized. To proceed, follow the steps below on how:


Run a Project Profitability Summary
 

  1. In Reports, select Project Profitability Summary.
  2. Filter the date in the Report period.
  3. You may also modify the report in the Customize tab.
  4. After that, hit Run report.

 

project profitability.png

 

Pull up a Sales by Customer Detail
 

  1. From the Reports, choose Sales by Customer Detail.
  2. Filter the date in the Report period.
  3. To Add a filter, click Filter and modify the following filter options then hit Add filter.
  4. To have a copy of the report, hit Save.

 

customer detail rep.png

 

After that, note that you may also export the reports in Excel to consolidate the data from there.

 

On the other hand, take a look at the following articles. This offers valuable insights to effectively manage projects within QBO, enabling you to better streamline your business operations:

 

 

For further inquiries or assistance with running reports in QBO, you can comment below. I'll circle back to help you once again. Keep safe. 

Need to get in touch?

Contact us