The Position Template, which can be found in the Imports module, is a self-serving tool that can be used to upload Buys, New Position, End Position and Transfer transactions for new and existing investors.
Once the Import Module is activated you will notice a new module on the left side of your screen.
After selecting this module, you will able to click on ‘Download Templates’ and select 'Position Template' to generate the Excel file that you will fill in with the information that you wish to upload. *Note: if you have a saved copy of the template it might be outdated - please download the most recent version as if any updates were made to this area of the system, any pervious templates will not work.
The column headers in the template are listed below. Please note, columns with an * are mandatory fields that need to be filled out; all other columns are optional.
Dealer Code *
Advisor Rep Code*
Investor Type*
Investor First Name*
Investor Last Name*
Investor Sin
Company Name
BIN
Investor Address*
Investor City*
Investor Prov/State*
Investor Postal Code*
Investor Email
Investor Phone
Joint First Name
Joint Last Name
Joint SIN
Joint Address
Joint City
Joint Prov/State
Joint Postal Code
Joint Email
Account #
Trust/Bank
Account Type
Account External Identifier
Reinvestment Percent
Create Date*
Trade Date*
Settle Date*
Offering Fundserve ID*
Tx Type*
Share/Units
Cost per Unit
Gross Amount
Fee Identifier
Please use the 'Data' sheet of the template in order to enter your information. Be mindful not to apply any filters to the file or adjust the formatting as this can cause errors upon upload.
To add some detail as to what information needs to be added in some of these columns we have provided a more comprehensive explanation below:
Dealer Code*
For users on Issuer Edge, each Dealer in your system will be assigned a Dealer Code. Please add a value into this field in order to enter it into the Dealer Code* column in the template.
For users on Dealer Edge, there is a Dealer Code located in the Company Details of your Admin Module. Please add a value into this field in order to enter it into the Dealer Code* column in the template.
Advisor Rep Code*
Every advisor profile in both Issuer Edge and Dealer Edge will have a Rep Code field. Please add a value into this field in order to enter it into the Advisor Rep Code* column in the template.
Investor Type*
There are three options that can be added to this mandatory field they are ‘Individual’, 'Joint' or ‘Corporate’ investor types.
Joint Investors*
If you are wanting to create two investor profiles who share a joint account, you would fill out the primary investor's information using the fields 'Investor First Name', 'Investor Last Name' etc. - and you would fill out the secondary/joint investor's information in all fields that say 'Joint'. This will create two separate profiles in the system with a shared joint account.
Investor Prov/State and Joint Prov/State*
You must use the full name of the Province or State - Abbreviations will not be accepted.
Account Number*
If you do not have an account number, you can enter something generic for your own internal record keeping. Please be mindful that whatever you enter into this field will be displayed on investor statements, next to the Trust/Bank and the account type.
Trust/Bank*
The Trust/Bank details in your template must match the options available in the Trust Company / Bank dropdown. If you require a trust company or bank that does not exist in our system, please reach out to your Client Success Manager to request these be added to the system.
*Please note, this is a required field in the template. If the account is non-registered, you can select 'Open' or 'Other' from the drop-down.
Account Type*
The account type details in your template must match the options available in your Account Type Dropdown. You are able to create multiple different accounts for the same investor using the Position Template by creating multiple line items and selecting the type (TFSA, RRSP, RESP etc.).
*Please note, this is a required field in the template. If the account is non-registered, you can select 'Cash' or 'Non-Registered'.
Created Date*
Trade Date*
Settle Date*
* Please note, all of the dates should be entered in YYYY-MM-DD format.
Offering Fundserv ID*
In the Offering Details section there is a ‘Fundserv Reference’ field. Please add a value into this field in order to enter it into the Offering FundServ ID* column in the template.
Tx Type*
The transaction types that are currently compatible with the Generic Uploader Module are listed below. Be advised that the transaction types need to be added into the template with same capitalization and spelling as the beneath description:
Buy
Sell
Transfer-In
Transfer-Out
New-Position
End-Position
Only dealer users will be able to upload New Position and End Position transaction types.
Gross Amt
Write the dollar amount in the format "1000.00", meaning that there should be no dollar sign and no comma.
Fees
Fees on Buy, Sell, Transfer-In, Transfer-Out, New-Position, End-Position transactions can be added in the Position Template by using the 'Fee Identifier' column in the 'Transactions' sheet, and the 'Fees' sheet. For each transaction that will have fees applied, you will need to enter a unique value in the 'Fee Identifier' column.
Once each transaction that will receive fees has a unique 'Fee Identifier' in the 'Transactions' sheet, fees can be entered into the 'Fees' sheet of the template. You will reference each transaction using the unique 'Fee Identifier' in the 'Transaction Fee Identifier' column. Fees must be entered in total fee value, not as a percentage of the transaction. When the transactions are created in the system, fees defined in the 'Fees' sheet will apply to each specified transaction.
Uploading process
After the template has been filled out with all the information that you wish to add you will be able to select Upload.
*Before uploading the template you should TRIM LEADING AND FOLLOWING SPACES. For example, a phone number should be entered as 5555555555 and a SIN should be entered as 123456789.
You will then be able to pick the status that you want the transactions to be in once they are added to the system. If none are selected, the transactions will be uploaded in Approved status by default. The status must be defined before the file is dropped into the drop-box.
Once a file is added it will automatically start the validation and uploading process. Please note, the allowable file extensions are xls, xlsx and csv. Also, the maximum file size that can be uploaded is 80MB.
Subsequently, you will be able to track the status of the upload until it is complete. Be advised that it may take several minutes to finish based on the size of the file. If there are any issues the errors will be recorded so that you can make the necessary amendments to the file before uploading it again.
Otherwise, the file will be uploaded successfully and the data will now be in your system.