T2200

FIRST TOPIC  BACK  PREVIOUS TOPIC  NEXT TOPIC

eForms Standard & Enterprise Only

 

Cell A1 (import from Excel) or the first data element (import from CSV) must contain "T2200"

 

Heading

Description

Type, Size

Comments & Examples

LASTNAME

Recipient last name

Text, 30

Required

FIRSTNAME

Recipient first name

Text, 12

 

INITIAL

Recipient initial

Text, 1

 

ADDRESS1

Address line 1 (Home address)

Text, 30

 

ADDRESS2

Address line 2 (Business address)

Text, 30

 

CITY

City

Text, 6

 

PROV

Province code

Text, 2

 

POSTAL

Postal code (including space)

Text, 10

 

COUNTRY

Country, in address

Text, 3

CAN, USA, etc.

SIN

Social insurance number

Text, 9

 

TAXYEAR

Taxation year

Numeric, 4

2012

EMPNUM

Employee number

Text, 20

 

JOBTITLE

Job title & brief description of duties

Text, 100

 

Q1YES

Q. 1, "Expense," Yes

Yes/No

"Yes" selects option

Q1NO

Q. 1, "Expense," No

Yes/No

 

Q2YES

Q. 2, "Area of travel," Yes

Yes/No

"Yes" selects option

Q2NO

Q. 2, "Area of travel," No

Yes/No

 

Q2AREA

Q. 2, "Area of travel"

Text, 60

 

Q3YES

Q. 3, "Consecutive hours," Yes

Yes/No

"Yes" selects option

Q3NO

Q. 3, "Consecutive hours," No

Yes/No

 

Q3HOWFREQUENTLY

Q. 3, "How Frequently"

Text, 50

 

Q4FROM

Q. 4, "From date"

Date

Mmm. dd, yyyy (Apr. 1, 2012)

Q4TO

Q. 4, "To date"

Date

Mmm. dd, yyyy (Apr. 1, 2012)

Q4BREAK

Q. 4, "Break in employment"

Text, 60

 

Q5AYES

Q. 5, "Vehicle allowance," Yes

Yes/No

"Yes" selects option

Q5ANO

Q. 5, "Vehicle allowance," No

Yes/No

"No" de-selects option

Q5AMTFIXED

Q. 5, "Fixed allowance amount"

Currency

 

Q5PERKMRATE

Q. 5, "Per km rate"

Currency

 

Q5AAMTFORKM

Q. 5, "km amount received"

Currency

 

Q5AMTONT4

Q. 5, "Amount reported on T4"

Currency

 

Q5BYES

Q. 5, "Company vehicle," Yes

Yes/No

"Yes" selects option

Q5BNO

Q. 5, "Company vehicle," No

Yes/No

"No" de-selects option

Q5CYES

Q. 5, "Expense," Yes

Yes/No

"Yes" selects option

Q5CNO

Q. 5, "Expense," No

Yes/No

"No" de-selects option

Q5AMT1

Q. 5, "Expense Amount," Line 1

Currency

 

Q5TYPE1

Q. 5, "Expense Type," Line 1

Text, 50

 

Q5AMT2

Q. 5, "Expense Amount," Line 2

Currency

 

Q5TYPE2

Q. 5, "Expense Type," Line 2

Text, 50

 

Q5AMT3

Q. 5, "Expense Amount," Line 3

Currency

 

Q5TYPE3

Q. 5, "Expense Type," Line 3

Text, 50

 

Q6YES

Q. 6, "Repayment received," Yes

Yes/No

"Yes" selects option

Q6NO

Q. 6, "Repayment received," No

Yes/No

"No" de-selects option

Q6AMTPROOF

Q. 6, "Received on proof of payment"

Currency

 

Q6AMTCHARGED

Q. 6, "Amount charged to employer"

Currency

 

Q6TYPEPROOF

Q. 6, "Expense type, Proof"

