ACE Reporting Spreadsheet of Total Hours/Month

Thanks for posting in this forum, @MandyHRManager. We can run the Payroll Summary report, which contains the necessary information you need. I'm here to assist you in generating this report.

The Payroll Summary report in QuickBooks Desktop (QBDT) gives a clear view of payroll data for a specific period. This report is essential for managing employee details and preparing tax documents.

To run this report, here's how:

1. Open your QBDT company file.
2. Go to the Reports menu.
3. Navigate to Employees & Payroll, then Payroll Summary.

Once done, you will see your employees' names and their worked hours.

For more details, check this article: Create a payroll summary report in QuickBooks.

Additionally, please know that the option to access a monthly report directly is unavailable. Instead, you must generate it and export it to Excel. This way, you can combine all the data in your spreadsheet.

To help you with the process, follow the steps below:

1. Open your Payroll Summar report.
2. Go to Dates, adjust the From and To fields, then Refresh.
3. Head to the Excel dropdown to export this data.
4. A prompt window will show, then click Export to download this information to a CSV file.
5. Continue following the steps until you arrive at the final date.

See this article for additional information: Export reports as Excel workbooks in QuickBooks Desktop.

If you're looking to enhance your understanding of your business processes, reports, and the ways to tailor this information in QBDT, these articles offer valuable guidance:

• Understand reports
• Create, access and modify memorized reports

You can always utilize the Reply button if you have other concerns about generating a payroll report in QBDT. I'll make sure to help you as soon as possible.

@MandyHRManager  RE: I need to know the hours worked, by month, by employee.

Do you need to know the hours worked, or the hours paid? And, by the date worked or the date paid?

If worked, then the only way to get that in QuickBooks is if you use the Time Tracking feature, since payroll dates and worked dates don't always end up in the same month.