Use the Bank Account Interest Settlement window to view your bank account balances and to settle the interest accrued on your interest bearing bank accounts
Bank balances are collected from your company, intercompany group, and interest setoff bank accounts. These balances are used to calculate your cash position. See: Cash Positioning.
Optionally you can assign the Pricing model before working with bank balances in Treasury. You must assign a portfolio and a pricing model to each bank account. Portfolios are necessary for calculating interest on the bank account balance. Pricing models are used in the revaluation process. Limits are optional and used to calculate the limit utilization. Normally, you would complete this step during the company bank account setup. For more information on portfolios, see: Portfolio Codes.
On the Cash Management Bank Account page, create or query an existing bank account. For more information, see Setting Up Company Bank Accounts
Navigate to the Account Access page and choose Treasury Access Options..
Select the Portfolio Code.
Select the Pricing Model.
Select Investment Limit Code and Funding Limit Code.
Save your work.
Use Oracle Cash Management's Interest Rate Schedules to assign day count basis, basis, interest rounding and interest includes for a company or intercompany group bank account. For more information, see: Interest Rate Schedule.
Use the Bank Account Interest Settlement window to settle accrued interest on a company or intercompany group bank account.
Set up bank accounts for a company and the parties in the company's intercompany group. See: Company Profiles and Counterparty Profiles.
Assign portfolios for your bank accounts. See: Assigning Portfolios to Bank Accounts.
Assign an Interest Rate Schedule to your bank accounts. See: Interest Rate Schedule.
Record bank account balances in Cash Management. See: Bank Account Balances.
Navigate to the Find Bank Accounts window and complete the fields as needed to locate the bank account that you want to update. Choose the Find button. The Bank Account Interest Settlement window appears.
Select the account you want and choose the Maintain Balances button. The Bank Account Balances window appears.
In the Accrued Interest field, the total amount of accrued interest appears. You can override this calculated interest amount by entering a new interest amount. The System Interest field shows the accrued interest amount calculated by the system.
Note: You can only override interest amounts if you have the appropriate user access levels. See: User Access Levels.
If you want to settle the accrued interest, check the Settle check box. The amount of interest settled appears in the Settle Interest field
Save your work.
In you need to enter bank balances frequently and the balance details are available in an electronic source such as a bank file or a third party application, you can do so using the Cash Management's bank statement import functionality. See Importing Bank Statements.
Use the Cash Management's Interest Rate Schedules to set up and maintain the interest rates for your company and intercompany group bank accounts. Using this page you can set up different rates for different account balances effective on different dates. For example, you can create credit and overdraft rates for each account. See Interest Rate Schedule.