Text, 50

 

Q6TYPECHARGED

Q. 6, "Expense type, Charged"

Text, 50

 

Q6PROOFYES

Q. 6, "Expense, Proof, T4," Yes

Yes/No

"Yes" selects option

Q6PROOFNO

Q. 6, "Expense, Proof, T4" No

Yes/No

"No" de-selects option

Q6CHARGEDYES

Q. 6, "Expense, Charged, T4" Yes

Yes/No

"Yes" selects option

Q6CHARGEDNO

Q. 6, "Expense, Charged, T4" Yes

Yes/No

"Yes" selects option

Q7YES

Q. 7, "Other expenses," Yes

Yes/No

"Yes" selects option

Q7NO

Q. 7, "Other expenses," No

Yes/No

"No" de-selects option

Q7TYPEOTHER

Q. 7, "Other expense description"

Text, 50

 

Q8AYES

Q. 7, "Commission," Yes

Yes/No

"Yes" selects option

Q8ANO

Q. 7, "Commission," No

Yes/No

"No" de-selects option

Q8COMMISSION

Q. 7, "Commissions"

Currency

 

Q8TYPEOFSALES

Q. 7, "Type of goods or contracts"

Text, 50

 

Q8BYES

Q. 7, "Bus. development acc't," Yes

Yes/No

"Yes" selects option

Q8BNO

Q. 7, "Bus. development acc't," No

Yes/No

"No" de-selects option

Q8CYES

Q. 7, "Commission incl. T4," Yes

Yes/No

"Yes" selects option

Q8CNO

Q. 7, "Commission incl. T4," No

Yes/No

"No" de-selects option

Q9AYES

Q. 9, "Rent office, Yes"

Yes/No

"Yes" selects option

Q9ANO

Q. 9, "Rent office, No"

Yes/No

"No" de-selects option

Q9BYES

Q. 9, "Pay substitute, Yes"

Yes/No

"Yes" selects option

Q9BNO

Q. 9, "Pay substitute, No"

Yes/No

"No" de-selects option

Q9CYES

Q. 9, "Pay supplies, Yes"

Yes/No

"Yes" selects option

Q9CNO

Q. 9, "Pay supplies, No"

Yes/No

"No" de-selects option

Q9DYES

Q. 9, "Pay cell phone, Yes"

Yes/No

"Yes" selects option

Q9DNO

Q. 9, "Pay cell phone, No"

Yes/No

"No" de-selects option

Q9EYES

Q. 9, "Repay, Yes"

Yes/No

"Yes" selects option

Q9ENO

Q. 9, "Repay, No"

Yes/No

"No" de-selects option

Q9AMT1

Q. 9, "Expense Amount," Line 1

Currency

 

Q9TYPE1

Q. 9, "Expense Type," Line 1

Text, 50

 

Q9INCLUDED1YES

Q. 9, "Expense, Incl. T4," Line 1, Yes

Yes/No

"Yes" selects option

Q9INCLUDED1NO

Q. 9, "Expense, Incl. T4," Line 1, No

Yes/No

"Yes" selects option

Q9AMT2

Q. 9, "Expense Amount," Line 2

Currency

 

Q9TYPE2

Q. 9, "Expense Type," Line 2

Text, 50

 

Q9INCLUDED2YES

Q. 9, "Expense, Incl. T4," Line 2, Yes

Yes/No

"Yes" selects option

Q9INCLUDED2NO

Q. 9, "Expense, Incl. T4," Line 2, No

Yes/No

"No" de-selects option

Q9AMT3

Q. 9, "Expense Amount," Line 3

Currency

 

Q9TYPE3

Q. 9, "Expense Type," Line 3

Text, 50

 

Q9INCLUDED3YES

Q. 9, "Expense, Incl. T4," Line 3, Yes

Yes/No

"Yes" selects option

Q9INCLUDED3NO

Q. 9, "Expense, Incl. T4," Line 3, No

