Skip to main content

Compensation Accumulator Simple Format Import and Comp Accumulator Simple Format Import by PaySource - File Requirements and Sample Files

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 C

Updated over 2 weeks ago

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

Did this answer your question?