Monthly Retirement Report Instructions

Use the Monthly Retirement Report to print the monthly retirement and fringe information required by the Maine MSRS retirement office for certain municipalities and school districts.  This report also generates transactions for magnetic filing, fringe processing and the Retirement Detail Report.  You can define up to nine different combinations of report selections and save them for future use.  You can optionally print the summary page for the Consolidated or Non-Consolidated plan.

For additional information, click More.

Directions:

To see directions for...

• Opening the Monthly Retirement Report, click More.

   

  1. Click Reporting from the Menu Bar.

  2. Click Government Reports.

  3. Click Monthly Retirement Report.
     
     Or, use the keyboard shortcut:  [ALT] [e] [g] [r].

   

  Window Examples:

  Monthly Retirement Report Prompt:

  

   

  Report Writer Prompt:

  

   

  Monthly Retirement Report Summary Page Prompt:

  Tip:  Click No Summary to omit the summary page from the report.

  

   

• Choosing the selections at the prompt windows, click More.

   

  Procedure:

  1. Fill in the Monthly Retirement Report prompts described below.

  2. Click Continue to display the Report Writer prompt.

  3. Review the Report Writer prompts and make changes, if applicable.
     Tips:

  4. To send the report to the Print View window, enter the appropriate Printer Number (usually 5).

  5. For more information, refer to the Report Writer Overview.

  4. Click OK to display the Retirement Summary prompt.

  5. Fill in the Retirement Summary prompts described below.

  6. Click Continue to run the report.

   

  Monthly Retirement Report Prompts Options Tip: To see more information about a field, click the hyperlink for the field name.
  Monthly Retirement Report Prompt Example:
  Run Code	To include a specific group of employees in the report, click the Run Code in the drop-down list.  (1.0 numeric) Tip:  To specify all employees, click All Run Codes.
  Report Type	To specify the report type, click one of the following options in the drop-down list: 1 - Participating Local District 2 - School Support 3 - Teachers Tip:  The Report Type is required for magnetic filing.
  Report Selection	To specify a selection number for an existing or new group of report criteria, click the number in the drop-down list or simply type the number in the field.  You can use the same criteria on subsequent reports.  (1-9) Tips: If any report criteria has already been defined for the selection number, you will see the recalled information filled in. For consistency, you may want to use the same Report Selection number as the Run Code number. If the report criteria is for a new selection, you will see New displayed next to the selection field. After you fill in the information and click Continue , the information for the current selection is automatically saved for future use. To Search for an existing Report Selection, click Search .
  	To create another version of the report for the same Report Selection number, click Next. Keyboard shortcut:  [ALT + n] Tips: Most facilities, including schools, can skip this button. This creates a second record for a particular Report Selection. Example:  You may want to print two versions of the report for Run Code 1 - one for retired employees and one for non- retired employees.  First enter Report Selection 1 and fill in the fields for retired employees and run the report.  Then specify Report Selection 1 and click Next; fill in the fields for non-retired employees.
  Report Title	Enter the Report Title to print on the report.  (up to 15 characters)
  Employer Name	Enter the name of the employer, municipality or school district.  (up to 30 characters)
  Employer Code	Enter the assigned Employer Code.  (up to 10 characters)
  Number of Pay Periods	Enter the Number of Pay Periods to include in this report.  (1.0 numeric)
  Pay Periods Ending	Enter up to five Period Ending Dates for the Pay Periods to be included in this report.  Enter a single space between each date.  (MM/DD/CCYY) Example: 04/03/2006 04/10/2006 04/17/2006 04/24/2006 04/31/2006 Tip:  Although the Period Ending Dates are informational-only on the report, they are required for magnetic filing.
  Basic Monthly Insur. Rate	Enter the Basic Monthly Retiree Insurance Rate (established by the MSRS).  (1.2 numeric) Note:  If a flat Retiree Ins Amount exists for an individual employee, the flat amount overrides the amount calculated by using the rate.
  Retired	Specify if the report is to include retired employees. To include only retired employees, select the box. To include only active employees, de-select the box. Tip:  Retired employees are assigned to Retirement Code 5.
  Codes List Area Tips: To select the gross wages for certain groups of employees for the report, enter the applicable Position Classification Codes and Personnel Status Codes.  For an employee to be included in the report, all criteria entered in a row must match the employee's information (AND logic).   You can enter selection criteria two ways: Click an option in the Code Selection drop-down list to select groups of codes. Or, manually enter the specific Position Classification Codes and Personnel Status Codes in the Codes List.
  Codes List Example:
  Code Selection	To select groups of Position Classification Codes and Personnel Status Codes, click one of the following options in the drop-down list, and then click Add : Drop-Down List Example: Options: blank:  Manually enter the Position Classification Codes and Personnel Status Codes into the Codes List. All Position Class Codes:  The report includes employees for all Position Classification Codes. '0' - All PLD:  The report includes all Participating Local District employees with Position Classification Codes that have "0" (zero) in the first character. 'N' - All School Support:  The report includes all School Support employees with Position Classification Codes that have "N" in the first character. 'Y' - All Teachers:  The report includes all Teacher employees with Position Classification Codes that have "Y" in the first character. AllPer Status Codes:  The report includes employees for all Personnel Status Codes. All Status Codes Included in Totals:  The report excludes employees assigned to all Position Class Codes from the totals, but includes them in the detail. Tips: You can combine a Position Classification Code option with a Personnel Status Code Option. The selected option displays in the first row of the Codes List within the appropriate column.
  Position Classification Codes: Manual Entry	To manually add up to eight Position Classification Codes to the Codes List: Position the pointer in the row you want to update, within the Position Class Code column.  Click once. Confirm that the Item # for the row appears next to the entry field and that the field label changes to Position Class Code. Enter the new or changed value in the Position Class Code field. Click Add to make the change. Repeat for each field you want to update.
  Personnel Status Codes: Manual Entry	To manually add up to fourteen Personnel Status Codes to the Codes List: Position the pointer in the row you want to update, within the Personnel Status Code column.  Click once. Confirm that the Item # for the row appears next to the entry field and that the field label changes to Personnel Status Code. Enter the new or changed value in the Personnel Status Code field. Click Add to make the change. Repeat for each field you want to update.
  Status Codes Not Included: Manual Entry	To manually exclude specific Personnel Status Codes from the report totals, add the codes to the Codes List: Position the pointer in the row you want to update, within the Status Not Included column.  Click once. Confirm that the Item # for the row appears next to the entry field and that the field label changes to Status Code Not Included. Enter the new or changed value in the Status Code Not Included field. Click Add to make the change. Repeat for each field you want to update.
  Codes List	The Codes List displays the following fields in each of the 14 rows: Item #:  Identifies the row. Position Class Code:  Displays a Code Selection or the actual Position Class Code. Personnel Status Code:  Displays a Code Selection or the actual Personnel Status Code. Status Code Not Included:  Displays a Code Selection or the actual Personnel Status Code for omission.
  	To update a Code Selection or changed field, click Add or press [ENTER]. Keyboard shortcut:  [ALT + a]
  	To clear the value for a field in the Codes List: Position the pointer in the row that contains the field you want to clear (within the appropriate column).  Click once. Confirm the displayed Item #, field label, and field value in the entry field. Click Delete. Keyboard shortcut:  [ALT + d]
  	After entering the report prompts, click Continue to display the Report Writer prompts. Keyboard shortcut: [ALT + o]
  	To escape from the print routine, click Cancel. Keyboard shortcut: [ALT + c]
  	To delete all of the report prompt values for the currently displayed Report Selection, click Delete. Keyboard shortcut: [ALT + e]
  Monthly Retirement Report Summary Page Prompt Tips: There are two types of summary pages with different layouts, the Consolidated Summary and the Non-Consolidated Summary. As with the first prompt, the Summary Page criteria is saved with the Report Selection number for use on subsequent reports. After you enter the Report Writer prompts and click OK, you will see the Monthly Report Summary Page prompt. To omit the summary page, leave the fields blank, and then click No Summary . For detailed instructions for entering the summary page fields, refer to the appropriate MSRS Payroll Reporting Manual. Example:
  Telephone No.	Enter the Employer's Telephone Number.  (up to 14 characters)
  Person Preparing Report	Enter the name of the person preparing the report.  (up to 30 characters)
  Payroll Payments in Teacher Contract Year	Enter the number of payroll payments in the teacher contract year.  (3.0 numeric) Tip:  This field prints only on the Non-Consolidated Summary Page.
  Days Worked in Contract Year No.	Enter the number of days worked in the Contract Year.  (6.0 numeric) Tip:  This field prints only on the Non-Consolidated Summary Page.
  Covered Employees Previous Report No.	Enter the number of covered employees included in the previous report.  (3.0 numeric) Tip:  This field prints only on the Non-Consolidated Summary Page.
  Covered Employees Separated Last Month No.	Enter the number of covered employees separated last month.  (3.0 numeric) Tip:  This field prints only on the Non-Consolidated Summary Page.
  Covered Employees Added This Month No.	Enter the number of covered employees added this month.  (3.0 numeric) Tip:  This field prints only on the Non-Consolidated Summary Page.
  Covered Employees Separated This Month No.	Enter the number of covered employees separated this month.  (3.0 numeric) Tip:  This field prints only on the Non-Consolidated Summary Page.
  Participating District Employer Contributions % X Gross Wages	Enter the value for the participating district employer contributions percent (to be multiplied by the gross wages). (3.2 numeric) Tip:  This field prints only on the Non-Consolidated Summary Page.
  Participating Local Employer Contribution Amount	Enter the amount of the participating local employer contribution.  (6.2 numeric) Tip:  This field prints only on the Non-Consolidated Summary Page.
  Teacher Employer Contributions (Fed Funded % X Gross Wages)	Enter the value for the federally funded teacher employer contributions percent (to be multiplied by the gross wages). (3.2 numeric) Tip:  This field prints only on the Non-Consolidated Summary Page.
  On Consolidated Plan	To print the Consolidated plan summary page, select the box. To print the Non-Consolidated plan summary page, de-select the box.
  Update Retirement Fringe	To specify updating of the retirement fringe, select or de-select the box. Tip:  For this option to be active, the following Company Control Options must be set: Create Automatic Invoices/Checks must be 1 - Single Post or 2 - Dual Post at the Payroll 1 tab. Auto Fringe Active must be Y(es) at the Payroll II tab. Update Employee Fringes During Post must be Y(es) at the Payroll II tab. If any of these options are not set accordingly, the Update Retirement Fringe option is dimmed.
  Adjustment Invoice #:  1 - 3	Enter up to three invoice numbers for adjustments applied due to adjustment invoices.  (up to 10 characters)
  Adjustment Amount:  1 - 3	Enter up to three invoice amounts for adjustments applied due to adjustment invoices.  (3.2 numeric)
  	To run the report and include the summary page, click Continue. Keyboard shortcut:  [ALT + o]
  	To run the report and exclude the summary page, click No Summary. Keyboard shortcut:  [ALT + n]
  	To delete summary page prompt values for the currently displayed Report Selection, click Delete. Keyboard shortcut: [ALT + e]

   

• Report Sample, click More.

   

  To see an example of the report, click Monthly Retirement Report Sample.