Option 4: reconciling transactions from a reconciliation statement

  1. Access Bank Tape Mass Reconciliation (CB185).
  2. To reconcile transaction from a reconciliation statement, use these guidelines to specify the field values on the Main tab:
    Run Option

    Select R (Reconciliation Statement) to read records in the Statement Records database file. The program reconciles or voids transactions loaded from the database file, and creates a listing of reconciled or voided transactions and an error report listing transactions that were not reconciled or voided.

    Update

    Select Yes to update the transactions. If you select No, then the program creates a listing only.

  3. Select the Reconciliation Statements tab. Use these guidelines to specify the field values:
    Statement Number, Suffix

    Use this field to select the statement to be processed out of the CBSTMTREC file. You must define the statement number on Reconciliation Statement Maintenance (CB81.1).

    Default Transaction Code

    This field displays the default transaction code for statement records that do not have one already defined. If not populated, then it will not reconcile the statement records with no transaction code.

  4. If you are reconciling one to many transactions, then use these guidelines to specify the field values:
    Tolerance

    This is the tolerance amount for one to many reconciling. The statement record line amount and the total of the CBTRANS records must be within the tolerance (+/-) for the records to be reconciled. If no tolerance is entered, then the total of the CBTRANS records must equal the statement line amount.

    Company

    Required if tolerance amount is populated. This is the company where the reconciliation difference will be posted.

    Account

    This field is required if tolerance amount is populated. This is the accounting unit where the reconciliation difference will be posted.

    Transaction Code

    For the entered transaction code, the CB185 will reconcile the selected statement option field for the statement to selected Cash Management option field on the Cash Management transaction (CBTRANS).

    Statement Option

    This field is required if transaction code is entered. Select the statement line field that you will reconcile to the Cash Management transactions field/value (CBTRANS records).

    The CB185 will use the selected statement field value to match to the selected Cash Management field value.

    These are the valid values:

    1 = User field 1; 2 = User field 2; 3 = User field 3; 4 = User field 4; 5 = Tran Nbr

    Cash Ledger Option

    Required if transaction code is entered. Select the Cash Management field where the statement line will be reconciled.

    The CB185 will reconcile all ledger transactions with the selected field values that match to the value of the selected statement field.

    These are the valid values:

    1 = User field 1 2 = User field 2 3 = User field 3 4 = User field 4 5 = Tran Nbr