RSA Retirement - Contribution Report

The RSA Retirement - Contribution Report provides information about employees' contributions towards RSA Retirement.

Menu Path

Choose Human Resources from the main navigation menu, then choose State. Click RSA Retirement - Contribution Report.

Submission Period

On any specified pay date.

Selection Rule

Includes all the employees who are enrolled to contribute towards RSA Retirement as part of Employee Setup.

Process

To create a report:

If needed, update the related setup to reflect any changes.

1. Load the data for the report.
2. Create the report file and verify that data was loaded correctly.
   
   • Review the log file for possible errors, if any.

   • Use the maintenance options to add or delete records or to correct data. Note that any changes that you make here must be duplicated in the source data.

     

     If errors require changes to the setup or source data, you must purge the loaded data, then repeat steps 1 and 2.

3. Once the data is correct, create the RSA Retirement - Contribution Report.

Download the RSA Retirement - Contribution Report and follow the State's submission procedures.

Setup

Retirement Deductions

Map the retirement deductions to the employee deductions.

1. Choose Setup, then Retirement Deductions.
2. Filter records using the following criteria:
   • Deduction Code
   • Description
   • Retirement Type
   • Plan Type
     To specify filter criteria, select an option from the list, enter a keyword or select an option in the following field, and click Add. The filter is added.
3. To add a new record, click Add Record. Specify valid information in the required fields and click Save. Click Yes.
4. To edit a record, click the ellipsis in the Actions column and select Edit.
5. To delete a record, click the ellipsis in the Actions column and select Delete. Click Yes.

Prerequisites

• Enter valid RSA enrollment information on the Employee Information page.
• Map the Payment Reason to Pay Code.

Load Data

You can load data based on Pay Date, Pay Period Begin Date, Pay Period End Date, and Employer Code. When you load data, all employees that are enabled for RSA Retirement deduction are loaded.

1. Choose Load.
2. Specify the Pay Date.

3. Specify the Pay Period Begin Date and Pay Period End Date.

   

   The date range is used to identify void or manual checks.

4. Enter the Employer Code.

5. Click Load, then Yes. The AL RSA Retirement Contribution Load Summary Report is created.

6. Save the file, then click OK.
7. Navigate to the folder containing the summary report file.
8. Inspect the file. Update data, if needed.
9. Repeat steps 1 to 8 until all the required data is loaded.

Maintain Data

You can correct loaded data before submitting the report. However, any corrections to the application's information must also be updated in the source data.

1. On the RSA Retirement - Contribution Report page, you can filter records by the following criteria:
   • Pay Date
   • Employee Number
   • Social Security Number
   • Last Name
   • First Name
   • Contribution Group
   • Position Status
   • Employee Contribution
2. To specify filter criteria, select an option from the list, enter a keyword or select an option in the following field, and click Add. The filter is added.
3. To add a record, click Add Record. Specify valid information in the required fields and click Save. Click Yes.
4. To edit a record, click the ellipsis in the Actions column and select Edit.
5. To delete a record, click the ellipsis in the Actions column and select Delete. Click Yes.

Create File

1. Choose Report.

2. Select the Pay Date.

3. Select the Payroll Frequency.
4. Create a hard copy of the report to verify data before you create the electronic file:
   
   1. Under File Type, select Hard Copy.
   2. Under File Format, select PDF or Excel.
   3. Under Group By, select Contribution Group or Payroll Frequency.
   4. If you have security to view the entire Social Security Number (without masking) and want to include the entire Social Security Number, select Print Full Social Security Number.

   5. Click Create, then click Yes.
      The RSA Retirement - Enrollment Report is created.

5. Save the file and navigate to the folder containing the report file.

6. Inspect the file. Update data, if needed.
7. Repeat steps 1 to 6 until all the required data is included.
8. Create the electronic file:
   1. Under File Type, select Electronic File.
   2. Click Create, then click Yes.
      The electronic file is created.
9. Save the file and click OK.

Purge Data

You can purge the data for the report in the following scenarios:

• You want to discard the data for the report completely.
• You want to change the setup or employee data and reload the data.

1. Choose Purge.
2. To purge records for a specific pay date:
   
   1. Select the Pay Date option.
   2. Select a Pay Date.
   3. Click Submit.
   4. Click Yes, then OK.
3. To purge records for a specific year:
   
   1. Select the Year option.
   2. Select a Year.
   3. Click Submit.
   4. Click Yes, then OK.