T2200 Headings

FIRST TOPIC  BACK  PREVIOUS TOPIC  NEXT TOPIC

eForms Standard & Enterprise Only

 

Updated        2023 T2200

 

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, 30

 

INITIAL

Recipient initial

Text, 1

 

ADDRESS1

Address line 1 (Home address)

Text, 50

 

ADDRESS2

Address line 2 (Business address)

Text, 50

 

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

Numeric, 9

SIN is not required and is not printed but can be used by eForms Enterprise as a password on individual recipient PDFs

TAXYEAR

Taxation year

Numeric, 4

2024

EMPNUM

Employee number

Text, 20

 

JOBTITLE

Job title & brief description of duties

Text, 100

 

Q1YES

Q. 1, "Expense," Yes

Text, 1

"X" = Checked

Q1NO

Q. 1, "Expense," No

Text, 1

"X" = Checked

Q2FROM

Q. 2, "From date"

Date

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

Q2TO

Q. 2, "To date"

Date

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

Q2BREAK

Q. 2, "Break in employment"

Text, 60

 

Q3AYES

Q. 3, "Commission," Yes

Text, 1

"X" = Checked

Q3ANO

Q. 3, "Commission," No

Text, 1

"X" = Checked

Q3COMMISSION

Q. 3, "Commissions"

Currency

 

Q3TYPEOFSALES

Q. 3, "Type of goods or contracts"

Text, 75

 

Q3BYES

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

Text, 1

"X" = Checked

Q3BNO

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

Text, 1

"X" = Checked

Q3CYES

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

Text, 1

"X" = Checked

Q3CNO

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

Text, 1

"X" = Checked

Q4YES

Q. 4, "Repayment received," Yes

Text, 1

"X" = Checked

Q4NO

Q. 4, "Repayment received," No

Text, 1

"X" = Checked

Q4AMTPROOF

Q. 4, "Received on proof of payment"

Currency

 

Q4AMTCHARGED

Q. 4, "Amount charged to employer"

Currency

 

Q4TYPEPROOF

Q. 4, "Expense type, Proof"

Text, 75

 

Q4TYPECHARGED

Q. 4, "Expense type, Charged"

Text, 75

 

Q4PROOFYES

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

Text, 1

"X" = Checked

Q4PROOFNO

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

Text, 1

"X" = Checked

Q4CHARGEDYES

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

Text, 1

"X" = Checked

Q4CHARGEDNO

Q. 4, "Expense, Charged, T4" No

Text, 1

"X" = Checked

Q5AYES

Q. 5, "Rent office, Yes"

Text, 1

"X" = Checked

Q5ANO

Q. 5, "Rent office, No"

Text, 1

"X" = Checked

Q5BYES

Q. 5, "Pay substitute, Yes"

Text, 1

"X" = Checked

Q5BNO

Q. 5, "Pay substitute, No"

Text, 1

"X" = Checked

Q5CYES

Q. 5, "Pay supplies, Yes"

Text, 1

"X" = Checked

Q5CNO

Q. 5, "Pay supplies, No"

Text, 1

"X" = Checked

Q5DYES

Q. 5, "Pay cell phone, Yes"

Text, 1

"X" = Checked

Q5DNO

Q. 5, "Pay cell phone, No"

Text, 1

"X" = Checked

Q5EYES

Q. 5, "Repay, Yes"

Text, 1

"X" = Checked

Q5ENO

Q. 5, "Repay, No"

Text, 1

"X" = Checked

Q5AMT1

Q. 5, "Expense Amount," Line 1

Currency

 

Q5TYPE1

Q. 5, "Expense Type," Line 1

Text, 75

 

Q5INCLUDED1YES

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

Text, 1

"X" = Checked

Q5INCLUDED1NO

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

Text, 1

"X" = Checked

Q5AMT2

Q. 5, "Expense Amount," Line 2

Currency

 

Q5TYPE2

Q. 5, "Expense Type," Line 2

Text, 75

 

Q5INCLUDED2YES

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

Text, 1

"X" = Checked

Q5INCLUDED2NO

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

Text, 1

"X" = Checked

Q5AMT3

Q. 5, "Expense Amount," Line 3

Currency

 

Q5TYPE3

Q. 5, "Expense Type," Line 3

Text, 75

 

Q5INCLUDED3YES

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

Text, 1

"X" = Checked

Q5INCLUDED3NO

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

Text, 1

"X" = Checked

Q60AYES

Q. 6, "Use Portion," Yes

Text, 1

"X" = Checked

Q6ANO

Q. 6, "Use Portion," No

Text, 1

"X" = Checked

Q6PERCENTAGE

Q. 6, "Percentage of Workday"

Text, 75

 

Q6CYES

Q. 6, "Repay," Yes

Text, 1

"X" = Checked

Q6CNO

Q. 6, "Repay," No

Text, 1

"X" = Checked

Q6AMT1

Q. 6, "Expense Amount," Line 1

Currency

 

Q6TYPE1

Q. 6, "Expense Type," Line 1

Text, 75

 

Q6INCLUDED1YES

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

Text, 1

"X" = Checked

Q6INCLUDED1NO

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

Text, 1

"X" = Checked

Q6AMT2

