9.2 Entering Current Day Bank Statements

Purpose: Use this document as a reference for entering current day bank statements in ctcLink.

Audience: Settlement Manager, GL Accountant.

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

  • ZD Treasury Inquiry
  • 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 Current Day Balances page to view and update automatically loaded current day statements. The Current Day Balances page is similar to the Bank Balance Entry page in form and function. However, current day bank statement information is stored in the Bank Current Day table and utilized in creating cash position reports.

Entering Current Day Bank Statements

Navigation:  NavBar > Navigator > Banking > Bank Statements > Enter Current Day Statements

  1. The Enter Current Day Statements search page displays.  It defaults to the Find an Existing Value tab.  In this example, we'll create a new value.
  2. Select Add a New Value.
  3. Enter External Bank ID.
  4. Enter Bank Account #.
  5. Enter Statement ID.
  6. Select Add.
Enter Current Day Statements Add a New Value tab
  1. The Current Day Balances tab displays.
  2. Enter Statement Date.
  3. Enter Creation Date.
  4. Enter File ID.  Displays the bank statement number provided by the bank. This field is populated during import of MT940, BAI2, and FINSTA statements and is display-only. The user cannot change the File ID for a bank statement that has been loaded into the system.  When you manually create a new bank statement, you can enter the File ID value.  The File ID value appears as display-only during update mode
  5. Enter Statement Code.
  6. Enter Value Date.
  7. Enter Balance.
  8. Select the Funds Availability tab.
Current Day Balances tab
  1. The Funds Availability tab displays.
  2. Enter Available Balance.
  3. Enter One Day Float.
  4. Enter Two+ Days Float.
  5. Select the Current Day Transactions tab.
Funds Availability tab
  1. The Current Day Transactions tab displays.
  2. Enter Statement Code.
  3. Enter Reference.
  4. Enter Bank Date.
  5. Enter Transaction Amount.
  6. Enter Value Date.
  7. Select the Misc. Transaction Information tab.
Current Day Transactions tab
  1. The Misc. Transaction Information tab displays.
  2. Enter Statement Code.
  3. Enter Reference.
  4. Enter Available Balance.
  5. Enter One Day Float.
  6. Enter Two+ Days Float.
  7. Enter Description.
  8. Select Save.
Misc Transaction Information tab
  1. Process complete.