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

Report showing hours worked by employee by pay period.

I need to run a report with just the hours worked by pay period for my employees.  We do not bill clients for time.  Where is this report.  I have found total hours for a time period and all of the financial reports breaking down employee pay and time by week, but I'd like pay per pay period do I do not have to re-figure each employee.  Please advise.

3 Comments
Highlighted
Moderator

Report showing hours worked by employee by pay period.

It’s nice to have you here in the Community, CFIP.


I’m happy to provide you the report that shows the hours worked by employee per pay period.


You can run and customize the Time by Name report for this. This report shows how much time each employee spent on various jobs.


Here’s how to run the report:

  1. Go to the Reports menu.
  2. Click Jobs, Time & Mileage, then select Time by Name.
  3. Set the date range.
  4. Under Columns, choose the preferred option.
  5. Click Refresh.

If you want to memorize this report, just follow the steps in this article: Create, access and modify memorized reports.

 

This report will allow you to see the hours worked by employee per period. I look forward to hearing from you again. I'll be here if there's anything you need about QuickBooks Desktop. Enjoy your day!

image.png

 

Highlighted
Level 1

Report showing hours worked by employee by pay period.

I need to run a report for hours per week per employee. Our pay week begins on a Saturday and ends on a Friday. I tried creating a report starting on 02/02/19 to 02/15/19, which is what I need. However when I do this it creates  3 columns, when I think it should be only 2 columns. The first column is only grabbing time worked on Saturday and the next two columns are grabbing Sunday through Friday.

 

 

 

Highlighted
Moderator

Report showing hours worked by employee by pay period.

Thanks for joining this thread, @jesco

 

I'll share some information about running payroll reports. 

 

QuickBooks is designed to create a payroll report based on the default week starting from Monday to Saturday. 

 

If you used the Time by Name report as suggested by my peer above and customize the columns by week, it will create three columns. Since your pay week begins on a Saturday and ends on a Friday, the report is working as designed. You can see the screenshot below to serve as your visual reference. 

 

 

 

If you'd want to have only two columns on the report, I'd suggest sending feedback to our Product Development Team. This can be done by going to the Help menu at the top, then choose Send Feedback Online. By doing so, they'll use this feedback for future updates. 

 

On the other hand, you can also run the Payroll Item Detail report. For additional reference, you can check out this article: Create a Total Hours Worked by Employee Report

 

For more information about customizing payroll reports, you can visit this helpful article: Customize Payroll and Employee Reports

 

Feel free to click the Reply button if you have any other concerns about running reports in QuickBooks. I'm always here to help. Have a great day!

Need to get in touch?

Contact us