In general, all bank account reconciliation is done in Oracle Cash Management. For information on how to perform bank account reconciliation in Cash Management, see: Reconciling Bank Statements Automatically.
However, at this time it is not possible to reconcile retail term money deals in Cash Management. Therefore, you must reconcile retail term money deals in Treasury. When you reconcile a retail term money deal, the transactions that make up the deal are updated to reflect the date they were settled and the principal and interest amounts are adjusted accordingly. Once you reconcile an amount for a retail term money transaction, you cannot reverse it.
Treasury reconciliation can be set up so that Bank account reconciliations in performed automatically, automatically with manual confirmation, or manually. For information on how to set up bank account reconciliations, see: Import Sources and Reconciliation.
Before you can begin to reconcile a bank account you must either enter the bank statements into Treasury and then you must transfer those bank statements. For more information on entering, importing and transferring bank statements, see: Bank Statement Input.
Use a concurrent process to reconcile your bank statements automatically.
Define your import sources for automatic reconciliation. See: Import Sources and Reconciliation.
Transfer your bank statements for reconciliation. See: Transferring Bank Statements.
In the Current Bank Account Balances window, select Requests from the View menu. The Find Requests window appears.
Choose the Submit a New Request button. The Submit a New Request window appears.
Select the Single Request option and choose OK. The Submit Request window appears.
In the Name field, select Program - Bank Statement Reconciliation.
Complete the program parameters as needed. Choose OK. The concurrent request reconciles your bank statements against your Treasury transactions.
If you chose to perform automatic reconciliations with manual confirmation, you must confirm your automatically reconciled bank statements.
Define your import sources for automatic reconciliation with manual confirmation. See: Import Sources and Reconciliation.
Transfer your bank statements for reconciliation. See: Transferring Bank Statements.
In the Bank Statements window, select the record that you want to confirm. Choose the Confirm button.
In the Find Confirmed window, complete the fields as needed to locate the bank statement that you want to confirm. The Reconciliation Process window appears.
Save your work.
Use the Manual Reconciliation window to manually reconcile your bank statements.
Define your import sources for manual reconciliation. See: Import Sources and Reconciliation.
Transfer your bank statement for reconciliation. See: Transferring Bank Statements.
In the Find Bank Statements window, complete the fields to identify the bank account for which you want to perform a reconciliation. Choose the Find button. The Bank Statements window appears.
Select the bank statement that you want to reconcile and choose the Manual Reconciliation button. The Find Available window appears.
Complete the fields to identify the transactions that you want to manually reconcile. The Manual Reconciliation window appears.
Note: The Unreconciled Records area of the Manual Reconciliation window contains information from the bank statement. The Transaction Records area of the window contains information from Treasury.
In the Unreconciled Records area, check the Sel field beside those records that you want to select for reconciliation. The reconciliation balance is shown at the bottom of the window.
In the Transaction Records area of the window, check the Sel field beside those records that you want to reconcile against the selections you made in the Unreconciled Records area.
Note: For retail term transactions, you can match only one transaction record against the records in the Unreconciled Records area.
If your statement information does not reconcile, save your work and correct the unreconciled items. For more information, see: Reconciling Bank Statements Manually.
When you finish reconciling all the records for this account, choose the Reconcile button.
Use the Reconciliation Process window to review reconciled items. You can also use this window to unreconcile any previously reconciled items. Note that you cannot unreconcile retail term money deal transactions.
Perform an automatic or manual reconciliation. See: Reconciling Bank Statements Manually, or Reconciling Bank Statement Automatically.
In the Find Bank Statements window, complete the fields as needed to find the bank account that you want to review. The Bank Statements window appears.
Choose the bank statement you want to review and choose the Reconciled button.
In the Find Reconciled window, complete the fields as needed to find the statement that you want to review. The Reconciliation Process window appears.
If you want to unreconcile an automatically reconciled item, in the Review Unreconciled Items region check the Unreconciled check box beside each item you want to unreconcile.
Save your work.
Use the Manual Reconciliation window to reconcile any items that were not successfully reconciled during an automatic reconciliation.
Perform an automatic reconciliation. See: Reconciling Bank Statement Automatically.
Reconcile each unsuccessfully reconciled item manually. See: Reconciling Bank Statements Manually.
If you cannot manually reconcile an item, enter an adjusting transaction as an exposure. See: Interest Rate Exposures.
Save your work.
Use the Import Sources window to review bank statement import sources you defined for reconciliation purposes. The Import Sources window contains information about your import sources, reconciliation methods, reconciliation passes, and reconciliation matrixes.
In the Bank Statements window, choose the Review Source/Process button. The Import Sources window appears.
In the Manual Statement Input window, query the bank statement you want to correct.
Choose the Delete File button. The transaction details for this bank statement are deleted from the window.
Re-enter the bank statement information. See: Entering Bank Statements Manually.
Re-transfer the bank statement for reconciliation. See: Transferring Bank Statements.