25 Process Bank Statements

This chapter contains the topic:

Section 25.1, "Processing Bank Statements."

25.1 Processing Bank Statements

Navigation

From General Accounting (G09), choose Account Reconciliation

From Account Reconciliation (G0921), choose Bank Statement Processing

From Bank Statement Processing (G09211), choose an option

Banking practices in some countries rely on magnetic media process, electronic fund transfers, and direct bank involvement in settling outstanding debts. For these countries, the bank statement serves as the source document for all banking activity.

When you use J.D. Edwards base software to process your bank statements, the system accepts and clears transactions in the following tables:

Accounts Receivable Ledger (F0311)
Account Ledger (F0911)
Account Ledger for Reconciliation (F0911R)

The system also uses the following tables to store bank statement information:

Bank Statement Header (F0916)
Bank Statement Detail (F0917)

The following graphic illustrates how you process bank statements using J.D. Edwards based software.

Figure 25-1 Bank Statements Processing

Description of "Figure 25-1 Bank Statements Processing"

The steps for processing bank statements using J.D. Edwards based software include:

Step	Explanation
Enter statement	Enter the transactions that appear on your bank statement.
Post manual receipts	Post manual receipts if you enter a cash receipt (for example, if a customer makes a payment directly to your bank account).
Refresh tables	Update the Account Ledger for Reconciliation worktable (F0911R) by refreshing the reconciliation file.
Reconcile statement	Reconcile the transactions to update tables, create accounting batches, and generate reconciliation reports.
Post automatic receipts	Post automatic receipts in batch mode if you enter a cash receipt (for example, if a customer makes a payment directly to your bank account).
Post bank statement batch	Post general journal batches to update the bank statement batch to the Account Ledger (F0911) and Account Balances (F0902) tables.
Refresh and reconcile	Refresh the reconciliation file and manually reconcile if you have entered automatic receipts and you are not using a transit account.

25.1.1 What You Should Know About

Option	Explanation
Multi-currency bank statements	You can process multi-currency bank statements. Transactions can include up to three different currencies. The system calculates the gain or loss.