When you use manual reconciliation, you reconcile each line with available transactions. If you are using Oracle General Ledger, you can also reconcile statement lines to journal entries. Cash Management lets you search for receipts, payments, journal entries, and statement lines that meet specific criteria, and reconcile the statement line against them. You can search for transactions based on customer or supplier, batch name, or remittance number, as well as ranges for transaction numbers, transaction date, transaction amount, and maturity date. You can search for journal entries based on Period Name, Journal Entry Name, Document Number, or Line Number.
As you reconcile a statement manually, you may need to create transactions to account for differences between the sum of the reconciled transaction and the line amount. For example, you can create a miscellaneous transaction to account for bank charges or interest. You can also create Oracle Payables payments and Oracle Receivables receipts from Cash Management.
Note: If you don't use Oracle Receivables Automatic Lockbox, and your bank statement includes direct deposits or bank transfers, you must create the related receipts manually in Oracle Receivables before you can reconcile them in Cash Management. For more information on Automatic Lockbox, see your Oracle Receivables User's Guide.
Note: You can open custom folders that display statement information in a custom format if you or your organization has defined any. Refer to the Oracle Applications User's Guide for more information on modifying and saving folders.
Note: Miscellaneous payments are actually handled as negative receipts by Cash Management. Therefore, to create miscellaneous payments you must have Oracle Receivables installed and set up.
Finding Available Detail and Batch Transactions for Reconciliation
Reconciling Available Transactions and Batches
Changing the Reconciliation Status
Creating Payments and Receipts Transactions
Creating Miscellaneous Transactions
Manually Clearing and Unclearing Receipts and Payments
Marking a Bank Statement as Complete
Entering Bank Statements Manually
Overview of Setting Up
Customizing the Presentation of Data in a Folder