How to load bank statement in Oracle Cloud

How to load bank statement in Oracle Cloud

In this post we will see how to load a bank statement in oracle cloud cash management

There are majorly two types of bank statements MT940 and BAI2 bank statement format. Let us see how to load or import a bank statement in oracle cloud cash management.

How to load or Import a bank statement file in oracle cloud/fusion cash management

Bank statement files are loaded in oracle and then are reconciled against your payments and receipts. This is a small but very critical business process to reconcile balances. This process of loading the bank statement is generally scheduled in a business ( as bank sends payment files on daily basis )and does not require manual intervention, unless their is a error, but we can upload bank statement manually as well in oracle cloud cash management. Let us see how we load/import a bank statement manually in oracle cloud and how we reconcile it against payment.

Below are the detailed steps given on how to load/Import a bank statement in oracle cloud cash management.

Step 1: Place the bank statement file on UCM server.

Navigator >File Import and Export

 

                                        How to load/Import Bank statement in oracle cloud cash management

Step 2: Click on Plus (+) Icon and Choose the bank statement file which you want to load. Make sure in Account you select “fin/cash Management/import” Click save. File will be saved

How to load/Import Bank statement in oracle cloud cash management

Step 3: Navigate to Cash Management module

Navigator >Bank Statement and Reconciliation

How to load/Import Bank statement in oracle cloud cash management

 Step 4: Task Pane>Load and Import bank statement

How to load/Import Bank statement in oracle cloud cash management

Step 5: Select the parameters

Format : your bank statement format (most of the cases it will be MT940 or BAI2)

Data File : Select the file which you have uploaded on UCM from the drop drown.

Click Submit. Your bank statement job will be submitted.

                                                                    How to load/import Bank statement in oracle cloud cash management

Step 6: Check you bank statement here after filling the search criteria.

How to load Bank statement in oracle cloud cash management||How to import Bank statement in oracle cloud/fusion/ load bank statement in oracle cloud

How to create credit memo in oracle receivables

In this post we will see how to create a credit memo in oracle cloud receivables

In this post we will see how to create and apply a credit memo in oracle cloud receivables

To know more about what is credit memo in oracle click here

Detailed steps for how to create a credit memo in oracle cloud receivables are shown below

Step 1: Login to oracle cloud application click Receivables > Billing 

How to create credit memo in oracle cloud receivables

Step 2: On the right-hand side click on task icon >Select >Manage Transaction

how to create credit memo in oracle cloud receivables

Step 3: Enter the transaction number against which Credit memo is to be generated in Transaction       Number and click on search

create credit memo in oracle cloud receivables

Step 4 : Click on Search and then click on the hyperlink which appears in the search results.

Step 5 : Click on actions down arrow and select Credit transaction

How to create credit memo in oracle cloud receivables

Step 6 : Enter the transaction source, Credit reason (optional ) click on Credit entire Invoice and then click on Complete and Close.

create credit memo in oracle cloud | How to create credit memo in oracle cloud receivables