In order to use the Compensation Accumulator, system and/or company exchange rates must be imported into Equus Platform. Rules for how exchanges rates are looked up can be set on the Exchange Rate Settings screen at the company level.

The comp accumulator data can be reported in the following currencies: System, Company, Primary Payroll, Secondary Payroll and Payment (the currency that the compensation was initially imported in). To be able to do a currency conversion from payment currency to the other currencies listed above, exchange rates will need to be imported into the system.

Note: The import will error if an exchange rate cannot be found between the payment currency and the primary payroll system currency.

Sample file 1- user friendly version using TO_PAYROLL_ID as the AssignmentTableColumnValue

Sample file 2 - ID is used as the AssignmentTableColumnValue and doesn't use tax year columns for tax accounts.

Note that when the spreadsheet is deployed to locations to collect data for input, rows 3-7 are hidden. Only the compensation data worksheet/tab in the Excel file will be used for the import step of the Compensation Accumulator - Process Overview. The worksheet/tab will contain :

Configure the Excel file as per the below steps:

Step 1: Row 2 has data type information. The data types are AssignmentTableColumnValue, Amount, Tax Year, Description, PaymentDate and Currency. Any other header name will not have its column of data imported.

AssignmentTableColumnValue – row 3 in this column is the assignment identifier database field that will be used to lookup an assignment in the Equus Platform. Possible values are

Note: Compensation Data cannot be imported for Inactive Assignments.

Amount – any non-zero currency value will be imported if a valid account is specified in row 3 of the column.

Tax Year – Some columns could be for a tax account. If you would like to associate the amount with a tax year, then add a new column to the right of the Amount column for that account. Then specify the tax year that the amount should be associated with in each data row.

PaymentDate – this field is the date that the source system is reporting the payment amounts.

Note: On the production report that is generated in the payroll reporting process, amounts are grouped by month. The PaymentDate value is what determines which month bucket that the payment will be reported under.

Currency – If necessary, each row in the compensation data worksheet could be in a different currency. The currency value must be a valid 3 character Equus Platform currency.

Note: On the production report that is generated in the payroll reporting process, amounts will be shown as converted from the payment amount currency into the primary payroll system currency.

Step 2: Row 3 has account number, sub account number or wage code

The value in row 3 should be specified either without an account number or account number “.” sub account number or wage code. Each account specified must be an active account for the company that the data is being imported into.

Note: For wage codes that are imported in based on selecting the Payroll System from the dropdown on the Comp Accumulator Wage Code Import by PaySource import, a conversion of that wage code into an associated account will occur. It will take into account whether that payroll is the home or host payroll system for that assignment and assign each line item and account.

Step 3: Data in rows 4-10 can be modified at will.

Step 4: Compensation data should not start until row 11 of the worksheet.

Step 5: You can have as many columns in the file as the Excel worksheet will allow for, as long as each column has valid row 2 and row 3 values.