PeopleSoft Enterprise Cash Management 9.1 PeopleBook

Performing In-House Banking Activities

This chapter discusses how to:

Calculate interest accruals.
Generate schedules.
Generate the In-House Bank Statement report.

Prerequisites

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.

Managing In-House Banking Activities

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.

Pages Used to Manage In-House Banking Activities

Page Name	Definition Name	Navigation	Usage
Generate Schedules	SCHEDULE_CREATE	Click Generate Schedule on the Internal Accounts - Account Information page. Set Up Financials/Supply Chain, Product Related, Treasury, Generate Schedules	Create an interest accrual schedule. The frequency of the schedule determines the frequency with which the interest is posted to the internal account balance.
Calculate 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.

Calculating Interest Accruals

Access the Calculate Interest Accruals page (Cash Management, In-House Banking, Calculate Interest Accruals).

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.

Generating the In-House Bank Statement Report

This report shows balance, debit, credit, and activity information for a selected bank over a specified date range.

Page Used to Generate the In-House Bank Statement Report

Page Name	Definition 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.