- Navigate to the report menu > Deductions report.
- Set date range as required and all filtering to All. Tick include terminated employees. Run and download the report into Excel.
- From the Excel report, switch the filtering on from Data > filter.
- Filter the J column IRD Arrears for non-blank cells. This will highlight all impacted employees in all impacted pay runs.
- Pivot the data proceeding as follows: Select all > Insert > Pivot Table.
- From Table/Range > Choose where you want the PivotTable to be placed > New Worksheet > OK.
- In the newly created worksheet, from the PivotTable Fields menu, add Employee Id field to Rows and IRD Arrears to Values. Ensure the Value is set to Sum (as opposed to count).
- The sum of IRD Arrears displayed is the total deduction to be remediated by employee i.e. the total IRD arrears to be recovered from the employee’s earnings.