Create and Upload Bank Statements from a Spreadsheet in Oracle Fusion Applications

Oracle allows the import of non-standard bank statement formats using just a Excel spreadsheet. You just have to populate the spreadsheet with the correct data and there's a button that allows you to generate a CSV file that you would then load to the cloud.

From the Welcome Springboard, Navigate to the Cash Management application and go into the Bank Statements and Reconciliations work area.

Click on the Task Pane and select the function “Create bank statements in Spreadsheet”:

The template includes instructions for the generation of the CSV file after the population of data being imported. There's a separate tab for bank statement headers, a statement balances, statement balance availabilities, statement lines, etc. 

To find out how to Manually create Bank Statements, check out a separate article:
Manually Creating a Bank Statement and Reconciling against a Receivable Transaction

For more information on Cash Management and Bank Statements, check out this separate article: Overview of Cash Management in Oracle Fusion Applications

For more full-detailed Tutorials and Tips, check out #TheOracleProdigy at https://lifeofanoracleprodigy.blogspot.com/
Follow The Oracle Prodigy on Facebook (https://www.facebook.com/theOracleProdigy/) and Twitter (https://twitter.com/D_OracleProdigy)