Thanks for bringing up your concern here, @odko95.
Let me chime in and share some information on how we can generate a payroll report that includes hours in QuickBooks Desktop (QBDT).
We can create a separate report for the total hours worked by employees to show the worked hours of your employees.
Here's how:
- Go to the Reports menu. Then select Employees & Payroll and Payroll Item Detail.
- Select Customize Report.
- Go to the Display tab. In the Columns list, select Qty.
- From the Total By ▼ dropdown, select Employee.
- Go to the Filters tab. From the Filter list, select Payroll Item.
- Choose the specific item associated from the dropdown. Note: If there is more than one type of hourly payroll item, choose Multiple payroll items.
- Select Ok.
- Change the date range if necessary.
However, combining this report and the payroll summary report is not an option. But you can export both reports to Excel, and manually add the hours.
Here's how:
- Go to Reports, then Reports Center.
- Find and double-click the report you want to export.
- Select the Excel ▼dropdown, then Create New Worksheet or Update Existing Worksheet.
- If you see a message that says your report has too many columns, select Advanced, then uncheck the Space between columns checkbox. Select OK.
- When you’re ready to export, select OK.
Once done, you can import customized reports from Excel to QBDT.
For more tips, while generating your payroll reports in QuickBooks Desktop (QBDT), you can open these articles:
If you have other questions about your reports or payroll transactions, let me know by leaving a comment below. I'm more than happy to help you again. Have a good one!
