To import the fund rebates navigate to Instrument Management > Fund Rebates
Click on the action menu to create a fund rebate.
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 has to be booked into an exception account that is owned by the house. |
From Date | The timespan for the period of the fund rebate |
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. There is possible to import fund rebates for several instruments.
The file must consist of the following fields, ISIN, Trade date, Settlement date, Value date, Amount, and Currency.
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.
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.
The transaction types that are used are:
Default_Payment_Settle_Cash_FundRebates
Default_Payment_Trade_Cash_FundRebates
