9.2 Entering Bank Statements

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

Audience: Settlement Manager, GL Accountant

Entering Bank Statements

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

After you transfer bank statement information to the production tables, you can update the data by using the Bank Balance Entry and Bank Transaction Entry pages. If you do not receive bank statements electronically from the bank, you also use the same pages to manually enter bank statement information online.

  1. The Enter Bank Statements search page displays.
  2. Enter External Bank ID.
  3. Enter additional Search Criteria to identify your statement.
  4. Select Search.
Enter Bank Statements search page
  1. The Bank Balance Entry tab displays.
  2. The Bank Balances tab contains the bank balances details:
    • Statement Code– Determines the type of balance that is being entered. The system uses these balances for various bank features and processes, such as the cash position worksheet.
    • Balance– Enter the total amount of funds that are available on the specified value date.
  3. Select the Funds Availability tab.
Bank Balance Entry tab
  1. The Funds Availability tab displays:
    • Available Balance– Displays the portion of the balance amount that is immediately available for use. Differences between the balance and available balance amounts are generally due to deposits (credits) that have not yet cleared the bank.
    • One Day Float– Stores the one-day float information that is provided by you or the bank.
    • Two+ Day Float (two or more day float) – Stores the two (or more) day float information that is provided by you or the bank.
  2. Select the Bank Transaction Entry tab.

 

Funds Availability tab
  1. The Bank Transaction Entry tab displays.
  2. The Transaction Information tab displays the bank transaction details:
    • Statement Code– Select a statement code to indicate if the transaction is a debit or a credit. This value determines the default transaction code and statement activity type that is on the Recon Information grid.
    • Reference– Enter a transaction reference number.
    • Bank Date– Select the entry date of the transaction. The default is the statement date.
    • Funds Availability– Click this icon to enter available funds information for bank deposit transactions.
    • Value Date– Enter the date that the bank recorded the transaction. The default is the statement date.
  3. Select the Recon Information tab.
Transaction Information tab
  1. The Recon Information tab displays.
    • Trans Code– Identifies the type of transaction in a bank statement; such as bill orders, deposits, direct debits, drafts, fees, payments, receipts, and voided transactions. Other transaction values are:
      • ACH: Automatic clearing house
      • BOE – Out: bill of exchange – outgoing (or disbursed)
      • Bank Adj: bank adjustments
      • Bill Order
      • Check
      • DD-Out: direct debit – outgoing
      • Deposits
      • EFT: electronic funds transfer
      • Fund Rcpt: fund receipt
      • G: general transaction
      • I: interest expense
      • Man Check: manual check
      • Misc: miscellaneous
      • Stop Pay: stop payment
      • Wire Out: wire – outgoing
    • Reconciliation Status– Select a status for the transactions.  If you import this statement data, the system initially sets the row to "Unreconciled". If you then run the Cash Management Bank Statement Accounting process, it reconciles those specific transactions that match predefined rules and changes their status to "Reconciled".
    • Activity Type– Select a statement activity type. This identifies a transaction to be processed by a specific accounting template.
  2. Select the Addenda Information tab.
Recon Information tab
  1. The Addenda Information tab displays.
    • Addenda can store up to 254 characters, and each value in the Seq No field corresponds to a text field. If the addenda information is more than 254 characters long and contained in multiple text fields, the sequential numbering keeps the addenda message in the correct processing order. You can also view this information in the Expanded Addenda field, by using the scroll arrows.
  2. Select Expanded Addenda.
Addenda Information tab
  1. The Bank Addenda Details window displays.
  2. The Addenda field displays bank-transmitted comments.
  3. Select OK.
Bank Addenda Details window
  1. Process complete.