My Oracle Support Banner

E1: 09: Overview of Automatic Bank Statement Reconciliation (P09610/P09616/P09617/P09621/P09622/P09626/P09627/P09628/P09631/R09600/R09612/R09616) (Doc ID 2097234.1)

Last updated on DECEMBER 14, 2021

Automatic bank statement processing is used within the cash management process to reconcile bank account information that you receive from your bank against bank account information in the EnterpriseOne General Accounting system. This automated process saves you time as it creates accounts receivable and general ledger transactions when it reconciles your bank statement against your general ledger. Specifically, the automatic bank statement process creates:

  • Entries for receipts, if an item has cleared your bank but has not yet been recorded in the system.
  • Journal entries for receipt and payment variances, taxes, bank fees, and transfers.
  • Offsetting journal entries for a bank account or an alternate offset account.
  • Journal entries for the drafts payable account.

This document provides details on the Automatic Bank Statement Reconciliation Process including the following steps:

  • Setup
  • Processing Flat Files from the bank
  • Revising data in the staging tables
  • Loading data into the bank statement tables
  • Revising data in the bank statement tables
  • Revising transactions without a customer number
  • Processing automatic bank statements
  • Reconciling unreconciled transactions
  • Purging bank statement tables
  • Field Mapping


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.