T2200REV25

FIRST TOPIC  BACK  PREVIOUS TOPIC  NEXT TOPIC

eForms Standard & Enterprise Only

 

Form Released:        01/21/2025

 

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

 

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

 

Q1FROM

Q. 1, "From date"

Date

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

Q1TO

Q. 1, "To date"

Date

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

Q1BREAK

Q. 1, "Break in employment"

Text, 60

 

Q2AYES

Q. 2, "Commission," Yes

Text, 1

"X" = Checked

Q2ANO

Q. 2, "Commission," No

Text, 1

"X" = Checked

Q2COMMISSION

Q. 2, "Commissions"

Currency

 

Q2TYPEOFSALES

Q. 2, "Type of goods or contracts"

Text, 75

 

Q2BYES

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

Text, 1

"X" = Checked

Q2BNO

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

Text, 1

"X" = Checked

Q2CYES

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

Text, 1

"X" = Checked

Q2CNO

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

Text, 1

"X" = Checked

Q3AYES

Q. 3, "Rent an office," Yes

Text, 1

"X" = Checked

Q3ANO

Q. 3, "Rent an office," No

Text, 1

"X" = Checked

Q3BYES

Q. 3, "Pay substitute," Yes

Text, 1

"X" = Checked

Q3BNO

Q. 3, "Pay substitute," No

Text, 1

"X" = Checked

Q3CYES

Q. 3, "Pay supplies", Yes

Text, 1

"X" = Checked

Q3CNO

Q. 3, "Pay supplies", No

Text, 1

"X" = Checked

Q3DYES

Q. 3, "Pay cell phone," Yes

Text, 1

"X" = Checked

Q3DNO

Q. 3, "Pay cell phone," No

Text, 1

"X" = Checked

Q4AYES

Q. 4, "Req'd to use home," Yes

Text, 1

"X" = Checked

Q4ANO

Q. 4, "Req'd to use home," No

Text, 1

"X" = Checked

Q4BYES

Q. 4, "Worked over 50% from home," Yes

Text, 1

"X" = Checked

Q4BNO

Q. 4, "Worked over 50% from home," No

Text, 1

"X" = Checked

Q4CYES

Q. 4, "In person meetings," Yes

Text, 1

"X" = Checked

Q4CNO

Q. 4, "In person meetings," No

Text, 1

"X" = Checked

Q5YES

Q. 5, "Reimbursed for Q3 and Q4," Yes

Text, 1

"X" = Checked

Q5NO

Q. 5, "Reimbursed for Q3 and Q4," 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

Q6YES

Q. 6, "Area of travel," Yes

Text, 1

"X" = Checked

Q6NO

Q. 6, "Area of travel," No

Text, 1

"X" = Checked

Q6AREA

Q. 6, "Area of travel"

Text, 75

 

Q7YES

Q. 7, "Consecutive hours," Yes

Text, 1

"X" = Checked

Q7NO

Q. 7, "Consecutive hours," No

Text, 1

"X" = Checked

Q7HOWFREQUENTLY

Q. 7, "How Frequently"

Text, 75

 

Q8AYES

Q. 8, "Vehicle allowance," Yes

Text, 1

"X" = Checked

Q8ANO

Q. 8, "Vehicle allowance," No

Text, 1

"X" = Checked

Q8AMTFIXED

Q. 8, "Fixed allowance amount"

Currency

 

Q8PERKMRATE

Q. 8, "Per km rate"

Currency

 

Q8AMTFORKM

Q. 8, "km amount received"

Currency

 

Q8AMTONT4

Q. 8, "Amount reported on T4"

Currency

 

Q9AYES

Q. 9, "Company vehicle," Yes

Text, 1

"X" = Checked

Q9ANO

Q. 9, "Company vehicle," No

Text, 1

"X" = Checked

Q9BYES

Q. 9, "Expense," Yes

Text, 1

"X" = Checked

Q9BNO

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

Q10AMT1

Q. 10, "Expense Amount," Line 1

Currency

 

Q10TYPE1

Q. 10, "Expense Type," Line 1

Text, 75

 

Q10INCLUDED1YES

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

Text, 1

"X" = Checked

Q10INCLUDED1NO

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

Text, 1

"X" = Checked

Q10AMT2

Q. 10, "Expense Amount," Line 2

Currency

 

Q10TYPE2

Q. 10, "Expense Type," Line 2

Text, 75

 

Q10INCLUDED2YES

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

Text, 1

"X" = Checked

Q10INCLUDED2NO

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

Text, 1

"X" = Checked

Q10AMT3

Q. 10, "Expense Amount," Line 3

Currency

 

Q10TYPE3

Q. 10, "Expense Type," Line 3

Text, 75

 

Q10INCLUDED3YES

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

Text, 1

"X" = Checked

Q10INCLUDED3NO

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

Text, 1

"X" = Checked

Q11YES

Q. 11, "Other expenses," Yes

Text, 1

"X" = Checked

Q11NO

Q. 11, "Other expenses," No

Text, 1

"X" = Checked

Q11TYPEOTHER

Q. 11 "Other expense description"

Text, 75

 

Q12AYES

Q. 12, "Tradesperson," Yes

Text, 1

"X" = Checked

Q12ANO

Q. 12, "Tradesperson," No

Text, 1

"X" = Checked

Q12BYES

Q. 12, "Purchase tools," Yes

Text, 1

"X" = Checked

Q12BNO

Q. 12, "Purchase tools," No

Text, 1

"X" = Checked

Q12CYES

Q. 12, "Satisfy," Yes

Text, 1

"X" = Checked

Q12CNO

Q. 12, "Satisfy," No

Text, 1

"X" = Checked

Q13AYES

Q. 13, "Apprentice," Yes

Text, 1

"X" = Checked

Q13ANO

Q. 13, "Apprentice," No

Text, 1

"X" = Checked

Q13BYES

Q. 13, "Designation," Yes

Text, 1

"X" = Checked

Q13BNO

Q. 13, "Designation," No

Text, 1

"X" = Checked

Q13CYES

Q. 13, "Purchase Tools," Yes

Text, 1

"X" = Checked

Q13CNO

Q. 13, "Purchase Tools," No

Text, 1

"X" = Checked

Q13DYES

Q. 13, "Satisfy," Yes

Text, 1

"X" = Checked

Q13DNO

Q. 13, "Satisfy," No

Text, 1

"X" = Checked

Q14AYES

Q. 14, "Forestry," Yes

Text, 1

"X" = Checked

Q14ANO

Q. 14, "Forestry," No

Text, 1

"X" = Checked

Q14BYES

Q. 14, "Provide Saw," Yes

Text, 1

"X" = Checked

Q14BNO

Q. 14, "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