Monthly Retirement Report Sample

Monthly Retirement Report Detail Pages Fields Tips: To see more information about a field, click the hyperlink for the field name. To see more details about the report fields, refer to the appropriate Maine State Retirement System (MSRS) Payroll Reporting Manual. The numbers next to the field names relate to the labels on the report sample that appears later in this topic.
1. Report Title	Report Title (from prompt)
2. Run Date	System Date
3. Page	Page Number
4. Employer Code	Employer Code assigned by the MSRS (from prompt)
5. Rate	Basic Monthly Retiree Insurance Rate (from prompt)
6. Employer Name	Employer, municipality, or school name (from prompt)
7. Pay Periods Ending	Period End Dates (from prompt)
8. Active / Retired	"X" prints in the box indicating Active or Retired employees on the report. (from Retired option in prompt)
Tip: The following fields print for each employee that meets the selection criteria at the prompts.
9. SSN	Employee Social Security Number
10.Name	Employee Last Name, Employee First Name and MI
11. Life Ins. Code	MSR Life Insurance Code
12. Life Ins Prem	Total Life Insurance Premium
13. Earnable Compensation - L/S	MSR Local or State Funded Earnings Total for the current month
14. Employee Contributions	Retirement Deduction Withholding Amount Total for the current month
15. Monthly Hours or Days	MSR Expected Hours or Days per Pay Pd
16. Pay Rate Code	MSR Pay Rate Code
17. Rate of Pay	Employee Hourly Rate or Employee Salary Rate Tip: If the Report Type is 3 - Teachers, only Employee Salary Rates print.
18. Date of Hire	Employee Date of Hire
19. Employee Code - Status	MSR Personnel Status Code
20. Employee Code - Position	MSR Position Classification Code
21. Plan Code	MSR Report Remark Code Tip: Although only the first two characters of the Report Remark Code contain the Plan Code, the entire Report Remark Code prints.
22. Life Ins Level	MSR Annual Salary
23. Date of Birth	Employee Date of Birth
24. Earnable Compensation - Fed	MSR Federally Funded Earnings Total for the current month
25. Payback or Excess Contributions	MSR Payback Amount
26. Full Time Work Week Hours	MSR Expected Hours or Days per Pay Period
27. Work Weeks Per Year	MSR Expected Pay Periods per Year
28. Y-T-D Earnings	Y-T-D Earnings = YTD Gross Pay Earnings Totals + YTD Deduction Amount Totals for Annuities deductions
29. Page Totals	Page totals for... Life Insurance Premium Earnable Compensation Employee Contributions
30. Report Totals	Report totals for... Life Insurance Premium Earnable Compensation Employee Contributions

Detail Pages:

Selection Parameters for this Report Sample:
Run Code = 1	Report Type = 1 - Participating Local District
Report Selection = 1	Report Title = FAIRCITY MSR
Employer Name = TOWN OF FAIRCITY	Employer Code = P0999
Number of Pay Periods = 4	Pay Periods Ending: 08/04/2006 08/11/2006 08/18/2006 08/25/2006
Basic Monthly Insur. Rate: 1.30	Retired: No
Position Class Codes: ALL	Personnel Status Codes: ALL
Page Width = 132 Columns

Detail Page Sample:

Tip: Your report layout may vary from the following example, depending on your form design.

Detail Page Form Sample:

Tip: Your form may vary from the following sample.

