Skip to main content
C
CFIP
November 13, 2018
Question

Report showing hours worked by employee by pay period.

  • November 13, 2018
  • 3 replies
  • 0 views

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 replies

PreciousB
PreciousB
November 14, 2018

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!

 

J
jesco
February 21, 2019

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.

 

 

 

R
RaymondJayO
February 21, 2019

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!

M
Minneapolis
March 7, 2022

I am looking for a labor report. Want to see total hours worked this year across employees. Would like to see split by regular and overtime. Last, would like to understand average pay for regular hours. I have desktop pro.

B
BethDGC
August 18, 2022

In payroll I assign every employee hour to a job.

All efforts to run a report to see total time an employee has spent on a job have opened with no data. 

We have QuickBooks desktop premier contractor edition 2021.

    C
    ChristieAnn 11
    August 18, 2022

    Hi there, BethDGC.

     

    Welcome to QuickBooks Community. I appreciate you providing detailed information about your concern. I'll be providing troubleshooting instructions to ensure that you can see an employee's total time spent on a job on a report.

     

    Since you assign every employee's hour to a job, they should appear when you pull up the Payroll or Job report. I suggest running the  Verify and Rebuild Data Utilities to get this sorted out. The Verify Data utility identifies any potential data damage issues that might've caused unusual behavior of your data on a report. While the Rebuild Data utility repairs damaged data in your company file. Before this, you'll have to secure a backup copy of your company file.

     

    To Verify data:

     

    1. Go to the File menu.
    2. Scroll down to Utilities.
    3. Select Verify Data.
    4. Click OK.

     

    To Rebuild Data:

     

    1. Go back to the File menu.
    2. Choose Utilities.
    3. Select Rebuild Data.
    4. Click on OK when you get the message Rebuild has completed.

     

    For further details, you can refer to this article: Verify and Rebuild Data in QuickBooks Desktop.

     

    Lastly, you may refer to this article to see steps on how you can customize any report in QBDT to personalize the font and style of the page: Customize reports in QuickBooks Desktop.

     

    Let me know if you have other questions about the details mentioned above or any related concerns with employee data in QBDT. I'm always free to help you whenever you need my assistance, BethDGC. Take care and stay safe always!

    B
    BethDGC
    August 24, 2022

    When I ran the Verify Data Utility it did not identify any issue.  So I am back to square one.  Is there any other reason why no data would fill in the report?  We do not use the Quickbooks Time feature but as I said,  every employee hour is assigned to a project when entering data in a scheduled payroll.  Thank you.

    Terms & ConditionsAccessibility statement