Previous  Next          Contents  Index  Navigation  Glossary  Library

Reconciling Bank Statements Manually

In Cash Management you can reconcile a bank statement manually as well as automatically. You can use the manual method to reconcile any bank statement, whether imported or entered manually. In addition, you can create new bank statement lines as you reconcile transactions, as well as update the reconciliation information for a previously manually- or automatically-reconciled statement.

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.

   To manually reconcile a previously-entered bank statement:

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.

See Also

Creating Reconciled Bank Statement Lines

Finding Available Detail and Batch Transactions for Reconciliation

Reconciling Available Transactions and Batches

Changing the Reconciliation Status

Using Attachments

Creating Payments and Receipts Transactions

Creating Miscellaneous Transactions

Recording Exceptions

Entering Reversals

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

         Previous  Next          Contents  Index  Navigation  Glossary  Library