9.2 Perform Manual Reconciliation

Purpose: Use this document as a reference for performing manual reconciliation of bank statements 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.

Use the Manual Reconciliation page to reconcile statements for banks that do not provide an electronic file of their transaction data.

Important! If you open a bank account in the Manual Reconciliation page that is set for automatic reconciliation, you get a warning message stating “This bank account is set up to use Automatic Reconciliation.” To avoid this warning, you should not perform manual reconciliation on bank accounts whose reconciliation method is Automatic.

Some care should be taken, as any system transaction marked as manually reconciled will not be considered a candidate for automatic (or semi-manual) reconciliation. In addition, you need to be careful not to mark the transaction of an automatic bank for manual reconciliation. The system will then not retrieve these marked transactions for automatic or semi-automatic reconciliation.

Perform Manual Reconciliation

Navigation: Banking > Reconcile Statements > Manual Reconciliation

  1. The Manual Reconciliation search page displays.
    1. Enter or select the appropriate bank ID of the bank that you want to manually reconcile in the Bank ID field.
    2. Enter or select the appropriate account in the Account # field.
    3. Use the Status drop-down button to select the appropriate search status.
    4. Enter or select the dates using the From Date and Thru Date fields for the manual reconciliation.
    5. Select Search to display results in the System Transactions area.
Manual Reconciliation search page
  1. The System Transactions area displays reconciliation details in the following fields:
    1. Reconciliation Date– From the bank statement, enter the date when the transaction cleared the bank. The date cannot be after today’s date nor earlier than the date entered in the Enter Reconciliation Date field if Override Reconciliation Date is selected.
    2. Status– Displays the reconciliation status. There are two possible statuses from which to select for manual processes (use the Select checkbox to make your selection):
      • UNR (unreconciled) – Select to reconcile transactions.
      • REC (reconciled) – Select to view and undo the reconciliation for a transaction. Only transactions that were reconciled manually will appear. Hence, transactions that were reconciled automatically or semi-manually can only be unreconciled from the Semi Reconciliation page.
    3. Transaction Date– Displays the date on which the system transaction occurred.
    4. Status– Displays the payment status for the Payables/Receivables transactions.
    5. Detail– Displays the transaction type or payment method.
  1. Choose from the following Recon Date Override Options:
    1. Override Reconciliation Date– Select to override the displayed value date when you reconcile selected transactions. Select this option and also enter a new date in the Enter Value Date field.
    2. Enter Reconciliation Date– This date defaults to the Thru Date listed in your search criteria.
    3. Select the Reconcile button to reconcile selected transactions.
  2. Run Reports:  Select the Account Register Report button to generate the Account Register report, which you can view using the Report Manager Process.
Manual Reconciliation System Transactions section
  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 COMING SOON!

Video Tutorial Via Panopto

View the external link to Perform Manual Reconciliation. This link will open in a new tab/window.