Importing and Reviewing Bank Acknowledgement Files

Purpose: Use this document as a reference for importing and reviewing bank acknowledgment files in ctcLink.

Audience: Settlement Manager, GL Accountant.

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

  • ZZ Treasury Bank Processing
  • ZZ Treasury Maintenance

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

Acknowledgment files are imported from financial institutions into Financial Gateway. They contain data that are used to:

  • Verify the receipt of a payment;
  • Acknowledge that a payment was processed successfully; and
  • Notify the sender of problems with a payment.

Import and Review Bank Acknowledgement Files

Importing Bank Acknowledgement Files

Navigation: Financial Gateway > Process Payments > Import Acknowledgment Files

  1. The Import Acknowledgment Files 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_IMPORT_ACKFILE (College, Process).
  3. The Import Acknowledgment Files page displays.  Complete the import parameters:
    1. Use the Import Type drop-down menu to select a method for importing the acknowledgment files. Choose from the following options:
      • File: Select if you are importing a file, and complete the File Path and File Name fields.
      • FTP: Select if you are importing the file by using file transfer protocol, and enter a bank node through which to transfer the data.
      • HTTP: Select if you are importing an XML file using a URL that is included as part of the node configuration. No file path or file name is required.
    2. Enter the node that will be used to relay the payment acknowledgment files from the bank to your system in the Bank Node field. This field appears only if FTP or HTTP is selected as the import type.
    3. Select the ViewBank Node Details link to review property details of the selected node. This field appears only if FTP or HTTP is selected as the import type.
    4. Enter the complete file path location. To select files using the Select File button, the file path must have a trailing backslash (\).  You can also search for files of a specific type by entering an asterisk and the extension suffix.
    5. Select the specific file name to import. If you want to import multiple files based on extension, leave this field blank.
    6. Select the View Layout Details link to access the Layout Catalog page to view details of the acknowledgment file layout.
  4. If Advanced Options are required:
    1. Enter or select an Encryption Profile to decrypt payment acknowledgments. Encryption profiles contain both encryption and decryption information.
    2. We are not using Integration Broker at this time.
    3. Use the Post Process File Action drop-down menu to select what action, if any, is to be performed on the payment acknowledgment files after the data has been processed. The options are:
      • Copy: Copy the file to the directory that is entered in the Post Process File Directory field.
      • Delete: Delete the file after the data in it is processed.
      • Move: Move the file to the directory that is entered in the Post Process File Directory field.
      • None: Take no action.
  5. For Layout Properties:
    1. Value – Property codes and values appear by default from values that are defined on the selected layout ID.
  6. Select Run.

Note: If you are importing multiple files for a single run control ID, you must add requests (by using the Add button) for each file that is being requested. Do not enter a file name. Doing this can result in duplicate acknowledgment loading errors. Run the import process, and then edit the file name and run the import process again.

Import Acknowledgement Files page

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

  • ZD Treasury Inquiry
  • ZZ Treasury Maintenance

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

  1. Next, navigate to the screen to review the imported bank acknowledgment files.

Navigation: Financial Gateway > Review Payments > Acknowledgment Files

Reviewing Bank Acknowledgement Files
  1. The Acknowledgement Files page displays.  Use the Search Files section to enter the search criteria.
    1. If it didn’t default, enter the business unit in the Bank SetID field.
    2. Enter or select the bank in the Bank Code field.
    3. Select Search.
    4. A list of acknowledgement files meeting the search criteria is displayed.
    5. Select Ack File ID to view the contents of the payment acknowledgement file.
    6. View the File Status. Status options:
      • Complete: Indicates that the Bank Acknowledgement Import process is complete.
      • Error: Indicates that the Bank Acknowledgement Import process failed. A red square also appears next to the file name. You can either cancel the payment file or recreate it.
Acknowledgement Files page
  1. Process complete.