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

Payroll Report

I need to report an employee's gross wages and hours worked, by pay period, for a time period spanning 7 years. I cannot find a report and/or filter that lets me accomplish this. I have tried filtering the payroll summary, but can't achieve what I need.

I appreciate any help.

Solved
Best answer May 24, 2021

Best Answers
Giovann_G
Moderator

Payroll Report

Hi there, ValA.

 

I can guide you run the payroll report base on your preference.

 

You can run the Payroll Item Details report and customize it base on your preference. Then, export it to excel to add a column for the pay period. You can use the Payroll Summary report as your reference.

 

Here's how:

 

  1. Go to the Reports menu. Then select Employees & Payroll.
  2. Choose Payroll Item Details.
  3. Hit Customize Report.
  4. Go to the Display tab. In the Columns list, select Qty.
  5. From the Total By dropdown, choose Employee.
  6. Go to the Filters tab. From the Filter list, select Payroll Item.
  7. Choose the specific item associated from the dropdown. 
  8. Select Ok.
  9. Change the date range if necessary.

 

For your reference, refer to this guide for the detailed steps: Create a total hours worked by employee report.

 

Feel free to check this resource for more insight: Customize payroll and employee reports. This contains helpful information about customizing payroll reports.

 

Add a comment if you have further questions about running payroll reports. The Community and I will always here to back you up.

View solution in original post

3 Comments 3
Giovann_G
Moderator

Payroll Report

Hi there, ValA.

 

I can guide you run the payroll report base on your preference.

 

You can run the Payroll Item Details report and customize it base on your preference. Then, export it to excel to add a column for the pay period. You can use the Payroll Summary report as your reference.

 

Here's how:

 

  1. Go to the Reports menu. Then select Employees & Payroll.
  2. Choose Payroll Item Details.
  3. Hit Customize Report.
  4. Go to the Display tab. In the Columns list, select Qty.
  5. From the Total By dropdown, choose Employee.
  6. Go to the Filters tab. From the Filter list, select Payroll Item.
  7. Choose the specific item associated from the dropdown. 
  8. Select Ok.
  9. Change the date range if necessary.

 

For your reference, refer to this guide for the detailed steps: Create a total hours worked by employee report.

 

Feel free to check this resource for more insight: Customize payroll and employee reports. This contains helpful information about customizing payroll reports.

 

Add a comment if you have further questions about running payroll reports. The Community and I will always here to back you up.

ValA
Level 1

Payroll Report

Hi,

Thank you for this solution. I do that job part time, so I'll try this solution tomorrow and I'll let you know.

Thanks again,

Valerie

ValA
Level 1

Payroll Report

That worked! I filtered it a little more and got all the info I needed. Thank you so much!

Need to get in touch?

Contact us