Adding a bank statement

You can enter a Reconciliation Statement number on Bank Transaction Adjustment (CB80.1) or Bank Tape Mass Reconciliation (CB185) to reconcile existing transactions to a bank statement. You must define the statement number on Bank Statement (CB06.1).

You must add a bank statement record for each cash code that requires you to reconcile bank statements before you enter associated transactions. The bank statement must include the statement number, statement date, and the beginning and ending balances. Use this procedure to create a bank statement record.

Note: You must select Yes in the Bank Statement Required field on Cash Code (CB00.2) before you can add a bank statement.
  1. Access Bank Statement (CB06.1).
  2. Use these guidelines to create a bank statement record:
    Cash Code

    Select a valid cash code representing a bank account that requires reconciliation statements.

    Note: Ensure that the cash code is set to Yes in the Bank Statement Required field on Cash Code (CB00.2).
    Bank Statement Number

    Specify the bank-assigned bank statement number or create a user-defined ID.

    Note: If you selected the single statement option on Cash Code (CB00.2), then you can have only one statement open at a time. With each new statement, the system will automatically update the statement number.
    Company

    Select the company number that represents the company where you want to create a bank statement record.

    Bank Statement Date

    Specify the date the bank statement was prepared.

    Reconciliation Journal Book

    If you use journal books, then select a valid reconciliation journal book.

    Note: If you leave this field blank, then the reconciliation journal book defined on Company - Cash Code Relationships (CB00.3) is used as default.
    Beginning Balance

    (Optional) Specify the beginning balance for the reconciliation statement. This amount is the balance prior to the first transaction listed on the statement.

    Note: If you selected the single statement option on Cash Code (CB00.2), then the system automatically displays the beginning balance.
    Ending Balance

    (Optional) Specify the ending balance for the reconciliation statement. The ending balance is the amount after the final transaction listed on the statement.

    Exchange Rate

    If the cash code currency is different from the company base currency, then you can specify a current exchange rate. If you do not, then the rate defined for the currency on Exchange Rates (CU10.1) is used as default.

    Default Pay Codes

    Select customer, vendor, general ledger, and reconciliation pay codes that represent types of bank transactions.

    The pay codes are defined on Bank Transaction Definition (CB00.4). You must set up customer, vendor, and bank codes to auto reconcile your transactions. These codes become the defaults for adding transactions on Cash Code (CB00.2).

    Note: You can enter a bank statement number on Bank Transaction Adjustment (CB80.1) or Bank Tape Mass Reconciliation (CB185) to automatically create bank statement detail.
  3. To enter detail information, select Detail to open Bank Statement Detail Entry (CB06.2). When you add detail information, you are transferred automatically to the appropriate form in the Accounts Payable, Accounts Receivable, or Cash Management application, to process the transaction. See Processing bank statement transactions.
  4. To close a completed bank statement, select Statement Close to open Bank Statement Close (CB191). See Closing a bank statement.