Importing Bank Statements - 16j

Purpose: Use this document as a reference for importing bank statements in ctcLink.

Audience: Settlement Manager, GL Accountant

The importing of bank statement information is an integral part of the reconciliation, and bank statement accounting. The system processes previous day statements that are used for reconciliation and accounting.

Importing Bank Statements

  1. Enter an existing Run Control ID or click the Add a New Value tab on the Import Bank Statements page to add a new value.
    1. Enter a name for the run control in the Run Control ID field, i.e., Bank_Import.

Note: A Run Control ID is an identifier that, when paired with your User ID, uniquely identifies the process that you are running. The Run Control ID defines parameters that are used when a process is run. These parameters ensure that when a process runs in the background, the system does not prompt you for additional values. If you have more than one account, you will want to use an identifier on the end of the Run Control ID.

  1. Click the Add button.
Add a New Value tab
  1. Use the Parameters section of the Import Bank Statements page, to enter the bank import file parameters:
    1. Use the Import Type drop-down button to select the import method to which you will upload the bank statement file. Choose from the following options:
      • FTP (file transfer protocol): Select if you are importing the file by using file transfer protocol, and enter a bank node through which to transfer the data.
      • File: Select if you are importing a file located on a shared server directory within your network.
      • HTTP: Select if you are importing a file using a URL that is included as part of the node configuration. No file path or file name is required.

Note: If FTP or HTTP is selected in the Import Type field, then you can use the View Bank Node Details link Click this link to access the Bank Node Details page and review the property details of the selected node.

  1. Enter the complete file path location in the File Path field.

Note: To select files by clicking the Select File button, the file path must have a trailing backslash (/).

Note: You can also search for files of a specific type by entering an asterisk and the extension suffix (i.e. /*.txt).

Import Bank Statements
  1. Click the File Selection Help button to view help information on specifying file paths and file names.
    1. Enter or select the specific File Name to import. If you want to import multiple files based on extension, leave this file blank.
    2. Use the Statement Type drop-down button to select one of the support bank statement types. Options include:
      • Current Day
      • Previous Day
      • Statement Analysis
    3. Select the file layout of the bank statement file being imported in the Layout field. In most cases this will be BAI2.
Import Bank Statements
  1. Use the Advanced Options section of the Import Bank Statement page, to enter post processing file options:
    1. Use the Post Process File Action drop-down button to select what action, if any, to perform on the bank statement files after the data has been processed. Choose from the following options:
      • 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.
    2. Enter a file path to the directory to which the Post Process File Directory file will be moved or copied if either option is selected as the post process file action.

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

  1. Click the Run button.
Process Scheduler Request
  1. Use the Process Scheduler Request page to enter or update parameters, such as server name and process output format.
    1. Use the Server Name drop-down button to select the appropriate server to process the request.

Note: You can leave the Server Name field blank.

  1. Click the OK button.

Note: A Process Instance number appears. This number helps you identify the process you have run when you check the status.

  1. Click the Process Monitor link.
  2. 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.'


Add your comment

E-Mail me when someone replies to this comment