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:

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

On this page

1 Create the Total Cash Summary Report
2 Query Total Cash Summary Panel Options
3 Create the Cash Recon Exceptions Report
4 Query Cash Recon Exceptions Panel Options

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:

From the Cash Recon console, double click Cash Recon Exceptions in the left pane.
Click the Query Cash Recon Exceptions tab.
You see the Query Cash Recon Exceptions panel.
Complete the fields on the Query Cash Recon Exceptions panel.
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