ICMA Report

Human Resources > State Requirements > ICMA Report

Created from selected retirement and pension benefits and deductions, the ICMA Report and transmittal file will include retirement loan data:

The following setup is required:

  • The Employment tab of Workforce Administration needs to include a user-defined field (UDF) for the loan number.
  • The Deduction and Benefit pages in Maintenance need a UDF to identify the type of retirement loan.
  • The Deduction page needs to include a user-defined check box to identify deductions as ICMA loans.

Employment Tab: ICMA Loan Number

  1. Navigate to Maintenance > new world ERP Suite > Security > User-Defined Fields.
  2. In the Record Type field, select Employee Employment.
  3. In the Maintenance Type field, select Attributes.
  4. Click the New button. The User-Defined Field dialog will open.
  5. In the Name field, type ICMA Loan Number.
  6. Select Text as the Data Type.
  7. In the Maximum Length field, type 3.

  8. Click OK.

Deduction and Benefit Pages: ICMA

  1. Navigate to Maintenance > new world ERP Suite > Security > User-Defined Fields.
  2. In the Record Type field, select Deduction.
  3. In the Maintenance Type field, select Attributes.
  4. Click the New button. The User-Defined Field dialog will open.
  5. In the Name field, type ICMA.
  6. Select Text as the Data Type.
  7. In the Maximum Length field, type 4.

  8. Click OK.

    To set up the Benefit UDF, repeat steps 1-8, substituting Benefit for Deduction in step 2.

  1. Navigate to Maintenance > new world ERP Suite > Security > User-Defined Fields.
  2. In the Record Type field, select Deduction.
  3. In the Maintenance Type field, select Attributes.
  4. Click the New button. The User-Defined Field dialog will open.
  5. In the Name field, type ICMA Loan.
  6. Select Check Box as the Data Type.

  7. Click OK.

  1. Navigate to Maintenance > Human Resources > Deductions and Benefits > Benefits.
  2. Select a ICMA benefit.
  3. Click the User-Defined Field button.

  4. Referring to the table below, type the appropriate code in the ICMA field:

    Code Description
    ER Employer
    EE Mandatory Pre-Tax
    EE Voluntary Pre-Tax
    EV Mandatory After-Tax
    RT Roth

  5. Click Save.

    To set up the deduction, repeat steps 1-5, navigating to Deductions in step 1 and selecting a deduction in step 2.

  6. Select an ICMA deduction.
  7. Click the User-Defined Field button.
  8. Select the ICMA Loan check box. Do not fill in the ICMA UDF.

  9. Important: For ICMA Loan deductions, fill in a Life-to-Date Limit.

To set up an employee to have these benefits and deductions, follow these steps:

  1. Navigate to Human Resources > Workforce Administration > Search > Employee > Payroll Data.
  2. Click the Deductions link. The page will scroll to the Deductions section.
  3. Click New.
  4. Select the appropriate ICMA deduction.
  5. Click OK.
  6. Fill out the rest of the deduction data.

  7. Click Save.

When you run the ICMA Report, make sure to select the benefits and deductions you set up with the ICMA user-defined fields, including the ICMA loan deductions.

After the report has generated, a message will display at the bottom of the page, giving you the option to open the transmittal file or save it. The report will be sent as a PDF to myReports.

The report output will contain two new columns: Loan Number and Loan Payoff (Yes or No).

The ICMA Report and transmittal file support the reporting of multiple loans per employee.

To set up multiple loan reporting, add as many user-defined ICMA Loan check boxes as you need to the Deduction page in Maintenance and corresponding ICMA Loan Number fields to the Employment tab in Workforce Administration; for example, if you add a deduction check box named ICMA Loan 1, also add a corresponding employment field named ICMA Loan Number 1. A deduction check box named ICMA Loan 2 requires a corresponding employment field named ICMA Loan Number 2 and so on.

Note: To show on the transmittal file, each ICMA loan deduction must have a life-to-date limit set on it.

  1. Navigate to Maintenance > new world ERP Suite > Security > User-Defined Fields.
  2. In the Record Type field, select Deduction.
  3. In the Maintenance Type field, select Attributes.
  4. Click the New button. The User-Defined Field dialog will open.
  5. Type the Name--for example, ICMA Loan 1.
  6. Select Check Box as the Data Type.

  7. Click OK.

    To set up more ICMA loan check boxes, repeat steps 4-7, changing the Name of each check box accordingly.

  1. Navigate to Maintenance > new world ERP Suite > Security > User-Defined Fields.
  2. In the Record Type field, select Employee Employment.
  3. In the Maintenance Type field, select Attributes.
  4. Click the New button. The User-Defined Field dialog will open.
  5. Type the Name--for example, ICMA Loan Number 1.
  6. Select Text as the Data Type.
  7. In the Maximum Length field, type 3.

  8. Click OK.

    To set up more ICMA Loan Number fields, repeat steps 4-7, changing the Name of each field accordingly.

  1. Navigate to Maintenance > Human Resources > Deductions and Benefits > Deductions.
  2. Select an ICMA deduction.
  3. Click the User-Defined Field button.
  4. Select the appropriate ICMA Loan check box. Do not fill in the user-defined ICMA field.

  5. Important: For ICMA loan deductions, fill in a Life-to-Date Limit.

  1. Navigate to Human Resources > Workforce Administration > Search > Employee > Payroll Data.
  2. Click the Deductions link. The page will scroll to the Deductions section.
  3. Click New.
  4. Select the appropriate ICMA deduction.
  5. Click OK.
  6. Fill out the rest of the deduction data.
  7. Click Save.
  8. Click the Employment tab.
  9. Scroll to the user-defined ICMA loan number field that corresponds with the ICMA loan on the deduction.
  10. Fill in the loan number.

  11. Click Save.

When you run the ICMA Report, make sure to select the deductions that have the user-defined ICMA check boxes selected.

After the report has generated, a message will display at the bottom of the page, giving you the option to open the transmittal file or save it. The report will be sent as a PDF to myReports.

ICMA Report PDF