cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
dm96
Level 1

How do I really create a total hours worked by employee report?

I'd like to see how many hours specific employees have worked in a given time period. The 'solved' article posted by Quickbooks refers to non-existent categories in the reports section and isn't helpful. 

5 REPLIES 5
Bryan_M
QuickBooks Team

How do I really create a total hours worked by employee report?

I'm glad you posted here, @dm96.

 

Let me help you run a report that will show how many hours your employee had worked in a given time period. 

 

To do this pull up the report Time Activities by Employee Detail. Here's how:
 

  1. Go to Reports.
  2. In the Search field, enter the word time and select Time Activities by Employee Detail on the dropdown lists.
  3. On the Time Activity Date field, enter the exact date range. 
  4. Tick Run report. It will then show each employee's total working hours.

 

Moreover, you can also customise your report to show specific employees, or format layout so the right data shows up.

 

Lastly, I'm adding this page to get other resources for managing employee-related tasks and getting records accurate: Manage employees.

 

Thank you for posting here. Feel free to come back if you have additional questions. We'll be happy to lend a hand. Keep safe always.

dm96
Level 1

How do I really create a total hours worked by employee report?

Thanks for responding. But all I get when following these instructions is "This report does not contain any data." 

GeorgiaC
QuickBooks Team

How do I really create a total hours worked by employee report?

Hi dm96, thanks for checking those steps. Since you're unable to see any data, please call our support line on 0808 234 5337 or begin a chat so that we can set up a secure screen share using our Smart Look software to view this with you.

dm96
Level 1

How do I really create a total hours worked by employee report?

Hi again, I still have no resolution to this issue. On 24 July I spent one hour with Quickbooks Support (which was painfully slow and did not appear to be progressing any closer to helping with the problem). The support officer asked me to email them some screenshots and promised to get back to me with more assistance. I followed up on 26 July and still have had no response. It seems like it should be a fairly straightforward issue to resolve?

Bryan_M
QuickBooks Team

How do I really create a total hours worked by employee report?

Hi there, @dm96.

 

I want to thank you for returning here. I understand that it hasn't been easy for you and I empathize with your situation. I'm aware that this issue is impacting your daily payroll activities.  

 

Right now, allow me to share information on why sometimes data aren't showing on the Time Activities by Employee Detail report.

 

Before anything else, I'd like to know if you're using the Weekly timesheet and Single time activity in QBO or QuickBooks Time on tracking your employee's hours of work. Because these two vary in terms of how they work.

 

When utilizing the Weekly timesheet or Single time activity feature in QBO, it is necessary to manually input the number of hours an employee worked. The Weekly timesheet can be updated at the end of each week to monitor their hours. To access this option, click the + New tab and select it from the Employees column.

 

See the picture below for reference:

 

For the Single time activity option, we can enter the hours of work by day, and not weekly. We just need to select a date we want to track the hours of work of our employees. 

 

See the example screenshot below:

 

 

After completing the previous task, please run the Time Activities by Employee Detail report again using the instructions I previously provided in this thread. If the report still doesn't appear, I suggest contacting QBO Payroll Support for an update on this issue.

 

If you are using QB Time and it's integrated into your QBO account, it will automatically synchronize when you click the Import option.

 

The synchronized time will then be displayed in the Time Activities by Employee Detail report. In case it's not showing, we should contact QB Time support to check our account and review if an error occurred during the import.

 

Moreover, you can open the topics from our help articles for additional resources while working with QuickBooks in the future.

 

Thank you for being here. If you require further assistance, don't hesitate to reach out. We're always happy to help. Take care and have a great day!

Need to get in touch?

Contact us