Can the "Payroll Summary by Employee Report" be sorted by Employee Last Name?

Hello there, @rawgen,

Right now, you can only sort the Payroll Summary by Employee report by the employee's full name.

I've added these articles for additional guidance with payroll reports in QuickBooks Online:

• Payroll Reports Overview
• View the Payroll Summary report.

If there's anything else you need, please don't hesitate to leave a comment below and I'll get back to you.

Is there a way to print the payroll summary by employee number.  We have a client that has 50 employees and they give us their payroll information each week by employee number, not name.  The payroll summary prints by name (each employee has been assigned a number) so when reviewing the summary against the hours, etc from the client, it is out of order and is quite time consuming - can we print something by employee number to review.  Seems like a lot of people would be interested in this.

Hi Lisa.

I appreciate you for joining the thread.

Yes, you can print the employee number from QuickBooks by adding it to the Notes section. I can guide you on how.

1. Open our QuickBooks Online (QBO) account, then click on Payroll at the left pane.
2. Select Employees, then tap on the employee's name.
3. Tap on the Profile section, then enter the employee number under Notes.
4. Hit Done to record the changes.
5. Repeat the steps for the other employees.

Then, open the Employee Details report, to see the employee number details.

1. Click on Reports, then open the Employee Details report.
2. Review the information from the Employee Details window.

Once you generate the Payroll Summary by Employee Report, you can now match their names to the numbers reflected on the Employee Details report. If you want to export or print the report, choose your option from the Share drop-down.

For more tips about running payroll reports in QuickBooks Online, you can open these links:

• Run payroll reports
• View and print payroll reports

Moreover, you can open the topics from this article for more additional help about the common payroll topics.

Please keep in touch if you need more help with running your payroll reports. I'm determined to help. Have a great day!

Sorry I should have been more clear - I am using QB desktop not online.

Hello again, @Lisa galvin. Thanks for getting back and confirming the QuickBooks version you're using. 

In QuickBooks Desktop (QBDT), you can run the Payroll Item Detail report to show the Employee I.D number as it's not possible in Payroll Summary.

To pull up the report, here's how:

1. Go to the Reports menu at the top.
2. Select Employees & Payroll. 
3. Choose Payroll Item Detail.
4. Click the Customize Report button.
5. In the Display tab, type in Account in the Columns search field. 
6. Select Name Account #.
7. Set the date range.
8. Click OK.

From there, the report will show payroll transactions on which each payroll item appears as well as the Employee ID of the employee.

To know more about running payroll reports in QBDT, see the below links:

• Create a payroll summary report
• Customize payroll and employee reports

If you have further questions when running payroll reports, feel free to comment below. I'm more than happy to help. Take care and keep safe.