This chapter discusses how to:
Calculate interest accruals.
Generate schedules.
Generate the In-House Bank Statement report.
Before you can perform in-house banking (IHB) activities, you must first:
Set up internal banks for each business unit you intend to use to internally exchange funds.
Define internal account information. On the Internal Account Information page you must:
Generate the schedule defined on Internal Account Information page (required to run interest accrual calculation process).
Specify both debit and credit rate index information (required to run interest accrual calculation and interest schedule generation processes).
Adjust the opening balances for both Service and Owner of an internal account, as needed. (The opening balances default to zero on setup.)
Check that an accounting template that is setup for internal account interest accruals is installed.
See Also
Defining Internal Account Information
Processing Bank Statements in Financial Gateway
This section discusses how to:
Automatically calculate interest accruals using the IHB Interest Accruals (in house banking interest accruals) Application Engine process (TR_TRINTACU).
View activity on your internal accounts.
Generate schedules for interest accrual.
Page Name |
Object Name |
Navigation |
Usage |
Generate Schedules |
SCHEDULE_CREATE |
|
Create an interest accrual schedule. The frequency of the schedule determines the frequency with which the interest is posted to the internal account balance. |
Calculating Interest Accruals |
TR_AE_RUNCNTL |
Cash Management, In-House Banking, Calculate Interest Accruals |
Run the IHB Interest Accruals process to calculate the amount of interest. |
Internal Account Activity |
BNK_INT_ACCT_BAL |
Cash Management, In-House Banking, Review Internal Account Activity |
View data that is related to activity on your internal accounts. |
Access the Calculate Interest Accruals page.
Note. You may only run the interest accrual process once each day—only when the system date changes can you run the process again.
This means that if you run this process, then perform any activity that affects an internal bank account for a prior date,
you cannot run interest accruals again (in the same day) to reset the prior day interest accrual activity. You must wait until
the next day to run the process and see the affect on the prior day(s) activity.
Because of this system limitation, you should perform any internal account prior day activity before running the interest accrual process.
Bind Variable Name and Value |
In the Parameters grid is an Application Engine run control function that enables you to specify the variable for which you are setting the value. Select the Bind Variable Name of ACCT_TMPL_ID, and enter an accounting template in the Value field. You can add records and specify as many bind variable names as are pertinent to the job. PeopleSoft provides INTERNAL_INTACC as a default accounting template. |
This report shows balance, debit, credit, and activity information for a selected bank over a specified date range.
Page Name |
Object Name |
Navigation |
Usage |
In-House Bank Statement |
RUN_TRC3005 |
Cash Management, In-House Banking, In-House Bank Statements |
Lists transaction and interest accrual activity for a specified bank and account during a defined time frame. |