Cash Management- Best Practice with Older Transactions

Summary:

We have been live with Oracle ERP Cloud (Financials/Fusion) since 2016 and have recently started implementing/using the Cash Management module specifically for Bank Reconciliation.

We are aware of the Journal Reconciliation Start Date setting under Manage Banks but are looking for practical, real-world experience and solutions for historical data.

We are specifically seeking feedback on two challenges:

1. Historical Outstanding Transactions (e.g., Uncashed Checks)

• Our users have historically maintained a separate Excel spreadsheet to track all outstanding payments (uncashed checks) month-to-month. This is a significant volume of transactions.
• We need feedback from users/organizations who have:
  • Implemented Bank Reconciliation