Adding and maintaining reconciliation statements

Reconciliation Statement Maintenance (CB81.1) is a maintenance screen. Reconciling of statements is performed on Bank Tape Mass Reconciliation (CB185) or Statement Reconciliation (CB82.1).

Use this procedure to add and edit records in the Cash Management statement record file. The statement record file is where bank records are loaded and then reconciled against records in the Cash Management Transactions file.

  1. Access Reconciliation Statement Maintenance (CB81.1).
  2. Specify or select a Statement Number and a Line Number on which to inquire. Use these guidelines to specify the field values:
    Bank Identification

    This field is required if cash code is not populated. This is the bank identification number.

    Bank Account Number

    This field is required if cash code is not populated. This is the bank account number for the transaction.

    Record Type

    This field has two options:.

    Blank=Cash Ledger Record

    B=Beginning Balance Record

    Cash Code

    This field is required if the bank ID and bank account number are not populated. This is the cash code for the transaction.

    Transaction Code

    This is the payment code for the transaction.

    Transaction Number

    (Required) This is the transaction number of the record.

    Amount

    This field is required if the Rec Status is Blank or R. This is the amount of the transaction.

    Function

    This field identifies what status the CBTRANS record will be changed to when this line is reconciled to the CBTRANS record. These are the valid values:

    Blank or R = Reconcile

    V = Void

    S = Stop Payment

  3. Add, change, or delete the record.

    Reconciliation Statement Maintenance (CB81.1) cannot:

    • change or delete records that have a line status of Closed.

    • change the Cash Code or Transaction Code for statment lines that are partially reconciled.

      Note: All transaction records reconciled to a statement line must have the same cash code and transaction code.