cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Frequent Explorer **

Job Costing Report

Good Day Ya'll, I am still learning; but we have quickbooks desktop priemier for contractor. I am trying to run a report that has everything it costed our company for one specific customer. So i am looking to run a customer report that shows all of the employee hours allocated to that job#, all of the vendor payments that are allocated to that job #. If it can include what we charged the customer for their job and payments recieved that would be great but i dont really need that. I just need to see pretty much what the job costed us per my allocations in the system? I have clicked all of the reports and i am wondering if this is a custom report i need to run or if there is already one and where i can find it or even how i can create it. I have a phone i am located in Las Vegas if anyone thinks speaking would be easier. Thank you for your help in advance. 

Solved
Best answer 10-31-2017

Accepted Solutions
Established Community Backer ***

Re: Job Costing Report

Reports menu > Jobs, Time & Mileage reports. Run Job Profitability Detail for one job. Run Job Profitability Summary, to see all jobs summarized. Run Job Costs reports, under the Reports menu > Contractor reports, such as Job Cost by Job and Vendor; or Job Cost by Vendor and Job. Summary or Detail.

 

Payroll will show, as long as you are Job Tracking payroll.

 

Or, for Hours from Timesheet data, that is Reports menu > Jobs, Time & Mileage, then the "Time By" reports. Such as Time by Job by Item by Name; or Time by Name by Job or Time by Item by Job by Name. Etc. Timesheets do not carry a Cost, of course.

 

If you use Estimates. you can report on Time, as Est vs Actual, for Units. And as Costs, in Est s Actuals. Also, you have Costs to Complete reporting.

8 Comments
Established Community Backer ***

Re: Job Costing Report

Reports menu > Jobs, Time & Mileage reports. Run Job Profitability Detail for one job. Run Job Profitability Summary, to see all jobs summarized. Run Job Costs reports, under the Reports menu > Contractor reports, such as Job Cost by Job and Vendor; or Job Cost by Vendor and Job. Summary or Detail.

 

Payroll will show, as long as you are Job Tracking payroll.

 

Or, for Hours from Timesheet data, that is Reports menu > Jobs, Time & Mileage, then the "Time By" reports. Such as Time by Job by Item by Name; or Time by Name by Job or Time by Item by Job by Name. Etc. Timesheets do not carry a Cost, of course.

 

If you use Estimates. you can report on Time, as Est vs Actual, for Units. And as Costs, in Est s Actuals. Also, you have Costs to Complete reporting.

Established Community Backer ***

Re: Job Costing Report

I have attached a side-by-side example: P&L by Job and Job Profitability Detail, for the Same Job. And a bunch of the other reports.

Job Comparison.JPGEst Vs Actuals Detail.JPGCost to Complete Report Comparison to Est Vs Actuals.JPGJobTrackTime.JPGJobTrackTime.JPGJob Costed PR Expenses.JPGJob Costs by Vendor and Job Detail.JPGEst Vs Act.JPG

Frequent Explorer **

Re: Job Costing Report

I am looking for a report that shows job costs by customer job, yet including my labor. We do job tracking and assign each payroll to a job. However, its not showing on the Job Cost by Vendor and Job Summary report??? 

QuickBooks Team

Re: Job Costing Report

Hi there, @wrboutros,

 

Thank you for joining QuickBooks Community.

 

You can pull up the job costing reports provided by @qbteachmt to see the jobs you tracked for payroll, excluding the Job Cost by Job and Vendor and Job Cost by Vendor and Job Summary/Detail reports.

 

You can also run the Profit and Loss by Job report and double-click the amount tied up to the payroll account to view all paychecks related to the jobs. Here's how:

 

1.    Click the Reports menu.
2.    Scroll down to Job, Time, and Mileage.
3.    Select Profit and Loss by Job.
4.    Set the report period.

 

If you have additional questions about running the reports, let me know and I'm here to help.

 

Not applicable

Re: Job Costing Report

I want to run a report, Job Cost by Job and Vendor Summary and Total Payroll cost. Our payroll is job tracking. However, when I run the report Job Cost by Job and Vendor Summary, the payroll does not show up. In the preferences, job tracking is checked in payroll. Can someone offer a suggestion?

Bill B

Established Community Backer ***

Re: Job Costing Report

Payroll is part of Employees and QB payroll.

 

Vendor Names are on purchases for outside goods and services, which is not payroll.

Not applicable

Re: Job Costing Report

"If you use Estimates. you can report on Time, as Est vs Actual, for Units. And as Costs, in Est s Actuals. Also, you have Costs to Complete reporting."

 

I came across this reply to someone's question.  How do you go about setting up this report in QB desktop?  I'm trying to get a report that will show me estimated hours vs actual hours used on a job.

 

QuickBooks Team

Re: Job Costing Report

Hello there, BSCS Finance.

 

Let me help you pull up the report that shows estimated hours vs. the actual hours used on a job in QuickBooks Desktop.

 

You can pull up the Job Estimates vs. Actual Details report. This shows how your company's estimated cost and revenues for a job and compares them for each of the items you billed.

 

Here's how:

  1. Go to Reports.
  2. Click Jobs, Time & Mileage.
  3. Choose Job Estimates vs. Actual Details.

In addition, you can also customize this report to show other columns and information you wish to include in the report. Check out this article to learn more: Customize reports in QuickBooks Desktop

 

If you have any other questions about QuickBooks reports, be sure to let me know as I'm always here to help.

Need to get in touch?

Contact us