Skip to main content
Trailer Uploader

How to use the Trailer Uploader

Exempt Edge avatar
Written by Exempt Edge
Updated over a year ago

The Trailer Template is a part of the Uploader Module and is a self-serving tool that can be used to upload Trailer transactions for existing investors.

Once the Uploader Module is activated you will notice a new module on the left side of your screen.

After selecting this tab, you will able to click on β€˜Download Templates’ and select 'Trailer 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, it's required to enter information into each column.

Dealer Code

Selling Advisor Rep Code

Create Date

Trade Date

Settle Date

Reference Transaction #

$ amount of total trailer fee

DR Grid %

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

Dealer Code

For users on Dealer Edge the Dealer Code can be added within the Company Details tab in the Admin Module.

For users on Issuer Edge, each Dealer in your system will be assigned a Dealer Code that can be added into this column.

Selling Advisor Rep Code

Every Advisor profile will have a rep code that can be added into this column.

The advisor rep code added in this column will populate the Selling Advisor field in the transaction. The Owning Advisor will be populated with the advisor that is on the profile.

Create Date

Please add the date in the yyyy-mm-dd format.

Trade Date

Please add the date in the yyyy-mm-dd format.

Settle Date

Please add the date in the yyyy-mm-dd format.

Reference Transaction #

Within this column the transaction # of the related Buy, Transfer In or New Position transaction type can 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 as the column named Original Purchase Ref will output this number for each investor.

$ amount of total trailer fee

The total trailer amount is entered into this column. Do not add any symbols.

DR Grid %

Please note, the existing DR Grid % on the advisor profile will not be replaced. The value added into this column will only apply to the specific trailer transaction being uploaded.

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.

Related articles

Did this answer your question?