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

Job Profitability report

Hi,

I do the QuickBooks for a flooring company. We often use the job profitability summary to see if we made money on the job. (comparing expenses vs income) I'm having an issue with the report, that when I customize it for specific dates, the total i see is only for the dates I put in. Then when I double click on it and do Dates "ALL" there are way more expenses popping up. Is there a way to make this total pop up in the main report?

 

Our jobs all have expenses scattered within a few months. I cant run this report with all dates, being then I am seeing jobs that we are long done with. Any job that has an expense in February, I wanna See the total account cost and total account Revenue for that job. Including cost from January and before. 

Can I do that?

 

The problem continues when I export this report to excel. Since If I put in the dates from 2/1/2022 till today, then my excel report will not be accurate, because i wanna see ALL expenses for this job, not only the February expenses.

Please let me know wat I can Do

6 Comments 6
MaryLandT
Moderator

Job Profitability report

Let me help you customize the Job Profitability report to see if you made money on the job, Mayer.

 

You'll have to use two reports so you'll be able to get the information you want. Run the Job Profitability Summary report to view those jobs that are completed depending on the status.

 

You can follow the steps below.

 

  1. Click Reports on the upper menu.
  2. Select Jobs, Time & Mileage, then choose the Job Profitability Summary report.
  3. Click Customize Report.
  4. Go to the Filter tab, then select Paid Status
  5. Click OK.
     

Once done, you can manually pull up the Transaction Detail report to check for dates when the invoice was fully paid. Here's how:

 

  1. Click Reports on the upper menu.
  2. Select Custom Reports, then choose Transaction Detail report.
  3. Under the Display tab, make sure to check the Date option.
  4. Go to Filters, then select the Date.
  5. Click OK.

 

You can also modify the font and style of the report. Check out this link to learn more  about this: Customize reports in QuickBooks Desktop.

 

Let me know if there are other reports you need in QuickBooks. I'll be right here to help manage your Job Profitability report.

Mayer
Level 1

Job Profitability report

Hi,

Thank You, but I don't see this helping me. I want to see the profit and loss for all open Jobs as of February and all jobs completed within February. For that reason, I select the dates. 

Let me explain my problem with pictures: Lets say this job called "17 Besen. It is showing on the report that there where $90 expenses, and no revenue.Profitability Summary.jpg

 

This is not accurate. If I double click on the $90 it takes me to a job actual cost. When I do the dates ALL it shows me my total cost is $2,817.88.17 Besen Actual Cost.PNG

 

All of these costs (-$90) happened before February) But I still wanted to see it in the main profit and Loss. Why Should I see that this Job Costed $90 when this is not accurate? 

(The Same is with the revenue. It is showing 00 but in reality I received a payment before February for this job.)

LieraMarie_A
QuickBooks Team

Job Profitability report

Hi there, @Mayer. Let me share some information about running job reports in a specific period.

 

Based on your second screenshot, most transactions happened before the custom period. When running a Job Profitability report, it shows all the transactions within the specified date. Make sure to select ALL to see all of them.

 

You'll want to set a job status for each job. Doing this allows you to filter the report to display ongoing jobs only.

 

Here's how:

  1. Go to the Customers menu and select Customer Center.
  2. Right-click on the job's name and select Edit Customer:Job.
  3. Choose Job info.
  4. Select a job status. You can choose In progress or Closed for ongoing and finished jobs, respectively.
  5. Click OK.

 

Once done, run the Job Profitability Summary report again. Then, customize the report to show ongoing jobs.

 

Here's how:

  1. Click Reports on the upper menu.
  2. Select Jobs, Time & Mileage, then choose the Job Profitability Summary report.
  3. Click Customize Report.
  4. Go to the Filter tab, enter and select Job Status from the list of filters.
  5. Choose In Progress from the Job Status dropdown list.
  6. Click OK.
  7. You can also save this report by clicking the Memorize button.

 

There are a lot more ways to get your desired report. You can check out this article to learn more: Customize reports in QuickBooks Desktop.

 

Come back and leave a comment below if you need more help with running reports. The Community is always here to help.

Mayer
Level 1

Job Profitability report

This is a solution, but there is tons of manual work involved. For a company doing floors and has a few hundred jobs its nearly impossible to constantly keep on updating the status (and If I start now, then its more work on all the old jobs). Is there a way QuickBooks could do it automatically?  When an Invoice is fully paid, can it be considered a closed job automatically? When there is no invoice, only an estimate can it be considered open? and when there is an open and not paid/not fully paid invoice, can it be automatically as "In Progress"?

ZackE
Moderator

Job Profitability report

Thanks for following up with the Community, Mayer.
 

I can certainly understand how an ability for invoices/estimates to automatically update job statuses based on their status could be useful and have submitted a suggestion about it as of today.
 

You can also submit your own feature requests while using QuickBooks.
 

Here's how:

  1. In your top menu bar, go to Help, Send Feedback Online, then Product Suggestion....
  2. Choose a Type of Feedback and Product Area (optional) from the available drop-down menus.
  3. Enter any suggestions/feedback in your Here is my suggestion: field.
  4. If you'd like, include your name/email in the My name is: (optional) and My e-mail address is: (optional) fields.
  5. Select Send Feedback.


Your feedback's definitely valuable to Intuit. It will be reviewed by our Product Development team and considered in future updates. You can stay up-to-date with the latest news about your product by reviewing Intuit's Product Updates webpage.
 

Please feel welcome to send a reply if there's any additional questions. Have a great day!

Boatmagic
Level 1

Job Profitability report

I have the same issue in QB2010. Act. Costs is always 0.

Even if I add an item from my items list into an invoice with a purchase costs etc., it will still always show 0 in the report and does this on every customer I've had since 2010.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us