This chapter provides an overview of external, internal, and netting accounts and discusses how to:
Define settlement instructions.
Define external account information.
Define internal account information.
Define netting account information.
In PeopleSoft, you can create and maintain the following types of bank accounts, depending on your organizational needs:
Settlement Instructions: You first create “stand alone” settlement instructions which will later be associated with specific accounts or counterparties when you define your internal, external, and netting accounts.
External accounts: External accounts in PeopleSoft represent physical (or “brick and mortar”) financial institutions. You must define external accounts for each physical bank with which you maintain a banking relationship. PeopleSoft defines maintaining a banking relationship as involving any of the following (or any combination) of the following banking activities:
Submit checks through Payables Pay Cycle Manager.
Create wires and electronic funds transfer (EFTs) that are then settled through Cash Management Payment Dispatch or Payables PayCycle Manager.
Send direct debits and EFTs that are then settled through Cash Management Payment Dispatch or Payables PayCycle Manager.
Transfer funds between bank accounts.
Internal accounts: Internal accounts are accounts that exist solely within your organization and that are used to transfer funds between business units.
Netting accounts: Netting accounts are virtual accounts that exist only within your organization.
You create netting accounts to net the cashflow between Payables and Receivables items. There are functional restrictions as to what external account cashflow can be netted.
A net is associated with two accounts: a netting account and a designated disbursement external account. After netting a cash flow, the system transfers the netted payment to the designated netting account. Any remaining balance is transferred to the disbursement account for settlement. (Note that the disbursement account is a different external account than the netting account defined for the netting bank.)
Account # (account number) |
Displays the account number of the bank, as defined by bank ID calculations on the Bank ID Qualifiers page. For banks in some countries with certain bank qualifier IDs, you must also enter a check digit. |
Acct Type (account type) and Bank Account Type |
Enter a value that identifies the type of account, such as Check Acct (checking account) or SB Acct (stocks and bonds account). |
Company ID or Company Identification Number or Remitter ID |
Enter a company ID, which is specified by certain European banks (for example, banks in France and Italy) to identify the issuer of an electronic file. Banks may issue one remitter ID per payment method for use with these four payment methods: Direct Debit (DD), Wire Transfer(WIR), Electronic Funds Transfer (EFT), or Automated Clearing House (ACH). During PayCyle Manager processing, the system accesses this data (if available) from a table and submits it with the specified payment method information. If you are specifying EFT options for a French bank account, you complete this field only if you are also using the ETEBAC EFT layout. Company ID is then used to populate Numero d'emetteur. If specifying options for an Italian bank account, complete this field only if you are using the ITAPYMT EFT layout. Note. Numero d'Emetteurs (or remitter IDs) are different from the 'Numéro National d'émetteur' (NNE). Remitter IDs are issued by any central European bank. NNEs are issued only by the Banque de France and are mandatory information when processing direct debits using a ETBDD EFT layout. Numero d'emetteur is also optional information when processing drafts using ETBDR EFT layout. |
DFI Qualifier and DFI ID (depository financial institution qualifier) and DFI ID (depository financial institution ID) |
Select the DFI qualifier and enter the associated DFI ID to identify the bank using its DFI ID. If you use intermediary routings, this bank represents the final bank into which funds are transferred. The DFI qualifier indicates the format—the number of characters and numerics—that is used in the bank’s DFI ID. Each type has a specific number of digits that you can enter: Transit Number: Enter exactly nine numerics, plus check digit calculation. Swift ID: Enter 8 or 11 characters; positions 5 and 6 must be a valid two-character country code. CHIPS ID: Enter three or four numerics for a CHIPS ID (CHIPS Participant ID). CHIPS UID (CHIPS universal identification number): Enter six numerics for a CHIPS UID. Canadian Bank Branch/Institute: No validation. Mutually Defined: No validation. |
EFT Layout (electronic funds transfer layout) |
Select one of the predefined EFT formats used in various countries and by many clearing institutions. We also provide you with the tools to create additional EFT layout formats when needed. |
Last File Number |
Displays the last EFT file number. |
This section discusses how to:
Define beneficiary bank accounts.
Define EFT options for settlements.
Page Name |
Object Name |
Navigation |
Usage |
Beneficiary Bank |
STL_INSTRUCTION |
Banking, Bank Accounts, Settlement Instructions |
Create settlement instructions for use by Treasury Management. Associate the instructions with appropriate accounts or counterparties. |
Beneficiary Address |
STL_ADDRESS |
Banking, Bank Accounts, Settlement Instructions Select the Beneficiary Address tab. |
Capture bank address information on your settlement instructions. |
EFT Options |
TR_EFT_OPT_SEC |
Click EFT Options on the Beneficiary Bank page. |
Define specifics for EFT transmissions when using these settlement instructions. |
Access the Beneficiary Bank page.
Our Instructions/Receive Into |
Select if these instructions dictate receipt of funds from a counterparty. Generally, information entered here matches external bank account information already defined in the PeopleSoft system (on the External Accounts page). |
Partner Instructions/Pay Into |
Select if these instructions dictate payment of funds to a counterparty. Generally, information entered here enables electronic payment to an account not defined in the PeopleSoft system. |
Account Information
Complete the fields to identify the bank that receives funds when using these settlement instructions:
If the Partner Instructions/Pay Into radio button is selected, the bank account that you describe here is the counterparty’s bank account into which you’re transferring funds.
Because bank accounts are defined by currency, you must insert additional rows for each currency used for fund settlement.
If the Our Instructions/Receive Into radio button is selected, the bank account that you describe here is your bank account for receiving funds in the referenced currency.
Currency |
Select the currency. We recommend that you set up settlement instructions for each currency defined for the bank account. |
Name 1 and Name 2 |
Enter the beneficiary names, if required. |
Bank ID Qualifier |
Select an ID to enable the bank information to be edited online. For certain bank ID qualifiers, you must specify a check digit. |
For the specified settlement instructions, define the account’s IBAN for transmittal with other settlement information. Enter the check digit and click View IBAN. If the system validates the check digit, the IBAN for this account appears next to the View IBAN button, and the system stores it on a record. |
See Also
International Bank Account Number Functionality
Access the EFT Options page.
Payment Format |
Select a payment format for this settlement instruction’s EFT option. You can create your own payment formats or modify the delivered formats, such as Check Std, Pay & Dep, and Wire. Other options are: None: No information is sent. Pay+Advice: Both the actual payment and the advice are transmitted. Prenote: Test run to verify that all EFT information is correct before sending out an actual payment and advice. Pymnt Only: Only the payment is sent with the EFT file. Depending on the country in which an EFT takes place, there may be costs involved in carrying out such transactions, especially if there is a transfer between two different countries. The Domestic Costs field displays who pays for the bank costs of the EFT. If there are any other third parties to the transfer, correspondent's costs are also assessed. When there are domestic costs or correspondent's costs tied to an EFT transaction, select the source from which these costs are paid. |
Transaction Handling |
Select an option that determines the parts of the payment that are included in the EFT file when you send it to the bank. Options are: None: No costs are incurred. Payee Acct: The payee’s account is assessed for the charges. Payr/Payee: The payee and the payer share costs equally. This option applies only to domestic costs. Pyr D Acct: Costs are assessed to the payer’s domestic account. Pyr F Acct: Costs are assessed to the payer’s foreign account. |
Bank Check Drawn On |
Select where a check comes from, if it is necessary to generate a check for this EFT transaction. Options are: (none), Payee Bank, or Payer Bank. |
Check Forwarding |
Select where the check should go. Options are: (none), Payee Bank, Payee, Payer, or Pyr Bank. |
Crossed Check |
Select if the EFT involves a check that cannot be signed over to a third party. |
Payment Instruction 1, Payment Instruction 2, Payment Instruction 3, and Payment Instruction 4 |
Select additional payment instructions for the employee’s EFTs. These fields contain standard EFT instruction codes that are delivered with your system. |
Payment Instruction Ref 1 and Payment Instruction Ref 2 |
Enter any additional comments regarding EFT transactions. |
See Also
Setting Up Files for Electronic Funds Transfers
To define external accounts, use the External Bank Accounts component (BANK_EXTERNAL_GBL).
Use the TR_EXTERNAL_ACCOUNTS_CI component interface to load data into the External Bank Accounts tables.
To define bank cut-off times, use the Bank Cut-off Times component (CUTOFF_TIMES_GBL).
This section also describes how to:
Define external accounts information.
Define valid currencies.
Define ChartField inheritance options.
Define account signatories.
Review account contacts.
Define account information.
Define collection methods.
(Optional) Specify draft document types.
Define payment methods.
(Optional) Specify document sequence types.
(Optional) Define bank account draft ChartFields.
(Optional) Define EFT options for payment methods.
(USF) Define prenotification.
Define format properties.
Define account settlement information.
Understanding Nuances of External Bank Accounts
This section provides overviews on:
Bank account ChartField inheritance for Education and Government.
Bank account payment methods.
IBAN check digit validation.
Value date for bank accounts.
In education and government organizations, you can associate bank accounts with a single fund (non-pooled) or group of funds (pooled). Pooled accounts may contain funding from many different grants or endowments, and this pooled fund is represented as a fully configurable ChartField:
As nonpooled accounts are associated with a single fund, you may explicitly enter the fund as a ChartField on the bank account and use it like the other ChartFields.
For pooled bank accounts, the ChartField must be derived at the transaction that references the bank account, because all of the activity in the account must be tracked back to a particular fund (per governmental requirements).
To correctly process transactional ChartFields for pooled bank accounts, use the Bank Account ChartField Inheritance feature. This feature provides a balancing methodology at the ChartField level rather than at the business unit level, which in turn facilitates the interunit and intraunit accounting entry functionality. To enable ChartField inheritance, select one of four inheritance options for each fully configurable ChartField (plus Department and Project ChartFields) on the External Accounts - ChartField Options page. Automatic processes cross-validate whether the specific ChartField supports the inheritance option; the cross-validation is dependent on the PeopleSoft applications and options selected on the External Accounts page.
The following tables illustrate the valid inheritance option combinations:
Table labels (except for valid inheritance options) relate to page fields and check boxes that appear on the External Accounts page.
You specify inheritance option values (listed in italics in the following tables, next to valid inheritance options) on the External Accounts - ChartField Options page.
Inheritance Option Code Key
This table displays the codes for inheritance options:
Inheritance Option |
Code |
Always Inherit |
A |
Do Not Inherit |
N |
Inherit Within Unit |
I |
Use Unit Default |
D |
Option not applicable |
N/A |
Note. We define inheritance options in the Defining ChartField Inheritance Options section.
Receivables, Billing, and Cash
This table displays the inheritance options for Cash Management, Receivables, and Billing transactions:
Account Types |
Processing Options |
|||||||
Accounts Receivables (AR) or Billing (BI) |
Cash Clearing |
AR Draft Cash Control |
Dep in Transit |
|||||
Account Types |
Cash AR |
Deposit AR |
AR OffSetDr. * |
AR OffsetCr. * |
Cntrl - AR |
Disc - AR |
Draft - AR |
Dit-AR |
Valid Inheritance Options |
N |
N |
N/A |
N/A |
N |
N |
N |
N |
D |
D |
N/A |
N/A |
D |
D |
D |
D |
|
I |
N |
I |
I |
I |
I |
I |
I |
|
I |
D |
I |
I |
I |
I |
I |
I |
|
A |
N |
A |
A |
A |
A |
A |
A |
|
A |
D |
A |
A |
A |
A |
A |
A |
*If any Cash - AR ChartField inheritance option is set to either A or I, and you select the Cash Clearing check box, these ChartFields appear on the External Accounts - ChartFields tab when you save.
Payables
This table displays the inheritance options for payables (AP) transactions:
|
Account Types |
Processing Options |
||
|
AP |
Cash Clearing |
TFR Charge by Vendor |
Drafts Payable |
Acct Type |
Cash - AP |
Cntrl - AP |
Bnk Charge |
Draft - AP |
Valid Inheritance Options |
N |
N |
N |
N |
D |
D |
D |
D |
|
I |
I |
I |
I |
|
A |
A |
A |
A |
Treasury
This table displays the inheritance options for treasury (TR) transactions:
|
Account Types |
Processing Options |
||
|
TR |
Cash Clearing |
Stmt Accounting |
TR |
Acct Type |
Cash |
Control |
Fees |
Cash |
Valid Inheritance Options |
N |
N |
N |
N |
D |
D |
D |
D |
|
I |
I |
I |
I |
|
A |
A |
A |
A |
Expenses
This table displays the inheritance options for expense (EX) transactions:
|
Account Types |
Processing Options |
||
|
EX |
Cash Clearing* |
TFR Charge by Vendor * |
Drafts Payable * |
Acct Type |
Cash AP |
Cntrl - AP |
Bnk Charge |
Draft AP |
Valid Inheritance Options |
N |
N |
N |
N |
D |
D |
D |
D |
|
I |
I |
I |
I |
|
A |
A |
A |
A |
When you select the AP application check box on the External Accounts page, these ChartFields appear on the ChartFields tab. When you select only the EX application check box, no inheritance validation is enforced. However, when you select the EX and AP check boxes, the AP inheritance validation rules are enforced.
If you use Cash Management and Payables in your organization's banking processes, you can configure banking accounts to automatically process certain Cash Management settlements through either the Cash Management Payment Dispatch or Payables Pay Cycle Manager (PCM) functionality.
To enable this settlement integration, there are now two payment sources predefined in PCM:
TR: Payment source used for bank transfers, fees, and deal settlements.
TRET: Payment source used for EFT request transactions.
The following is a listing of supported and unsupported settlement options for Cash Management settlements:
You can settle ACH and EFT payment methods through either Treasury settlements pages or Pay Cycle Manager.
Checks are automatically configured to settle through Pay Cycle Manager.
As this is a system default value, you cannot access the External Accounts - Payment Methods settle through option.
You cannot settle direct debits through Pay Cycle Manager.
Note. All Cash Management settlements processed through PCM must use the same default currency of the account. For example, if a bank account has a default currency of USD, and you create a settlement from this account with a currency of JPY, PCM cannot process the settlement.
International Bank Account Number (IBAN) provides an international standard account identifier in order to facilitate automated processing of cross border transactions. IBAN standards are established by the European Committee for Banking Standards (ECBS) and the International Standards Organization (ISO).
PeopleSoft provides a function that validates an IBAN for new account information and stores the IBAN check digit in a record. Clicking the View IBAN button on either the Beneficiary Bank page or External Accounts page starts a function that validates the IBAN check digit entry, using processes and functions that conform to ISO 13616, 3166, and 7064. If the check digit is successfully validated, the system concatenates the IBAN check digit and the existing Basic Bank Account Number (BBAN) to create the IBAN:
Calculation Page |
Related Record |
External Accounts |
BANK_ACCT_DEFN |
Settlement Instructions |
STL_INSTRUCTION |
EFT Request Entry |
TR_WR_DETAIL |
EFT Template |
TR_WR_TEMPLATE |
For electronic formats, the IBAN includes the two-letter country code, two-numeral check digit, and existing BBAN. For paper formats, the IBAN is the same as the electronic format, and also includes the tag IBAN followed by a space, with the number separated into groups of four characters. The last group may vary in length, up to four characters.
This section discusses how to manually validate the IBAN check digits as established by the ECBS and the ISO. Before performing any validations, you should refer to the comprehensive ISO documentation of these methods on the ISO website (http://www.iso.ch/iso/en/ISOOnline.frontpage), specifically:
ISO 13616:1997.
Banking and related financial services - IBAN.
ISO 3166-1:1997, 3166-2:1998, and 3166-3:1999.
Country code information.
ISO 7064.
Data processing - check character systems.
Validating the Check Digits Manually
If the IBAN is in paper format, convert it to basic format by deleting all nonalphanumeric characters and the preceding tag IBAN.
IBAN BE62 5100 0754 7061 becomes BE62510007547061.
Perform these tasks:
Move the first four characters of the IBAN to the right of the number.
Result = 510007547061BE62.
Convert the letters into numerics in accordance with the conversion table that follows.
Result = 510007547061111462.
Apply MOD 97-10 (see ISO 7604).
For the check digits to be correct, the remainder after calculating the modulus 97 must be 1.
The remainder of the division of 510007547061111462 by 97 = 1.
Alpha to Numeric Conversion Table
This table displays the alpha to numeric conversion:
A |
= 10 |
G |
= 16 |
M |
= 22 |
S |
= 28 |
Y |
= 34 |
B |
= 11 |
H |
= 17 |
N |
= 23 |
T |
= 29 |
Z |
= 35 |
C |
= 12 |
I |
= 18 |
O |
= 24 |
U |
= 30 |
|
|
D |
= 13 |
J |
= 19 |
P |
= 25 |
V |
= 31 |
|
|
E |
= 14 |
K |
= 20 |
Q |
= 26 |
W |
= 32 |
|
|
F |
= 15 |
L |
= 21 |
R |
= 27 |
X |
= 33 |
|
|
Value dating transactions is a common practice in Western European countries, similar to the banking practice of float in the U.S. The value date of a transaction is the date on which funds are available (either as a deposit or a settlement). Banks negotiate this date to be a specified number of days before or after the business date of a transaction. For payments or settlements, the value date is calculated as a number of days before the business date, which means that the check must clear the bank prior to settling with the individual beneficiary. For deposits, the value date is calculated as a specified number of days beyond the business date.
You specify a value date (expressed as a positive or negative number) for a selected payment method. This functionality is available to you depending on how you configure Treasury Management. If you do not enable the value date functionality for a business unit, automatic processes enable the accounting date (or business date) to appear by default in the Value Date field. Using the Value Date option in PeopleSoft is mainly a setup step. After you specify value date parameters for a specific bank account on the External Accounts - Payment Methods page, automatic processes populate the calculated value date in the system and on applicable PeopleSoft reports.
See Also
Page Name |
Object Name |
Navigation |
Usage |
External Accounts |
BANK_PNL2 |
Banking, Bank Accounts, External Accounts |
Set up external accounts. |
Bank Branch Information |
BANK_BRNCHPNL |
Click Bank Branch Information on the External Accounts page. |
Edit bank branch information associated with an external account. |
Valid Currencies |
BANK_ACCT_CURR_SEC |
|
Enter valid default currencies for an external account. |
ChartField Options |
BNK_CF_OPTIONS_SEC |
|
Specify inheritance rules for ChartFields for an account type. |
External Accounts - Signatories |
BANK_PNLSIGNATORYS |
Banking, Bank Accounts, External Accounts, Signatories |
Define account signatories. |
External Accounts - Contacts |
BANK_PNLCNTCT |
Banking, Bank Accounts, External Accounts, Contacts |
View the names and phone numbers of bank contacts. |
Bank Contact Notes |
BRANCH_CNT_DISP_SP |
|
Enter notes about the bank contact for an external account. |
External Accounts - Account Information |
BANK_PNL3 |
Banking, Bank Accounts, External Accounts, Account Information |
Specify additional information for each bank account. |
External Accounts - Collection Methods |
COLLECT_BANK |
Banking, Bank Accounts, External Accounts, Collection Methods |
Associate different payment methods and collection options (for your receipts) with multiple bank accounts that you established with a particular bank. |
Document Types |
BANK_COLCT_SEC |
Click Document Type on the External Accounts - Collection Methods page. |
Specify a document type for document sequencing for each draft event. The Receivable Update process (AR_UPDATE) uses this to create document sequence numbers. Note. The Document Type link appears only if Draft is selected in the Payment Method field. |
External Accounts - Payment Methods |
PYMNT_BANK |
Banking, Bank Accounts, External Accounts, Payment Methods tab |
Define the payment methods supported for an account, payment processing options, and EFT file attributes. For each account, you can enter multiple payment methods. |
Document Sequence |
PYMNT_BANK_DOC_SEC |
Click Document Sequencing on the External Accounts - Payment Methods page. |
Set up tracking of individual documents. Note. To access this page, document sequencing must be enabled on the Treasury Options page at the business unit level. |
Bank Account Draft ChartFields |
BANK_ACCT_CFDR_SEC |
Click Draft Status on the External Accounts - Payment Methods page. |
Enter details about the draft account ChartFields. |
Prenotification |
BANK_PRENOTE |
Click Prenote on the External Accounts - Payment Methods page. |
Indicate whether prenotification files (used in Federal Schedule Reconciliation) must be generated. |
Define Layout Properties |
PMT_BANK_MTHD_PROP |
Click the Define Layout Properties icon on the External Accounts - Payment Methods page. |
Review and edit values defined for a specific electronic format. |
External Accounts - Account Settlement |
BANK_PNLSETTLE |
Banking, Bank Accounts, External Accounts, Account Settlement tab |
Associate settlement instructions with a bank account. |
Access the External Accounts page.
Bank Accounts
Branch |
Select a branch. The branch determines the location of the account and the bank qualifier to use for bank account validation. Depending on the bank ID qualifier associated with the branch, you might need to specify a check digit for the account. Click the Bank Branch Information button to view and edit bank branch information. |
GL Unit (general ledger unit) |
Select the GL business unit associated with this account. |
RFC (regional finance center) |
Enter the three-character value that identifies the RFC to be assigned to the summary payment file. |
(USF) Sender DO (sender disbursing office) |
Enter the U.S. federal government Intragovernmental Payment and Collection System (IPAC) Sender DO Symbol identifier for the agency that is sending the IPAC transaction. This five-character code is assigned by the U.S. Treasury to agencies enrolled in IPAC. |
Define the account’s IBAN for transmittal with other account information for the bank account. Enter the two-numeral check digit code for the country and click View IBAN. If the system successfully validates the check digit, the IBAN for this account appears, and the system stores the IBAN check digit on the BANK_ACCT_DEFN table. |
Important! For a specified setID and bank ID, no two accounts should have the same bank account number.
Rate Type |
Select the exchange rate type that expresses the value of one currency in terms of another. |
Index |
Select the market rate index. |
Currency Code |
Click the Currencies button to access the Valid Currencies page, and designate multiple valid currencies and a single default currency for this external account. |
Select the appropriate check boxes to indicate which PeopleSoft applications use this account. This determines which Ledger Account ChartFields that you must establish.
BI: Billing
AP: Payables
AR: Receivables
TR: Treasury
EX: Expenses
Select the appropriate check box for the type of bank balance accounting used by this account.
Important! If you are setting up bank accounts for bank account transfer functionality, you must select the TR check box. Doing this creates a Cash ChartField for the bank account. The system requires a cash account ChartField active at the bank account level to display the account in the bank account transfer feature.
DD/AR Draft Cash Ctrl (direct debit/accounts receivable draft cash control) |
Select to record cash prior to actually receiving the funds in a draft. Available for entry only when you’ve selected the AR or BI bank check box. Selecting DD/AR Draft Cash Ctrl also generates the SQL object used to control ChartField inheritance for direct debits. |
Drafts Payable |
Available for entry only when you’ve selected the AP bank check box. |
Cash Clearing |
Available for entry only when you’ve selected the AR , AP ,or TR bank check box. You must select this check box before you can select the Dep in Transit check box. |
Stmt Accounting (statement accounting) |
Available for entry only when you’ve selected the TR bank check box. Statement accounting makes particular ChartFields available so that you can map where fees and interest will go. This is important when you are installing Treasury to support bank reconciliation and Cash Management Bank Statement Accounting functionality, which supports generating accounting lines for fees and interest. |
TRF Charge |
Available for entry only when you’ve selected the AP bank check box. |
Dep in Transit (deposits in transit) |
Select to associate a Deposit in Transit account with this external bank account; the system adds the DIT-AR row to the Bank Account Types grid. You must first select the Cash Clearing check box to enable this check box. |
This table displays the Bank Account Ledger Types that you must establish, depending on your selections in the Account Use group box:
Account Use |
Required ChartFields |
Drafts Payable ChartFields |
Cash Clearing ChartFields |
AR Draft Cash Control |
Stmt Accounting ChartFields |
TRF Charge by Vendor |
Dep in Transit |
BI |
Cash − AR Deposit-AR DIT-AR |
NA |
NA |
NA |
NA |
NA |
NA |
AP |
Cash − AP DIT-AR |
Draft − AP |
Control- AP |
NA |
NA |
Bnk − Charge |
NA |
AR |
Cash − AR Deposit-AR |
NA |
NA |
Draft − AR Control − AR Discount - AR |
NA |
NA |
if selected |
TR |
Cash |
NA |
Control |
NA |
Interest Fees |
NA |
NA |
EX |
Cash − AP |
NA |
NA |
NA |
NA |
NA |
NA |
Enter the ChartField values to use for each account type.
|
Click to select ChartField inheritance options for a specified account type. |
Previous in List and Next in List |
Select to access the previous or next external account listed on the External Accounts search page. |
|
Click to add a new external account to the system. |
Note. You must specify the correct ChartField inheritance option combination to save the account information, depending on the Account Type options selected. Refer to the tables of valid inheritance option combinations listed in the Bank Account ChartField Inheritance section.
Access the Valid Currencies page.
Currency |
Enter all valid currencies for the external account. Select the Default check box to indicate the default currency of the bank account. The default currency drives certain PeopleSoft financial processes, such as reconciliation and transaction revaluation. Generally, the default currency is the same as the associated General Ledger business unit currency. However, there can be situations where a bank account's specified default currency is different than that of the associated General Ledger Unit currency, depending on the system processing requirements. |
Rate |
Select a currency conversion rate type code. |
Index |
Enter a market index rate from which to derive the defined currency conversion rate. |
Access the ChartField Options page.
Select an inheritance option for each ChartField.
Always Inherit |
The system uses ChartFields from the offsetting entry. Entries are either explicitly derived (entered by user) or derived by way of substitution (entered by the system at run time). |
Do Not Inherit |
Appears by default. You specify ChartField values on the External Accounts page. |
Inherit Within Unit |
The system uses ChartFields from the offsetting entry within the same business unit or the system uses the ChartField value specified on the External Accounts page for interunit transactions. |
Use Unit Default |
The business unit value appears by default from values specified on the Business Unit Option page, regardless of the offsetting transaction. |
When you change inheritance from Do Not Inherit to another value, the specified ChartField appears as a read-only field on the External Accounts page. In the previous example, if you set the Department inheritance option to Always Inherit, the field is unavailable for entry on the External Accounts page.
See Also
Bank Account ChartField Inheritance for Education and Government
Access the Signatories page.
Enter the name of the signatory and the monetary ceiling (the signatory limit) that the signatory can approve.
This page is for informational purposes only. The system does not generate a required activity for the signatory (for example, the signatory's electronic signature on a system-generated check). You can use this for reports or configurations that you want to add.
Access the Contacts page.
Contact ID |
Click a contact link to access that person’s financial contacts page. |
|
Click the Bank Contact Notes button to enter notes for the contact on the Bank Contacts Notes page. |
Access the External Accounts - Account Information page.
Holiday List ID |
Displays the EFT calendar associated with this bank. This field is used by EFT payments for Treasury, Expenses, and Payables. Enter a value only if you intend to use EFT as a payment method. Because this field is at the bank level, you cannot have two accounts for the same bank with different holiday lists. |
Account Information
Preferred Language |
Select the preferred default language for the account. |
Charge Bank and Charge Acct (charge account) |
Select the bank and account that charges bank processing fees to this account, if applicable. |
Remitter ID |
Displays the remitter ID that the bank assigned to your account. This information is used by the receiving bank when you submit files by EFT. Depending on your country and bank, you could also define a remitter ID in the Company Identification Number field of the EFT Options page for Payment Methods. For French bank accounts, the Remitter ID field is used to store the French Numéro National d'émetteur (NNE) issued by the Banque de France. This information is required to issue direct debits in France and is used in processing the direct debits EFT layout, ETBDD. |
If this account is pooled with other bank accounts, select a pool ID (defined on the Pool ID page). |
Only Payables uses the information in the Payment Information group box.
Check# Len (check number length) |
Enter the number of digits in your check number during check printing, to a maximum of 10 digits. For example, if a check number has four digits, the system prints only those four digits, justified to the left, padded with leading zeros. For example, if the check number length is 4, then check #27 is 0027. |
Fract Rtg# (fractional routing number) |
Displays the number that the system uses to route checks to the drawee institution if the MICR line is illegible. The bank’s routing number is usually printed twice on a check: on the MICR line and in the upper right corner as a fraction, such as 11-35/1210. Note. Both the routing number and the fractional routing number are assigned to the bank. In the U.S., the Rand McNally Corporation publishes these numbers, although they are actually assigned by the Routing Numbers Administrative Board of the American Bankers Association. |
Only Payables uses the information in the Payment Handling group box.
Override |
Select this check box to sort checks with large amounts during payment creation. Enter an amount in the Amount field to define the check amount that triggers an override. The payment handling code dictates the print order for these special checks. For example, if you specify an override limit of 50,000 USD with a handling code of HD, the system prints checks equal to or more than 50,000 USD in the sort sequence specified by the payment handling code. |
You define handling codes on the Payment Handling Codes page. When adding new codes, leave gaps between numbers in the sort sequence so that you can easily add more codes as necessary. This table lists some handling codes that you may want to implement:
Handling Code |
Name |
Sort Sequence |
HD |
High Dollar Payment |
99 |
IN |
Internal Distribution |
10 |
PO |
Route to Purchasing |
50 |
RE |
Regular Payments |
1 |
PayCycle Amount Limits
This functionality is integrated with the Payables bank replacement functionality.
The system is not enabled for amount splitting. If a voucher amount exceeds the maximum amount per pay cycle or the maximum amount per payment, the entire voucher amount is derived from another account. For example, you establish that Bank Account 001 has a 50,000 USD maximum and Bank Account 002 has a 25,000 USD maximum. A 10-voucher group to be paid totals 51,000 USD. The first nine vouchers total 47,000 USD and are paid from Bank Account 001. The number 10 voucher totaling 4,000 USD is paid from Bank Account 002.
Note. You must first define valid currency codes for the account before you can define Paycycle Currency Code and Payment Currency Code values.
Maximum Amount Per Paycycle |
Enter the maximum amount that may be paid from a bank account per pay cycle run, and specify a pay cycle currency code. If the pay cycle amount exceeds the maximum limit set here, the system switches to the specified replacement bank accounts to pay the remainder. For example, the total pay cycle is 2,000,000 USD. You specify that:
|
Maximum Amount Per Payment |
Enter the maximum amount that may be paid for an individual amount out of a bank account. If the limit is exceeded, the payment program selects another bank. |
Only Receivables uses the information in the Receipt Information group box.
Deposit Type |
Select the type of deposits that this account receives, and also indicate the associated Deposit Unit. This information tells you the nature of the deposit and varies according to record keeping practices. Deposit types might categorize regions in which you do business or might separate deposits by source of income. You must establish deposit types on the Deposit Type page before you can select one in this field. |
Payment Predictor |
Select to enable the Payment Predictor process (AR_PREDICT) to process the deposits and payments that this account receives. If you select Payment Predictor for a bank account, the system sets the Payment Predictor process as the default method to apply all payments received from that bank account. You can disable the Payment Predictor process for individual payments during deposit and payment entry. |
Payables uses the Discount Evaluation Rate feature. Processes (during pay cycle selection) on a federal invoice amount calculate money saved by taking an “early pay” vendor discount, versus money earned by interest accrued on the invoice amount to the full due date. You can specify the interest rate per account of a single bank. To enable interest accrual calculation, specify the interest rate and related information.
Interest Rate |
Enter a percentage as a decimal. |
Days in Year |
Displays the number of days that the system uses to compute the annual effective discount rate specified by the vendor. The default value is 360. |
See Also
Defining Account Pool Information
Setting Up Payment Predictor Processing
Access the External Accounts - Collection Methods page.
Payment Information
Payment Method |
Select the form of receipts reserved for a particular account. Options are:
If you select the Draft payment method, and the bank account is assigned to a business unit that uses the document sequencing feature, you must set up document sequencing for draft processing. Click Document Type to specify the document types for each draft event. |
The fields that are available vary based on the payment method that you select on this page.
Currency, Min Remit Amt (minimum remittance amount), and Draft Risk Days |
If you select Draft as the payment method, complete these fields. The system populates the Currency field with the default currency for the bank account. The system uses this currency for the credit limit amount for discounted drafts and for the minimum remittance amount. You can change the currency, if necessary. The Min Remit Amt field displays the minimum that the bank permits you to remit for discounted drafts. This value appears on the Draft Remittance worksheet. The Draft Risk Days field displays the number of days after the draft due date that the bank waits to notify you that a customer failed to pay for a draft. The system uses this information to trigger due-date processing for a discounted draft. For example, if a draft is due on January 6, and the number of risk days is 3, the Receivable Update process generates the accounting entries for due-date processing on January 9. |
Notice |
Enter a notice period for direct debits. In various countries, the notice period is sometimes mandated by law. It may be contractually established by you with your customer, or it may be a courtesy that you extend as a reminder that you will be transferring funds from your customer’s bank account in a specified number of days. |
Clearing Method |
Select a clearing method for this particular account, if you are using cash-control accounting. The timing of the cash-control entry (debiting cash and crediting the cash clearing or control account) depends on your selection. Options are: Bank Recon (Reconciliation):You recognize the cash as received (that is, cash is debited) when the payment is reconciled on the bank statement. European countries frequently use this method. Due Date: You recognize (debit) cash as received when payment is made. Most companies in the U.S. use the cash-control method. None: You have not implemented cash-control accounting or you want cash to update when you remit the direct debit to the bank. |
These fields are available only if you selected the Draft payment method.
Credit Limit |
Enter the maximum amount that you have available with the bank account for discounted drafts. When you remit a draft, you see whether the customer has exceeded the credit limit on the Available Credit page. |
Date |
Displays the date on which the bank account agreed to the credit limit. |
Review |
Displays the date on which the bank plans to review the credit limit. |
A value date is a virtual date for a banking operation, generally not the real date for the operation. The practice of value date consists of recording a banking operation:
One or several days (two to five) before the operation date for a debit.
One or several days (two to five) after the operation date for a credit.
Value Date |
Select to enable value dating for the bank account. |
Value Date Days |
Enter a value date (expressed as a positive or negative number) for the selected payment method. |
Payment Cutoff Time |
Enter the cutoff time, using AM or PM, or use the timestamp button to enter the current system time. Payments arriving by this time are processed by the bank that day. Payments arriving afterwards are processed on the next business day. |
Holiday Options |
Select the rules for the bank that the system uses to calculate the estimated settlement date for drafts and direct debits. Treasury Management uses this date for cash forecasting. It defines how to change the date when it falls on a bank holiday. You define holidays on the Business Calendar page, and then you assign a calendar to a bank account on the External Accounts - Account Information page. Options are: Not Applicable: Does not change the estimated settlement date. Pay After Holiday: Changes the estimated settlement date to a day after the holiday. Pay Before Holiday: Changes the estimated settlement date to a day before the holiday. |
Days |
Enter the number of days that you want to move the date to accommodate the holiday. |
Allow due date in next month |
If you select the Pay After Holiday option, select Allow due date in next month to allow the new estimated settlement date to be in the next month. If you do not select this option, the system adjusts the date to the last business day prior to the original date. |
This grid is available only if the payment method is Direct Debit or Draft. If draft is the specified payment method, then you can specify only one layout.
Default Flag |
Select to make this layout the default layout for the specified payment method. |
Send to Financial Gateway |
Select to send the settlement through Cash Management's Financial Gateway. Only direct debits can be settled through Financial Gateway. If left unchecked, Pay Cycle Manager is used as the settlement method. Note. Financial Gateway is a component of Cash Management 8.9. Therefore, you must have Cash Management installed on your system to make settlements using Financial Gateway. |
Layout (electronic file transfer layout) |
Select an EFT file format. |
Last File Number |
Displays a sequence number used to uniquely identify payment files generated by the Receivables Collection Methods process. The system uses the last file number as part of the file name of the newly created payment file. It also automatically increases the last number by one to create the next file with a different file name. This prevents overwriting any other files. |
Layout Options |
Click to access the EFT Layout Codes and Details page. This icon is enabled only for layouts being settled through Pay Cycle Manager. |
Define Layout Properties |
Accesses a secondary page used for entering layout properties that are required by a particular bank. This field is available only if the settlement is processed through Cash Management's Financial Gateway. |
Bank Integration Layouts |
Accesses the Bank Integration Layouts page if the settlement is processed through Financial Gateway. |
Access the Draft Document Types page.
Event |
Displays the type of draft activity in the draft life cycle, such as draft remitted or draft created. |
Action |
Select the posting action for the draft. Options are: A (actual): Specify the document type for the actual draft business event. D (dishonor): Specify the document type to use when you dishonor the draft after the business event. |
Document Type |
Displays the document type that the Receivables Update process uses to create the document sequence numbers. |
Access the External Accounts - Payment Methods page.
Payment Information
Payment Method |
Select a payment method, which determines the additional attributes that you specify on the page. Also, the links available on this page change depending on the selection. For most of the payment methods, you must specify a form ID and last reference number in the Payment Form group box. Values are: Automated Clearing House Direct Debit Draft-Customer EFT Draft-Customer Initiated: (Bill of Order) You must also specify a form ID and last reference number. Draft-Vendor Initiated: (Bill of Exchange) Electronic Funds Transfer Giro-EFT Giro-Manual Letter of Credit Manual Check System Check Wire Transfer Important! If you are establishing a payment method of ACH or EFT for U.S. federal payment formats for an employee, or a vendor , or both an employee and vendor, you must select specific ACH or EFT layouts, depending on the specified payment method.
Refer to the following section for a discussion of delivered federal ACH and EFT layouts and their use. |
Note. When defining multiple payment methods for one bank account, you cannot define multiple Electronic Funds Transfer payment methods with different EFT layouts.
Note. The ETEBAC and ITAPYMT EFT layouts must be associated with the Electronic Funds Transfer payment method, not the Giro - EFT method.
A value date is a virtual date for a banking operation, generally not the real date for the operation. The practice of value date consists of recording a banking operation:
One or several days (two to five) before the operation date for a debit.
One or several days (two to five) after the operation date for a credit.
Value Date |
Select to enable value dating for the bank account. |
Value Date Days |
Enter a value date (expressed as a positive or negative number) for the selected payment method. |
Enter the cutoff time, using AM or PM, or use the timestamp button to enter the current system time. |
Holiday Options |
Select the rules for the bank that the system uses to calculate the estimated settlement date for drafts and direct debits. Treasury uses this date for cash forecasting. It defines how to change the date when it falls on a bank holiday. You define holidays on the Business Calendar page, and then you assign a calendar to a bank account on the External Accounts - Account Information page. Options are: Not Applicable: Does not change the estimated settlement date. Pay After Holiday: Changes the estimated settlement date to a day after the holiday. If you select this option, select Allow due date in next month to allow the new estimated settlement date to be in the next month. If you do not select this option, the system adjusts the date to the last business day prior to the original date. Pay Before Holiday: Changes the estimated settlement date to a day before the holiday. |
Days |
Enter the number of days that you want the date moved to accommodate the holiday. |
Select check boxes in the Payment Options group box, if you selected Manual Check or System Check as the payment method.
Confirm Numbers |
Select to activate the Confirm Payment Reference capability in the Pay Cycle Manager. This feature enables you to use prenumbered payment forms and to ensure that the check numbers and the system payment reference numbers agree. If they do not agree, you can renumber the system references to accurately mirror the printed forms. |
Payment Schedule |
For reconciliation of Federal Schedule ID payments, select this check box to generate the correct federal payment schedules for submission to the U.S. Treasury for payment. |
Positive Payment |
Select to enable the system to create a payment file for every pay cycle using this bank account. The system formats the file to the specifications of the positive payment form that you select. This file format is defined by the APY2055 Query and the associated Crystal report. We provide a default positive pay report called POS1. The form ID and Crystal report must have the same name, such as POS1 and POS1.RPT. If you alter the POS1 Crystal report and rename it as POS2.RPT, you must use POS2 as the form ID. If you select this check box, you also must specify a value in the Positive Payment Form field in the Payment Form group box. |
File Copy |
Select to enable the Pay Cycle Manager to generate a duplicate set of checks for your files. Like Checks and Positive Payment, this method uses a Crystal report form that must match the form ID. For instance, you can specify Crystal report Copy 1 as a file copy form. If you select this check box, you also must specify a value in the File Copy Form field in the Payment Form group box. |
Document Sequencing |
This link is available if this bank belongs to a GL business unit that is set up for document sequencing. Click to access the Document Sequencing page to assign the default document types for each payment method. |
Prenote |
Click to access the Prenotification page, and indicate that the system must generate Federal Schedule ID prenotification files. |
Draft Status |
Click to access the Bank Account Draft ChartFields page and define Draft ChartFields. |
Last Ref Number (last reference number) |
Select the check reference that Payables uses when printing payments. The system increments this number for each payment that it makes on the specified bank account. The system also increments this number when you record a manual payment for this account. |
Form ID |
Enter a form ID, which defines the payment layouts for your ACH, system check, wire transfer, customer draft, and EFT files. Payables has predefined forms: CHECK1 - 3, EFT1 and EFT2, and WIRE1. You specify which payment forms to use for a bank account. If you do not set up a specific form before you define your banks, you can use one of the defaults and adapt it later. Note. Do not enter a form ID for manual checks or vendor drafts. |
Positive Payment Form |
Enter a pay form if the Positive Payment check box is selected. |
File Copy Form |
Enter a form is the File Copy check box is selected. |
This table lists the payment methods that can be used for making settlements using Pay Cycle Manager or Financial Gateway. The Electronic Layouts grid appears only for the payment methods listed in the table:
Payment Method |
Settle Through Method |
Automated Clearing House |
Both |
Direct Debit |
Financial Gateway only |
Electronic Funds Transfer |
Both |
Giro - EFT |
Pay Cycle Manager only |
Wire Transfer |
Both |
Note. Financial Gateway is a component of Cash Management 8.9. Therefore, you must have Cash Management installed on your system to make settlements using Financial Gateway.
Default Flag |
Select to make this layout the default layout for the specified payment method. |
Layout |
Select an EFT file layout. This field is uneditable if Wire Transfer is the selected payment method. |
Layout Options |
Click to access the EFT Layout Codes and Details page. This icon is enabled only for layouts settled through Pay Cycle Manager. |
Define Layout Properties |
Accesses a secondary page used for entering layout properties that are required by a particular bank. Only available if the settlement is processed through Financial Gateway. |
Bank Integration Formats |
Accesses the Bank Integration Formats page if the settlement is processed through Financial Gateway. |
See Also
Reconciling Federal Schedule ID Payments
Specifying Payment Form Attributes
Access the Document Sequence page.
Document Type |
Displays the document type that the system uses to assign document sequence numbers. |
Manual Document Type |
Displays the default document type on pages where you specify the document sequence number manually. |
See Understanding Document Sequencing.
Access the Bank Account Draft ChartFields page.
Accounting Template |
To create balanced accounting entries, select one of the templates that you defined on the Accounting Entry Template page. |
Enter the appropriate ChartField values.
Access the EFT Options page.
Originating DFI ID (originating depository financial institution ID) |
(Optional) Displays the DFI ID of the bank issuing the specified payment method. |
Access the Prenotification page.
Select Prenotification Required. This generates the correct prenotification files used in Federal Schedule ID reconciliation.
Access the Define Layout Properties page.
Note. Contact your system administrator before editing any fields on this page. The system displays layout values defined on the Layout Catalog and Layouts pages that normally do not need to be changed.
See Also
Configuring Bank Statement, Payment, and Payment Acknowledgment Layouts
Defining Bank Integration Layouts for Payments
Access the Account Settlement page.
Instructions |
Select the settlement instructions to use for this account, if you selected the TR check box in the Account Use group box on the External Accounts page. |
To define internal accounts, use the Internal Accounts component (BANK_INTERNAL_GBL).
This section lists prerequisites and discusses how to:
Define internal accounts.
Generate interest accrual schedules.
Define ChartFields for internal accounts.
Internal Accounts in PeopleSoft
Internal accounts are specific to PeopleSoft treasury management functionality. In Cash Management, they are used for internal funds transfers (transfers between internal bank accounts). In Deal Management, you use internal accounts with the On Behalf of Deals functionality.
When processing external bank transfers, the system also automatically generates internal account accounting entries for external business units indirectly related through internal business units. For a detailed explanation of this functionality, see the Processing Bank Transfers section in the PeopleSoft Cash Management 8.9 PeopleBook.
See Also
Processing Bank Account Transfers
Performing In-House Banking Activities
Understanding On-Behalf-Of Deals
For internal accounts, you must:
Define internal banks using the Bank Information page.
Designate one internal bank as the corporate treasury bank.
Select the Corporate Treasury check box (on the Bank Information page) for one of the counterparties as the account servicer. You must create a corporate treasury bank to set up internal accounts.
Define internal account information using the Internal Account pages.
You can establish internal accounts between two internal banks as long as one of the internal banks is specified as a Corporate Treasury.
See Defining Bank Information.
Page Name |
Object Name |
Navigation |
Usage |
Internal Accounts - Account Information |
BANK_ACCT_INT |
Banking, Bank Accounts, Internal Accounts, Account Information |
Maintain balances and transfer amounts among the business units within your enterprise, with one or more treasury units serving as an in-house bank. |
Generate Schedules |
SCHEDULE_CREATE |
|
Generate interest accrual schedules. |
Internal Accounts - Chartfields |
BANK_ACCT_INT2 |
Banking, Bank Accounts, Internal Accounts, Chartfields |
Enter both the account servicer’s (treasury’s) and the account owner’s (business unit’s) ChartField and account number information. |
Access the Internal Accounts - Account Information page.
There are two perspectives for each internal account: the view from the account owner’s side (the business unit’s perspective) and the view from the account servicer’s side (the treasury’s perspective). You must define both banks as internal banks, and define at least one bank as a corporate treasury.
Account Information
Account # (account number) |
Displays the bank account number assigned by the system. |
Default Account |
Select to set this account as your default internal account. |
Accrue Interest |
Select to accrue interest on this account. You can run interest accruals on the Interest Accruals page. You can view your interest accruals on the Internal Account Activity page. |
Interest Accrual Information
Schedule ID |
If you specified that this account accrues interest, select a schedule ID to indicate how often interest accrues. |
Credit Rate Index and Debit Rate Index |
Enter both debit and credit rate index information, which is required to run interest accrual calculation and interest schedule generation processes. |
Access the Generate Schedule page.
Create Schedule |
Click to create the interest accrual schedule for the internal account, using the start date and end date that you enter. |
Access the Internal Accounts - Chartfields page.
Account Display Options
Display Servicer’s Version |
Select to view or modify ChartFields for the servicer. |
Display Owner’s Version |
Select to view or modify ChartFields for the owner. |
Cash Account ChartFields
Select a cash account ChartField for both the servicer's version and the owner's version.
Important! To properly book internal account transfer activity between the servicer and owner, you must specify General Ledger cash account ChartFields for all internal accounts. Doing this ensures that the system creates the necessary accounting entries and events, and updates the appropriate system tables and internal ledger accounts. In addition, if you selected the Accrue Interest check box on the Internal Accounts - Account Information page, you must enter ChartFields to create transactional accounting entries for the servicer and owner.
To define netting bank accounts, use the Netting Accounts component (BANK_PNLNET_GBL).
Use the TR_NETTING_ACCOUNTS_CI component interface to load data into the Netting Accounts tables.
This section discusses how to:
Define netting accounts.
Define valid currencies for netting accounts.
Page Name |
Object Name |
Navigation |
Usage |
Netting Accounts |
BNK_PNL2 |
Banking, Bank Accounts, Netting Accounts |
Set up netting accounts for a bank. |
Netting Accounts - Valid Currencies |
BANK_ACCT_CURR_SEC |
Click the Currencies icon |
Define all the valid currencies for a netting bank account, both default currency and secondary currencies. For nets involving multicurrency processing, you must define these values for the automatic multicurrency netting adjustment process. |
Netting Accounts - Payment Methods |
PYMNT_BANK |
Banking, Bank Accounts, Netting Accounts, Payment Methods |
Set up payment methods for a netting account. |
Access the Netting Accounts page.
If you selected Netting as the bank type, you use the Netting Accounts component to set up the bank account. This component is similar to the External Accounts component, except that it includes only three pages: Netting Accounts, Valid Currencies, and Payment Methods.
See Also
Defining External Accounts Information
Access the Netting Accounts - Valid Currencies page.
Define the default currency for the netting bank account.
If you use this netting bank account in multicurrency nets, also define all necessary “convert into” currencies. This ensures that the automatic multicurrency netting adjustment process correctly calculates the associated accounting entries. In the example, note the bank account is a Japanese bank defined with Japanese yen (JPY) as the default valid currency and U.S. dollars (USD) as a second valid currency.
See Also