Manage Fund Rebates

To import the fund rebates navigate to Instrument Management > Fund Rebates

Click on the action menu to create a fund rebate.

Property	Comment

Property	Comment
Name	The name of the fund rebate
From Account	The account where the money for the fund rebates is deposited. The total amount in the fund rebate must manually be deposited in this account.
Exception Account	If the amount does not match the difference is booked into an exception account that is owned by the house.
From Date	The timespan for the period of the fund rebate. A period from when the customer should av a position in the fund.
To Date

Click Confirm to create the fund rebate. A new tab will be opened where you will view information about the Fund Rebate which now has status Created.

Click on the button Edit if you need to change any information about the Fund Rebate.

Now you can import a file with the fund rebate/rebates.

Use our example file to import your rebates. It is possible to import fund rebates for several instruments. The file must consist of the following fields, ISIN, TradeDate, SettlementDate, ValueDate, Amount, and Currency. The spelling of the words must be like the example file.

When the file is uploaded the fund rebate gets status In Progress and the file is visible under File.

If you want to attach a new file you need to remove the uploaded file by clicking on the button Clear, which removes the file but saves the data about the Fund Rebate. (If you click Clear when the file is prepared the prepared fund rebates transactions will be removed.)

Click on the button Prepare to review the transactions that will be created on the customers.

Click on the + icon to expand the fund rebate and to review the transaction that will be created.

In this example, we can see that there will be a little diff (view amount in Total distributed amount and Total amount). The transactions on the exception account will not be visible in this view. Navigate to the big transaction list or to the exception account to view the transactions. This will only be possible when the fund rebate is executed.

Click the button Execute to apply the fund rebates to the customers.

The fund rebate is now executed and fund rebate transactions are created on the customers.

If you navigate to the big transaction list, Transactions > Business Transactions, you can filter on the transactions that are in the same fund rebate. Click on the icon to filter on batch id.

Error handling

If there is something wrong with the file there will be an error message. To make it easier for the user to find the error the message shows which row as well as a description of the error. See the examples below.

Correct the file and import it again.

Exceptions

There can also be an exception these will be visible on the transaction after doing Prepare or Execute. Example: A customer should not have a fund rebate transaction if the account is closed. Then the transactions should be created on the exception account instead.

There will be a message in the transaction list about the exception.

The transactions will be made on the exception account instead of the closed customer accounts.