Setting Up Bank Statement Processing

This section describes the components that you use for setting up the Bank Statement Import process and discusses how to:

Define balance codes.
Define transaction codes.

Pages Used Exclusively for Setting Up Bank Statement Processing

Page Name	Definition Name	Navigation	Usage
Balance Codes	BSP_BAL_CODES	select Banking, then select Administer Bank Statements, then select Bank Statement Codes	Define bank statement code information. Also select three favorite statement codes for display in online inquiry pages.
Transaction Codes	BSP_TXN_CODES	select Banking, then select Administer Bank Statements, then select Bank Statement Codes, then select Transaction Codes	Define bank statement, transaction code information, such as activity type and payment method.

Components Used to Set Up Bank Statement Processing

Use these application pages to set up the Bank Statement Import process.

Balance Codes

Define codes that are used for bank statement balances.

See Defining Bank Statement Balance Codes.
Transaction Codes

Define codes that are used for bank statement transaction information.

See Defining Transaction Codes.
Code Mappings

Define the mappings between external system codes with their equivalent internal PeopleSoft codes.

See Code Mappings Page.
Layout Catalog

See Layout Catalog Page.
(Optional) Event Code Definition

See Event Code Definition Page.
Node Definition (required only if you are using Integration Broker)

See Setting Up PeopleSoft Integration Broker for Bank Statements, Payments, and Payment Acknowledgements.
(Optional) Encryption Profile

See Understanding File Encryption.

Note: If you create new layouts or modify existing ones for an organization's bank-statement-processing requirements, you must add them to the Layout Catalog.

Defining Bank Statement Balance Codes

Use the Balance Codes page (BSP_BAL_CODES) to define bank statement code information.

Also select three favorite statement codes for display in online inquiry pages.

Navigation

select Banking, then select Administer Bank Statements, then select Bank Statement Codes

Image: Bank Statement Codes - Balance Codes page

This example illustrates the fields and controls on the Bank Statement Codes - Balance Codes page. You can find definitions for the fields and controls later on this page.

Assign balance codes to each balance line and determine how the reconciliation process manages them. Assign a balance code to each balance entry that is received electronically or entered manually.

Statement Code

Enter a three-digit statement code that is to be defined.

Type Code

Indicate whether the code is a Status or Summary code.

CR/DB (credit/debit)

Indicate whether the code is a CR (credit) or DB (debit), or select NA (not applicable) if this categorization does not apply.

Display Balance

Select to indicate that the balance is a favorite balance. The system automatically displays the favorite balances on certain pages, such as the Bank Balance Inquiry page. You can select no more than three bank balances, however, you can change these selections at any time.

Defining Transaction Codes

Use the Bank Statement Codes - Transaction Codes page (BSP_TXN_CODES) to define bank-statement, transaction-code information, such as activity type and payment method.

Navigation

select Banking, then select Administer Bank Statements, then select Bank Statement Codes, then select Transaction Codes

Image: Bank Statement Codes - Transaction Codes page

This example illustrates the fields and controls on the Bank Statement Codes - Transaction Codes page. You can find definitions for the fields and controls later on this page.

The system assigns transaction codes to each bank-statement-transaction line during electronic load or manual entry. The transaction code determines how reconciliation processes the specific line item.

Trans Code (transaction code)

Identifies the type of transaction in a bank statement. Select from:

Automated Clearing House
Bank Adjustments
Bill of Exchange - Disburse
Bill of Order - Disburse
Check
Deposits
Direct Debit
Direct Debit - Disburse
Drafts
Electronic Funds Transfer
Fee Expense
Funding Receipt
General Transaction
Interest Expense
Manual Check
Miscellaneous Transaction
Payment
Stop Pay (stop payment)
Trade Receipt
Voided Payment
Wire - Disbursement
Wire - Incoming

Activity

Select a bank-statement activity type.

Payment Method

Identifies the payment method that is specified for a transaction code. Select from:

ACH: Automatic clearing house.
Check
Cust Draft:Customer draft.
Direct Debit
EFT: Electronic funds transfer.
EFT Drafts:Electronic funds transfer drafts.
Giro-EFT: Giro-electronic funds transfer.
Giro-Manual Giro-manual.
LC: Letter of credit.
Manual: Manual check.
Wire: Wire transfer.
Vndr Draft:Vendor draft.
Wire: Wire disbursement.