Use this report to reconcile the General Ledger cash account balance to the bank statement closing balance and to identify any discrepancies in your cash position. The General Ledger cash account should pertain to only one bank account. This report is available in Summary and in Detail format.
The Summary report lists the General Ledger cash account balance and an adjusted balance for the bank statement. It also lists a separate adjustment amount for unreconciled receipts, payments, and journal entries which have been recorded in the General Ledger cash account, as well as bank errors. The Detail report provides details for the unreconciled items as well as the information contained in the Summary report.
Additional Information: This report does not include information on Payroll payments, Treasury settlements, or external transactions in the Reconciliation Open Interface because they may have been posted to a different General Ledger account than the one assigned to the bank account.
Warning: To ensure that this report is accurate, you must first perform the following tasks:
Reconcile all statements in Cash Management.
Transfer journal entry transactions from Oracle Payables and Oracle Receivables to your General Ledger.
Post journals in General Ledger.
Run the report for the current GL period.
See: How Using Cash Management Affects Your Closing Process
You submit this report from the Submit Request window. See: Submitting Requests.
Period Name: Enter the name of the period for which you want to reconcile to the General Ledger.
Closing Balance: Enter the bank statement closing balance for the period you entered.
Report Type: Choose either Summary or Detail to indicate if you want the report to provide summary balances only or details of unreconciled items.
General Ledger Cash Account Balance: The balance in the General Ledger cash account after all relevant entries have occurred for the reconciliation period. The General Ledger cash account pertains to only one bank account.
Bank Statement Closing Balance: The bank statement closing balance that you specified.
Unreconciled Receipts: Total amount of receipts that were recorded in the General Ledger cash account for the reconciliation period, but were not reconciled as of the statement cutoff date.
Unreconciled Payments: Total amount of payments that were recorded in the General Ledger cash account for the reconciliation period, but were not reconciled as of the statement cutoff date.
Please note that this report shows the below type of payments:
Payments which have been credited into the GL Cash Account but not Reconciled against a Bank Statement Line in the current period - these payments are deducted from the Bank Statement Closing Balance.
Payments which have not been credited into the GL Cash Account but are Reconciled against a Bank Statement Line in the current period - these payments are added to the Bank Statement Closing Balance.
Payments which have not been credited into the GL Cash Account and are not Reconciled against a Bank Statement Line but appear on a Bank Statement in the current period - these payments are added to the Bank Statement Closing Balance.
If the report includes Negotiable Payments it suggests that there is a Bank Statement Line Existing that is Unreconciled but that matches this Payment.
Reconciled Unaccounted transactions should appear only if they are reconciled before but not accounted before the as of date.
Unreconciled Journal Entries: Total amount of journal entries that were posted to the General Ledger cash account but were not reconciled for the reconciliation period. Depending on the transactions, these are added to or subtracted from the General Ledger cash account balance.
Lines Marked as Errors: Total amount of transactions that are in dispute with the bank and are considered to be outstanding as of the statement cutoff date.
Adjusted Bank Statement Balance: The sum of the Bank Statement Closing Balance, Unreconciled Receipts, Unreconciled Payments, Unreconciled Journal Entries, and Lines Marked as Errors.
Difference: The net difference between the General Ledger Cash Account Balance and the Adjusted Bank Statement Balance. You can investigate this balance to identify items that comprise it. You can start by investigating the corresponding items for the lines marked as error in the bank statement.
Unreconciled Receipts: Details of transactions that comprise the Unreconciled Receipts total amount. The transactions include receipts that have the status of Cleared, Remitted, or Reversed.
Cleared: Receipts that have been manually cleared in Cash Management or automatically cleared in Receivables, but have not been reconciled.
Remitted: Receipts that have been deposited and accounted, but have not been cleared or reconciled.
Reversed: Receipts that have been reversed either through Cash Management or through Receivables and are available for reconciliation.
Unreconciled Payments: Details of transactions that comprise the Unreconciled Payments total amount. The transactions include payments that have the status of Cleared, Negotiable, or Stop Initiated.
Cleared: Payments that have been manually cleared but have not been reconciled.
Negotiable: Payments that have been issued and accounted, but have not been cleared or reconciled.
Stop Initiated: Payments that have been stopped in Payables and are available for reconciliation.
Note: If the Payment transactions are accounted on Creation and also after Clearing, then such unreconciled payments will be displayed in this report only after accounting the clearing events.
Unreconciled Journal Entries: Details of transactions that comprise the Unreconciled Journal Entries total amount. The transactions include budget journals created with the Balance Type of Actual.
Lines Marked as Errors: Details of transactions that comprise the Lines Marked as Errors total amount.