- OracleApps Epicenter - http://www.oracleappshub.com -

Bank Statements – in Oracle Cash Managment Prospective

Bank statements include information on bank accounts, deposits received by the bank, and checks cleared.

Each bank statement is composed of one bank statement header and several bank statement lines or called Transmision lines.

The bank statement header record identifies the statement number, bank account number, and statement date. It also contains optional information like the bank name, bank branch name, bank account currency, and control amounts.

A bank statement line can refer to one or more payments, receipts, miscellaneous transactions, open interface transactions, or journal entry lines.

Each line has a line number, transaction type, date cleared (bank transaction date), and amount. Optional information includes the bank transaction code, number, bank transaction identifier (such as the payment or deposit number), currency information (currency code, original amount in transaction currency, exchange rate), value date, customer or supplier details, customer or supplier bank account, a comment, and a descriptive flexfield for user-defined additional information.

A bank statement line's status can be one of the following:

Before you can reconcile transactions against a bank statement, you need to enter the bank statement information into Cash Management.

Bank statements can be either manually entered or loaded electronically from information received directly from your bank.

If your bank provides account statements in a flat file, using a defined format like BAI or SWIFT940, you can use the Bank Statement Open Interface to load this information into Cash Management.

Bank Statements can be in any of the following formats:

Next Post will discuss on different file formats.