Q. 6, "Expense Amount," Line 2

Currency

 

Q6TYPE2

Q. 6, "Expense Type," Line 2

Text, 75

 

Q6INCLUDED2YES

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

Text, 1

"X" = Checked

Q6INCLUDED2NO

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

Text, 1

"X" = Checked

Q6AMT3

Q. 6, "Expense Amount," Line 3

Currency

 

Q6TYPE3

Q. 6, "Expense Type," Line 3

Text, 75

 

Q6INCLUDED3YES

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

Text, 1

"X" = Checked

Q6INCLUDED3NO

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

Text, 1

"X" = Checked

Q7YES

Q. 7, "Area of travel," Yes

Text, 1

"X" = Checked

Q7NO

Q. 7, "Area of travel," No

Text, 1

"X" = Checked

Q7AREA

Q. 7, "Area of travel"

Text, 75

 

Q8YES

Q. 8, "Consecutive hours," Yes

Text, 1

"X" = Checked

Q8NO

Q. 8, "Consecutive hours," No

Text, 1

"X" = Checked

Q8HOWFREQUENTLY

Q. 8, "How Frequently"

Text, 75

 

Q9AYES

Q. 9, "Vehicle allowance," Yes

Text, 1

"X" = Checked

Q9ANO

Q. 9, "Vehicle allowance," No

Text, 1

"X" = Checked

Q9AMTFIXED

Q. 9, "Fixed allowance amount"

Currency

 

Q9PERKMRATE

Q. 9, "Per km rate"

Currency

 

Q9AAMTFORKM

Q. 9, "km amount received"

Currency

 

Q9AMTONT4

Q. 9, "Amount reported on T4"

Currency

 

Q9BYES

Q. 9, "Company vehicle," Yes

Text, 1

"X" = Checked

Q9BNO

Q. 9, "Company vehicle," No

Text, 1

"X" = Checked

Q9CYES

Q. 9, "Expense," Yes

Text, 1

"X" = Checked

Q9CNO

Q. 9, "Expense," No

Text, 1

"X" = Checked

Q9AMT1

Q. 9, "Expense Amount," Line 1

Currency

 

Q9TYPE1

Q. 9, "Expense Type," Line 1

Text, 75

 

Q9AMT2

Q. 9, "Expense Amount," Line 2

Currency

 

Q9TYPE2

Q. 9, "Expense Type," Line 2

Text, 75

 

Q9AMT3

Q. 9, "Expense Amount," Line 3

Currency

 

Q9TYPE3

Q. 9, "Expense Type," Line 3

Text, 75

 

Q10YES

Q. 10, "Other expenses," Yes

Text, 1

"X" = Checked

Q10NO

Q. 10, "Other expenses," No

Text, 1

"X" = Checked

Q10TYPEOTHER

Q. 10 "Other expense description"

Text, 75

 

Q11AYES

Q. 11, "Tradesperson," Yes

Text, 1

"X" = Checked

Q11ANO

Q. 11, "Tradesperson," No

Text, 1

"X" = Checked

Q11BYES

Q. 11, "Purchase tools," Yes

Text, 1

"X" = Checked

Q11BNO

Q. 11, "Purchase tools," No

Text, 1

"X" = Checked

Q11CYES

Q. 11, "Satisfy," Yes

Text, 1

"X" = Checked

Q11CNO

Q. 11, "Satisfy," No

Text, 1

"X" = Checked

Q12AYES

Q. 12, "Apprentice," Yes

Text, 1

"X" = Checked

Q12ANO

Q. 12, "Apprentice," No

Text, 1

"X" = Checked

Q12BYES

Q. 12, "Designation," Yes

Text, 1

"X" = Checked

Q12BNO

Q. 12, "Designation," No

Text, 1

"X" = Checked

Q12CYES

Q. 12, "Purchase Tools," Yes

Text, 1

"X" = Checked

Q12CNO

Q. 12, "Purchase Tools," No

Text, 1

"X" = Checked

Q12DYES

Q. 12, "Used for work," Yes

Text, 1

"X" = Checked

Q12DNO

Q. 12, "Used for work," No

Text, 1

"X" = Checked

Q13AYES

Q. 13, "Forestry," Yes

Text, 1

"X" = Checked

Q13ANO

Q. 13, "Forestry," No

Text, 1

"X" = Checked

Q13BYES

Q. 13, "Provide Saw," Yes

Text, 1

"X" = Checked

Q13BNO

Q. 13, "Provide Saw," No

Text, 1

"X" = Checked

EMAILADDRESS

Recipient email address

Text, 255

eForms Enterprise only

One email address, or two separated by a semi-colon

OKTOEMAILSLIP

Permission granted to email slip

Yes/No

eForms Enterprise only

COMPANY.NAME1

Company associated with slip

Text, 35

eForms Enterprise only

COMPANY.COMPANYTAG

Tag associated with company name

Text, 10

eForms Enterprise only

SLIPTAG

Subset tag

Text, 10

eForms Enterprise only

CUSTOMFIELD

GUID or other unique identifier

Text, 50

eForms Enterprise only

CUSTOMPASSWORD

Password for recipient PDF slip

Text, 20

eForms Enterprise only