Use Trade Recon for Warehouse Reconciliation

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

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.

Content on this page:

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.

  • DS Option (tag 989). Displays the configured DataSetOption. Options include 1 (DTCC) and 2 (Warehouse to Warehouse).
  • Low/High Precision Switch (tag 7003). Indicates whether high precision tolerance amounts are used. Default is low precision.
  • Left Source Name (tag 1102). Specifies the data source or source list to use for the left match.
  • Right Source Name (tag 1114). Specifies the data source or source list to use for the right match.
  • Post Date (tag 30). Specifies the post date of the records to match.
  • Entity Name (tag 1164). Specifies the name of the entity to match on trades.
  • Entity ID (tag 1163). Specifies the entity ID or composite entity ID to match on trades.
  • Entity Active Status (tag 1283). Specifies the entity active status to filter trades.
  • Tolerance Rule ID (tag 4256). Specifies the tolerance rule, including trade record filters.
  • Price Tolerance (tag 7660). Specifies the price tolerance for matched trades. Default is 0.25.
  • Principal Tolerance (tag 7661). Specifies the principal tolerance for matched trades. Default is 0.25.
  • Quantity Tolerance (tag 7662). Specifies the quantity tolerance for matched trades. Default is 0.25.
  • Accrued Tolerance (tag 7663). Specifies the accrued tolerance for matched trades. Default is 0.25.
  • Settlement Amount Tol (tag 7664). Specifies the settlement amount tolerance for matched trades. Default is 0.25.
  • User Float1 Tolerance (tag 4697). Specifies the tolerance amount allowed for User Float1.
  • User Float2 Tolerance (tag 4698). Specifies the tolerance amount allowed for User Float2.
  • User Float3 Tolerance (tag 4699). Specifies the tolerance amount allowed for User Float3.
  • User Char1 Tolerance Switch (tag 7051). Indicates whether to reconcile for matching User Char1 values.
  • User Char2 Tolerance Switch (tag 7052). Indicates whether to reconcile for matching User Char2 values.
  • User Char3 Tolerance Switch (tag 7053). Indicates whether to reconcile for matching User Char3 values.
  • User Char3 Tolerance (tag 2501). Indicates whether to reconcile for matching User Char3 values.
  • Unmatch Only (tag 7250). Indicates whether to store only unmatched or out of balance records to the Exception tables to conserve table space.
  • Event ID Switch (tag 7251). Indicates whether to use event ID or Trade Ticket Number for trade match with Entity ID, Security ID, and Event type.