Create a total hours worked by employee report

Customize the Payroll Item Detail report in QuickBooks Desktop to calculate and display the total hours worked for each employee.

Overview

By default, standard payroll reports may not show cumulative hours per employee. You can modify the Payroll Item Detail report to total the quantity (hours) by employee and filter for specific hourly payroll items.

Create the report

Follow these steps to build the report.

1. Go to the Reports menu.
2. Select Employees & Payroll, then select Payroll Item Detail.
3. Select Customize Report.
4. Go to the Display tab.
5. In the Columns list, select the Qty checkbox.
   • Note: This column tracks the hours recorded on paychecks.
6. From the Total by ▼ dropdown, select Employee.
7. Go to the Filters tab.
8. In the Filter list, select Payroll Item.
9. From the dropdown menu, choose the specific hourly payroll item you want to track.
   • Note: If there is more than one type of hourly payroll item, select Multiple payroll items to include them all.
10. Select OK.

Review the report

Once generated, the report groups transactions by employee and sums the Qty column to show total hours.

• Change the Dates range at the top of the report window to view hours for a specific pay period, quarter, or year.