Bank Statement Detail Report

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 Statement Detail Report in the Cash Management Data Hub in Oracle.

Prerequisite

· Cash Management Data Hub.

Business Questions

· What type of transaction is being captured for the statement identifier?

· Utilize the Statement Identifier filter to narrow the table to a specific transaction.

· View the Transaction Code Description or Transaction Type column in the table.

· How much was this transaction?

· Utilize the filters to narrow the table to a specific transaction.

· View the Amount column in the table.

· Was this transaction a credit or debit?

· Utilize the filters to narrow the table to a specific transaction.

· View the Flow Indicator column.

· What is the reconciliation status (header or line) for a Bank Account?

· Utilize the filters to narrow the table to a specific bank account.

· View the Statement Header Reconciliation Status column for (Header).

· View the Statement Line Reconciliation Status (Line).

· When was this statement last updated?

· Utilize the filters to narrow the table to a specific statement.

· View the Statement Last Update Date column.

Terminology

· BAI2 File: A specialized and standardized set of codes used for cash management and bank reconciliations and introduced by the Bank Administration Institute (BAI). Provides end of day and intraday account information from a bank to a customer’s TMS or ERP environment.

· 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