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 From and 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 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 to the right.
- 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.
- 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 Batch Number field label 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 Batch Type drop-down menu is used to select the type of batch you would like to display on the report.
- Once the export file is configured, click the Display icon to display the expected file layout. Click here for information on File Layouts.
- 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.
- Click the Confirm icon when complete to generate the export file immediately or enter a date and time in the field next to the Confirm icon to schedule the export file to generate at a later time.
- You can view the progress of the export on the Job Viewer window (SS> Utilities> Show Scheduled Jobs). Click here for information on the Jobs Viewer window.
- Once the export has finished processing, the Export Settings window will open. This window is used to specify the export path for the file.
- Check the Open toggle if you would like to open the exported file after it is saved locally.
- Enter the export path location and click the Save icon to export the file to the local path.