Monthly Retirement Report Consolidated Summary Report Fields Tips: To see more information about a field, click the hyperlink for the field name. To see more details about the report fields, refer to the appropriate Maine State Retirement System (MSRS) Payroll Reporting Manual. Printing the Summary Page is optional. The numbers next to the field names relate to the labels on the report sample that appears later in this topic.
1. Report Title	Report Title (from prompt)
2. Run Date	System Date
3. Page	Page Number
4. Employer Code	Employer Code assigned by the MSRS (from prompt)
5. Rate	Basic Monthly Retiree Insurance Rate (from prompt)
6. Employer Name	Employer, municipality, or school name (from prompt)
7. Pay Periods Ending	Period End Dates (from prompt)
8. Active / Retired	"X" prints in the box indicating Active or Retired employees on the report. (from Retired option in prompt)
9. Person Preparing Report	Name of person preparing the report (from prompt)
10. Telephone No.	Employer Telephone Number (from prompt)
The following fields pertain to a specific Plan Code. Each Plan Code prints in a separate row along with its totals for the employees assigned to the Plan Code.
11. Plan Code	Plan Code Tip: One row prints for each Report Remark Code assigned to an employee. The first two characters of the Report Remark Code correspond with a Plan Code.
12. Rate	Employer Retirement Rate for the Plan Code Tips: This rate is maintained during MSR Plan Codes Maintenance. This field is zero if the Plan Code is not created during MSR Plan Codes Maintenance.
13. Earnable Comp	Earnable Compensation = Local or State Funded Earnings + Federally Funded Earnings
14. Employer Contrib	Employer Contribution = Employer Rate for the Plan Code X Earnable Compensation Tip: 14 = 12 X 13
15. IUUAL Cost (or Credit)	IUUAL Cost or Credit Amount Tip: This field is zero if the Plan Code is not created during MSR Plan Codes Maintenance.
16. Employee Contribs	Employee Contributions
17. Total Contribs per Plan	Total Contributions per Plan = Employer Contributions + IUUAL Cost or Credit Amount + Employee Contributions Tip: 17 = 14 + 15 + 16
18. Total Employer Contrib	Total Employer Contribution for report
19. Total IUUAL Cost (or Credit)	Total IUUAL Cost or Credit Amount for report
20. Total Employee Contribs	Total Employee Contributions for Report
21. Total Contribs for Report (A)	Total Contributions for Report is the sum of the Total Contributions per Plan Tip: The red letters in parentheses that follow some field names, such as (A), relate to the printed letters on the report.
The following fields pertain to Group Life Insurance Premium Data.
22. Basic Prems for Actives	Basic Insurance Premiums for Active Employees
23. Basic Prems for Retirees	Basic Insurance Premiums for Retired Employees
24. Supplemental Premiums	Supplemental Insurance Premiums
25. Dependent Premiums	Dependent Insurance Premiums
26. Premium Total(B)	Total Insurance Premiums = Basic Insurance Premiums for Active Employees + Basic Insurance Premiums for Retired Employees + Supplemental Insurance Premiums + Dependent Insurance Premiums Tip: 26 = 22 + 23 + 24 + 25
27. Total before (Credits)/Debits (C)	Total before (Credits)/Debits = Total Contributions for Report + Total Insurance Premiums Tip: C = A + B
The following fields pertain to the adjustment invoices entered at the prompt.
28. Adj Invoice # 1-3	Up to three invoice numbers for adjustments (from prompt)
29. Adj Invoice Amt 1-3	Up to three invoice amounts for adjustments (from prompt)
30. Total Adj (D)	Total Adjustments = Sum of Invoice Amt 1 - 3
Report Total
31. Total Remittance	Total Remittance = Total before (Credits)/Debits + Total Adjustments Tip: 31 = C + D
32. Signature Line	Prints the Signature, Title, Date line.

Summary Page - Consolidated:

Selection Parameters for this Report Sample:
Telephone No. = 353-3000	Person Preparing Report = Janet Smith
Payroll Payments in Teacher Contract Year = 52	Days Worked in Contract Year No. = 25
Covered Employees Previous Report No. = 390	Covered Employees Separated Last Month No. = 4
Covered Employees Added This Month No. = 3	Covered Employees Separated This Month No.: 5
Participating District Employer Contributions % X Gross Wages: 5.90	Participating Local District Employer Contribution Amount: 2.30
Teacher Employer Contributions: 1.75	On Consolidated Plan = Yes
Updated Retirement Fringe = Yes	Adjustments Invoices = 12345 - $12.30 67890 - $6.78 111213 - $1.35
Page Width = 80 Columns

Consolidated Summary Page Sample:

Tip: Your report layout may vary from the following example, depending on your form design.

Consolidated Summary Page Form Sample:

Tip: Your form may vary from the following sample.

