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! Go to Solution.
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.
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.
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???
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.
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?
"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.
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.
- Go to Reports.
- Click Jobs, Time & Mileage.
- 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.