Reconcile Bank-Originated Entries

Reconcile bank-originated entries directly in the Manual Reconciliation Dashboard by matching one bank statement line with another statement line. This enhancement supports bank-originated transactions such as service fees, transaction fees, maintenance fees, and interest earned, where a bank charge or reversal might not have a corresponding subledger transaction.

Before this enhancement, manual reconciliation focused on matching statement lines to available transactions, and bank-originated entries without subledger counterparts required less direct handling. With this release, cash management users can identify bank-originated entries, filter by receipt and miscellaneous receipt, find the corresponding available statement-line records, reconcile the records, and update the dashboard. The result is greater flexibility for reconciling bank charges and reversals and less dependency on separate forms for exception processing.

Steps to enable and configure

  1. Confirm that Oracle Enterprise Command Center Framework Release 12.2 V13 is available for this feature.
  2. Complete Oracle Cash Management setup as described in the Oracle Cash Management Implementation Guide.
  3. Configure the Cash Management Command Center security grants and access described for the Manual Reconciliation Dashboard, including the Cash Management Manager access role and the Manual Reconciliation Menu navigation grant.
  4. Confirm the same Cash Management data security model used by core Cash Management. The user must have access to the organization that owns the transaction through the related security profile.
  5. Submit or schedule the Cash Management Command Center Data Load so the dashboard reflects current bank statement lines and available statement-line records. Use a full load when first using the command center and incremental loads to keep the dashboard current.

Tips and considerations

  • Use this feature for bank-originated entries such as service fees, transaction fees, maintenance fees, and interest earned, especially when those entries do not have corresponding subledger transactions.
  • Start with high-value unreconciled statement lines, focus on a single bank account, filter by receipt and miscellaneous receipt, then find and reconcile the corresponding available statement-line records.
  • Because the dashboard can help spot unusual transactions, review bank-originated entries carefully for possible bank-charge, reversal, accounting-error, or fraud scenarios.
  • Keep incremental data loads current so reconciliation users work from the latest dashboard data.