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: Banking > Analyze Exceptions > Route Reconciliation Exception

  1. The Route Reconciliation Exception run control ID search page displays.
  2. If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and select the Add button. 
    • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA010_ROUTE_RECON_EXCEPTION (College, Process).
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. 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.  Please refer to the Process Schedule Request steps for further 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.

Video Tutorial

The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.


Video Tutorial Via Panopto

View the external link to Utilizing Route Reconciliation Exception. This link will open in a new tab/window.