Bank Reconciliation

for JD Edwards


As part of your period-end processes, you might need to reconcile your bank account balances with those of your statements. Oracle’s Automatic Bank Reconciliation feature is easy to use and extremely helpful, but can be tricky to implement, especially if you have several bank accounts that feed into various ledgers. That’s where we come in!

JD Edwards Bank Reconciliation Process

Instead of manually reconciling voided payments and receipts during the account reconciliation process, you can save time by utilizing the automatic features within the JD Edwards platform, such as the Automatic Reconcile Void Payment Program – R09551. This program reconciles voided payments and receipts automatically by updating the GLRCND field with the default reconciliation code ‘R’ on each transaction.

  • Time Savings: Eliminates the need to reconcile bank transactions manually, saving time within your accounting and finance departments.

  • Reduces Human Error: The JD Edwards Bank Reconciliation program uses automation technology to reduce human intervention in the process.

  • Quick Setup: After performing the initial setup, you can easily reconcile bank accounts on a periodic basis (monthly, quarterly, etc.).

JD Edwards Bank Reconciliation

Take it to the bank with JD Edwards Bank File Importer!

Many JD Edwards customers can benefit from the built-in functionality that automatically reconciles your bank transactions with your JD Edwards transaction.

Refreshing Account Reconciliation Programs

Before starting the reconciliation process in your accounts, the Refresh Reconciliation File Program – R09130 must be ran first. Usually this is ran at the end of each period to reconcile transactions for the time span. The Refresh Reconciliation File Program copies the unreconciled transaction detail for all reconcilable accounts from the F0911 table into the F0911R reconciliation table.

Each time the F0911R table is refreshed, all previously reconciled transactions are removed and replaced with new ones that meet the data selection criteria for the Refresh Reconciliation File program. Here are the criteria that must be met:

  • The account being reconciled must be within the AAI range for GLRCxx.

  • The general ledger date for the transaction must be within the date range specified.

  • The GLRCND field for the transaction must be blank, and therefore unreconciled.

Read more on JD Edwards Bank Reconciliation:

Western Dental, the largest dental practice management company in the West, partnered with Smartbridge to streamline and simplify their bank reconciliation process.


You need a partner that can do it all

For all things JD Edwards, we can provide assistance to move your digital agenda forward. Start your journey or explore our library of JDE insights! Contact us today to learn more about our Oracle Cloud for JD Edwards.