View Segregated Position Data for One Portfolio

In the Position Viewer workspace, when you view position data for one portfolio and use cash segregation, you can view information in the portfolio's custody accounting basis for a position that has one or more custodians. 

Search Position Data for One Portfolio by Custody Location

In the Position Viewer workspace, you can view unit and cash balances by custody location and settlement cash account for positions in entities that use cash segregation. If you hold a position in multiple custodian banks, you can identify quantity for holdings associated with each custodian in the custody basis. You can also identify the entitlements for units or cash that are segregated at the custodian level.

To search position data for one portfolio by custody location:

  1. In Accounting Center, in the left navigation pane, click Reports > Position Viewer.
    You see the Position Viewer workspace. The Search Type option has a value of One Portfolio by default.

  2. In the Search Details pane, select the entity and source you want to view.

  3. Click the Account Basis field and select the entity's custody basis.
    The custody basis is the entity's accounting basis that has its Position Cash Segregation Basis field set to Yes to enable cash segregation. 

  4. Click the Custodian Bank field or Custodian Bank Code field to select a custodian bank.
    You can select a custodian bank which has an bank account relationship defined for the entity or the entity's reporting composite. If multiple custodians have bank account relationships with the entity, you can select one custodian.

  5. Click the Cash Balance Date Type field and indicate the date type of cash balance record you want to view.
    Options include:
    –  Posting date
    –  Trade date
    –  Accounting date
    –  Contractual settlement date
    –  Month end date

  6. Click the Display Zero Cash Balances field and select Yes or No.
    If you select Yes, the query includes cash balance records for the specified cash position and asset currency. A zero cash balance is a valid balance. Otherwise, the results exclude zero cash balances.

  7. Complete the remaining search criteria.

  8. Click the Search button.
    You see the Cost, Cash, and Income objects for the position that met your criteria.

  9. View the Cost, Cash, and Income position data. 
    If a position in an entity that uses cash segregation has holdings in multiple custody locations, the grid results can include multiple Cost objects, multiple Cash objects, and multiple Income objects for a single position in the custody basis. 

View Segregated Asset Quantities in the Cost Object

In the Position Viewer workspace, if you use cash segregation, the Cost object for the custody basis allows you to view the asset quantity (units/shares) associated with a specified custody location for a position that has multiple custodians.

To view cost accounting information for a specific position with cash segregation:

  1. In Accounting Center, in the left navigation pane, click Reports > Position Viewer.
    You see the Position Viewer workspace.

  2. View positions for one portfolio by custody location.

  3. Select the position in the custody accounting basis that you want to view.
    If the position in an entity that uses cash segregation has holdings associated with multiple custody locations in the custody basis, you see multiple Cost objects for that position.

  4. In the Reports list, select Cost.
    You see the tabs that apply to the Cost object. populated with data, if there is related activity available. Tabs containing data are highlighted. You can view the asset quantity (units/shares) associated with the specified custody location for a position.

  5. Click a row to view the cost accounting activity in the Cost object.
    The Source System Code column (tag 98) value for a position's custody basis identifies the bank account relationship alias for the custodian associated with the segregated custodian quantity. This value matches the value of the transaction's Bank Alias (tag 16). (Otherwise, the Source System Code for a non custody basis displays a value of F.)

The following figure shows details from the Cost object for the custody basis of a position in an entity that uses cash segregation. The search results include cost information for more than one custodian location, and you see two Cost objects for the issue in the grid rather than a single Cost object.

Position Viewer - Summary Tab

If you click the row for the second Cost object, in the Summary tab you see the Source System Code column (tag 98). You can double-click the source system row to display the value of 3848, in this example, for that Cost object in position's custody basis. This numeric value identifies the bank account relationship alias for the custodian associated with the segregated custodian quantity. This value matches the value of the transaction's Bank Alias (tag 16).

If you click the Open Lots tab to view the transaction details and scroll to the right, you can see the custodian information for the transaction. You can see the Bank Alias value of 3848, which identifies the instance of the bank account relationship that applies to the transaction. The bank account relationship links the custody location (custody bank/custody bank account number grouping) to the entity or entity group.

Position Viewer - Open Lots Tab

View Segregated Cash Balances in the Cash Object

You can view traded and settled cash balances associated with a Cash object. For entities that do not use cash segregation, you can view the overall cash balances. For entities that use cash segregation, you can view the Cash object in the entity's custody basis to view the cash and cash account associated with a specified custody location for a position that has multiple custodians.

The results for the Position Viewer workspace display local currency cash balances. To view non local currency balances, you can select the Position Viewer's Cash Position - Different Settle Currency option.

To view cash activity for a specific position with cash segregation:

  1. In Accounting Center, in the left navigation pane, click Reports > Position Viewer.
    You see the Position Viewer workspace.

  2. View positions for one portfolio by custody location.

  3. Select the position in the custody accounting basis that you want to view.

  4. If the position in an entity that uses cash segregation has cash associated with multiple custody locations in the custody basis, you see multiple Cash objects for that position.

  5. In the Reports list, select Cash.
    You see the tabs that apply to the Cash object populated with data. The following tabs associated with the Cash object provide information related to cash segregation:
    –  Traded Cash Balances. Displays the traded cash balance records for the position.
    –  Settled Cash Balance. Displays the settled cash balance records for the position.

  6. Click a row to view the cash activity in the Cash object.
    In the Traded Cash Balance tab or the Settled Cash Balance tab for the position's custody basis, the cash balance's Source System Code column (tag 98) value identifies the bank account relationship instance for the custodian associated with the segregated custodian cash amount in the custody basis. This value matches the value of the transaction's Bank Alias (tag 16). (Otherwise, the Source System Code for a non custody basis displays a value of F.) The Cash Account Alias column (tag 11698) identifies the cash account relationship instance for the cash balance record.

An example follows. In the following Cash object example, you select the custody basis of a position in an entity that uses cash segregation. The query results include cost information for more than one custodian location, and you see two Cash objects for the issue in the grid rather than a single Cash object.

After you set Reports to the Cash Position - Asset Currency option, you can click the Traded Cash Balance tab or the Settled Cash Balance tab to view the cash balances for the selected custody location. The cash balance's Source System Code column (tag 98) value identifies the bank account relationship instance for the custodian associated with the segregated custodian cash amount in the custody basis. This value matches the value of the transaction's Bank Alias (tag 16). The Cash Account Alias column (tag 11698) identifies the cash account relationship instance for the cash balance record.

If you examine the cash for a trade, corporate action, or direct cash event, you can see the information for the custodian cash account that the system assigned during processing during rules defined in bank account relationships and cash account relationships. You can view the custodian details in the Receipts, Disbursements, Traded, and Settled tabs, for example.