Report 8018 : Cash Balance Summary

PURPOSE

To provide the details used by CS Lucas to show the Cash Balance Summary.

WHY IS THIS IMPORTANT?

Allow users to verify the details of Cash Balance Summary.

QUERY

1. Navigate to Reporting > Standard > Report 8018: Cash Balance Summary.

blank

2. Fill in the mandatory parameter – Acct Cntr, Portfolio, As At Date.

3. Click on the required format.

4. The report shows the cash balance summary for a bank account as at reporting date. Column fields available on this report are Portfolio/SSI Reference, Trade Currency, Settled Amount in Trade Currency, Unsettled Amount in Trade Currency, Net Amount in Trade Currency, Portfolio Valuation Currency, Settled Amount in Portfolio Valuation Currency, Unsettled Amount in Portfolio Valuation Currency, Net Amount in Portfolio Valuation Currency.

blank

For explanation of blank button, please see link.

For explanation of blank buttons, please see link.

DATA SOURCE

 To view or verify the settled and unsettled amount for the following SSI,

blank

Follow the steps as shown below:

1. Navigate to Reporting > Standard > 8008 Portfolio NAV Report.

2. Select Acct Cntr* (From example: TFI-SG).

3. Select Portfolio* (From example: TACTICAL).

4. Select As At Date* (From example: 30-Jun-2017).

5. Click PDF.

blank

6. A = All transactions where portfolio are tagged to TACTICAL that are booked and settled in TF-CI-GBP on and before 30-Jun-2017.

7. B = All transactions where portfolio are tagged to TACTICAL that are booked as of 30-Jun-2017 and to be settled in TF-CI-GBP after 30-Jun-2017.

8. C = A * Valuation Rate on Reporting As At Date (See Exchange Rate Maintenance below)

= 20,602,673.46 * 1.793000

= 36,940,593.51

9. D = B * Valuation Rate on Reporting As At Date (See Exchange Rate Maintenance below)

= (2,129,376.71) * 1.793000

= (3,817,972.44)

10. E = A + B

11. F = E * Valuation Rate on Reporting As At Date (See Exchange Rate Maintenance below)

= 18,473,296.75 * 1.793000

= 33,122,621.07

Exchange Rate Maintenance for GBP/SGD on 30-Jun-2017

blank

FREQUENTLY ASKED QUESTIONS

RELATED INFORMATION

CHANGE HISTORY

blank

Categories:

0 Comments

Leave a Reply

blank

Your email address will not be published. Required fields are marked *



    Close Bitnami banner
    Bitnami