Files can be submitted as Excel worksheets.
If you do not have Microsoft Excel, you can use Open Office Calc to prepare the Excel Worksheet. Open Office Calc is part of the free Open Office software suite. You can download the free Open Office software at http://download.openoffice.org/index.html.
You can download a sample Microsoft Excel Template from the Employer Access area of the IMRF Website.
Please note: the wage data must be on the first sheet.
Column Description |
Requirement Description |
employer_nbr |
Employer number (text): |
report_month |
Wage Report Month (text) |
report_year |
Wage Report Year (text) |
member_ssn |
Member Social Security Number (text) |
member_name |
Member Name (text) Enter two-part names without spaces or punctuation (e.g., ’Van Horn’ should be entered as ’VANHORN’ and ’O’Brien’ should be entered as ’OBRIEN’). |
member_gender |
Member gender (text) |
plan_code |
IMRF Member Plan Code Tier 1 (text)
See Section 4.23 for an explanation of ECO codes.
IMRF Member Plan Code Tier 2
|
current_wages |
Current Member Wages (number) |
current_contributions |
Current Member Contributions |