Skip to main content

Filter out former employees in the Pay & Allowance report

Find out how to run the Pay & Allowance report and remove former employees.

Written by Cristiana Ghinea

To report on your TLRs, the best option is the standard report Pay & Allowance.

The report, by default, shows current as well as former employees. However, once you've exported the report you can remove the rows that have a blank value in the PrimaryEmploymentNumber column. These are former employees.

To remove former employees in the Pay & Allowance report:

  1. Click Reports, then Standard Reports.

  2. Click Pay, then Pay and Allowance Export.

  3. Select the divison or section in the Organisation Structure.

  4. Select the start and end dates.

  5. Click Generate Extract.

  6. Open the Excel spreadsheet.

  7. Filter Column B, PrimaryEmploymentNumber, from smallest to largest.

    • All rows with a blank value in Column B will now show at the bottom of the spreadsheet.

  8. Remove the rows with a blank value in Column B.

Did this answer your question?