Reconciling Bank Statements Manually (Oracle Cash Management User's Guide)


	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:

1. Import or manually enter the statement information.

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.

3. Enter the query criteria for the statement you want to reconcile, or leave the criteria blank to query all existing statements.

Reconcile Bank Statements window containing the statements that meet your query criteria.

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.

Bank Statement window, with the header information for the account you queried, including Bank Name, Bank Branch, statement Date, bank Currency, Document Number, and Statement Number. You can update any of the header information except for the bank information and the Currency. If you use automatic document sequence numbers, you cannot change the Document Number either.

7. Select the statement line that you want to reconcile.

8. Choose Available to search for detail or batch transactions that are available for reconciliation.

9. Enter your search criteria in the Find Available window.

10. Reconcile the available detail or batch transactions that apply to the current bank statement line.

11. Reconcile other statement lines.

12. (Optional) Create miscellaneous transactions for bank statement transactions with no matching Oracle Payables, Oracle Receivables, or Oracle General Ledger activity.

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.

13. (Optional) Create payments or receipts for bank statement transactions with no matching Oracle Payables or Oracle Receivables activity.

14. Reverse any NSF or rejected bank transactions.

15. Optionally, when you have reconciled all the bank statement lines, mark your bank statement as complete.

16. Save your work.

Reconciling Bank Statements Manually

To manually reconcile a previously-entered bank statement:

See Also