9.2 Importing and Reviewing Bank Acknowledgement Files

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

Audience: Settlement Manager, GL Accountant

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.

Navigation:  NavBar > Navigator > Financial Gateway > Process Payments > Import Acknowledgment Files

Importing Bank Acknowledgement Files

  1. The Import Acknowledgement Files 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 new journal entry 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.
Import Acknowledgement Files Add a New Value page
  1. The Import Acknowledgement Files page displays.  Complete the import parameters:
    1. Use the Import Type dropdown 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. Click the View Layout Details link to access the Layout Catalog page to view details of the acknowledgment file layout.
  2. 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 dropdown 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.
  3. For Layout Properties:
    1. Value – Property codes and values appear by default from values that are defined on the selected layout ID.
  4. 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.

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

Navigation:  NavBar > Navigator > 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 Acknowledgment Import process is complete.
      • Error: Indicates that the Bank Acknowledgment Import process failed. A red square also appears next to the file name. You can either cancel the payment file or recreate it.
  1. Process complete.