How is the order of employees stored online?

Sort Order is always done first by Department and then by either Surname or Employee Number. However for data capture it is done by Department and then Surname. The default is by Department and then by Surname. If you are adding employees it is a good idea to add them before you print off time book sheets if you want the order to be the same. For offline input using the monthly template, you can make a template to sort your employees by Department and then employee Number. In this way your data-input, sort-order can be changed in terms of the input-order when you process payroll-input using the offline excel template. Some of the reports can also be changed in terms of sort order: The order of the time-book sheet reports can easily be changed by selecting the top left "Order by" drop down box and sorting by employee number before you export the time sheet to excel. Other reports can also be sorted by employee number: eg To order order a Summary report or Payslip report by Employee Number instead of the usual "Surname" order please do the following: On the report page e.g Summary Report click on the drop down box called "Options" and then look for the option "Order by Employee No". Then export your report to Excel and in the Excel version the sorting Order will be adjusted.