I need a report showing employees hire date, hours worked in each year, and the total earnings for active and inactive employees.

I don't think you will be able to get all of this information on the same QuickBooks report, but you could export to Excel and modify the spreadsheet to the format you desire. But, to get hire date report go to "Reports" then "Employees & Payroll" then "New Hire List." Hit "Customize Report" button. Select "Filter" tab and set the hire date range you wish to see the hire dates for.  You can modify display columns to remove any sensitive information before exporting to Excel.  With regard to hours worked, I would run a "Payroll Summary" report, set filters as you want, and view total only for date range desired and export to Excel.  Then once you have all of the information in Excel, cut & paste away.

Thank you for posting here in the Community, @Tiffanyrice.

Allow me to help you achieve your goal today. I agree with what @VaTT suggested as a workaround and other users with similar questions might also find this to be of great help.

Additionally, you could customize the report to make it easier for you to include some essential information in it.

Since it was also recommended to export it to excel, feel free to read this article for more details: Export reports as Excel workbooks in QuickBooks Desktop.

You can also read through this article if you want to learn more about getting a new hire report.

To see the detailed steps in viewing what you've paid out to your employees, you can read through this article: Create a payroll summary report in QuickBooks.

If you have additional information and/or questions, openly share them in this thread or you can post again here in the Community. We'll be willing to entertain it. Keep safe and have more power!

I also need a report like this.  @Bryan_M  Is there any chance that we could have a filter added for active employees only?  This would be so helpful!

Hi Angie,

Having an option to filter out inactive employees can help to trim down the data on reports. While we are unable to do this, I suggest sending feedback to our Product Development team. That way, they can consider adding it in future updates.

1. Click on Help.
2. Choose Send Feedback Online.
3. Select Product Suggestion.
4. Enter the details in the box provided and click Send Feedback.

Feel free to go back to this thread if you have other questions in mind. Have a good one.

Hello @Tiffanyrice @Angie618  ,

I have attached a sample report generated from QuickBooks data by a third-party application. It might be something you are looking for.

Below are the steps needed to create it:

1. Select the Begin Date (Reporting Period).
2. Select the End Date (Reporting Period). Optionally, you may choose to include or exclude inactive employees.
3. Click the "Generate Report" button.
4. Review the report briefly.
5. Click "Save as PDF" if everything is satisfactory.

For more information and guidance on more complex and less common reports, you may visit this page: https://ledgerscript.com