Defining External Account Information

Always Inherit

A

Do Not Inherit

N

Inherit Within Unit

I

Use Unit Default

D

Option not applicable

N/A

Account Types

Cash - AR

Dep - 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

AP

Cash Clearing

TRF Charge

Drafts Payable

Account Type

Cash - AP

Cntrl - AP

Bank Charge

Draft - AP

Valid Inheritance Options

N

N

N

N

D

D

D

D

I

I

I

I

A

A

A

A

TR

Cash Clearing

Stmt Accounting

TR

Account Type

Cash

Control

Fees

Interest

Cash

Valid Inheritance Options

N

N

N

N

D

D

D

D

I

I

I

I

A

A

A

A

EX

Cash Clearing *

TRF Charge *

Drafts Payable *

Account Type

Cash - AP

Cntrl - AP

Bank Charge

Draft - AP

Valid Inheritance Options

N

N

N

N

D

D

D

D

I

I

I

I

A

A

A

A

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 on the Bank Branch Information page (BANK_BRNCHPNL).

GL Unit

Select the general ledger business unit associated with this account.

Account #

Enter bank account number.

If you set up bank account encryption, account numbers are masked when you save the page.

For more information about bank account number encryption and the National Automated Clearing House Association (NACHA) data security requirements, see Understanding Bank Account Encryption and Setting Up Bank Account Encryption.

Unmask

Select to unmask the bank account number and IBAN.

RFC

Enter the three-character value that identifies the RFC (regional finance center) to be assigned to the summary payment file.

(USF) Sender DO (sender disbursing office)

Enter the U.S. Federal government Intra-Governmental Payment and Collection (IPAC) System's 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.

See Processing Inbound IPAC Transactions.

DFI Qualifier and DFI ID

