PURPOSE
To provide the details used by CS Lucas to show total amount of deposit by bank sorted out by currency.
WHY IS THIS IMPORTANT?
Allow users to verify the details of Trade.
QUERY
1. Navigate to Reporting > Standard > Report 2021: Deposit By Bank.
2. Fill in the mandatory parameters – Acct Cntr, As At Date, Reporting Currency and Rate Type. Portfolio Group is an optional parameter.
3. Click Action and select the required format.
4. The report shows the Bank, Client, Accounting Centre, Currency, Principal (Amount), Rates, Value Date, Days, Due Date, Interest Earned, Exchange Rate, Principal in the reporting currency and Interest in the reporting currency.
For explanation of Excel Raw export, please see link.
For explanation of buttons, please see link.
DATA SOURCE
To view the following transaction,
Follow the steps as shown below:
1. Navigate to Transaction > Money Market.
2. Select Acct Cntr: TFS-SG.
3. Select Transaction: Lend/Place.
4. Key in the Mdate From*: 08/07/2017 and MDate To: 08/07/2017.
5. Click Refresh.
6. Click on the Edit button of the trade to drill down to the Amend Money Market screen.
7. H = Number of days between Value Date (G) and Due Date (I). Due Date (I) – Value Date (G).
8. K = Exchange Rate (Valuation/ Accounting/ Alternate based on selected Rate Type). Navigate to Prices > Exchange Rate.
9. L = Principal in the reporting currency. Principal (E) * Ex Rate (K).
10. M = Interest Earned in the reporting currency. Interest (J) * Ex Rate (K).
FREQUENTLY ASKED QUESTIONS
RELATED INFORMATION
CHANGE HISTORY
0 Comments