Recording Exceptions
A bank statement can contain information about NSF (non-sufficient funds) and rejected receipts, stopped payments, direct deposits or debits, and transactions created outside Oracle Payables and Oracle Receivables. The bank statement may also contain errors that cannot be reconciled against any transactions.
To record NSF or rejected receipts when using AutoReconciliation:
When you run the AutoReconciliation program, you define the NSF Handling method:
- No Action: NSF or rejected receipts will be handled manually (see below).
- Reverse: AutoReconciliation unmatches and unclears the receipt, and reopens the invoice.
To handle NSF or rejected receipts manually:
2. Reconcile the reversed receipt to the NSF or rejected receipt statement line.
Note: If you have two statement lines for an NSF or rejected receipt (one for the original receipt and one for the reversal), you need to reconcile the original receipt with the original statement line, then reverse the receipt and reconcile it with the reversal statement line.
To record a stopped payment:
1. Void the payment in Oracle Payables to mark the supplier invoice as unpaid.
2. Reconcile the "stopped" payment statement line to the voided payment.
To record a direct debit from a supplier:
If the bank statement contains information about a direct debit that you have not entered:
1. Create a payment in Oracle Payables for the appropriate invoices.
2. Match the payment against the bank statement line.
To record a direct deposit or wire transfer:
If you enter your bank statements into Cash Management manually, enter the receipts for direct deposits and wire transfers in Oracle Receivables manually. After saving the receipt, you can then match it against the related Cash Management statement line.
If you import your bank statement information to Cash Management from an electronic bank file, you can use the same bank file with the Receivables AutoLockbox program to automatically create receipts for direct deposits and wire transfers. See your Oracle Receivables User's Guide for more information about using AutoLockbox.
To record a bank error:
1. Navigate to the Find Bank Statements window.
2. Enter the query criteria, or leave the criteria blank to query all existing statements.
4. Select a statement and choose Review.
6. Select the bank error line.
8. Select Error to mark the line as a bank error.
To record transactions from external documents:
1. Navigate to the Find Bank Statements window.
2. Enter the query criteria, or leave the criteria blank to query all existing statements.
3. Choose Find to see the Reconcile Bank Statements folder window containing the statements that meet your query criteria.
4. Select a statement and choose Review.
6. Select the external document line.
8. Select External to mark the line as originating outside Oracle Payables and Oracle Receivables. A line marked as External is considered reconciled. To reconcile lines with external sources, see Reconciliation Open Interface.
See Also
Reconciling Bank Statements Manually
Reviewing Reconciled Transactions
Creating Payments and Receipts Transactions
Creating Miscellaneous Transactions
Entering Reversals
Reconciling Corrections and Adjustments to Bank Errors
Manually Clearing and Unclearing Receipts and Payments
Cash Management Reports
Setting Up Oracle Cash Management
Bank Statements
Oracle Payables Reconciliation Accounting
Oracle Receivables Reconciliation Accounting
Reconciliation Open Interface
Using AutoLockbox (Oracle Receivables User's Guide)