| layout | default |
|---|---|
| title | CE General Ledger Reconciliation | Oracle EBS SQL Report |
| description | Application: Cash Management Description: Bank Statements - General Ledger Reconciliation Provides equivalent functionality to the following standard… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, R12 only, General, Ledger, Reconciliation, gl_balances, gl_code_combinations, ce_bank_accounts |
| permalink | /CE%20General%20Ledger%20Reconciliation/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Application: Cash Management Description: Bank Statements - General Ledger Reconciliation
Provides equivalent functionality to the following standard Oracle Forms/Reports
- General Ledger Reconciliation Report Applicable Templates: Pivot: Reconciliation Summary
Source: General Ledger Reconciliation Report Short Name: CEXRECRE DB package: CE_CEXRECRE_XMLP_PKG
Legal Entity, Bank Account Name, Bank Account Number, Period Name, Closing Balance
gl_balances, gl_code_combinations, ce_bank_accounts, ce_bank_acct_uses_all, ce_gl_accounts_ccid, dual, ar_cash_receipts, ar_cash_receipt_history, hz_cust_accounts, hz_parties, ar_receipt_methods, ce_bank_acct_uses_ou_v, ce_system_parameters, ar_cash_receipt_history_all, ce_statement_recon_gt_v, ce_statement_lines, ce_statement_headers, ap_checks_all, ce_security_profiles_gt, xla_transaction_entities, xla_events, ap_payment_history_all, xla_ae_headers, xla_ae_lines, ce_statement_reconcils_all
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
| Resource | Link |
|---|---|
| Excel Example Output | CE General Ledger Reconciliation 06-Sep-2021 012753.xlsx |
| Blitz Report™ XML Import | CE_General_Ledger_Reconciliation.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/ce-general-ledger-reconciliation/ |
The CE General Ledger Reconciliation report is the primary month-end report for reconciling the General Ledger cash balance to the Bank Statement balance. It highlights the differences caused by unposted journals, unreconciled transactions, and transactions in the subledger that haven't been transferred to GL. This report is the "bridge" that proves the financial statements accurately reflect the cash position.
Reconciling the GL to the Bank is a multi-step process involving three balances:
- Bank Balance: What the bank says we have.
- Subledger Balance: What AP/AR says we have.
- GL Balance: What the Trial Balance says we have.
Discrepancies can arise from manual journals, unposted batches, or timing differences. Identifying the root cause of a variance is often the most stressful part of the month-end close.
This report compares the GL Account Balance (for the designated cash account) against the Bank Statement Balance and itemizes the reconciling items.
Key Features:
- Three-Way Match: Conceptually links Bank, Subledger, and GL.
- Variance Identification: Explicitly lists "Transactions in GL but not in Bank" and "Transactions in Bank but not in GL".
- Period-End Focus: Designed to be run for a specific accounting period to support the close process.
The report aggregates GL_BALANCES for the cash account and compares it to the CE_STATEMENT_HEADERS closing balance, adjusting for unreconciled items in CE_STATEMENT_LINES and CE_AVAILABLE_TRANSACTIONS.
Key Tables:
GL_BALANCES: The official GL balance.CE_STATEMENT_HEADERS: The official bank balance.CE_RECONCILIATION_ERRORS: Any system errors preventing reconciliation.XLA_AE_LINES: Subledger accounting entries (to check for posting status).
- Financial Integrity: Validates the accuracy of the Cash line item on the Balance Sheet.
- Audit Compliance: Serves as the primary evidence of cash control for external auditors.
- Process Improvement: Highlights recurring reconciling items (e.g., manual journals) that should be automated.
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics