Create Cash Recon Exception Reports

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.

Query Total Cash Summary Panel Options

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

Option

Description

Option

Description

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

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.

Option

Description

Option

Description

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.

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

  • Exact Value (Default)

  • Range

Â