PeopleSoft 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 are related to activity on your internal accounts.

Calculating Interest Accruals

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

Bind Variable Name and Value/Date

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. You can add records and specify as many bind variable names as are pertinent to the job.

ACCT_TMPL_ID: When you use this bind variable name, enter an accounting template in the corresponding Value field. PeopleSoft provides INTERNAL_INTACC as a default accounting template.

END_DT: When you use this bind variable name, enter an end date in the Date field. Accounting events and cash flow entries will be created with the specified end date. The system processes and updates records only once for the end date.

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.