PURPOSE
To provide the details used by CS Lucas to show Call/Sweep Interest Income and Expenses.
WHY IS THIS IMPORTANT?
Allow users to verify the details of Call/Sweep Interest Income and Expenses.
QUERY
1. Navigate to Reporting > Standard > Report 3108: Call/Sweep Interest Income and Expenses.
2. Fill in the mandatory parameter – Acct Cntr, Call/Sweep Shortname, From Date, Time Bucket.
3. Click Action and select the required format.
4. The report shows Counterparty, Currency and Call/Sweep Interest Income/ Expense by different time buckets.
For explanation of Excel Raw export, please see link.
For explanation of buttons, please see link.
DATA SOURCE
To verify the interest expense amount for the following,
Follow the steps as shown below:
1. Navigate to Transaction > Call/Sweep.
2. Select View* to Cumulative.
3. Select Short Name* (From example: PINE-Funding).
4. Select View* (From example: PINE-NY/ PINE-SF).
5. Select VDate From 1-Jun-2017 to 30-Jun-2017.
6. Tick the checkbox to include Accrual to last end date.
7. Click Refresh.
8. Interest outstanding (30-Jun-2017 included) is -324.57.
9. Change the VDate to 31-Jul-2017 and click Refresh.
10. Interest outstanding (31-Jul-2017 included) is -1,507.64.
11. D = -1,507.64 – (- 324.57)
= -1,183.07
FREQUENTLY ASKED QUESTIONS
RELATED INFORMATION
CHANGE HISTORY
0 Comments