Entering Bank Statements - 16j

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

Audience: Settlement Manager, GL Accountant

Once 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.

Navigation: Main Menu > Banking > Bank Statements > Enter Bank Statements

Entering Bank Statements

  1. Enter existing search criteria or click the Add a New Value tab on the Enter Bank Statements page to add a new value.
    1. Enter or select the appropriate external bank ID in the External Bank ID field.
    2. Enter or select the appropriate bank account number in the Bank Account # field.
    3. Enter the Statement ID of the bank statement that you are manually entering into the system.
    4. Click the Search button.
Find an Existing Value tab
  1. Use the Bank Balance Entry page to review the following bank statement information:
    1. 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.
Bank Balance Entry tab
  1. Click the Funds Availability tab to view the following:
    • 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.


Bank Balance Entry tab
  1. Click the Bank Transaction Entry tab.
  2. Use the Bank Transaction Entry page to the review the following bank statement information:
    1. 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.
Bank Transaction Entry tab
  1. Click the Recon Information tab to view the following information:
    • 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
    • Recon 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.
Bank Transaction Entry tab
  1. Click the Addenda Information tab to view the following information:
    • Expanded Addenda– Click to access the Bank Addenda Detail page and view addenda detail information that is transmitted from the bank for this item. This field 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 Addenda field, by using the scroll arrows.
Bank Transaction Entry tab


Add your comment

E-Mail me when someone replies to this comment