Select the DFI qualifier (depository financial institution 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.

IBAN (international bank account number)

Define the account's IBAN (International Bank Account Number) for transmittal with other account information for the bank account. This field and the View IBAN button appear only if the IBAN Enterable field is not selected on the IBAN Formats page.

If you set up bank account encryption, IBAN is masked when you save the page.

IBAN Digit

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.

Other Identification

Click this link to access the Bank Account Other Identification page (BANKACCT_PNL_OTHID), where you can provide other ID information for the bank account used in ISO and SEPA formats. Other ID information consists of issuer, identification, and either an ISO Code List or a Proprietary Scheme Name under which the identification was issued. You must designate one issuer as the default that will be populated on the ISO and SEPA format.

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.

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.

If Cash Clearing check box is selected and Enable Federal Payment check box is not selected on the Installation Options - Payables page, payment posting will not create Cash Distribution Clearing entries for vouchers created with a payment method of ACH or EFT. Instead, it will create Cash Distribution entries. See also Setting Up Application-Specific Installation Options

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 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 (bank transfer 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.

Required ChartFields

Cash − AR

Deposit-AR

DIT-AR

Cash − AP

DIT-AR

Cash − AR

Deposit-AR

Cash

Cash − AP

Drafts Payable ChartFields

NA

Draft − AP

NA

NA

NA

Cash Clearing ChartFields

NA

Control - AP

NA

Control

NA

DD/AR Draft Cash Control

NA

NA

Draft − AR

Control − AR

Discount - AR

NA

NA

Stmt Accounting ChartFields

NA

NA

NA

Interest

Fees

NA

TRF Charge

NA

Bank Charge

NA

NA

NA

Dep in Transit

NA

NA

If selected

NA

NA

Click to edit ChartField inheritance options for a specified account type.

Previous in List and Next in List

Select buttons to access the previous or next external account listed on the External Accounts search page.

Click the Add button to add a new external account to the system.

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.

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.

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.

HD

High Dollar Payment

99

IN

Internal Distribution

10

PO

Route to Purchasing

50

RE

Regular Payments

1

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:

1. The system derives funds from Bank Account 01, to a maximum of 1,250,000 USD.

2. The system then derives funds up to a maximum of 500,000 USD from Bank Account 02.

3. The system then derives funds up to a maximum of 300,000 USD from Bank Account 03.

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.

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.

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 supplier. The default value is 360.

Payment Method

Select the form of receipts reserved for a particular account. Options are:

• Cash

• Check

• Credit Card

• Direct Debit

• Draft

• Electronic Fund Transfer

• Giro - EFT

• Giro - Manual

If you select Direct Debit as the payment method, a Prenote Required check box appears. If you select this check box, the Create Direct Debit process in PeopleSoft Receivables creates a prenote that is sent to a customer's bank to confirm that the customer's account information is correct. The bank either confirms that the information is correct, or the prenote is automatically confirmed by the system after a specified number of days has elapsed.

If you select the Direct Debit payment method, the Electronic Layouts grid appears, where you can select an EFT (electronic file transmission) Layout to use for the direct debit transactions. If you select the Prenote Required check box and select an EFT Layout code, the system verifies that the EFT Layout is valid for use with direct debits with prenotes.

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 the Document Type link to specify the document types for each draft event.

Direct Debit Lead Time Days

Enter the days needed to process a direct debit payment. This field is used by PeopleSoft eBill Payments and PeopleSoft Receivables to determine the payment date. Payment Date is the day of the funds transfer. Payment Date is usually defaulted to item due date, however, if the due date subtracted from the direct debit lead time days is less than the current date, then the item should have already been selected for processing. In this case, the payment date is the current date plus the direct debit lead time days.

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 Receivables 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 (bank 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.

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.

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.

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.

EFT Layout Code (electronic file transfer layout)

Select an EFT file format.

See Understanding the Set Up and Processing of Direct Debits with Prenotes.

Last File Number

Displays a sequence number used to uniquely identify payment files generated by the Receivables Collection Methods process, when using EDI file layouts only. 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

Access 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

Access the Bank Integration Layouts page if the settlement is processed through Financial Gateway.

CTX (Corporate Trade Exchange) flat file payment order

CTX

CTX ASC X12 820 payment order

CTX820FED

SPS vendor check payment

SPSCHK

SPS vendor ACH payment (CCD+)

SPSVNDR

SPS vendor ACH payment (CCD+) - Same Day

SPSVNDRSDA

Bulk vendor ACH payment (CCD+) — Same Day

PAMVNDRSDA

SPS travel ACH payment (PPD+)

SPSTRVL

SPS travel ACH payment (PPD+) - Same Day

SPSTRVLSDA

Bulk travel ACH payment (PPD+) — Same Day

PAMTRVLSDA

SPS Miscellaneous payment

SPSMISC

SPS Miscellaneous payment - Same Day

SPSMISCSDA

Bulk Miscellaneous ACH payment — Same Day

PAMMISCSDA

SPS IAT Travel

SPSIATTRVL

SPS IAT Vendor

SPSIATVNDR

SPS IAT Miscallaneous

SPSIATMISC

SPS Same day payment request

SPSSDPR

IPAC (Intra-Governmental Payment and Collections)

IPAC

Bulk vendor check payment

PAMCHK

Bulk Misc IAT ACH Payment

PAMIATMISC

Bulk Travel IAT ACH Payment

PAMIATTRVL

Bulk Vendor IAT ACH Payment

PAMIATVNDR

Bulk Misc ACH Payment

PAMMISC

Bulk Travel ACH Payment

PAMTRVL

Bulk Vendor ACH Payment

PAMVNDR

Federal PAMCTX

PAMCTX

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.

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.

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 in the APY2055 Application Engine. The system provides a default positive pay report called POS1. The Application Engine generates a positive payment form depending on whether a form is associated with the bank. Modifications to the form can be introduced to modifications of the Application Engine. The positive payment file provided is a text (.txt) document with no spacing between lines.

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, this method uses a report form that must match the form ID. For instance, you can specify 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 Sequence 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.

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.

Automated Clearing House

Both

Direct Debit

Financial Gateway only

Electronic Funds Transfer

Both

Giro - EFT

Pay Cycle Manager only

Wire Transfer

Both

Default Flag

Select to make this layout the default layout for the specified payment method.

Layout

Select an EFT file layout. This field is unavailable 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.