The Redemption Template is a part of the Import Module and is a self-serving tool that can be used to upload Redemption transactions for 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 'Redemption Template' in order to generate the Excel file that you will fill in with the information that you wish to upload.

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.

Investor Name

Offering

Account Number

Transaction Type*

# Units Redeemed*

Cost Per Unit*

Approved Date*

Closed Date*

Purchase Tran Num*

Fee/Charge

Admin Fee

Reinvestment %*

We have provided a more comprehensive explanation of a few of these fields below:

Transaction Type*

The available inputs that need to be entered in these exact formats are REDEMPTION and SALE.

Closed Date*

The Closed Date on a transaction will be the date displayed on statements and the investor portal.

* Please note, all of the dates should be entered in Y-M-D format

Purchase Tran Num*

Within this column, the transaction # of the investor's first Buy, Transfer In or New Position transaction type should be added. The system will be able to determine the investor, account and issuer/offering based on the related transaction.

A tip for finding this number is to create an Offering Securities Export and refer to the column named Original Purchase Ref as it will output this number for each investor.

Fee/Charge

Depending on what fees you track, this column will allow you to enter a regular Fee/Charge which reflects what the investor paid.

Admin Fee

This column allows you to enter an Admin Fee which reflects what the investor paid.

Reinvestment %*

This will be the investor's reinvestment % going forward for all future distributions.

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

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.

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.