Recurring Earnings/Deductions Report

The Recurring Item file import feature provides the ability to create Recurring Earnings, Deductions, and/or Employer Contributions for multiple employees simultaneously through a file upload. This may be done using the ExponentHR standard file template or a custom template that can be created to match your existing file.

Once the template data has been uploaded, a system validation flags any items on the file that are a potential duplicate of an existing recurring item record. For the flagged items, you can compare the two items and choose to do any of the following actions:

Additionally, the File Import option may be used to apply one-time retirement contribution adjustments and to assign multiple employees to an existing Group Recurring Item record. The templates for both of these actions are also available for selection in the Recurring Items Import tool.

For historical review, the Recurring Items Import page displays all previously uploaded files with the ability to see the details of each file.

Note: If your upload file does not presently match the ExponentHR Standard file template, a custom template can be created to match your file.

On the Recurring Items Import page, select the Create ExponentHR Standard Template option in the Setup Options drop-down list.
Choose the appropriate recurring import type (ex. earnings, deductions, etc.) in the File Type drop-down list.
Click the Create button.

The Help Glyph on page describes the expected values of each column. You can edit the values in these files and then upload it into ExponentHR as a comma-separated values (.csv) file.

On the Recurring Items Import page, select the Template Setup for Custom File option in the Setup Options drop-down list.
Select an existing custom template to edit or choose the Add in the Options drop-down menu and select the import type (ex. earnings, deductions, etc.)
Click Add another row to include additional columns in the template that are on your import file.
Use the Up/Down arrows to rearrange the columns to place them in the order that they appear on your import file.
To map items on your import file to the values as displayed in the ExponentHR system, click the Map Values link next to any applicable column.
To remove any columns from the custom template, click the Delete icon.
Click the Save button to keep all changes made.

4. In the Template drop-down list, select the template that matches the type of upload being performed.

5. Click the Select File button to locate the saved file on your computer or device.

The Recurring Items Import Errors page displays with a list of any general or critical errors that were identified when validating the import. The Print button makes it convenient to save a list of the validation results.

The Review: Recurring Items Import page lists all records to be imported (validation successful) and those that received a validation error and are unable to be imported as-is. The Print button makes it convenient to save a list of the validation results.

Result: The Recurring Items Import page is displayed with a record of the file just imported in the Previously Imported Files section. At any time, you may use the onscreen filters to search for historical uploads and click on the file name to see import/validation results.

2. Click the Remove Multiple Records feature under the Options drop-down menu.

3. Check the box next to the recurring item records you would like to inactivate.

4. Choose whether to inactivate the records immediate or on a future effective date.

5. Click the Remove button.

Recurring Items File Import