Report 2022: Money Market Transaction Analysis

See previous W5 version guide

PURPOSE

To provide the details used by CS Lucas to show Money Market Movement sort by Counterparty ID and Currency.

WHY IS THIS IMPORTANT?

Allow users to verify the details of Money Market Trade.

QUERY

1. Navigate to Reporting > Standard > Report 2022: Money Market Transaction Analysis.

blank

2. Fill in the mandatory parameters – Acct Cntr, From Date and To Date, Borrow/Lend, Report Currency and Rate Type. The rest are optional parameters.

3. Click Action and select the required format.

4. The report shows the Accounting Centre, Counterparty ID, Trade ID, VDate, MDate, Days, Rate, Interest, Currency, Principal (Amount), New and Matured.

blank

For explanation of Excel Raw export, please see link.
For explanation of blank buttons, please see link.

DATA SOURCE

To view the following transaction,

blank

Follow the steps as shown below:

1. Navigate to Transaction > Money Market.

2. Key in the Mdate From: 01/06/2017.

3. Select Ctpy: DBS-SG.

4. Select Transaction: Lend/Place.

5. Click Refresh.

6. Click on the Edit button of the trade (From example: MMK100001.00) to drill down to the Amend Money Market screen.

blank

7. F = Number of days between VDate (D) and MDate (E). MDate (E) – VDate (D).

8. L = Exchange Rate (Valuation/ Accounting/ Alternate based on selected Rate Type). Navigate to Prices > Exchange Rate.

9. M = New Principal in the reporting currency. Principal (J) * Ex Rate (L).

10. N = Outstanding Principal in the reporting currency as at reporting to date. Principal (K) * Ex Rate (L).

    FREQUENTLY ASKED QUESTIONS

     

    RELATED INFORMATION

     

    CHANGE HISTORY

    blank

    Categories:

    0 Comments

    Leave a Reply

    blank

    Your email address will not be published.



      Close Bitnami banner
      Bitnami