PR> State Reports> MA ICMA

Massachusetts ICMA Export

 

Summary

 

The Massachusetts ICMA Export tool is used to create an export file containing ICMA contribution, loan, and plan data.

 

Step by Step

 

1     Open the MA ICMA window (PR> State Reports> MA ICMA).

 

2     Configure the export.  

 

  • The Date Type field is used to specify which type of date will be used to filter the export.
    • Select Check to filter the export by the date on the check or select Period End to filter the export by the end date of the payroll period. Selecting one of these options will enable the From and To date fields above.
    • Select Batch to filter the export by batch number. This will enable the Batch Number and Batch Type fields below.
  • The Date From and Date To fields are used to specify a date range for the transactions that will be included in the export file.
    • These fields will only be enabled if Check or Period End is selected in the Date Type field below.
  • The Batch Type drop-down menu is used to select the type of batch you would like to display on the report.
  • The Batch Number field is used to select the batch number you would like to include in the report.
    • This field will only be enabled, and is a required field, if the Date Type field is set to Batch.
    • Enter a batch number or click the field search button to select one from a list. Only the batch of the type selected in the Batch Type field below will display in the window.
  • The Plan Code field is used to enter your organization's ICMA plan code.
  • The Deduction Code and Loan Code fields are used to filter the pay check history included in the export. Any payroll history that includes either of these two codes and falls in the data range specified above will be aggregated into their respective totals and displayed by employee. Click here for information on Deduction Code Maintenance.
  • Once the export file is configured, click the Export Settings button to display the expected file layout.
  • The MA ICMA Export layout is as follows (all values will be sorted by employee):
    • Contribution Record 1
    • Plan Code (6 character width)
    • “20001” (constant)
    • Blank Spaces (4 character width)
    • SSN (9 character width)
    • Last Name, First Name, Middle Initial (30 character width, right padded with spaces)
    • Blank Spaces (24 character width)
    • “3” (Constant)
    • Contribution Record 2
    • Plan Code (6 character width)
    • “20002” (Constant)
    • Blank Spaces (4 character width)
    • SSN (9 character width)
    • Negative Amount indicator(either “-“ or “ ”)
    • Amount (9 character width, no decimals, left padded with zeros)
    • Blank Spaces (44 character width)
    • “3” (Constant)
    • Loan Record 1
    • Plan Code (6 character width)
    • “30001”
    • Blank Spaces (4 character width)
    • SSN (9 character width)
    • Last Name, First Name, Middle Initial (30 character width, right padded with spaces)
    • Blank Spaces (24 character width)
    • “3” (Constant)
    • Loan Record 2
    • Plan Code (6 character width)
    • “30002”
    • Blank Spaces (1 character width)
    • “001” (Constant)
    • SSN (9 character width)
    • Negative Amount indicator(either “-“ or “ ”)
    • Amount (9 character width, no decimals, left padded with zeros)
    • Blank Spaces (44 character width)
    • “3” (Constant)
    • Plan Record 1
    • Plan Code (6 character width)
    • “10001”
    • Blank Spaces (4 character width)
    • SSN (9 character width)
    • Last Name, First Name, Middle Initial (30 character width, right padded with spaces)
    • Blank Spaces (24 character width)
    • “3” (Constant)
    • Plan Record 2
    • Plan Code (6 character width)
    • “10002”
    • Blank Spaces (4 character width)
    • Federal Tax ID (9 character width)
    • Negative Amount indicator(either “-“ or “ ”)
    • Amount (9 character width, no decimals, left padded with zeros)
    • Blank Spaces (25 character width)
    • “03” (Constant”)
    • Blank Spaces (6 character width)
    • Check Date (8 character width)
    • Blank Space (3 character width)
    • “3” Constant

 

3     Export the file.