North
Dakota Teachers Retirement Report - New Format Setup ProceduresThe instructions below are for generating the new format of the North Dakota Teachers Retirement Report, which is expected to go into effect at some point during the last quarter of 2024.
Note: Complete the North Dakota Teachers Retirement Report - New Format Setup Procedures for each employee who earned teachers retirement before completing the steps listed below to generate the North Dakota Teachers Retirement Report - New Format.
North
Dakota Teachers Retirement Report - New Format Setup Procedures
From the Payroll screen, select the Government Reporting menu and then North Dakota Teachers Retirement Report - New Format.
If not previously done, complete the Import Permitted Values option to import all the valid codes that were provided to SUI by the North Dakota Retirement Office for employment change reasons, enrollment types, gender, marital status, and pay codes.
Steps
to Import Permitted Values
Tip: If needed, edit the codes within the Permitted Values section of the North Dakota Teachers Retirement Report - New Format.
Steps
to Edit Permitted Values
At the North Dakota Teachers Retirement Report - New Format screen, click the Report Options tab and complete the information.
Enter the month for which to generate the report in the Ending Month field. Use the mm/yyyy format or click the down-arrow button to select the desired date. The default of the most recent (greatest) month used as the Processing Month in Payroll will appear, but can be changed.
Enter the number for your school district (up to 5 digits) in the Organization Code field.
Enter the correct model number (0 for Model 0, 1 for Model 1, 2F for Model 2 Full (All), or 2P for Model 2 Partial) utilized by the school district in the Employer Model field, or click the down-arrow button to select the correct one.
If you expense payroll as part of the end of fiscal year process, select the Subtract Expensed field if the report is being generated for a month in which the payroll had previously been expensed (for example, if the payroll had been expensed in June, select this field in July and August). A checkmark will appear in the box if the field is selected.
If you expense payroll as part of the end of fiscal year process, select the Include Expensed field if the report is being generated for the same month in which the payroll was expensed (for example, if the payroll was expensed in June, select this field in June). A checkmark will appear in the box if the field is selected.
Select the Include Last Date Taught and Hours field to generate the last date worked and hours worked for all employees as part of the retirement report at the end of the fiscal year. A checkmark will appear in the box if the field is selected.
Note: If an employee has a status of Deceased or Terminated, the last date worked and hours worked will generate and print on the retirement report automatically even if this field is not selected.
Click the down-arrow button for the ND Teaching License Number field to select the correct text custom field defined in the Employee File to track the license number for employees as issued by the state.
Only for school districts with the Human Resources module, select the Use Human Resources field located to the right of the ND Teaching License Number field to have the system use the license number from the most recent certificate as entered on the Certificates screen in the Employee File. A checkmark will appear in the box if the field is selected.
Note: If this field is selected and a custom field is entered in the ND Teaching License Number field, the information entered in the custom field (if completed) will override the license number for an employee as entered in the Employee File. This field is disabled for those school districts without the Human Resources module.
Click the down-arrow button for the License Expiration Date field to select the correct date custom field defined in the Employee File to track the date the teacher certificate (license) expires for employees.
Only for school districts with the Human Resources module, select the Use Human Resources field located to the right of the License Expiration Date field to have the system use the expiration date from the most recent certificate as entered on the Certificates screen in the Employee File. A checkmark will appear in the box if the field is selected.
Note: If this field is selected and a custom field is entered in the License Expiration Date field, the information entered in the custom field (if completed) will override the expiration date as entered in the Employee File. This field is disabled for those school districts without the Human Resources module.
Click the down-arrow button for the Member Exceeded IRC 401(a)(17) Limit field to select the correct referenced custom field defined in the Employee File to track whether employees reached the limit if different than the default.
Enter Yes or No to use as the default for whether employees reached the limit in the Default field for Member Exceeded IRC 401(a)(17) Limit for those employees where the Member Exceeded IRC 401(a)(17) Limit custom field was left blank.
Click the Save button.
Click the Pay Groups tab to select the pay groups to include on the Enrollment Reporting file. (Note: The selected pay groups do not apply to the Employee Contribution Reporting file.)
Note: The pay groups defined (within the Pay Group File) to be included on the North Dakota Teachers Retirement Report - New Format (for the Enrollment Reporting file only) are selected by default, but can be changed if needed; if changes are made here, the changes will also be reflected in the Pay Group File.
To select a pay group, click the box under the Selected column to the left of the pay group ID. A checkmark will appear in the box if the pay group is selected.
To select all of the pay groups, click the Select All button located above the Pay Groups List.
Click the Save button.
Click the Deductions tab to select which deductions are set up for the various retirement options.
Tip: To lock a column in place so that it does not move while scrolling the information in the grid, click the pushpin located to the right of the desired column heading. Once the pushpin has been selected for a column, the pushpin will appear vertical to indicate the column is locked, and the locked column will move to the left and appear in front of all unlocked columns. To unlock a column, click the pushpin again; the pushpin will appear horizontal to indicate a column is unlocked. If the screen is closed and re-opened, or the Save button is clicked, the settings for the pushpins will go back to the defaults.
For each retirement deduction, enter which share (Employee, Employer, or Both) of the deduction to include on the report in the field under the column for the appropriate category (EE Pre-Tax Contributions, EE After-Tax Conributions, ER Pick-Up Pre-Tax Contributions, or Employer Contributions), or click the down-arrow button in the field under the appropriate category to select the correct one.
Click the Save button.
Click the Pay Codes tab to select which pay codes are set up for the various pay code categories as defined by the state.
For each applicable pay code, enter the appropriate code for the category as defined by the state in the Pay Code field (column), or click the down-arrow button in the field to select the correct one.
Click the Save button.
7. Click the Report Options tab and then click the Execute button to generate the report.
8. To view the information for employees included on the Employee Contribution Reporting file and manually make changes if necessary, click the Contributions tab.
Note: Only the employees with contributions for the month the report was generated appear on the Contributions tab. Only the fields that appear in white (rather than gray) can be changed. The Transaction Type field for all employee records will be RGLR for Regular, but can be changed as needed. If applicable, the number entered or generated in the Hours Worked field will be rounded to the nearest whole number, as required by the state retirement office. To delete an employee, click the Delete button to the left of the Employee ID.
To view the payroll earnings information for an employee, click the plus sign (+) in the box in front of the employee to expand the record. The pay code and earnings for the employee appears on the screen with each different pay code category listed separately.
Note: To delete a payroll earnings record for an employee, click the Delete button to the left of the desired record. If needed, to add a new record for an employee, complete all the fields of information in the blank line (indicated with an asterisk) and click the Save button.
9. To view the information for employees included on the Enrollment Reporting file and manually complete the records, click the Enrollment tab.
Note: Only the employees in the selected pay groups with a most recent hire/rehire date or latest termination date (as entered in the Employee Dates List on the Employment screen in the Employee File) that is within the month the report was generated appear on the Enrollment tab. Only the fields that appear in white (rather than gray) can be completed or changed. To delete an employee, click the Delete button to the left of the Employee ID. If needed, to add a new record for an employee, complete all the fields of information in the blank line (indicated with an asterisk) and click the Save button.
The retirement report can then be generated to paper or a file (or both).
Printing to Paper:
From the North Dakota Teachers Retirement Report - New Format screen, select the Reports menu and then select ND TFFR.
Creating a File:
Complete the Create Report File option by selecting the appropriate option: Create Contributions File or Create Enrollment File.
After the retirement report is printed and the file created, click the X in the upper right-hand corner to close the screen.
