Reconciling Bank Account Transactions

To track cleared dates and maintain a duplicate set of records for the AZ (cash basis) ledger when reconciling bank account transactions:

  1. Run the Create Cash Basis Entries program (R11C850) to process cash basis transactions and generate records for the AZ ledger.

  2. Reconcile voided payments and receipts.

    Run these programs:

    • Automatic Reconcile Void Payment (R09551)

    • Automatic Reconcile Void Receipt (R09552)

  3. Run the Refresh Reconciliation File program (R09130) to reconcile bank account transactions for a period.

  4. Run the Print Reconciliation Report (R09132P) for a list of any outstanding items that are un-reconciled.

  5. In the Manual Reconciliation program (P09131), set these processing options to include an additional ledger type (AZ) and a cleared date:

    • Additional Ledger Type to Update

    • Cleared Date

  6. Use the Manual Reconciliation program (P09131) to enter the date that the bank transaction cleared, and other necessary information.

See "Reconciling Bank Account Transactions Manually" in the JD Edwards EnterpriseOne Applications General Accounting Implementation Guide.