IROC Compare

Every NJ district is required to report pension deductions quarterly (four times a year).  The District can electronically compare the Quarterly IROC report to the actual deductions processed in SchoolFi.  SchoolFi will generate a report of exceptions that compares the Report of Contributions to the actual deductions processed in SchoolFi.  

The District must have a MOVEit account with the New Jersey Division of Pensions & Benefits to utilize this feature.  The District's MOVEit Administrator will receive an email from it's MOVEit account to access the PROJECTIONS file.   The PROJECTIONS file can be viewed in your location’s MOVEit “FilesAndReports” folder.

Once the file is downloaded, the District will navigate to the Payroll  >>  Pensions  >>  IROC Compare tab to upload the file for processing.  Then the District will populate the information highlighted in the tab below and upload the PROJECTIONS file into SchoolFi.

To create the comparison file you will:

1. Select the Tax Year
2. Select the Quarter
3. Enter a value to suppress differences (default is 1)
4. If back insurance should be combined with contributory insurance, check the box (option is checked for most districts)
5. Choose the PROJECTIONS file that you downloaded from MOVEit
6. Click on the Upload File and Download Excel Report button

The district can utilize the excel file that created to identify the differences between the PROJECTIONS and the actual deductions that were processed in SchoolFi and the IROC can be updated accordingly. 

What happens when a PROJECTIONS file is uploaded.

1. For each row in the file, a record is created where a staff member can be found in SchoolFi with a matching Pensions / Member #.  All other records are discarded.
2. The following comparisons are made from the data in the file to actual payroll run data:
   1. Last Name of the Staff vs in the file (up to the ,)
   2. Base Salary This Quarter
   3. Pension Rate
   4. Pension Contributions  (Sum of pension deductions taken out this quarter from payroll history)
   5. Pension + Back Contributions (Sum of pension + back pen deductions taken out this quarter from payroll history)
   6. Back Deductions (Sum of back pen deductions taken out this quarter from payroll history)
   7. Arrears Deductions (Sum of arrears pen deductions taken out this quarter from payroll history)
   8. Insurance Premiums (Sum of Contributory Insurance deductions taken out this quarter from payroll history)
   9. Loan Payments (Sum of Pension Loan Deductions taken out this quarter from payroll history)