How Bank Statement Reconciliation Data is Imported

Use the FBDI template for the Cash Management Bank Statement Reconciliation Data Import process to import external bank statement reconciliation data into Oracle Fusion Cash Management.

You can download the spreadsheet template to prepare your bank statement reconciliation data. The template contains an instruction sheet to help guide you through the process. To access the template, complete the following steps:

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

2. In the Table of Contents, click Cash Management.

3. Click Cash Management Bank Statement Reconciliation Data Import.

4. In the File Links section, click the link to the control file.

Follow these guidelines when preparing your data in the worksheet:

• Enter the required information for each column. Refer to the tool tips on each column header for detailed instructions.

• Don't change the order of the columns in the template.

• You can skip the columns you don't use, but don't delete them.

Settings That Affect the Bank Statement Reconciliation Data Import

The Bank Statement Reconciliation Data Import template contains the instructions tab and a tab that represents the table where the data is loaded:

Spreadsheet Tab	Description
Instructions and CSV Generation	Contains instruction information about preparing and loading data, the format of the template, submitting the Bank Statement Reconciliation Data Import process, and correcting import errors.
CE_EXTERNAL_RECON_INT	Enter information about the grouping of bank statement lines and system transactions for bank statement reconciliation, such as a value that identifies the grouping of records, or the bank account ID.

The following values are the source codes used to identify the sources of the reconciled items:

Source Code	Meaning
BS	Bank statement line
AP	Payables transaction
AR	Receivables transaction
PR	Payroll transaction
XT	Cash transaction
ORA_GL	General ledger transaction

The Source ID column is used to identify the reconciled bank statement line or the application transaction. The following table shows how the source IDs are mapped to the source codes:

Source Code	Source ID
XT	1001
AP	10022
AR	10033
BS	10044
ORA_GL	10055

How Bank Statement Reconciliation Data Import Is Processed

After you finish preparing the data in the spreadsheet, complete these steps:

1. Click the Generate CSV File button to generate a .zip file containing the CSV file.

2. Submit the ESS job Load Interface File for Import to load the CSV file.

3. The process automatically imports the reconciliation data from the .zip file into the interface table CE_EXTERNAL_RECON_INT and automatically reconciles the grouped transactions.

4. Review the automatic reconciliation output to review the successfully reconciled groups and the exceptions.