Option 1: A user report and the pay register import will be utilized to move data from the comp accumulator to the pay register.

Note: The system was designed to receive a complete pay register (all compensation, including host) from the primary payroll system.

Purpose: To use the shadow payroll and GSOE features of the Equus Platform.

Reason: Payroll systems are NOT sending entire pay registers in a data format. Either they are receiving pdf documents or only the portion paid by the primary payroll system.

The comp accumulator allows for import in multiple currencies, while the pay register only allows for primary payroll currency.

Using the following user report type, create a user report that mimics the pay register import file:

The comma-delimited pay register import file requires the following fields:

Column 1: ASSIGNMENT
Column 2: Database FIELD containing the employee identifier (ID, NUMBER, TO_PAYROLL_ID, etc.)
Column 3: Employee identifier value (ex. AB-9003)
Column 4: Wage Code (defined on the wage code tab of the primary payroll system)
Column 5: Amount in the primary payroll system’s currency
Column 6: (Optional) Payment Location (ex. Home, Host) This column is not required and can be omitted entirely or used on only select rows of data if necessary.

1. Once the user report is created, run it by clicking the Excel button.
a. The report should contain only comp data for one payroll system and one pay date.

2. Then delete the first 5 columns from the EXCEL file

3. Save the file as a comma-delimited file (should be only five columns)

4. From the Companies tab, the Processes menu group and the Imports menu, select the Pay Register Data Import.

5. Specify a payroll system and pay date (if pay dates don’t exist, the payroll calendar section of the payroll system screen.
a. The pay registers should be created in an “approved” status

6. Approved pay registers can be picked up in the shadow payroll process and will be displayed on the global statement of earnings report.