Comp Accum Import by Wage Code Import - Additional Details

In order to import the user is required to choose a Payroll System and a Payroll Pay Date to import. A list of payroll dates set-up by Payroll System will show in the Payroll Pay Date option or a ‘Custom Date’ can be selected from the dropdown and then entered in the Custom Pay Date field below. Upon import line items will use an Exchange Rate Date equal to the Payroll Pay Date or Custom Pay Date unlike other imports that have you select the Exchange Rate Date settings manually.

If you want to remove data from a field you can enter <Blank> instead of data. The import will blank the data out of the specified field for you. If you just leave the field blank, the import will skip that field and not change the data that exists in that field.

For each entry in the import, if PAYMENT_DATE is specified then that date will override the payroll pay date for that item and the exchange rate at that date will be used.

The following table contains details about every field/column on the import file. If you are interested in utilizing this feature, please contact EQUUS for a copy of our Comp Accum Import by Wage Code (By PaySource) Import Template.

** If an account number does not exist in the system chart of accounts, that line item will error and not import. If an account is inactive, the data will import but will not be visible on the screen because the inactive account will not show on the active payroll’s list of account codes.