The Compensation Accumulator Simple Format Import screen and Comp Accumulator Simple Format Import by PaySource screen are available under the Import screen is available under the Import menu on the Company tab.
Import Wizard
You can utilize the Import Wizard feature for these types of imports. The Import Wizard does not require an import-formatted file, as it can transform and map the import file before processing. Click '
' to start.
Manual Process
If using the manual process, you must ensure that the import file follows the template format and meets the requirements below.
Sample Files
File Requirements
The Compensation Accumulator Simple Format Import and Comp Accumulator Simple Format Import by PaySource allows users to import line items into the compensation accumulator by wage code or by account number. This can be useful when wanting to take information from a non-primary/secondary payroll source and have that information reported to the primary payroll system through the compensation accumulator. A comma delimited (.csv) file with the first line/row of the file identifying the database elements and the remaining rows containing the detail of the data to be imported is utilized.
The format is fixed with the following 8 columns:
IDENTIFIER_FIELD,
IDENTIFIER_VALUE,
PAYMENT_DATE,
ACCOUNT_ID, or WAGE_CODE
SUBMITTED_AMOUNT,
TAX_YEAR,
SUBMITTED_CURRENCY,
DESCRIPTION,
IDENTIFIER_FIELD2, -- Note1
IDENTIFIER_VALUE2 -- Note1
Note 1: These are optional columns. If these columns are used in the import template & there is data in IDENTIFIER_FIELD2, there must be a corresponding data for IDENTIFIER_VALUE2. However, not all rows require both these columns to be completed.
Possible IDENTIFIER_FIELD/ IDENTIFIER_FIELD2 values are:
ID
EMPLOYEE_ID
NUMBER
FROM_EMPLOYEE_ID
FROM_NATIONAL_ID_NUMBER
FROM_PAYROLL_ID
FROM_SOCIAL_INSURANCE_ID
FROM_NATIONAL_TAX_ID
FROM_COUNTRY
TO_EMPLOYEE_ID
TO_NATIONAL_ID_NUMBER
TO_PAYROLL_ID
TO_SOCIAL_INSURANCE_ID
TO_NATIONAL_TAX_ID
TO_COUNTRY
Optional fields by import:
DESCRIPTION
WHERE_PAID
IDENTIFIER_FIELD2
IDENTIFIER_VALUE2
See Compensation Accumulator - Process Overview regarding the process steps including importing the completed CSV file.
Things to Note
All column headers should always be capitalized

