9.2 Import Bank Statements

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.

Import Bank Statements

Navigation:  NavBar > Banking > Bank Statements > Import Bank Statements

  1. On the Import Bank Statements page, enter an existing Run Control ID or select the Add a New Value tab to add a new value.
  2. Enter the Run Control ID.
  3. Select Add.  The Import Bank Statements page will display.

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.

Import Bank Statements Add a New Value page
  1. On the Import Bank Statements page, select 'File" from the Import Type dropdown list.
  2. Enter the complete file path location in the File Path field.

Note: Every college has different file path. If you do not know your bank statement file path, Please consult ERP Support team.

As an example, the file path will looks like.

/FSIN/I-019_AcctRecon/WAXXX/BofA/Data/*

Make Sure you put * at the end.

  1. Select the specific File Name to import and select Select File . If you want to import multiple files based on extension, leave this file blank.

As an example, here we select a specific file and  Select the Select file button.

A File list window will pop up and then select the file, which we want to process.

Note: You will see only one file, if you are importing the bank statement file daily.

  1. Select "Previous Day" from the Statement Type dropdown list.  
  2. Select the file layout of the bank statement file being imported in the Layout field. In most cases, this will be BAI2.
  3. Expand Advanced Options section of the Import Bank Statement page, to enter post processing file options:

Select "Move" from the Post Process File Action dropdown list.

Enter a file path to the directory to which the Post Process File Directory file will be copied or moved if either option is selected as the post process file action.

Note: Every college has different file path. If you do not know your bank statement file path, Please consult ERP Support team.

As an example, the file path will looks like.

/FSIN/I-019_AcctRecon/WAXXX/BofA/Archive/

  1. Select Save to save the run control page to use next time.

Note: If you reusing the same control next time, make sure you select the different file or file name should be blank, otherwise you will get duplicate statement loading errors. In addition, if there is no bank statement file available to process, you will also get a warning/error. See step 17

  1. Select Run.
Import Bank Statement page image
  1. A Process Scheduler Request window will pop up. Select OK.

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

  1. Select 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.'

  1. Select Refresh  until both the process status (IMPORT_FILES and TR_BSP_LOAD) says Success/warning/Error. If you do not see both process then must be some problem. Check step 17.

Note: In order to load the bank statement in PeopleSoft,

  1. Both process IMPORT_FILES and TR_BSP_LOAD must be completed with Success.
  2. Select the Detail link. A Process Detail window will pop up
  3. Select the Message Log link to open the message log window.
  4. You will see Statement XXXX loaded.
  1. If bank statement load process completed successfully then existing statement file will be copied to achieve folder as mentioned above.
  2. If TR_BSP_LOAD process completed with Warning/Error, it means the statement file is not loaded into PeopleSoft. You can check the reason for failure.
  1. In case there is no statement file available to process then you will not see TR_BSP_LOAD process. You will only see IMPORT_FILES with Success. Actually, it has some error. To find the detail about error, Select the Detail link then select the Message Log link.
  1. Process complete.