Automatic Bank Statement Processing

To track cleared dates and maintain a duplicate set of records for the AZ (cash basis) ledger when using the automatic 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. Convert the data from the flat files that you receive from your bank to the JD Edwards EnterpriseOne General Accounting system.

   You run the Process Automatic Bank Statements Flat File program (R09600) to transfer the data to the staging tables (F09610 and F09611).

3. Transfer the data to the bank statement tables (F09616 and F09617).

   Run the Load Bank Statement program (R09612) to transfer the data.

4. Revise the bank statement data if necessary.

   Use the Revise Automatic Bank Statement program (P09616) to revise the data.

5. Automatically reconcile data from the electronic bank statement against the bank account information in your general ledger.

   1. Set the Additional Ledger Type to Update processing option in the Process Auto Bank Statement program (R09616) to update ledger type AZ.

   2. Run the Process Auto Bank Statement program to automatically reconcile the data.

6. Correct unreconciled exceptions.

   1. In the Manual Bank Statement Reconciliation program (P09631), set the Additional Ledger Type to Update processing option to update ledger type AZ.

   2. Set the Cleared Date processing option to display the Cleared Date field on the Reference 3 Selection form.

   3. Use the Manual Bank Statement Reconciliation program to correct unreconciled exceptions.

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