How to sort a payroll report by employee name?

Modified on Fri, 28 Feb at 1:26 PM

With the recent updates to employee IDs, payroll reports are now sorted by default based on employee ID. If you prefer to organize the data by employee name, follow these steps to adjust the sorting order:


1. Access the payroll report from your system and open the file in Excel.


2. Highlight all rows in the report, making sure to exclude the total amount section.


3. Click on the Sort & Filter option in the toolbar, then select Custom Sort.


4. In the Column field, choose Name from the dropdown list. Ensure that the sorting order is set to A to Z (ascending) or adjust it to Z to A (descending) based on your preference. Then, Click OK to apply the changes.



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article