Knowledge Base

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.

Report Preview

A screenshot of a computer

Description automatically generated

A screenshot of a computer

Description automatically generated

A screenshot of a computer

Description automatically generated

Helpful?