Monthly Retirement Report Non-Consolidated Summary Report Fields Tips: To see more information about a field, click the hyperlink for the field name. To see more details about the report fields, refer to the appropriate Maine State Retirement System (MSRS) Payroll Reporting Manual. Printing the Summary Page is optional. The letters and numbers next to the field names relate to the labels on the report sample that appears later in this topic.
A. Report Title	Report Title (from prompt)
B. Run Date	System Date
C. Page	Page Number
1. Employer Code	Employer Code assigned by the MSRS (from prompt)
D. Rate	Basic Monthly Retiree Insurance Rate (from prompt)
E. Employer Name7.	Employer, municipality, or school name (from prompt)
F. Pay Periods Ending	Period End Dates (from prompt)
G. Active / Retired	"X" prints in the box indicating Active or Retired employees on the report. (from Retired option in prompt)
2. Telephone No.	Employer Telephone Number (from prompt)
3. Person Preparing Report	Name of person preparing report (from prompt)
4a. Payroll Payments in Teacher Contract Year	Number of payroll payments in the teacher contract year (from prompt)
4b. Days Worked in Year	Number of days worked in the contract year (from prompt)
5. Covered Employees Previous Report No.	Number of covered employees included in the previous report (from prompt)
6. Covered Employees Added This Month No.	Number of covered employees added this month (from prompt)
7. Covered Employees Separated Last Month No.	Number of covered employees separated last month (from prompt)
8. Covered Employees This Report No.	Number of covered employees this month (calculated by report)
9. Covered Employees Separated This Month No.	Number of covered employees separated this month (from prompt)
10. Gross Wages - Total Covered Employees	Earnable Compensation total for covered employees
11b. Participating District Employer Contributions %	Participating District Employer Contribution % (from prompt)
11c. Participating District Employer Contributions	Participating District Employer Contributions = Participating District Employer Contribution % X Earnable Compensation Tip: 11c = 10 X 11b/100
11a. Participating Local District Employer Contribution Amount	Participating Local District Employer Contribution Amount (from prompt)
12. Gross Wages (Federally Funded Teachers Only)	Federally Funded Earnings Totals
13a. Teacher Employer Contributions (Federally Funded %)	Employer Contributions - Federally Funded Percent (from prompt)
13b. Teacher Employer Contributions	Teacher Employer Contributions = Federally Funded Earnings total X Employer Contributions - Federally Funded Percent Tip: 13b = 12 X 13a/100
14. Employee Retirement Contributions	Employee Retirement Contributions
15. Total of Retirement Contributions	Total of Retirement Contributions = Participating District Employer Contributions + Participating Local District Employer Contribution Amount + Teacher Employer Contributions + Employee Retirement Contributions Tip: 15 = 11c + 11a + 13b + 14
16. Basic Premiums -- Active	Basic Insurance Premiums for Active Employees
17. Basic Premiums -- Retirees	Basic Insurance Premiums for Retired Employees
18. Supplemental Premiums	Supplemental Insurance Premiums
19. Depend Premiums	Dependent Insurance Premiums
20. Insurance Premiums Total	Premium Total = Basic Insurance Premiums for Active Employees + Basic Insurance Premiums for Retired Employees + Supplemental Insurance Premiums + Dependent Insurance Premiums Tip: 20 = 16 + 17 + 18 + 19
21a. Adj Invoice # 1-3	Up to three invoice numbers for adjustments (from prompt)
21b. Adj Invoice Amt 1-3	Up to three invoice amounts for adjustments (from prompt)
22. Total Remittance	Total Remittance = Total of Retirement Contributions + Premium Totals + Adjustment Amounts Tip: 22 = 15 + 20 + 21b

Summary Page - Non-Consolidated:

Selection Parameters for this Report Sample:
Telephone No. = 353-3000	Person Preparing Report = Janet Smith
Payroll Payments in Teacher Contract Year = 52	Days Worked in Contract Year No. = 0
Covered Employees Previous Report No. = 390	Covered Employees Separated Last Month No. = 4
Covered Employees Added This Month No. = 3	Covered Employees Separated This Month No.: 5
Participating District Employer Contributions % X Gross Wages: 5.90	Participating Local District Employer Contribution Amount: 2.30
Teacher Employer Contributions: 1.75	On Consolidated Plan = No
Updated Retirement Fringe = Yes	Adjustments Invoices = 12345 - $12.30 67890 - $6.78 111213 - $1.35
Page Width = 80 Columns

Non-Consolidated Summary Page Sample:

Tip: Your report layout may vary from the following example, depending on your form design.

Non-Consolidated Page Form Sample:

Tip: Your form may vary from the following sample.