Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

You can use the Cash Recon console to create a total summary and detail report of cash match exceptions, with counts by security and match status. You can drill down and view the activity detail within each security. Results are based on the CASH_EXCEPTION table in the MSGCENTER database.

Create the Total Cash Summary Report

The Total Cash Summary report displays the statistical counts of cash activity matches and non-matches for each entity. You can submit the report using a effective date range, source, and entity list.

To create the Total Cash Summary report for cash activity:

  1. From the Cash Recon console, double click Total Cash Summary in the left pane.
  2. Click the Query Total Cash Summary tab.
    You see the Query Total Cash Summary panel.
  3. Complete the options on the Query Total Cash Summary panel.
  4. Click Search.
    You see the Total Cash Summary report.

Content on this page:

Query Total Cash Summary Panel Options

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

OptionDescription
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 DateSpecifies 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 DateSpecifies 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 DateSpecifies 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 NameSpecifies the custodian data source to filter query results. This is the right side of the mathematical match.
Left Source NameSpecifies the second data source to filter query results. This is the left side of the mathematical match.
Query Based OnSpecifies additional filter to use for query results. Options include Primary Asset ID, Issue Name, and Xref ID.
Max ItemsSpecifies the maximum number of result records that are returned for viewing. Default is 100 records.
Table OptionSpecifies 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


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.

Query Cash Recon Exceptions Panel Options

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

OptionDescription
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 DateSpecifies the low date to include in cash activity query results.
End DateSpecifies 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 IDSpecifies 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 IDSpecifies the asset identifier to filter query results. Available when the Query Based On option is set to Primary Asset ID.
Issue NameSpecifies the issue name to filter query results. Available when the Query Based On option is set to Issue Name.
Xref TypeSpecifies the security xreference type to use to filter query results. Available when the Query Based On option is set to Xref ID.
Xref IDSpecifies 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 ItemsSpecifies 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.

Specifies whether an exact date or date range is used to filter query results. Options include:

  • Exact Value (Default)
  • Range

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.

Specifies whether an exact date or date range is used to filter query results. Options include:

  • Exact Value (Default)
  • Range
  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.