[YEAR END REPORTING] Reporting Menu > Annual Reports

[YEAR END REPORTING] Reporting Menu > Annual Reports

GOAL: To provide a wholistic overview of the reports and resources that are available within HRP to review Year End/Start Data when entering the New Year. 

Reporting Menu > Annual Reports

PAYROLL > REPORTING MENU > ANNUAL REPORTS

**The above outlines the main Annual Reports boards utilize at Calendar Year End** 

PAYROLL > REPORTING MENU > ANNUAL REPORTS > OCT Annual Report

This procedure will generate an OCT annual report (OCT fee listing) and a data file to be submitted to the OCT.

**Configure the Year for Report & Deduction Code > Choose Submit**

Note: The Drop Down List is generated with all Entity Codes that have an Entity Type of DEDUCTION.

This report is something that boards need to run in January, as an annualized extract of OCT Data. 

PROCESS > COMPLETED > OCT ANNUAL REPORT

Here we can see the OCT Fees paid by Employee for the configured Year for Reporting. 

PAYROLL > REPORTING MENU > ANNUAL REPORTS > OMERS Year End Report

This process produces a data file for OMERS and three reports (the Annual Reporting for OMERS Contributions report, the list of employees with PA Override Amounts report and the OMERS Year End Service Validation report).

**Choose the Year for Reporting & Update EID Inclusion checkbox**

Note: Include EID on Transmission File  value automatically defaults to N.

Y indicates that the Employee ID will be visible in the OMERS data file. This indicator does not affect the reports generated.

PROCESS > COMPLETED > OMERS YEAR END REPORTS

It is important to note that the main function of the OMERS Year End Report is to create the 119 File.

Note: OMERS Year End Report can be run as many times as you want, as you can run the report to “vet” the numbers, adjust, and re-run to see your updates.

Annual Reporting for OMERS Contributions: YEAR

Important Note: You cannot run the Year End report and get any values without running the OMERS Service Credit for all 12 months. 

It is common practice to run the OMERS Year End Report to start reconciliation and use this to finish any broken service/LOAs that impact PA calculations, and also run the OMERS Service Credit Tool for all 12 months. 

Then after all adjustments to broken service/service credit are made, you can then re-run the OMERS Year End Report to see the changes

OMERS Cheat Sheet:

1. Reconcile Broken Service 
   1. Import Broken Service from DNP (OMERS folder) > import for the T4 Year
   2. Any Approved Leaves need to be inputted manually into the Broken Service screen (ex. ESA leaves, LOAs, etc.)
   3. Audit & edit any necessary Broken Service values in the Broken Service maintenance screen
2. Run OMERS Service Credit tool to calculate the service credit (Reporting Menu  > Monthly Reports > OMERS Service Credit screen) 
   1. NOTE: Run this one month at a time and you must wait until that month is done before Submitting the next month.
3. Reconcile your OMERS s/c.   Any adjustments can be made to in Pay Process > OMERS > Service Credit Adjustments screen > Look up the EE & choose the correct Group & Year in the middle table > Overwrite the applicable month with the correct service credit for that particular month > Save.  Note: There may be separate lines for the same month if the employee had two separate OMERS pension records in that month (ex. changed Pension classes). 
   1. You can see a summary of the entire year's service credit by running the OMERS Year End report in Reporting Menu > Annual Reports.  Run this report as many times as needed to see updated YTD values on contributions, contributory earnings & service credit.
4. Run the OMERS Year End report to reconcile the final 119 forms and the summary report of everyone's OMERS YTD totals.  The 119 file generates on the server - retrieve it and upload to OMERS.
5. Between steps 3 & 4, you may want to run T4s to calculate the PAs and vet the PAs before submitting your 119s.
6. Before sending your 119s, you may need to send all of your 119 Retro forms first.  Send the Retros to OMERS first.
7. After Retros have been sent/uploaded to OMERS, then send the 119 form file from the server (retrieve it in the same place you retrieve your EFT files from).
8. If you have PA corrections from OMERS, correct the PAs (either in OMERS' records or in HRP, depending on which is incorrect).  PA Adjustments in HRP can be made in Pay Process > PA Calculator screen.  Reminder: Initial HRP-generated PAs don't calculate unless you've run T4s at least once.
9. Proceed with year-end (PA adjustments, T4s, etc.)

PAYROLL > REPORTING MENU > ANNUAL REPORTS > TPP Annual Report

This process produces the TPP Earnings Cards report. It should be run for every teacher on the Board's staff who contributes to the Teachers' Pension Plan.

**Choose the Year for Calculation, Report option and Groups in Question to Submit the report** 

NOTE: Employee Group Code and the Description Abbreviation field are both contained in the pop up list. The pop-up list is ordered by the Employee Group Code. The values in this pop-up list are retrieved from the EC_GROUP_VIEW table.

In addition to the Employee Groups/Employee Group Descriptions you have access to, ‘All’ with a description of ‘All Groups’ also appears in this list.

PROCESS > COMPLETED > TPP ANNUAL REPORT

The functionality of TPP Annual Report is to report all DNP to TPP (Short Leaves (SH) & Leaves beyond 5 Days (SH) – anything without Pay). 

Service Credit is calculated on every pay run, alongside all of the contributory earnings and contributions. This information then becomes ready after the final pay of the year has been Confirmed. 

Note: If there are any YTD adjustments to be made, you can do so under the YTD Record Adjustment module first, before running the TPP Annual Report. 

Once the report is processed and confirmed to be satisfactory, the file can be uploaded to the TPP Employer Portal (TIM). 

PAYROLL > REPORTING MENU > ANNUAL REPORTS > TPP Credit Summary

This process creates a summary report on TPP Service Credits. You may choose a complete summary or a summary of a particular year as well as the tape serial number if tape generation is requested.

Note: The year entered must fall within 1900 and 4712.

When you choose to generate the report by a particular year, this field becomes enabled and mandatory.

If you choose to run the complete summary this field remains disabled.

PROCESS > COMPLETED > TPP SERVICE CREDIT SUMMARY REPORT

This report provides a summary of every Employee and their service credit for the period selected. 

PAYROLL > REPORTING MENU > ANNUAL REPORTS > WCB Reports

This process generates four Workplace Safety and Insurance Board (WSIB) reports.

NOTE: Percentage Increase for Projection is disabled when the report type “Actual Report Using Data for Completed Base Year” is selected. Otherwise, this field is enabled. The value entered in this field must be in the range of 0 to 99.999.

PROCESS > COMPLETED > SUMMARY WSIB EARNINGS REPORT

Important Note: This report can be run annually to produce the entire year summary – or it can be run Month by Month to reconcile on a per month basis; all year long. 

This can be done because every single time the report is run, it outputs both. 

PAYROLL > REPORTING MENU > ANNUAL REPORTS > PENSIONABLE AND INSURABLE EARNING REVIEW

This module produces the Pensionable and Insurable Earnings Review (PIER) report which contains employee year-to-date CPP and EI deduction information of all employees maintained on the system.

**Configure the Employee Groups & Year, then choose Submit**

NOTE: There must be Year-to-date reports for the Employee Group within the year specified, or an error message will appear.

PROCESS > COMPLETED > P.I.E.R REPORT

This report is used to check CPP, CPP2 and CPP_GROSS, along with EI, to compare the Deducted Amounts against Calculated amounts. 

NOTE: Any discrepancies noticed here can be due to things such as; 

• Wrong assessable (SEM wrong mappings)
• Incorrect manual override
• Top-ups

The functionality of the P.I.E.R Report is to ensure that you don’t owe anything, and so that the CRA is less likely to have questions about any T4’s being incorrect.