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

Payroll Report by Job

Is there a way to pull up a payroll summary report but have it be specific to one job if I use job tracking? I work for a contractor who would like to see payroll per employee for a specific job and see it in the format as a regular total payroll report. 

2 Comments 2
Mark_R
QuickBooks Team

Payroll Report by Job

Hi there, @MMajor.

 

At this time, there isn't a specific payroll report that includes jobs. As an alternative, you can run two different reports and export them to Excel. Then, combine them in one Excel file. 

 

Firstly, let's run the Payroll Summary report by going to the Reports menu and selecting Employees and Payroll. Then, export it to Excel. Here's how:

 

  1. On the report, click the Excel drop-down.
  2. Select Create new worksheet.
  3. Choose the in new workbook option, then click Export.

 

Once done, you can run and export the Job Profitability Detail report for your job. Let me guide you how.

 

  1. Go to the Reports menu, then select Jobs, Time & Mileage.
  2. Choose the Job Profitability Detail report.
  3. Enter then reporting date.
  4. Click the Export drop-down and select Create new worksheet.

 

After exporting them to Excel, you'll have to combine the data into one Excel file.

 

I'm also adding this article to learn more about customizing payroll reports in QuickBooks Desktop: Customize payroll and employee reports.

 

In the future, you might want to pay your payroll liabilities with QuickBooks Desktop. This article will guide you on how to do it: How to use QuickBooks to pay payroll taxes and other liabilities.

 

Please know you can continue to reach me here with any additional questions about payroll reports. Thanks for coming to the Community, wishing you continued success.

MMajor
Level 1

Payroll Report by Job

What I am finding with the Job Profitability reports is that they are not accurate, they do not include any Liability Adjustments I have made. I have made quite a few. I would like to recommend that Quickbooks make such a report that is a payroll summary but by job when you use timesheets to track jobs and hours/wages tied to those jobs. Thank you.

Need to get in touch?

Contact us