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

Reports

I am trying to find or make a report that would allow me to look at an individual employee's total gross pay by job.  So, I would be able to look up the job and be able to filter it out to see the individual employee's total pay for just that job during a certain time period.  I have tried to build my own report and I think I am close, but I can't seem to get it.  If there is a way to change the Source Name in the report, I may be able to get it, or if anyone else has a way I would love to hear it!  I am running on QB desktop Pro Plus 2021

Solved
Best answer January 28, 2022

Best Answers
JenoP
Moderator

Reports

I'd b glad to help with your question about running rports, Linz23.

 

There's an Excel report that will provide the information that you need. Here's how:

 

  1. Go to the Reports menu, scroll-down to Employees and Payroll, and then click Summarize Payroll Data in Excel.
  2. Select the report period in the Dates section, then click Get QuickBooks Data. You may also need to click Enable Macros if prompted. 
  3. Proceed to the Rates and Hours by Jobs tab.
  4. Click the drop-down list for Customer:Job, then select the job that you want.
  5. Select OK.

job report.PNGjr2.PNG

Here's an article about getting this report for more details: Excel Based Payroll Reports.

 

Let me also share this article for additional references: Customize Reports in QuickBooks Desktop.

 

Feel free to reply or post more questions in the Community if you still need more help. We're always here to guide you all the time. 

View solution in original post

3 Comments 3
JenoP
Moderator

Reports

I'd b glad to help with your question about running rports, Linz23.

 

There's an Excel report that will provide the information that you need. Here's how:

 

  1. Go to the Reports menu, scroll-down to Employees and Payroll, and then click Summarize Payroll Data in Excel.
  2. Select the report period in the Dates section, then click Get QuickBooks Data. You may also need to click Enable Macros if prompted. 
  3. Proceed to the Rates and Hours by Jobs tab.
  4. Click the drop-down list for Customer:Job, then select the job that you want.
  5. Select OK.

job report.PNGjr2.PNG

Here's an article about getting this report for more details: Excel Based Payroll Reports.

 

Let me also share this article for additional references: Customize Reports in QuickBooks Desktop.

 

Feel free to reply or post more questions in the Community if you still need more help. We're always here to guide you all the time. 

Linz23
Level 1

Reports

Thank you so much! That completely solved my problem, got the exact information I needed!!

Linz23
Level 1

Reports

Thank you so much, that got me all the information I needed!!

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

Need to get in touch?

Contact us