How Mass Reconciliation of Bank Statement Lines and System Transactions Is Processed

You can perform mass reconciliation by selecting a large volume of system transactions (mainly journal lines) and bank statement lines, group, and reconcile them using a spreadsheet. Use the FBDI template for Bank Statement Reconciliation Data Import for this purpose.

To perform mass reconciliation, you must do the following:

• Export the unreconciled transactions into a spreadsheet.

• Import the reconciliation data into Oracle Cash Management.

Prepare the Spreadsheet for Reconciliation Data Import

To generate a spreadsheet with unreconciled transactions, perform these steps:

1. Go to Navigator > Cash Management > Bank Statements and Reconciliation.

2. In the Tasks panel tab, select Manual Reconciliation.

3. On the Manual Reconciliation page, select the required bank account and date ranges to export.

   Note: If you don't select the dates, the application automatically selects the statement lines and system transactions of the last 180 days for export.

4. Click Export to generate the Transactions Available for Reconciliation Report.

5. Click Done to return to Bank Statements and Reconciliation page.

6. Review the report from the Process Monitor section.

7. Click View Output to open the report.

8. Once the report opens in a spreadsheet, use the filtering and sorting options to group transactions.

9. Add the reconciliation groups for the statement lines and system transactions.

   Note: The tolerance rule setup on the bank account is evaluated to reconcile the grouped transactions.

Import the Reconciliation Data into Oracle Cash Management

Once you have the reconciliation details added to the statement lines, you can upload it using the Load Interface File for Import utility. Here are the steps you must follow:

1. Navigate to the File-Based Data Import (FBDI) for Financials guide.

2. From the table of contents, go to Cash Management > Cash Management Bank Statement Reconciliation Data Import.

3. Download the XLSM template from the File Links section.

4. Copy the reconciliation information from the Transactions Available for Reconciliation Report and add it to the template.

5. On the Instructions and CSV Generation spreadsheet, click Generate CSV File.

6. Load the CSV file through the ESS job Load Interface File for Import. Select the import process as Autoreconcile Bank Statements.

7. Once the upload completes, review the Automatic Reconciliation process output file. It displays the specific groups reconciled and the exceptions.

8. Review the reconciled groups on the Manual Reconciliation page.