Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
S
SarahCO
New Member
January 20, 2026
Question

Time Activities by Employee Summary Report

  • January 20, 2026
  • 11 replies
  • 97 views

Is there a summary version of the Time Activities by Employee Detail report? I can't seem to find it in the standard reports, and I can't figure out a way to do it inside the detail report. I would love all of the information in a summary version that's not 99 pages long. I don't need it to show every entry for every customer, just the total time for each customer, subdivided by employee.

11 replies

RazzieE
RazzieEQuickBooks Team
QuickBooks Team
January 21, 2026

Hi there, @SarahCO.

 

I appreciate your effort in reviewing the Time Activities by Employee Detail report.

 

QuickBooks Online doesn't have a summarized version of the Time Activities by Employee Detail report. The detail view will always list every individual time entry.

 

As a workaround, you can export this report to Excel and create a pivot table with 'Customer' as rows, 'Employee' as columns, and 'Duration' as the summed value. This produces a clean summary of total hours per costumer, broken down by employee.

 

If you're using QuickBooks Time, you can also run the Itemized Total Time report. That one provides a summarized view without showing every individual entry.

 

If you have follow-up questions, please don't hesitate to click the Reply button.

S
SarahCOAuthor
New Member
January 21, 2026

Thanks for your response.

 

I've never created a pivot table in Excel, so I wouldn't even know how to start with that. In addition, I also need it subdivided by class. Also, Excel doesn't add the times, now that Quickbooks enters the times in the report as 1:30 hours instead of 1.5 hours. This is what got me in this pickle to begin with.

 

I found the itemized total time report, but it doesn't seem to be working correctly. It is only showing me time for one employee, and not even all of his time.

E
EvethCQuickBooks Team
QuickBooks Team
January 21, 2026

Hi there, Sarah.

 

Thank you for reaching out and sharing details about your situation with QuickBooks Online (QBO). Allow me to help you with this issue.

 

We can refine the data in the Itemized Total Time Report by applying the correct filters when running the report to group and subtotal your data properly. Ensure you apply filters for Team Members, Jobs, or Customers, as well as any Custom Fields, such as billable items, service items, or classes. This step is crucial to ensure the report captures all the relevant data you need.

 

For the Team Members filter, ensure "Include All Team Members" is selected. Entering a specific name might inadvertently exclude others. Select any relevant job codes or customers tied to your report and verify that class data is included to allow subdivision.

 

As for the times in the report as 1:30 hours, tick the radio button for  Decimal (4.75)  to choose decimal form instead of HH: MM (4:45).

 

Use the "View Timesheets" option to verify that the data matches your expectations. If the report still seems incomplete, download the timesheets as a .csv file to work in Excel.

 

You can refer to this article for detailed instructions on how to run the itemized total time report: Run the Itemized Total Time Report for QuickBooks Time.

 

If you require further assistance with running or modifying these reports, please let us know. We are here to help you.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement