The Commission and Closing Report can be generated from the Reports Module.
From the Reports Module, simply select Commission and Closing Report from the "Choose Report Export Type" drop-down menu.
Next, you can 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 Commission and Closing Report:
Investor Type
Account Owner
Account Owner First Name
Account Owner Last Name
Corporate Contact
Joint Account Owner
Account Owner Address
Account Owner Suite
Account Owner City
Account Owner Province
Account Owner Postal
Account Owner Country
Account Owner Mailing Address
Account Owner Mailing Suite
Account Owner Mailing City
Account Owner Mailing Province
Account Owner Mailing Postal
Account Owner Mailing Country
Phone
Account Owner At Time Of Close
Account Owner Address At Time Of Close
Account Owner Suite At Time Of Close
Account Owner City At Time Of Close
Account Owner Province At Time Of Close
Account Owner Province At Time Of Close
Account Owner Postal At Time Of Close
Account Owner Country At Time Of Close
Phone At Time Of Close
Email At Time Of Close
Email At Time Of Close
SIN/BIN
Issuer
Offering
Offering Currency
Trust Company/Bank
Account #
Account Type
Account Currency
Transaction #
Batch #
Transaction Status
Transaction Type
Approved Date
Close Date
Units
Total Investment
Reinvestment %
Withholding Tax
Branch Team (ONLY IF MODULE ACTIVE)
Branch Commission (%) (ONLY IF MODULE ACTIVE)
Branch Commission ($) (ONLY IF MODULE ACTIVE)
Branch Team (%) (ONLY IF MODULE ACTIVE)
Branch Team ($) (ONLY IF MODULE ACTIVE)
Branch Manager 1 (ONLY IF MODULE ACTIVE)
Branch Manager 1 (%) (ONLY IF MODULE ACTIVE)
Branch Manager 1 ($) (ONLY IF MODULE ACTIVE)
Branch Manager 2 (ONLY IF MODULE ACTIVE)
Branch Manager 2 (%) (ONLY IF MODULE ACTIVE)
Branch Manager 2 ($) (ONLY IF MODULE ACTIVE)
Commission (%)
Commission ($)
Admin (% )
Admin ($)
Advisor GRID (%)
Advisor Paid ($)
Referral One Name (ONLY IF MODULE ACTIVE)
Referral One (%) (ONLY IF MODULE ACTIVE)
Referral One ($) (ONLY IF MODULE ACTIVE)
Referral Two Name (ONLY IF MODULE ACTIVE)
Referral Two (%) (ONLY IF MODULE ACTIVE)
Referral Two ($) (ONLY IF MODULE ACTIVE)
Owning EMD
Owning Advisor
Selling EMD
Selling Advisor
Selling Advisor Email
Selling Advisor Phone #
Selling Advisor Rep Code
Exemption
Certificate (ONLY IF MODULE ACTIVE)
Original Purchase Ref #