Use Trade Recon for Warehouse Reconciliation

The Trade Recon console directs and monitors the trade reconciliation process for the warehouse to warehouse trade comparison approach. You can submit message streams to upload trades to the TRADE table in the TRADES database of the Eagle data warehouse and then directly match records stored under different sources. The trade match results are posted to the TRADE_RECON_EXCEPTION table in the MSGCENTER database. The TRADE_RECON_LASTRUN table tracks the most recent instance from the TRADES database to prevent unnecessarily running the reconciliation when no newer data is available.

Match Using the Trade Recon Console

You can use the Tools menu options on the Trade Recon console to match and reconcile trade activity. You can create and reuse profiles to specify the match and tolerance criteria, including the tolerance rules, the entities, and the approximate effective date of records to reconcile.

To match and reconcile trades from the Trade Recon console:

  1. Confirm that the trade activity data to reconcile is available in the data warehouse.

  2. On the Tools menu, click Run Match Now.
    You see the Run Match Now dialog box.
    NOTE: You can click the Matching Profile drop down and select a previously saved set of options for reuse.

  3. Click the Left Source drop down and select the data source for the left side of the match.

  4. Click the Right Source drop down and select the data source for the right side of the match.

  5. Click Date and select the business date for the records to match within tolerance.

  6. Click Tolerance Rule and select the tolerance rule you want to apply before applying the tolerances specified in the Run Match Now default message stream.
    For example, you can create tolerance rules to control reconciling cash records based on transaction types, security types, and entities.

  7. Set Scope with the entity criteria for the records to reconcile.
    Options include:
    –  All Entities. Reconcile all entities.
    –  Process Center. Reconcile entities by specific process center.
    –  Entity List. Reconcile entities by entity list.
    –  One Entity. Reconcile a specific entity.

  8. Click Save to store these options as a matching profile for reuse with this dialog box.

  9. Click Submit.
    You see the stream specified by the corresponding Match Stream option in the MSGSERVICE.INI file submitted to Message Center for processing.

Eagle recommends storing only out of balance exceptions to conserve database storage. You can elect to store only out of balance exceptions by setting switches in the Message Center runmatch_db2 rule used by the trade match stream.

Match Using a Run Match Now Stream

You can use a Run Match Now message stream to perform the match and reconciliation using Message Center services.

To match and reconcile cash activity using a Run Match Now message stream:

  1. From the Message Center console, click Message Streams.
    You see the Msg Stream Query dialog box.

  2. Enter Trade in the Title text box.

  3. Click Search.
    You see the list of message streams with titles starting with the character string in the text box.

  4. Select the Run Match Now message stream you want to execute.
    NOTE: The Eagle default message stream is trade-match-db. You can copy, rename, and customize this stream and then establish the custom stream as the Run Match Now default option using MSGSERVICE.INI parameters.

  5. Right click Run Now.
    You see the message stream submitted for execution.

 You must customize the rules used by the Run Match Now message stream to control the entities, securities, and cash field tolerances you want to use during reconciliation.

Match Using the Recon Trades Event Panel

You can use a Recon Trades event panel to match and reconcile trade activity.

To reconcile trade activity using the Recon Trades event panel:

  1. From the Accounting Center window, select Reconciliation in the left navigation and then click Trade Recon and Recon Event.

  2. Double click Recon Trades.
    You see the Recon Trades entry panel.

  3. Complete the Recon Trades Cash Event panel options.

  4. Click Submit.

Recon Trades Event Panel Options

The descriptions of the key options on the Recon Trades Cash Event panel follow.

Option

Tag

Description

Option

Tag

Description

DS Option

989

Displays the configured DataSetOption. Options include 1 (DTCC) and 2 (Warehouse to Warehouse).

Low/High Precision Switch

7003

Indicates whether high precision tolerance amounts are used. Default is low precision.

Left Source Name

1102

Specifies the data source or source list to use for the left match.

Right Source Name

1114

Specifies the data source or source list to use for the right match.

Post Date

30

Specifies the post date of the records to match.

Entity Name

1164

Specifies the name of the entity to match on trades.

Entity ID

1163

Specifies the entity ID or composite entity ID to match on trades.

Entity Active Status

1283

Specifies the entity active status to filter trades.

Tolerance Rule ID

4256

Specifies the tolerance rule, including trade record filters.

Price Tolerance

7660

Specifies the price tolerance for matched trades. Default is 0.25.

Principal Tolerance

7661

Specifies the principal tolerance for matched trades. Default is 0.25.

Quantity Tolerance

7662

Specifies the quantity tolerance for matched trades. Default is 0.25.

Accrued Tolerance

7663

Specifies the accrued tolerance for matched trades. Default is 0.25.

Settlement Amount Tol

7664

Specifies the settlement amount tolerance for matched trades. Default is 0.25.

User Float1 Tolerance

4697

Specifies the tolerance amount allowed for User Float1.

User Float2 Tolerance

4698

Specifies the tolerance amount allowed for User Float2.

User Float3 Tolerance

4699

Specifies the tolerance amount allowed for User Float3.

User Char1 Tolerance Switch

7051

Indicates whether to reconcile for matching User Char1 values.

User Char2 Tolerance Switch

7052

Indicates whether to reconcile for matching User Char2 values.

User Char3 Tolerance Switch

7053

Indicates whether to reconcile for matching User Char3 values.

User Char3 Tolerance

2501

Indicates whether to reconcile for matching User Char3 values.

Unmatch Only

7250

Indicates whether to store only unmatched or out of balance records to the Exception tables to conserve table space.

Event ID Switch

7251

Indicates whether to use event ID or Trade Ticket Number for trade match with Entity ID, Security ID, and Event type.

Â