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!

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.

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!

I do not have a report option for TIME BY NAME under JOBS, TIME, and MILEAGE.  Can you please help me understand why - or another way I might find this information?  I'm using QuickBooks Desktop Pro 2019.

Hello there, @47501qkbks.

This behavior with the missing report is often caused by damaged data. I recommend running the Verify/Rebuild tool. This helps identify the most commonly known data issues within the file and resolves it.

Before we begin with the troubleshooting, let's secure a backup of your company file. Once done, we can proceed to verifying and rebuilding your data in QuickBooks Desktop. I'll guide you how:

Here’s how to verify:

1. Go to the File menu.
2. Select Utilities.
3. Click Verify Data then select OK to close all windows.

To rebuild:

1. Go to the File menu.
2. Select Utilities.
3. QuickBooks will ask to make a backup before rebuilding your company file, select OK.
4. Once the rebuild is done, click OK.

For more details in verifying and rebuilding your QBDT, you can check out this article for reference: Verify and rebuild data in QuickBooks Desktop.

Once done, let's go back to the Reports menu and run the Time by Name report. This will show the time by person broken down by the customer for a specified date range.

1. Go to the menu, select Reports then, Jobs, Time & Mileage.
2. Select Time by Name.
3. Set the date range of the data you want to be included in the report.
4. Click the Customize Report and filter the necessary details.

Also, you can export the report to Excel and modify the changes from there.

To learn more about how to personalize your reports with formats and details you want, please feel free to check out this article: Customize reports in QuickBooks Desktop.

Once done, click Memorize to save its current customization settings. Doing so will help you quickly access the report in the future.

In case you want to fix common errors right away and set up timesheets, print them, and run a timesheet report. Just check out these articles:

•  Create And Print Timesheets
•  Repair your QuickBooks Desktop

 Please let me know if there's anything you need help with QuickBooks. I'll be happy to work with you anytime. Have a good one!

I still do not have a Time by Name after I verified data

Hi there, @Melissalanglais.

I appreciate you for following the troubleshooting steps above. I checked the report on my end, and I'm able to view it. 

Since the issue persists on your end, I'd suggest running the Time by Job Summary then customize it to Time by job by Name. Let me show you how: 

1. Go to the Reports tab, choose Job, Time & Mileage. 
2. Select Time by Job Summary. 
3. Click the Customize button on the left side. 
4. Choose Display, then pick Time by Name by Job in the drop-down. 
5. Hit the Filter tab, then type Name in the search box. 
6. Elect either Multiple names or All names. 
7. Tap OK. 

Also, I'd advise you to contact our Customer Care Team. They have tools to open your account and investigate the root cause. Please ensure to contact them within the business hours to address your concern as soon as possible. 

Here's how: 

1. Go to this link: https://help.quickbooks.intuit.com/prechats/offerings/QB-Desktop-ProPremier-CHAT/22240/view. 
2. Complete the required information. 
3. Hit Submit. 

Additionally, browse through these articles below about managing reports, customer's job, other topics. 

• Tracking job costs in QuickBooks Desktop
• Reports
• Understand reports

Let me know if you have another concern by clicking the Reply button. I'm always here for you. Keep safe!

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.

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.

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!

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.

I appreciate you for coming back to provide more details about what you've done to fix the issue, @BethDGC. I'll share other troubleshooting steps to ensure you'd be able to run a report showing the total time an employee has spent on a job.

In QuickBooks Desktop (QBDT), we have the QuickBooks File Doctor that we can use to fix damaged company files. 

To get started, download and install the QuickBooks Tool Hub. Let me show you how:

1. Make sure to close your QuickBooks.
2. Download the latest version of the QuickBooks Tool Hub (1.5.0.0) and save it where you can easily find it. 
3. Open the QuickBooksToolHub.exe link.
4. Follow the on-screen instructions to complete the installation process.
5. Next, double-click the icon on your desktop to access the tool hub.
6. From there, head to the Company File Issues menu on the left panel and click Quick Fix my File.
7. Click the OK button once completed. Then, launch your QuickBooks.

 To run the QuickBooks File Doctor. See these steps:

1. Select the Company File Issues menu from the tool hub.
2. Choose the Run QuickBooks File Doctor button. 
3. In QuickBooks File Doctor, choose your company file from the drop-down menu.
4. Select Browse and Search to find your file.
5. Press the Check your file option and then Continue.
6. Enter your QuickBooks admin password and then click Next.

If the issue persists, you can check out this article for more troubleshooting steps: Fix company files and network issues with QuickBooks File Doctor.

For additional resources, see the following article: Resolve network issues with QuickBooks File Doctor test results. It includes comprehensive instructions and illustrations for hosting QuickBooks company files in multi-user mode.

Reach out to me again if you have follow-up questions or concerns about the process when using the file doctor. I'll be around for you. Have a great day ahead.

Hello Beth,  Did you ever figure this out.  I am having the same issue.  Every time I try to do this report as they have listed there is zero data.  

Hello, Bobbie12. 

I'm here to assist you with any issues you might be facing. Have you already tried the solution provided by my colleagues MirriamM and ChristieAnn? If yes, and the problem persists, I recommend reaching out to our customer support team. They will be able to securely access your account and assist with figuring out why the report is showing zero data.

1. Go to the Help menu.
2. Press the QuickBooks Desktop Help option.
3. Tap the Contact Us hyperlink/button.
4. Enter your question and hit Let's Talk.
5. Scroll down and pick Get a callback.

Additionally, I'm adding an article about customizing payroll reports. Please visit this helpful article: Customize Payroll and Employee Reports.  

Keep us updated on how the call goes. We're always here to lend a helping hand. Have a great day!

I would like a report that shows ALL hours worked by employee INCLUDING time not associated with a specific job, like Clerical/Receptionist. 

I would like it to show similar to Time By Name, but also include the PAYROLL ITEM in that report. How are we able to run a report like that?

Thank you for joining the thread, @PWendt.

The option to generate a payroll report that's similar to the Time By Name report with payroll items is unavailable in QuickBooks Desktop.

For now, you can run two separate reports: the Time By Name and Payroll Item Details reports. Then, export them into Excel and combine their data.  

Here's how to run reports and export to Excel:

1. Go to the Reports menu, then open your desired reports.
2. Click the Excel drop-down list and select Create New Worksheet.
3. Continue by clicking Export, then Save your file.

You can also send feedback about your thoughts when generating reports in QuickBooks Desktop. This way, our developers can review your suggestions and most likely include them in future updates. Simply click Help and select Send Feedback Online. Then, choose Product Suggestions. Write down your ideas and click Send Feedback.

For additional reference about managing reports in QuickBooks Desktop, check the following articles:

• Understand reports
• Set report preferences
• Combine reports from multiple company files
• Set up and modify Scheduled Reports

If you have further concerns about running reports showing all hours employees worked, including time, post them again in this thread. Our QuickBooks Community team and other QuickBooks experts are always here to help. Have a good one.