Uploading Fee Deductions from a File

You can upload up to 25,000 fee deductions using a single text file (.txt) that you can create from a spreadsheet. The text file format must comply with the following specifications:

·         Column A:Must contain a nine-digit Account Number (Although not essential, it is recommended that you omit any dashes (-) that may exist.). IMPORTANT: This tool is case-sensitive. Therefore, if any of your account numbers include alpha characters, you must represent these characters using uppercase letters. If you do not, you will receive an error message and the associated fees will not be deducted.

·         Column B:Must contain a Fee Amount (Although not essential, it is recommended that you omit any commas (,) and dollar signs ($)). Do not total this column.

NOTE:

·         To create a text file (.txt) from a Microsoft Excel file (.xls), open the Excel file and then choose Save Asfrom the File In the dialog box, locate the folder in which you want to save the .txt file and then select Text (Tab delimited) (*.txt) from the Save as type drop-down list. Enter the Filename and then select the Save button.

·         If you wish to upload more than 25,000 deductions, you must use more than one .txt file (since there is a limit of 25,000 fee deductions per file or batch).

 

To upload fee deductions from a file

1.     Select Service> Fees > Advisor Fees - Brokerage > Fee Deductions. The Upload Fees From a File screen displays.

2.     Using the associated drop-down list, select the Fee Type.

3.     Using the Filetext field, enter the filename of the text (.txt) file containing the client account numbers and corresponding fee deductions you wish to upload. NOTE: If you do not know the file's location or its name, select the Browse button to find it. You can upload up to 25,000 fee deductions per batch.

4.     Select the Verify A verification window displays the File Name, Fee Type, Total Records, and dollar amount of the Total Fee Deductions. Review the contents. At this point, you can select the Cancellink to terminate the operation.NOTE: You can select the View Batch Details link to display a pop-up window containing a list of the individual records in the file and their associated Account Number and fee Amount. If you wish, you can select the Print link to display a print dialog box, which you can use to print the contents (up to 500 entries).

5.     If you need to make any changes, select the Editbutton to return to the Upload Fees From a File screen.
OR
If you want to continue with the upload, select the Submit A confirmation screen displays the Batch Summary information and a status message related to the fee deduction submittal.

6.     If you chose to continue with the submittal and are on the confirmation screen, you can do one of the following:

·         If you want to continue entering fee deductions, you can select the Upload From a File
OR

·         If you want to review any of the fee deductions you submitted (either in this or other selected batches), select the Go to Fee Historylink to display the Fee History Tab.