Bank Account Reconciliation Report
KB06003737 •128 Views • Updated 19-Apr-2024
Purpose
The following guide is intended for employees who are looking to view or complete any of the following actions:
· Answer business questions using the Bank Account Reconciliation report in the Cash Management Data Hub in Oracle.
Prerequisite
· Cash Management Data Hub.
· Report requires parameters for the Bank Account Name, From Accounting Period, and To Accounting Period fields prior to data being filled in the report.
Business Questions
· Where is journal information associated with reconciled bank accounts?
· Utilize the filters to narrow down the table to specified bank account information.
· View the Journal, Journal Batch, and Journal Line columns in the Reconciled table for journal information associated with reconciled bank accounts.
· What is the system transaction source for reconciled bank statement lines?
· View the Transaction Source column in the Reconciled table.
· View the Transaction Source column to see if a reconciled transaction originated from Receivables, Payables, General Ledger, or External Transaction.
· When were bank statements reviewed or reconciled?
· Utilize the filters to narrow down the table to specified bank account information.
· View the Reconciliation Date column in the Reconciled table.
· What is the book amount for unreconciled system transactions?
· View the Book Amount (USD) column in the Unreconciled System Transactions table.
· Who completed and reviewed a reconciliation?
· Utilize the filters to narrow down the table to specified bank account information.
· View the Reconciled By column in the Reconciled table.
Terminology
· Reconciliation Reference: An identifiable reference value that is entered or populated on bank statement lines. One example is a check number, which can be used to reconcile the bank statement line to a Payment transaction in Oracle.
· Transaction Code: BAI2 standard code representing various types of bank transactions.