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.
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 Sample Wage Code and Pay Register Import Template.
Excel
Column
|
Column Name
|
Req’d
|
Description
|
Valid
Field
Values
|
A
|
Account #
|
Y
|
Account Number
|
**
|
B
|
Primary
Indicator
|
N
|
Is this to be the Primary Wage Code for Pay Register Import?
|
Yes No
|
C
|
Primary WC
|
N
|
Wage Code When Primary
|
|
D
|
Secondary WC
|
N
|
Wage Code When Secondary
|
|
E
|
Shadow
Primary WC
|
N
|
Wage Code When Shadow Primary
|
|
F
|
Shadow
Secondary WC
|
N
|
Wage Code When Shadow Secondary
|
|
G
|
Override Desc
|
N
|
Pay Register Override Line Description
|
|
H
|
Sequence
|
N
|
Pay Register Sequence number
|
|
I
|
Wage Type
|
N
|
Pay Register Wage Type
|
Earnings
Deductions
No Impact
|
J
|
Tax Type
|
N
|
Pay Register Tax Type
|
Income Tax
Social Tax
Income & Social Tax
Not Applicable
|
** 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. If the inactive account exists on the pay register tab, that tab’s fields will be populated with the import.