9.2 Running Process Bank Reconciliation

Purpose: Use this document as a reference for running process reconciliation in ctcLink. This process will match and reconcile one-to-one transactions between the bank transactions and the system transactions based on the matching rules.

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.

Navigation:  NavBar > Navigator > Banking > Reconcile Statements > Process Bank Reconciliation

Running Process Reconciliation

  1. The Process Bank Reconciliation run control ID search page displays.  It defaults to the Find an Existing Value tab.  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 process reconciliation in the Run Control ID field.

Note: A Run Control ID is an identifier that, when paired with your User ID, uniquely identifies the process you are running. The Run Control ID allows important parameters to be available for a process when the process runs to ensure that when a process runs in the background, it does not have to prompt you for additional values. The system stores all parameters and associates them with Run Control IDs and User IDs.

  1. Select Add.
Process Bank Reconciliation Add a New Value page
  1. The Process Reconciliation page displays.  Enter your process frequency and request parameters:
    1. Use the Process Frequency drop-down button to select the ‘Always Process’ option.
    2. Enter the appropriate request number in the Request Number field. Leave this as one (1) unless you are running multiple requests.
    3. Enter or select the bank ID number in the External Bank ID field.
    4. Enter or select the bank account number in the Bank Account # field.
    5. Enter or select the appropriate statement number in the Statement ID field. – You can enter a specific statement ID or you can leave Statement ID blank and the system will run the selected process for all statements that are not marked “C” (complete).
  2. Select Run.
Process Reconciliation page
  1. The Process Scheduler Request page displays three reconciliation process methods: At this time only step 1 (Bank Reconciliation) is being selected.
    1. Selecting Bank Reconciliation runs the FSPRECON Application Engine process. This program processes the specified bank account transactions with the defined reconciliation parameters for the bank account.
    2. Selecting Recon and Statement Accounting (PSJob) runs the FSPRECON and TR_STMTACCTG Application Engine processes serially. This multi-process job runs both reconciliation and Cash Management Bank Statement Accounting reconciliation parameters on the specified bank account transactions.
    3. Selecting Recon and Bank Statement Process (PSJOB) runs FSPRECON and AR_BNKSTMT serially. This multi-process job runs both the Bank Reconciliation process and the Bank Stmt Processing (bank statement processing) process (AR_BNKSTMT), which loads payments into the Receivables tables.

Note: It is recommended that you select only one method to run at a time instead of selecting multiple methods to run concurrently.

  1. Select any combination of the three reconciliation methods to process the defined transactions.
    1. Use the Type drop-down menu to select the type of your output.
    2. Use the Format drop-down menu to select the format of your output.
    3. Select OK.
Process Scheduler Request
  1. The Process Scheduler Request page disappears.  The updated Process Reconciliation page displays.  Note the Process Instance number.
  2. Select Process Monitor.  Refer to the Process Monitor QRG for instructions.
Process Reconciliation
  1. Use the Process List page to view the status of submitted process requests.  Note: The process has finished successfully when the Run Status column indicates ‘Success.’
Process List tab

Additional Resources

Reconcile Bank Statements Business Process Map

  1. Process complete.