How to Pull a Standard Export:
The Standard Export can be generated from within both the Reports Module and Transactions Module.
From the Reports Module, simply select Standard Export from the "Choose Report Export Type" drop-down menu.
From the Transactions Module, click the "Export" button and select "Standard Export."
In both cases, filter your results using the provided fields. Please note that "Use Date Entry" is the only required field. Once you have defined your parameters, click "Export."
Your report will be viewable in the Report Exports tab. It may take a few minutes to generate the full report. You’ll still be able to download the CSV file during this process even if all the information hasn’t been added yet.
Headers Found in the Standard Export:
Investor Status
Investor Type
Transaction #
Batch #
Batch Master
Status
Confirmation Status
Requested Date
Approved Date
Closed Date
Transaction Type
Credit/Debit
Issuer
Offering Name
Offering Currency
Trust Company
Account Type
Account Currency
Account Other
Account Number
Account Description
Units
Cost Per Unit
Total Amount
Remaining Cash Value
Cash Value Used
Commission (%)
Commission ($)
Admin Commission (%)
Admin Commission ($)
DR Commission (%)
DR Commission ($)
Transaction Fee
Other Fee
Issuer Fee
Percent Reinvestment (%)
Withhold Tax (%)
Account Owner
SIN/BIN
Company Name
Corporate Contact
Conversion
Joint Account Owner
External Application Reference #
Certificate #
Selling Advisor
Transaction Dealer
Owning Advisor
Owning Dealer
Investor External ID