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.
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.
For explanation of button, please see link.
For explanation of buttons, please see link.
DATA SOURCE
To view or verify the settled and unsettled amount for the following SSI,
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.
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
FREQUENTLY ASKED QUESTIONS
RELATED INFORMATION
CHANGE HISTORY
0 Comments