9.2 Utilizing Route Reconciliation Exception

Purpose: Use this document as a reference for utilizing route reconciliation exceptions in ctcLink.

Audience: Settlement Manager, GL Accountant.

You must have at least one of these local college managed security roles:

  • ZZ Treasury Bank Processing

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

If you plan to route exceptions for automatic reconciliation to a user’s Worklist or email account, you must select Automatic in the Recon Method field, and choose either the Notification Framework or Workflow notification method for the bank account on the External Accounts – Reconciliation page.

If you choose the Notification Framework method for automatic reconciliation, the Notification Registry definition for Bank Reconciliation Exceptions is delivered as system data and provides the integration between Treasury and the Notification Framework. You can allow users to override the Worklist or email notifications on the Notification Registry page.

Information provided for system-level notifications can be changed in the Notifications System Overrides component. If required, you can modify the Email Notification and Worklist Notification details in the System-Level Notification page. Options to allow user overrides for Worklist or email notifications must be selected on the Notification Registry page in order to enter notification details at the system level. By default, the system notifies users with the Bank Manager role by Worklist if any reconciliation exceptions are found. In order to trigger email notifications, you must enter user IDs or email addresses in the Override Email Notification section.

Note: If you are using a reconciliation method other than automatic, the system sets the Recon Method field to No Workflow.

Utilizing Route Reconciliation Exception

Navigation:  NavBar > Navigator > Banking > Analyze Exceptions > Route Reconciliation Exception

  1. The Route Reconciliation Exception run control ID search page displays.  It defaults to Find an Existing Value.  In this example, we'll create a new run control ID.
  2. Select Add a New Value.
  3. Enter a meaningful run control ID for the Route Reconciliation Exception in the Run Control ID field.
  4. Select Add.
Route Reconciliation Exception Add a New Value page
  1. The Route Reconciliation Exception parameters page displays.
    1. Enter or select a bind variable name of either 'BNK_ID_NBR' or 'BANK_ACCOUNT_NUM' in the Bind Variable Name field.
    2. Enter the corresponding bank ID number or bank account number in the Value field.
    3. Select Run.
Route Reconciliation Exception parameters page
  1. The Process Scheduler Request page displays.  Use it to enter or update parameters, such as process output format.
  2. Select OK.
Process Scheduler Request page
  1. The Process Scheduler Request page disappears.  The updated Route Reconciliation Exception page displays.  Note the Process Instance number. This number helps you identify the process you have run when you check its status.
  2. Select Process Monitor.  Refer to the Process Monitor QRG for instructions.
updated Route Reconciliation Exception page
  1. The Process List page displays.  Use it to view the status of submitted process requests.
  2. The process has finished successfully when the Run Status column indicates ‘Success.’
Process List page
  1. Process complete.