The structure of a bank statement

Bank statements can be manually created or imported.

For information about importing bank statements, see the Financials Setup and Administration Guide.

This table shows the contents of bank statements.

Tab Description
Lines Shows bank statement lines. The status of the lines is updated based on its reconciliation status. Open a line record to view details about the reconciliation and the related, matched transactions.
Line Exceptions This tab is available when exceptions exist, such as out-of-balance or uncategorized statement lines.
Line Cash Ledger Transactions View cash ledger transactions that are created directly from a bank statement line. The lines are for bank fees or charges for non existing cash ledger transactions.
Line Distributions Create distributions if the category is set to post to Global Ledger. You can create distributions manually or from the category setup.
Cash Ledger Transactions View cash ledger transactions that are not reconciled, but are available for reconciliation. You can apply comments, process escheatment, maintain attachments, manually stale date, mass release, mass update, reconcile, process stale dates, stop and void payments.
Non Cash Ledger Transactions When the cash management account is added as the account for non-cash ledger transactions, use this tab to manually add the non-cash ledger transactions.

See Manually creating non-cash ledger transactions.
Statement Balances View balances for the statement. This list shows the available links:
  • All Statement Balances. View the balances by Transaction Type
  • Reconciliation Balances.
    • The balances for reconciled deposits, outstanding deposits, reconciled payments, outstanding payments, etc.
    • Current Cash Code Position. This is field applies for intraday statements only:
    • Reconciled Lines
    • Unreconciled Statement Lines
    • Outstanding Cash Ledger Lines
  • You can also update the Cash Code Position