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

 

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

Text, 50

 

ADDRESS2

Address line 2

Text, 50

 

CITY

City

Text, 28

 

PROV

Province code

Text, 2

 

POSTAL

Postal code (including space)

Text, 10

 

COUNTRY

Country, in address

Text, 3

CAN, USA, etc.

SLIPSTATUS

Status of slip

Text, 1

O - Original,

A - Amended or

C - Cancelled

YEAR

Year

Numeric, 4

2023

ACTUAL

Actual amount of non-eligible dividends (24)

Currency

 

TAXABLE

Taxable amount of eligible dividends (25)

Currency

 

CREDIT

Dividend tax credit for eligible dividends (26)

Currency

 

ACTUAL_E

Actual amount of eligible dividends (30)

Currency

 

TAXABLE_E

Taxable amount of eligible dividends (31)

Currency

 

CREDIT_E

Dividend tax credit for eligible dividends (32)

Currency

 

CAPGAINS

Capital gains for loses (34)

Currency

 

OTHER

Other income (35)

Currency

 

FORFEITED

Forfeited due to withdrawal (36)

Currency

 

FOREIGNINCOME

Foreign non-business income (37)

Currency

 

FOREIGNCAPGAINS

Foreign capital gains or losses (38)

Currency

 

FOREIGNTAX

Foreign non-business tax (39)

Currency

 

SPECIFIEDEMP

Specified employee? "Yes"

Text, 1

"X" = Checked

SPECIFIEDEMPNO

Specified employee? "No"

Text, 1

"X" = Checked

SIN

Canadian social insurance number (12)

Numeric, 9

 

TEXTATTOP

Optional text to print at top of slip

Text, 15

 

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