- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Reports and accounting
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Reports and accounting
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Reports and accounting
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???
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Reports and accounting
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Reports and accounting
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
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Reports and accounting
Payroll is part of Employees and QB payroll.
Vendor Names are on purchases for outside goods and services, which is not payroll.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Reports and accounting
"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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Reports and accounting
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:
- 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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Reports and accounting
@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!!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Reports and accounting
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!!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Reports and accounting
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.
- Go to the Reports menu
- Select Reports Center.
- Find and open a report on the list.
- 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!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Reports and accounting
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
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Reports and accounting
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.
- While logged in as admin, go to Reports on the left menu.
- In the search box type in Customer.
- Choose Customer Balance Detail (or try any of the other reports for customers).
- 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!