AU Payroll - Sort by Surname
To be able to sort Pay Employees by Surname and it holds them in that order instead of refreshing

Hiya community, thanks for your support in this. Totally get why you may want to set the default view to sort by surname in Payroll. Being open, with many of the teams resource working hard to fine tune payroll for STP phase 2 there are no direct plans for developing the option to set a default for sorting of employees atm.
To confirm, right now from your list of employees you can click on the column header to sort ascending or descending alphabetically - So, once on the screen you can click Last name to sort your employees by this column.
We'll update again if there's any change planned.
-
Aileen Candy commented
UNBELIEVABLE!!! Obviously the software designers are NOT actually using Xero themselves. i.e. inputting data on a regular basis.
Pretty sure everyone knows you can sort where you mentioned BUT you can't flick through one employee after another - keeps reverting back to the First Name sort. It's so frustrating every time you do a report to export to Xero and then have to insert a column and change the entries to Surname first then delete the original Employee name column and then do a Data sort on the new column to get a working copy that matches every other database etc.
Utterly disappointed in this LACK of support for something that should NEVER had been an issue to begin with. -
Wendy Bateman commented
This is about the least useful place to sort employees by last name. It is no kind of solution to be able to change the sort order on one screen (and you have to do it every single time you make any minor change or leave the screen). This option doesn't work for reports (results in many extra steps to correct the reports), doesn't functionally work when processing a payroll by using the save & next option and for bank payment reports even sorting by first name would be an improvement (is currently random). Xero is missing many very minor things that users prior to using Xero would not assume would be an issue as nobody else would even contemplate that software programmers would think this was good. It isn't that last name should be set as a default view (having experienced Xero, I would never presume that any flexibility would be added) it should be the main setting for sorting for everything. It is so frustrating that the software does not do this. Xero ignoring ideas, makes me think you have an 'ideas' section for show and to reduce formal complaints.
-
Vicki Caban commented
Very disappointing that Xero have chosen to ignore this request from so many people....
-
Vicki Caban commented
Yeah - we all know that already... the problem is that it keeps defaulting back to sort by First Name so you have to keep clicking the Surname header to get the list back into Surname order ... it is VERY frustrating and time consuming having to re-sort the list every time you do something... why can't you just give the option to have surname shown in the first column and default back to that each time instead of First Name... it's pretty standard practice...!
-
Lisa Wegner commented
Pretty sure we're all aware of being able to "sort", however it always reverts back to christian name when you've finished the particular screen you're on, or whenever a screen/page is refreshed, so still not achieving what we need this software to achieve!! Nowhere else and no other software automatically sorts by christian name, so why is it so difficult for Xero to fix this issue ??
-
Michelle Ervin commented
Sure you can sort it, in one window, but you can't work inside the payroll run in surname order by using the "Next" function after updating someones timesheet record for the payrun. It just defaults back to First name.
-
Liam Thomas commented
My CRM software that records hours is sorted by surname and it would make payroll far more efficient if xero did the same!
-
Mim Khoshaba commented
It creates less confuison if in surname order
-
Nicole Cummins commented
I am astonished that we have to even be voting on this!!!
I thought it was a common sense fix
-
Emma Rosenblatt (Accounts) commented
Super annoying we cannot do this!
-
Johanne Brigham commented
It is a real pain that Xero lists employee names alphabetically by Christian names when the rest of the world does it by surname, including ATO. It is a complete nuisance.
-
Selwyn Aldred commented
I need surname or employee or Employee Number.
-
Rebecca Forster commented
All other systems and current employee records are sorted/filed by surname. Would make sense and be consistent with filing principles to have Xero sort by surname and to hold that setting.
-
Liz James commented
Only payroll system I know that sorts by first names - too much time is wasted as a result
-
Rebecca McGinty commented
First names can be really inconsistent. Bob/Robert, Becky/Rebecca, Liz/Elizabeth, payroll really should be via surname.
-
Aileen Candy commented
How many votes does this have to get before it's actioned... I believe people have been crying out to Xero about this since 2019 or earlier... COME-ON... Xero, listen to those who use the package. Action urgently needed.
-
Helen Holley commented
Make life a lot easier if this option was available for all of my client base.
-
Aileen Candy commented
Such a PAIN that it keeps sorting on first name - not just in payroll but all over. Hard copies are never sorted on first name and neither are any other programs that I know of... Ridiculously cumbersome when shifting data - every report I export to Excel so I can change the order. PLEASE Xero - LISTEN to your clients and do something about this.
-
Michelle Macdonald commented
It seems like such a small fix would make such a difference - it drives my Managing Director crazy & I have to resort everything to match the reports based on christian name. If MYOB can do it surely Xero can do it better.
-
Lisa Wegner commented
Xero - it's about time this easy fix is instigated......don't see anyone that thinks it's a bad idea / not important !!