The Securities Export is a report that can be generated on a by offering basis which will provide a list of all active investors within an offering and their current units held as of a particular date. Please note, you can only generate one report per offering, so you may need to pull several reports to meet your requirements (i.e. if you require a report for all offerings within an Issuer).
To pull this report, navigate to the Reports/Exports Module. From the 'Choose Report Export Type' drop-down, select Securities Export.
Once this has been selected, you will be able to define the offering, high date, and whether or not you would like to include zero units.
Please note, if the 'Show Zero Units' toggle is turned off, investors that have 0 or near 0 (less than minimum digit) units will not be shown in the batch list. If turned on, all investors that were involved in this offering will be shown, regardless if they still have units.
Once your criteria has been defined, click 'Export'. The report will be queued and available for download in the Reports/Exports tab once it has completed processing.
The following columns are listed in the Securities Export:
Account Owners
Offering Name
Offering Currency
Units
Raw Units
Average Cost Per Unit - Original Cost
Position Cost
Raw Transaction Value
CMV Per Unit
Current Market Value
% Ownership
Current Reinvestment %
Trust
Account Type
Account Number
Account External Reference
Account Additional
Account Description
Address
City
Province
Postal
Country
Email
SIN/BIN
EMD
Owning Advisor
Advisor Email
External Identifier
Original Purchase Reference Number