The Custodial Cash Journal report displays the settled and traded cash records and cash balances stored in a custody basis for a given date range or type of date for entities. Cash segregation allows the system to track and store transaction activity by custody location and settlement cash account in the custody basis, which is a separate accounting basis from that used for core accounting. Grid and advanced report views available for this report include:
- Summary. This view displays basic cash information with the net amount local.
- Settled Detail. This view displays additional information, including accounting date and transaction code.
To create the Custodial Cash Journal report:
- In Accounting Center, in the left navigation pane, click Reports > Investment Accounting Reports > Cash > Custodial Cash Journal Report.
You see the Custodial Cash Journal Report panel. - Complete the fields on the Custodial Cash Journal Report panel.
- Under Result Options, click Grid or Advanced Report.
- Click Submit.
The report appears on your desktop for the view selected. An example follows.
Custodial Cash Journal Report Panel Options
A definition of the options on the Custodial Cash Journal Report panel follows.
| Option | Description |
|---|---|
Entity/Custodian Selection Criteria | |
| Entity ID | Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity. |
| Entity Name | Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by name of the entity. |
| Custody Bank Name | Specifies the name of the custodian bank. The lookup displays the bank account relationships established between the entity or the entity's reporting composite and the custodian bank, showing the custodian bank name, custodian bank code, and custodian bank account number. |
| Custody Bank Code | Specifies the code value, or short name, used to identify the custodian bank holding the assets. |
| Custody Bank Account Number | Specifies the custodian bank account number for the entity that is held in custody. |
| Cash Account Name | Specifies the name of the cash account for the custodian. The lookup displays the available cash accounts based on the cash account relationships defined for the selected custodian's bank account relationship. |
| Cash Account Number | Specifies the account number of the cash account for the custodian. |
Search Criteria | |
| Accounting Basis | Specifies the accounting basis for the entity. By default, the panel displays the entity's custody basis. For example, CUST. |
| Report Type | Specifies the type of date for controlling your report results. Options include:
|
| Report Period | Specifies the time period, date range, or particular date for your report. The time period may be entity specific or security specific, such as fiscal year. Options include:
|
| Report Start Date | Specifies the start date for your report results. The default is first day of the current month. To use this option, you must select Date Range as your report period. |
| Report End Date | Specifies the ending date for your report results. The default is today's date. |
| Report View | Indicates whether to show settled or traded report results. The default is Settled. |
| Cash Balance Grouping | Specifies the level for grouping the cash balances. Options include:
|
| Show Cancels? | Allows you to show cancel events in your report results. The default is No. |
| Show Zero Balances? | Allows you show zero balances in your report results. The default is Yes. |
Selection Criteria | |
| Report Filters | Allows you to show/hide additional report and security filters. The default is No. |
| Advanced Report Options | Allows you to show/hide advanced report, group, sort, and format options. The default is No. |
| Filter Security By | Allows you to show/hide additional report filters. Options include:
|
| Other Filters | You can filter results using other filters. Options include:
|
0 Comments