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:
-
Navigate to the File-Based Data Import (FBDI) for Financials guide.
-
In the Table of Contents, click Cash Management.
-
Click Cash Management Bank Statement Reconciliation Data Import.
-
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:
-
Click the Generate CSV File button to generate a .zip file containing the CSV file.
-
Submit the ESS job Load Interface File for Import to load the CSV file.
-
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.
-
Review the automatic reconciliation output to review the successfully reconciled groups and the exceptions.