Setting Up Bank Reconciliation Options

Agency staff can now use the bank reconciliation function in Oracle Fusion Cash Management to automatically or manually reconcile Oracle Permitting and Licensing payments, refunds, and reversal transactions.

Bank statement reconciliation is performed in Oracle Cash Management. You configure the OPAL bank reconciliations options here.

Configuring Bank Reconciliation Options

1. Select Payment Setup > Bank Reconciliation Options.

2. On the Bank Reconciliations Options page, click Add.

   Page Element	Description
   Transaction Category	Options must be created for both Transaction Categories (select Payment or Refund) and include all valid payment methods used by the agency.
   Payment Method	Select Cash (not valid for refunds), Check, Cashier check, Credit Card, Debit Card, PaypalPayPal, or Offline.
   Enabled	Use this switch to enable the option.
   Reconciliation System Code	Select Cash Management.
   Start Date	Select the starting transaction date OPAL will select for creating bank reconciliation transactions. This option will be unavailable if Cash Management is not selected.
   Bank Account	Search for and select the bank account.
   Business Unit	Search for and select the business unit.
   Transaction Type	Enter a valid, enabled lookup code value. The delivered values are extensible. You must use one of the codes configured for the transaction type on the Manage Cash Management lookups.
   Reference Text	Indicates what the Reference Text field is populated with. Search for and select the reference text. Options are: Check number, Payment reference ID, Payment transaction ID, Refund reference ID, Refund transaction ID, Deposit slip number, or a static value for example, Merchant ID.
   Description Text Option Code	Search for and select the Description Text Option Code. Options are: Check number, Payment reference ID, Payment transaction ID, Refund reference ID, Refund transaction ID, Deposit slip number, or a static value.
   Error Handling Option Code	If an error occurs when exporting transactions to Cash Management for this category or payment method, you can choose to stop or skip the transaction in error or continue processing. Search for and select the Error Handling Option Code. Options are: Continue on error, or Stop on error.

3. Click Save.