Understanding the Automatic Bank Statement Program

After you run the Load Bank Statement program and, if necessary, revise data in the bank statement tables, you can run the Process Automatic Bank Statement program. This program reconciles data that has cleared your bank against data that has been entered in the JD Edwards EnterpriseOne General Accounting system. Specifically, the Process Automatic Bank Statement program:

• Reconciles data based on the reconciliation rules that you set up for transaction types (UDC table 09/TT).

• Uses the offset business unit code (UDC table 09/BU) that is assigned to transaction code JE (on the Revise Transaction Type Cross Reference form) to determine whether to create an offsetting journal entry using the business unit of an alternate offset account or a bank account.

• Processes the transactions in the F09616 and F09617 tables and reconciles them to the transactions in the F0911 table.

  Note: The Process Automatic Bank Statement program does not automatically reconcile manual journal entries entered in the JD Edwards EnterpriseOne General Accounting system; you must manually reconcile them. There is no reference number field to connect these transactions from the F09616 and F09617 tables to the F0911 table.

• Runs the Automatic Batch Receipt program (R03B551) to create batch receipts for CR transactions that are marked for automatic batch receipts.

  The system creates automatic batch receipts and attempts to apply the receipts to invoices if a customer number is assigned to a transaction. If the customer number is blank, the system creates a logged receipt, which is not applied to invoices.

  The Process Automatic Bank Statement program populates the GLR3 (Reference 3) field in the F0911 table with the batch number of the bank statement, not the batch number of the receipt or deposit number. If you want the bank statement number to appear on transactions, you must select a check box for the reconciliation rule on the Revise Auto Reconciliation Group form.

  For multicurrency processing, the program creates batch receipts only if the receipt and invoice currencies are the same.

• For transactions with customer numbers, runs the Apply Receipts to Invoices program (R03B50) to apply the batch receipts to invoices.

  If there is no matching invoice, the program creates an invoice with type RU.

• Updates records in the staging tables as reconciled, unless the records were purged earlier in the process.

  In a multicurrency environment, the bank account format uses the transaction currency of the bank account. If the bank account currency is foreign (not in the base currency of the company), the foreign currency is the transaction currency. The Process Automatic Bank Statement program cannot calculate gains and losses on foreign currency bank accounts because there are no domestic amounts on the transactions.

After you run the Process Automatic Bank Statement program, you can review transactions on the Reconcile Bank Statement Detail to Account Ledger form and manually reconcile any exceptions that did not reconcile and, if applicable, unreconcile reconciled transactions.