Yes/No

"No" de-selects option

Q10AYES

Q. 10, "Use Portion," Yes

Yes/No

"Yes" selects option

Q10ANO

Q. 10, "Use Portion," No

Yes/No

"No" de-selects option

Q10PERCENTAGE

Q. 10, "Percentage of Workday"

Text, 50

 

Q10BYES

Q. 10, "Exclusive, "Yes

Yes/No

"Yes" selects option

Q10BNO

Q. 10, "Exclusive," No

Yes/No

"No" de-selects option

Q10CYES

Q. 10, "Repay," Yes

Yes/No

"Yes" selects option

Q10CNO

Q. 10, "Repay," No

Yes/No

"No" de-selects option

Q10AMT1

Q. 10, "Expense Amount," Line 1

Currency

 

Q10TYPE1

Q. 10, "Expense Type," Line 1

Text, 50

 

Q10INCLUDED1YES

Q. 10, "Expense, Incl. T4," Line 1, Yes

Yes/No

"Yes" selects option

Q10INCLUDED1NO

Q. 10, "Expense, Incl. T4," Line 1, Yes

Yes/No

"Yes" selects option

Q10AMT2

Q. 10, "Expense Amount," Line 2

Currency

 

Q10TYPE2

Q. 10, "Expense Type," Line 2

Text, 50

 

Q10INCLUDED2YES

Q. 10, "Expense, Incl. T4," Line 2, Yes

Yes/No

"Yes" selects option

Q10INCLUDED2NO

Q. 10, "Expense, Incl. T4," Line 2, Yes

Yes/No

"Yes" selects option

Q10AMT3

Q. 10, "Expense Amount," Line 3

Currency

 

Q10TYPE3

Q. 10, "Expense Type," Line 3

Text, 50

 

Q10INCLUDED3YES

Q. 10, "Expense, Incl. T4," Line 3, Yes

Yes/No

"Yes" selects option

Q10INCLUDED3NO

Q. 10, "Expense, Incl. T4," Line 3, Yes

Yes/No

"Yes" selects option

Q11AYES

Q. 11, "Tradesperson," Yes

Yes/No

"Yes" selects option

Q11ANO

Q. 11, "Tradesperson," No

Yes/No

"No" de-selects option

Q11BYES

Q. 11, "Purchase tools," Yes

Yes/No

"Yes" selects option

Q11BNO

Q. 11, "Purchase tools," No

Yes/No

"No" de-selects option

Q11CYES

Q. 11, "Satisfy," Yes

Yes/No

"Yes" selects option

Q11CNO

Q. 11, "Satisfy," No

Yes/No

"No" de-selects option

Q12AYES

Q. 12, "Apprentice," Yes

Yes/No

"Yes" selects option

Q12ANO

Q. 12, "Apprentice," No

Yes/No

"No" de-selects option

Q12BYES

Q. 12, "Designation," Yes

Yes/No

"Yes" selects option

Q12BNO

Q. 12, "Designation," No

Yes/No

"No" de-selects option

Q12CYES

Q. 12, "Purchase Tools," Yes

Yes/No

"Yes" selects option

Q12CNO

Q. 12, "Purchase Tools," No

Yes/No

"No" de-selects option

Q12DYES

Q. 12, "Used for work," Yes

Yes/No

"Yes" selects option

Q12DNO

Q. 12, "Used for work," Yes

Yes/No

"Yes" selects option

Q13AYES

Q. 13, "Forestry," Yes

Yes/No

"Yes" selects option

Q13ANO

Q. 13, "Forestry," No

Yes/No

"No" de-selects option

Q13BYES

Q. 13, "Provide Saw," Yes

Yes/No

"Yes" selects option

Q13BNO

Q. 13, "Provide Saw," No

Yes/No

"No" de-selects option

COMPANY.NAME1

Company associated with slip

Text, 30

eForms Enterprise only