Below is a description of the Spire Fields for this Import. 

Please refer to the User Manual for more information on how to do Imports.


Spire 3.11 Fields
Explanation
Example
Employee No (Required)Employee numberBELCHR
NameEmployee nameBell, Christopher
Address 1First address linePO Box 123
Address 2Second address line123 2nd street
Address 3 Third address lineUnit B
Address 4Fourth address lineAttn: Chris
CityCityLangly
ProvinceProvinceBC
CountryCountry - 3 digit codeCAN
Postal CodePostal codeV2Y 0E2
PhonePhone number555-555-5555
FaxFax number555-555-5555
EmailEmailChristopher@email.ca
Web pageWeb pagewww.christoperbell.ca
SIN (Required)Social Insurance Number 000000000
StatusEmployee status;
A = Active
L = On leave
T = Terminated
A
GenderEmployee gender;
F = Female
M = Male
M
Birth DateBirth date08/08/1980
Hire DateHire date01/01/2024
Termination DateTermination date03/01/2024
Review DateReview date02/28/2024
Job TitleJob TitleSales
Payroll Department CodeExisting payroll department code
SALES
Language CodeLanguage code;
E = English
F = French
E
Health NumberHealth number (up to 30 characters)1234-5678
Union NumberUnion number (up to 30 characters)123456789
Direct DepositEmployee is paid with direct deposit;
T = Yes
F = No
T
Bank InstitutionBank institution number
123
Bank TransitBank transit number12345
Bank AccountBank account number123456789
Tax TableProvince or State for taxes
BC
Federal TD1 ClaimFederal TD1 Claim form amount15705
Provincial TD1 ClaimProvincial TD1 Claim form amount 12580
Child careAmount used for child or other support payments, as authorized by a tax services office or tax center. The timecard Taxable amount will be reduced by the pay period portion of this annual amount.
500
Remote amountUnder the heading “Deduction for living in a prescribed zone”, enter the calculated annual amount for the employee living in a northern or intermediate zone.
0
Additional tax deductions (TD1 page 2)Additional tax deductions (TD1 page 2)
100
Estimated Expenses (comission)Estimated expenses for commission remunerated employees only 200
Estamated Pay (comission)Estimated pay for commission remunerated employees only1500
Pay Periods

The number of pay periods that employee is paid per year

24
Retain Vacation PayRetain employee's vacation;
T = Yes
F = No
T
Vacation Rate
Vacation percentage rate this employee receives for vacation pay
4
Vacation OwedVacation owed0
WCB RateWCB (Work Safe) rate for this employee
1.4
WCB AssessableAnnual WCB (Work Safe) assessable amount
102100
Dental BenefitsDental benefits;

1 = Not eligible to access any dental care insurance, or coverage of dental services of any kind 

2 = Payee only

3 = Payee, spouse and dependent children

4 = Payee and their spouse

5 = Payee and their dependent children 

1
Last Year Dental BenefitsLast year dental benefits;

1 = Not eligible to access any dental care insurance, or coverage of dental services of any kind 

2 = Payee only

3 = Payee, spouse and dependent children

4 = Payee and their spouse

5 = Payee and their dependent children 


1