Match Cash Activity

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

Recon Center allows you to reconcile traded and settled cash activity within a settled/traded date tolerance. You can use the Cash Recon console to trigger the match process using tolerance rules and cash match profiles. Or, you can use a recon cash event to manually trigger reconciliation for model office testing and quality assurance purposes. You can use a customized Run Match Now stream to implement the cash match and reconciliation process for the production cycle. The trade match results are posted to the CASH_RECON_EXCEPTION table in the MSGCENTER database. The CASH_RECON_LASTRUN table tracks the most recent instance from the TRADES database to prevent unnecessarily running the reconciliation when no newer cash activity is available.

The three supported modes of warehouse to warehouse cash matching are:

  • Traded STAR Cash. Matches the ESTAR TRADED_CASH_ACTIVITY table to the CASH CASH_ACTIVITY table.
  • Settled STAR Cash Match. Matches the ESTAR SETTLED_CASH_ACTIVITY table to the CASH CASH_ACTIVITY table.
  • Warehouse to Warehouse Cash Match. Matches the CASH CASH_ACTIVITY table to the CASH CASH_ACTIVITY table.
Content on this page:

Match Using the Cash Recon Console

You can use the Tools menu options on the Cash Recon console to match and reconcile cash activity records. 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 cash activity from the Cash Recon console:

  1. Confirm that the cash activity data to reconcile is available in the locations expected for your mode of comparison, before using the Cash Recon console to schedule the recon message streams:
    –  ESTAR Traded/Settled Cash Activity. You must confirm that all Eagle STAR settled/traded cash activity is complete and file processing statistics are recorded.
    –  Data Warehouse Tables. You must confirm that all cash activity data uploads from external sources have completed. You can view the Message Center console (MCC) file processing statistics for load streams to check record counts and completion statuses. If using STARDIRECT warehouse records, you must confirm that the STAR to PACE Direct batch process has completed for cash activity, for the portfolios you want to reconcile. If using the eagle_default_in_CSV_ThirdParty2Pace message stream to load the CASH database, confirm that stream activity has completed.
    –  Local Tables. You must confirm that all required message streams to load cash activity records to work tables have completed. You can use the Cash Txn report and the Cust Cash Txns report to view the loaded work tables for reasonableness and completion.
  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 by process center.
    –  Entity List. Reconcile by entity list.
    –  One Entity. Reconcile by 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.
    NOTE: Eagle recommends storing only out of balance exceptions to conserve database storage. You can elect to store only out of balance exceptions by setting the SWITCH_2 (tag 990) field to 1 in the Message Center runmatch_db2 rule of the cash matching stream.

Match Using the Cash Recon Event Panel

You can use a Cash Recon event panel to match and reconcile cash activity.

To reconcile cash activity using a Recon Cash event panel:

  1. From the Accounting Center window, select Reconciliation in the left navigation and then click Cash Recon and Recon Event.
  2. Double click Cash Recon.
    You see the Cash Recon entry panel.
  3. Complete the Recon Cash Event panel options. See the Recon Cash Event Panel Options section for details.
  4. Click Submit.

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 Cash 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 cash-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.
    NOTE: 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.