Viewing Bank Statement Reconciliation
You can use View Bank Statement Reconciliation window to review statement reconciliations, details, and status. You can also access other inquiry windows from View Bank Statement Reconciliation window. You cannot change the information in a bank statement or reconciliation.
Prerequisite
Have bank statements entered and/or reconciled in Cash Management.
To query a bank statement:
1. Navigate to the Find Bank Statements window.
2. Enter the criteria for the statement you want to query, or leave the criteria blank to see a list of all existing statements.
4. Select the statement you want to review, then choose Review. The View Bank Statement window appears.
Cash Management displays the header information for the statement you queried. You can view Bank Name, Bank Branch, statement Date, bank Currency, Document Number, Statement Number, and GL Date. You also see Control and Line Totals for the statement and the corresponding reconciliation. Also, the number of lines and total amount are displayed for any statement lines that remain unreconciled. Finally, there is a Complete check box indicating whether the statement reconciliation has been completed.
5. Navigate to other inquiry windows, as needed, by selecting one of the buttons at the bottom of the View Bank Statement window. You may choose the Errors, Reversals, Reconciled, Available, and Lines buttons.
- Available button: The Find Available Transactions window appears, or the View Available Batches window appears, depending on your selection criteria.
- Lines button: The View Bank Statement Lines window appears, from which you can also choose Errors, Reconciled, and Available buttons.
To query bank statement lines:
1. Query the bank statement you want to review.
3. Choose Exchange from the poplist to view exchange rate information for foreign currency transactions.
4. Choose Reference from the poplist to view the Agent (supplier or customer), Agent Bank Account and Invoice number associated with each transaction.
5. Choose Description from the poplist to see the Effective Date and Description of the transaction, as well as any associated Bank Charges.
6. Navigate to other inquiry windows, as needed, by selecting one of the buttons at the bottom of the View Bank Statement Lines window. You may choose Errors, Reconciled, and Available.
To query reconciled transactions:
1. Query the bank statement you want to review.
At the bottom of the window, you can see three fields showing the Status, Date, and Maturity Date for the selected transaction line.
3. Choose Exchange from the poplist to view the Exchange Date, Type, and Rate, as well as the bank Account Currency Charges and Errors.
4. Choose Reference from the poplist to view the Batch Name, Agent Name, Deposit Number, and Reference Type and Number.
5. Choose the Next button to move to the next record, if any, or choose the Previous button to move to the previous record, if any.
To query reversals:
1. Query the bank statement you want to review.
2. Choose Reversals from the View Bank Statement window. The Find Reversals window appears.
3. Enter any query values for receipt or check Number, Amount, Currency, and Date. You can also search for receipts and payments based on the Payment Method, Status, Account Number, and Account Currency Amount. Finally, you can enter Agent information to further narrow your search for a specific customer or supplier Name and Number.
Suggestion: Many of the query fields also have associated lists from which you can select a value. Choose the List of Values button from the Oracle Applications toolbar to see the list.
At the bottom of the window, you can see three fields showing the Status, transaction Date, and Maturity Date for the selected transaction line.
5. Choose Reference from the poplist to view the Batch Name, Agent Name, Deposit Number, and Payment Method.
6. Choose Comment from the poplist to view the Reversal Category, Reason, and Comments.
7. Choose Bank from the poplist to view the Bank Account Number, Currency, and Name, as well as the Statement Number.
To review reconciliation errors:
1. Query the bank statement you want to review. (See above).
2. Choose Errors from the View Bank Statement window or View Bank Statement Lines window. The View Reconciliation Errors window appears, showing the Account, Bank Name, Currency, and Statement Date. The window also shows the Line Number and Message for each reconciliation error.
See Also
Entering Bank Statements Manually
Entering Bank Statement Lines
Reconciling Bank Statements Manually
Reviewing Reconciled Transactions
Reviewing Reconciliation Errors
Entering Reversals
Using Attachments