Create Cash Recon Exception Reports

Owned by Tom Fahey (Unlicensed)
Last updated: Oct 04, 2016 by Former user (Deleted)
4 min read

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.

  • 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.

  • 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.