Anchor
_Toc439930540 _Toc439930540

Query Total Cash Summary Panel Options

The following describes the key options on the Query Total Summary panel.

• Entity List ID. Specifies the Entity list to filter query results. Or, you can select by composite entity ID to roll up all entities in the composite to the security level.
• Select by Effective Date. Specifies whether an exact date or date range is used to filter query results.
  Options include:
  –  Exact Value (Default)
  –  Range
• Effective Date. Specifies the effective date in a date range to include in query results. To use this option, you must select Exact Value as your effective date selection.
• Start Effective Date. Specifies the low effective date in a date range to include in query results. To use this option, you must select Range as your effective date selection.
• End Effective Date. Specifies the high effective date in a date range to include in query results. To use this option, you must select Range as your effective date selection.
• Right Source Name. Specifies the custodian data source to filter query results. This is the right side of the mathematical match.
• Left Source Name. Specifies the second data source to filter query results. This is the left side of the mathematical match.
• Query Based On. Specifies additional filter to use for query results. Options include Primary Asset ID, Issue Name, and Xref ID.
• Max Items. Specifies the maximum number of result records that are returned for viewing. Default is 100 records.
• Table Option. Specifies the database tables to use for querying results. You select the tables to use when you decide on the mode of comparison during Cash Recon setup.
  Options include:
  –  Cash Txn/Cust Cash Txn. Specifies the reconciliation of local Eagle cash activity to local custodian cash activity records.
  –  Warehouse/Warehouse. Specifies the reconciliation of warehouse records to warehouse records.
  –  Traded Cash/Warehouse. Specifies the reconciliation of ESTAR traded/unsettled cash activity to warehouse records.
  –  Settled Cash/Warehouse. Specifies the reconciliation of ESTAR settled cash activity to warehouse records.

Anchor
_Toc439930541 _Toc439930541

Create the Cash Recon Exceptions Report

To submit the Cash Recon Exceptions report:

1. From the Cash Recon console, double click Cash Recon Exceptions in the left pane.
2. Click the Query Cash Recon Exceptions tab.
   You see the Query Cash Recon Exceptions panel.
3. Complete the fields on the Query Cash Recon Exceptions panel.
4. Click Search.
   The report results appear on your desktop.
   You can correct breaks by entering cash transactions, correcting positions that affected cash activity, or processing corrective cash activity records from external custodian sources, and then resubmitting the Recon Cash Event panel to reconcile using the new warehouse cash activity information.

Anchor
_Toc439930542 _Toc439930542

Query Cash Recon Exceptions Panel Options

The following describes the key options on the Query Cash Recon Exceptions panel.

• Status. Specifies the status of the cash activity match to filter query results.
  Options include
  –  Unmatched
  –  Not Reconed
  –  Auto Recon
  –  Auto Recon With Tolerance
  –  Manual Recon
  –  Out-of-Balance
  –  Error
• Query Date Type. Specifies the type of date range used to filter cash activity query results.
  Options include:
  –  Post Date
  –  Trade Date
  –  Accounting Date
  –  Settlement Date
• Start Date. Specifies the low date to include in cash activity query results.
• End Date. Specifies the high date to include in cash activity query results.
• Entity Query Based On. Specifies the entity qualification to use to filter query results.
  Options include:
  –  Entity ID/Entity Composite ID
  –  Process Center
  –  Entity List
  –  All Entities
• Entity ID. Specifies the Entity ID to filter query results. Available when the Entity Query Based On option is set to Entity ID.
• Query Based On. Specifies the security qualification to use to filter query results.
  Options include:
  –  Primary Asset ID
  –  Issue Name (Default)
  –  Xref ID
• Primary Asset ID. Specifies the asset identifier to filter query results. Available when the Query Based On option is set to Primary Asset ID.
• Issue Name. Specifies the issue name to filter query results. Available when the Query Based On option is set to Issue Name.
• Xref Type. Specifies the security xreference type to use to filter query results. Available when the Query Based On option is set to Xref ID.
• Xref ID. Specifies the security xreference for the Xref ID type to filter query results. Available when the Query Based On option is set to Xref ID.
• Table Option. Specifies the data location assumed for the query.
  Options include:
  –  Cash Txn/Cust Cash Txn. Specifies the reconciliation of local Eagle cash activity to local custodian cash activity records.
  –  Warehouse/Warehouse. Specifies the reconciliation of warehouse records to warehouse records.
  –  Traded Cash/Warehouse. Specifies the reconciliation of ESTAR traded/unsettled cash activity to warehouse records.
  –  Settled Cash/Warehouse. Specifies the reconciliation of ESTAR settled cash activity to warehouse records.
• Max Items. Specifies the maximum number of result records that are returned for viewing. Default is 100 records.

You can optionally qualify report results by left source, right source, assigned by and assigned to users, cash category, has comments (yes/no), transaction type, flow type (receipts/disbursements), is approved (yes/no), category and sub-category classifications, and custom xref type.