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

Payroll report showing all pay data for all emplyees BY pay period over a period of time

Hello,

I am trying to figure out how to run pay roll report that will show payroll data (including hours worked and rates) by payroll period for all employees over the course of a year. I want the data separated out by employee and by pay period. And it needs to include pay rates and hours worked with OT and regular hours. Is this possible?

Thank you!

CaliKicks

10 Comments 10
Adrian_A
Moderator

Payroll report showing all pay data for all emplyees BY pay period over a period of time

Hi Calikicks,

 

I'm here to help you achieve your goal of running a payroll report with the details you've mentioned.

 

As of now, the payroll reports reflect the calculated amount of the regular and overtime rate of each paycheck. However, you can pull up each employee's Paycheck Detail report. This way, you'll be able to review each employee's overtime hours and regular hours by pay period.


Here's how:

 

  1. From the Employees menu, select Employee Center.
  2. Select the employee's name.
  3. Double-click the paycheck.
  4. Click Paycheck Detail.

 

Then, if you want to collate the data to make one report, you'll have to manually take note of the data on an Excel spreadsheet.

 

Moreover, I've added here an article in case you want to change your payroll tax filing: Set up or change payroll tax filing.

 

Keep me posted whenever you have payroll-related concerns.

calikicks
Level 1

Payroll report showing all pay data for all emplyees BY pay period over a period of time

Thanks very much for this. For each employee, can I ask for a report of all pay periods during a given time period at once? Or do I have to go pay period by pay period to get the hours worked each pay period?

I need to pull this data for approximately 600 employees over a 4+ year time period, so you can see why I am looking for a faster way to do this!

MadelynC
Moderator

Payroll report showing all pay data for all emplyees BY pay period over a period of time

I recognize how convenient it is to generate a report that contains all pay periods at once, @calikicks. I’m here to share an alternative to get around it.


While QuickBooks Desktop doesn’t have a specific report that can break down all employees' pay periods during a given period at once, you may consider running the Payroll Detail Review report as a workaround. This statement shows details for each employee's payroll, including the amount, taxes, and deductions.


Here are the steps to access it:

 

  1. Select the Reports menu.
  2. Click Employees & Payroll, then go to Payroll Detail Review.
  3. Hit the Customize Report button, then filter the date and add columns such as payroll item, pay period, etc. You can export them to Excel to gather all the information in one place.


Our Product Development team is constantly looking for ways to enhance our offerings to meet your expectations. That being said, I recommend submitting your idea to them so they can carefully review your feedback and get it possibly added to future upgrades.


I’m adding some comprehensive guides that provide insights into how QuickBooks generates reports and ways you can personalize them to draw the information you need the most:

 


If you have other questions or concerns about managing your payroll statements, please feel free to add comments below. We’re always here to assist you, @calikicks.

calikicks
Level 1

Payroll report showing all pay data for all emplyees BY pay period over a period of time

I'm familiar with this report (I think) but the issue is it doesn't tell me per pay period info, just combines all hours and wages for the time period, and if there is a pay rate change in that time period, it doesn't show up.

calikicks
Level 1

Payroll report showing all pay data for all emplyees BY pay period over a period of time

If I want to focus on one single employee, is there a way to show all data for that employee for each pay check over the course of a year? IE: a summary report of all that employee's pay checks over a period of time, separated by pay check/pay period? So i can look at the report and know hours worked, pay, and rate for each pay period? Thank you!

IrizA
QuickBooks Team

Payroll report showing all pay data for all emplyees BY pay period over a period of time

I know a way where you can see all the data for a specific employee, calikicks

 

In QuickBooks Desktop (QBDT), you'll need to pull up the Payroll Summary report and then Customize it right after to see the hours worked, pay, and rate for each pay period.

 

Here's how: 

 

  1. Go to the Reports menu and click Employees & payroll.
  2. Press Payroll summary.
  3. Hit the Customize report option right beside the Comment on Report.
  4. Under the Display tab, choose Employee from the display columns by dropdown.
  5. Enable the Hours and Rate check.
  6. Then, under the Filters tab, specify the following:
     
      • Account
      • Name
      • Date
      • Payroll Item

  7. Once done, click OK.

 

After pulling up this report and adjusting it according to your preference, you can now export this report by clicking the Excel dropdown and choosing between Create New Worksheet or Update Existing Worksheet

 

Furthermore, you can also create, access, and modify memorized reports in QBDT. 

 

If you need further assistance, just hit the reply button and we'll be right here to assist you. Have a nice day and stay safe. 

calikicks
Level 1

Payroll report showing all pay data for all emplyees BY pay period over a period of time

Thanks very much. Is it possible to run this report (for a single employee) for each pay period if the pay period run from the 1st - 15th of each month and from the 15th to the end of each month? I see how to run it weekly. If so, how?

Thank you!

CharleneMaeF
QuickBooks Team

Payroll report showing all pay data for all emplyees BY pay period over a period of time

It's great to hear from you again, calikicks. I'm confident I can help you in pulling that specific data.

 

Yes, you can run the  Payroll Summary report for a single employee and each pay period (from the 1st - 15th of each month - from the 15th to the end of each month). To do so, I recommend following the detailed steps below.

 

  1. Go to the Reports menu and choose Employees & payroll.
  2. Select Payroll summary.
    1.PNG
  3. Hit the Customize report option.
    2.PNG
  4. From Display, set the Dates to Custom. Then, add the correct period. 
    3.PNG
  5. After that, go to the Filters tab.
  6. On the Search Filters, type in Name.
    4.PNG
  7. In the All names drop-down field, type the specific employee name. You can also click the arrow to locate it. 
    Capture.PNG
  8. Modify the other filters, then hit OK.
    Capture1.PNG

 

For visual reference on how the report will look, I've added this screenshot:

Capture2.PNG

 

Additionally, QuickBooks Desktop offers a selection of payroll and employee reports that can help you manage payroll and keep track of employee expenses. Please see this article to know more: Run and Customize Reports.

 

If you have additional specific data that you would like to access in the system, please feel free to inform me, calikicks. I am committed to assisting you.

calikicks
Level 1

Payroll report showing all pay data for all emplyees BY pay period over a period of time

Thanks very much. I understand how to do it for a set date period, but what I'd like to know is if I can run this report for a single employee, to give me data for each pay period over a longer period of time - ie: give me all the pay data broken down by pay period for Employee X over a 4 year period. So I can see pay detail, including rates and hours worked, for each pay period over a period of time.

Thank you!!

Erika_K
QuickBooks Team

Payroll report showing all pay data for all emplyees BY pay period over a period of time

Let me share some details about this matter, cali.  

 

As my colleague mentioned, we can personalize the Payroll Summary report to generate information suitable to our preferences. However, customizing the report to include the pay periods isn't available. Nevertheless, we would love to hear your ideas about having this functionality in the program, and I suggest submitting feedback. This will be shared with our Product Development Team. 

 

Here's how: 

 

  1. Go to the Help option.
  2. Choose the Send Feedback Online option.
  3. Select the Product Suggestion option. A pop-up window displays.
  4. Enter your feedback suggestion.
  5. Click the Send Feedback button.

 

As a workaround, we can pull the Summarize Payroll Data in Excel report to generate your employee's data, including pay periods, and filter it accordingly.

Slide1.PNG
Slide2.PNG

Additionally, check out this article to learn more about modifying your employee's personal details: Edit or change employee info in payroll

 

I'm still ready to assist with any report-related queries. Keep safe, and have a good day!  

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

Need to get in touch?

Contact us