Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 2

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 October 31, 2017

Best Answers
Level 15

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.

View solution in original post

13 Comments
Level 15

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.

View solution in original post

Level 15

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

Level 2

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??? 

Moderator

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.

 

Level 1

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

Level 15

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.

Level 1

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.

 

Moderator

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.

Level 3

Job Costing Report

@qbteachmt is there any way for you to break this down a little more. I ran the Time by Job and moved all of the hours to the correct job, item, and class, but as you mentioned, I don't have cost, and I am not understanding your explanation. I do not see a contractors reports option.

Is that not payroll? That is what you are saying, Time and Payroll are being separated in this example?

My issue then becomes, I have the revenue side of labor now. Because we are contractors with a set contract amount I am not billing anything, and I set up my estimate to hit an expense as well as sales.

 

I think my brain is fried today. I hope that makes sense. Any help would be greatly appreciated!

You are typically the person who answers my questions whether you know it or not, lol. Thanks for all of the help so far!!

Level 3

Job Costing Report

I need a Job Cost Report showing:

  • ITEMS down the side
  • Columns for MULTIPLE JOBS 

In other words, I have a "CUSTOMER" that is actually a development, with multiple "JOBS" which are actually houses underneath it.

 

I want to be able to run a JOB COST REPORT that includes columns for each JOB [i.e., lot/house] so that I can compare them within the same report rather than having to run a separate piece of paper for each lot/house.

 

Very similar to the PROFIT & LOSS by Job but with ITEMS replacing General Ledger Accounts.

 

Ideas??

 

Thanks so much!!

QuickBooks Team

Job Costing Report

 

Greetings @NumbersNC,

 

Thanks for reaching out to the Community! I’ve done some testing and customizing reports in QuickBooks, and it doesn’t look like there is an option to add the field types in the columns you are looking for. You can play around with customization to see if you can get the data you are looking for. Here’s how:

 

You can customize most reports in QuickBooks Desktop.

  1. Go to the Reports menu
  2. Select Reports Center.
  3. Find and open a report on the list.
  4. Choose Customize Report.

Use the filters and other features available to customize your report. Once you find the settings you like, select Memorize to save the report so you can use it again in the future.

 

I’m here for any additional questions about reports or anything else. Let me know!

Level 1

Job Costing Report

I have  quick  books  online  full version. We are construction  business  and would  to generate  specific  job reports  for its  income  and  expenses  how  can I do  this 

QuickBooks Team

Job Costing Report

Good morning, @Onally! We made it to Friday. :) I'm be happy to go over some options with you for job reports in QuickBooks Online.

  1. While logged in as admin, go to Reports on the left menu.
  2. In the search box type in Customer.
  3. Choose Customer Balance Detail (or try any of the other reports for customers).
  4. Customize the report as needed.

The Customer Balance detail will give you the most information in one report but there are also summary reports that give you an overview. Feel free to check out a few of them to see what best fits what you're looking for.

 

As always, if you have anymore questions, feel free to reply to this post. All of us here in the Community are eager to help!

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us