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: 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. Enter field values for your college:
    1. Enter or lookup External Bank ID.
    2. Enter or lookup Bank Account #.
    3. Enter Statement ID.
  3. Select the Add button.
Add new value using college bank information
  1. The Enter Current Day Balances tab displays.
  2. Enter the Statement Date.
  3. Enter the Creation Date.
  4. Enter the 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 or lookup the Statement Code.
  6. Enter the Value Date (defaults to current date).
  7. Enter the Balance.
  8. Select the Funds Availability tab.
Current Day Balances tab
  1. The Funds Availability tab displays. Enter the Available Balance amount.
  2. Enter the One Day Float amount.
  3. Enter Two+ Days Float amount. Select the Current Day Transactions tab.
Funds availability tab
  1. The Current Day Transactions tab displays. Enter or lookup the Statement Code.
  2. Enter the Reference.
  3. Enter the Bank Date.
  4. Enter the Transaction Amount.
  5. Enter the Value Date.
  6. Select the Misc. Transaction Information tab.
Current Day Transaction tab
  1. The Misc. Transaction Information tab displays. Enter or lookup the Statement Code.
  2. Enter Reference.
  3. Enter the Available Balance amount.
  4. Enter the One Day Float amount.
  5. Enter the Two+ Days Float amount.
  6. Enter a Description.
  7. Select the Save button.
Misc Transaction Info tab
  1. Process complete.

Video Tutorial

The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.

Video Tutorial Via Panopto

View the external link to Entering Current Day Bank Statements. This link will open in a new tab/window.