Option 3: reconciling transactions from a bank tape

  1. Access Bank Tape Mass Reconciliation (CB185).
    Note:  Bank Tape Mass Reconciliation (CB185) does not reconcile transactions directly from a bank tape.

    Before you can reconcile transactions from a bank tape using the Tape Run Option on Bank Tape Mass Reconciliation (CB185), you must load data from the bank tape to the CB185 work file. The file layout is available in KB2218730 in Infor Customer Portal.

    See the information about loading files in the Enterprise Financial Management Conversion Guide.

  2. To reconcile transactions from a bank tape, use these guidelines to specify the field values:
    Run Option

    Select the process used to reconcile or void bank transactions. Select Tape to reconcile or void transactions loaded in the bank tape file. The program uses the bank account and transaction numbers from the bank tape and updates corresponding transactions with a reconciled status, amount, and date. This program creates a listing of reconciled transactions and an error report listing transactions that were not reconciled.

    Cash Code or Cash Code Group

    If Run Option Tape is used, then leave this field blank.

    Default Transaction Code

    If you selected Tape in the Run Option field, specify or select a valid default transaction code that you will assign to tape records that were not assigned a transaction code.

    Bank Statement

    Select the bank statement number to reconcile transactions to a bank statement. You must define the statement number on Bank Statement (CB06.1).

    Note: Select a bank statement number only if one is required for the cash code.

    See Adding a bank statement and Processing bank statement transactions.

    Update

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