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

Job Cost Report with hours

I am looking for a report, by job, similar to the Job Profitability Report or any custom report that will show the labor hours and the cost as well as a breakdown by item type.  In general, a report by job that will show me the hours worked (ST, OT, DT) ultimately the employee with the cost of the labor, as well as all of the the expenses (materials, subcontractors etc.). Has any one created a custom report they would be willing to share?

1 Comment 1
Rasa-LilaM
QuickBooks Team

Job Cost Report with hours

Let me share an alternative method for obtaining job cost hours for your employees, plongstock.

 

We'll have to run the Job Costs Detail and Payroll Summary reports and exports them to Excel. Then, filter and combine the data to get the information you need.

 

To build the Job Costs Detail report:

 

  1. In your company file, head to the Reports menu at the top bar to choose Contributed Reports and then Jobs, Time & Mileage.
  2. Head to the Jobs, Time & Mileage menu on the left panel and select Job Costs Detail.ct.png
  3. Click the Run button to open the report.
  4. Tap the Customize Report to display the Modify Report window.
  5. Go to the Columns section and pick the items you wish to add to the statement. For example, Item, Payroll Item, and Account.
  6. Navigate to the Filters tab. 
  7. Type Name in the Choose Filter box and select All customers/jobs.ct.1.png
  8. Enter Transaction Type and choose Paycheckct2.png
  9. Click OK to apply the changes. 
  10. Next, export the report to Excel.

 

To open the Payroll Summary report:

 

  1. Go to the Reports menu at the top bar select Employees & Payroll and then Payroll Summary.
  2. Click the Dates drop-down and set the correct period.
  3. Tap the Customize Report button to display the Modify Report window.
  4. In the Display tab, type the payroll items you wish to add to the report. For example, Account, Date, Name, and Payroll Itemps.png
  5. Press the OK button for the changes to take effect. 
  6. Then, export it to Excel.

 

This guide covers the basics of personalizing data on employee reports, including how to customize payroll and employee reports: Customize payroll and employee reports. It also includes links to how to run and tailor your financial statements, items, customers, jobs, and sales reports.

 

If you require additional assistance with completing a specific payroll task or other related concerns, feel free to browse our self-help articles. Then, choose the topic from the list. 

 

If you have any further questions about building reports or other payroll concerns, leave a comment below. I'd be delighted to help you. Have a wonderful rest of your day.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us