TP64 Headings

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 "TP64"

 

Heading

Description

Type, Size

Comments & Examples

LASTNAME

Recipient last name

Text, 30

Required

FIRSTNAME

Recipient first name

Text, 12

 

SIN

Social insurance number

Text, 9

 

TAXYEAR

Taxation year

Numeric, 4

2017

Q1YES

Q. 1, "Expense," Yes

Yes/No

"Yes" selects option

Q1NO

Q. 1, "Expense," No

Yes/No

"No" de-selects option

Q2FROM

Q. 2, "From date"

Date

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

Q2TO

Q. 2, "To date"

Date

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

Q3

Q. 3, "Title or position"

Text, 50

 

Q4YES

Q. 4, "Remunerated by commissions," Yes

Yes/No

"Yes" selects option

Q4NO

Q. 4, "Remunerated by commissions," No

Yes/No

"No" de-selects option

Q4AMT

Q. 4, "Amount of remuneration"

Currency

 

Q4TYPE

Q. 4, "Type of property or contract"

Text, 50

 

Q5YES

Q. 5, "Kilometrage allowance," Yes

Yes/No

"Yes" selects option

Q5NO

Q. 5, "Kilometrage allowance," No

Yes/No

"No" de-selects option

Q5RATESPERKM

Q. 5, "Rates per km"

Currency

 

Q5DISTANCE

Q. 5, "Distance travelled"

Numeric, 4

 

Q5ALLOWANCE

Q. 5, "Total allowance"

Currency

 

Q5AMTONR1

Q. 5, "Amount reported on RL-1"

Currency

 

Q5TYPE

Q. 5, "Type of trips covered"

Text, 50

 

Q6YES

Q. 6, "Allowance for expenses," Yes

Yes/No

"Yes" selects option

Q6NO

Q. 6, "Allowance for expenses," No

Yes/No

"No" de-selects option

Q6AALLOWANCE

Q. 6, "Motor vehicle allowance"

Currency

 

Q6AREIMBURSEMENT

Q. 6, "Motor vehicle reimbursement"

Currency

 

Q6AAMTONR1

Q. 6, "Motor vehicle amount on RL-1"

Currency

 

Q6BALLOWANCE

Q. 6, "Travel allowance"

Currency

 

Q6BREIMBURSEMENT

Q. 6, "Travel reimbursement"

Currency

 

Q6BAMTONR1

Q. 6, "Travel amount on RL-1"

Currency

 

Q6CALLOWANCE

Q. 6, "Other allowance"

Currency

 

Q6CREIMBURSEMENT

Q. 6, "Other reimbursement"

Currency

 

Q6CAMTONR1

Q. 6, "Other amount on RL-1"

Currency

 

Q6INFO

Q. 6, "Other expenses" specify

Text, 20

 

Q7YES

Q. 7, "Expenses on employee's behalf," Yes

Yes/No

"Yes" selects option

Q7NO

Q. 7, "Expenses on employees behalf," No

Yes/No

"No" de-selects option

Q7TYPE

Q. 7, "Type of expenses paid"

Text, 50

 

Q7AMT

Q. 7, "Amount of expenses paid"

Currency

 

Q7AMTONR1

Q. 7, "Amount on RL-1"

Currency

 

Q8YES

Q. 8, "Work away from office" Yes

Yes/No

"Yes" selects option

Q8NO

Q. 8, "Work away from office" No

Yes/No

"No" de-selects option

Q8A

Q. 8, "Percentage of hours at workplace"

Percentage

 

Q8B

Q. 8, "Percentage of hours at clients' premises/on road"

Percentage

 

Q8C

Q. 8, "Percentage of hours at employee's home"

Percentage

 

Q9YES

Q. 9, "12 hours away from workplace municipality" Yes

Yes/No

"Yes" selects option

Q9NO

Q. 9, "12 hours away from workplace municipality" No

Yes/No

"No" de-selects option

Q9AREA

Q. 9, "Area where employee performed duties"

Text, 50

 

Q10YES

Q. 10, "Employee supply vehicle," Yes

Yes/No

"Yes" selects option

Q10NO

Q. 10, "Employee supply vehicle" No

Yes/No

"No" de-selects option

Q11YES

Q. 11, "Travel expenses under contract," Yes

Yes/No

"Yes" selects option

Q11NO

Q. 11, "Travel expenses under contract," No

Yes/No

"Yes" selects option

Q11INFO

Q. 11, "Particulars"

Text, 50

 

Q12YES

Q. 12, "Purchase supplies," Yes

Yes/No

"Yes" selects option

Q12NO

Q. 12, "Purchase supplies," No

Yes/No

"No" de-selects option

Q12INFO

Q. 12, "Particulars"

Text, 50

 

Q13YES

Q. 13, "Pay substitute," Yes

Yes/No

"Yes" selects option

Q13NO

Q. 13, "Pay substitute," No

Yes/No

"No" de-selects option

Q14YES

Q. 14, "Employee office at workplace," Yes

Yes/No

"Yes" selects option

Q14NO

Q. 14, "Employee office at workplace," No

Yes/No

"No" de-selects option

Q15YES

Q. 15, "Employee office away from workplace," Yes

Yes/No

"Yes" selects option

Q15NO

Q. 15, "Employee office away from workplace," No

Yes/No

"No" de-selects option

Q15A

Q. 15, "Performed >50% duties at away office"

Yes/No

 

Q15B

Q. 15, "Office exclusively used to earn employment income"

Yes/No

 

Q16YES

Q. 16, "Other expenses not on form," Yes

Yes/No

"Yes" selects option

Q16NO

Q. 16, "Other expenses not on form," No

Yes/No

"No" de-selects option

Q16INFO

Q. 16, "Particulars"

Text, 50

 

Q17YES

Q. 17, "Incur shareman expenses," Yes

Yes/No

"Yes" selects option

Q17NO

Q. 17, "Incur sharement expenses," No

Yes/No

"No" de-selects option

Q17INFO

Q. 17, "Particulars"

Text, 50

 

EMAILADDRESS

Recipient email address

Text, 255

eForms Enterprise only

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