Manual Bank Statement Processing

To track cleared dates and maintain a duplicate set of records for the AZ (cash basis) ledger when using the manual bank statement process:

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

    See Cash Basis Accounting.

  2. Enter transaction information including the transaction code that specifies how the system reconciles the transaction.

    You use the Bank Statement Entry program (P09160) to enter transaction information.

  3. Post receipts, payments, and journal entries, if necessary.

  4. Post batches to update the WF - Account Ledger Reconciliation workfile (F0911R).

  5. Run the Refresh Reconciliation File program (R09130) to update the F0911R table with the transactions that you recorded before receiving your bank statement.

  6. On the Reconciliation tab of the Bank Journal Statement Process program (R09170), set the Additional Ledger Type to be updated processing option to update a ledger type AZ.

  7. Run the Bank Journal Statement Process program to compare transaction information and create any needed journal entries.

    The Bank Journal Statement Process program also:

    • Runs the Update Receipts Header (R03B551) and Apply Receipts to Invoices (R03B50) programs.

    • Generates reconciliation reports.

    • Reconciles transactions.

  8. Post any journal entries created by the Bank Journal Statement Process program.

See "Running the Bank Journal Statement Process Program" in the JD Edwards EnterpriseOne Applications General Accounting Implementation Guide.