Oracle Cash Management - Payment Reconciliation Statements


Creating Bank Reconciliation Statements
Cash Management lets you create new bank statement lines when reconciling available transactions. This is useful if you want to reconcile without entering statement line information first.

a. Payment Reconciliation
N: - Bank Statements-> Bank Statements and Reconciliation



To create a new bank statement line from reconciled transactions:
1. Navigate to the Find Bank Statements window.
2. Enter the query criteria for the statement you want to reconcile, or leave the criteria blank to query all existing statements.
3. Choose Find to see the Reconcile Bank Statements window containing the statements that meet your query criteria.
4. Select the statement you want to reconcile, and choose Review. Optionally, choose New to enter a new bank statement.
5. If you are entering a new bank statement, enter the bank statement header information. If you select an existing bank statement, Cash Management displays the corresponding bank information.
6. Choose Available to search for detail or batch transactions that are available for reconciliation.
7. Enter your search criteria in the Find Transactions window, or leave the criteria blank to search for all available transactions.
8. Choose Find.
9. Select the detail or batch transactions that apply to the bank statement line you want to create.
10. Choose reconcile. Cash Management creates a new bank statement line with an Amount and Type that match the reconciled transaction(s) for that line.


Click on Find button


Click on Lines button


Click on Available button


Enable AP Payment and Click on Find button


Select the Payment Transaction Document Number ‘1001’
Check the Status as Negotiable
Click on Reconcile button


Click on Reconciled Button


Check the Status as Reconciled Unaccounted
Switch Responsibility: - Ivas_Payables


N:- Payments-> Entry-> Payments



Query the Document Number ’1001’ and Press Ctrl+F11



Check the Status as Reconciled Unaccounted
Click on Actions…1 and enable Create Accounting and Final Post


Click on OK button
Menu-> Tools-> View Accounting Events