Skip to main content
T
Tiffanyrice
January 18, 2023
Question

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

  • January 18, 2023
  • 2 replies
  • 0 views
Original commenter did not share additional details

2 replies

V
VaTT
January 30, 2023

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.

Bryan_M
Bryan_M
January 30, 2023

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!

A
Angie618
June 12, 2023

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!

LedgerScript
LedgerScript
November 4, 2023

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

 

Terms & ConditionsAccessibility statement