PeopleSoft Enterprise Global Payroll for Spain 9.1 PeopleBook

Setting Up and Processing Banking

This chapter provides overviews of banking and discusses how to:

Set up banking.
Process banking.
Run banking reports.

Understanding Banking

This section discusses:

Banking setup.
IBAN setup.
Bank processing.

Banking Setup

In PeopleSoft Enterprise Global Payroll, the majority of banking setup starts in the core application and continues with processing in PeopleSoft Enterprise Global Payroll for Spain. Oracle strongly recommends that before reading this chapter, you read the banking feature in the Global Payroll core documentation.

Before running the banking process for Spain, you must set up basic banking information in the core application and within the PeopleSoft Enterprise Global Payroll for Spain country extension. You must:

Define bank information, such as bank name, address, and ID.
Define Electronic Funds Transfer (EFT) formats.
Identify source banks and link source banks to pay entities.
Define employee bank accounts and net pay election.
Define deposit schedules.
Define recipients.
Define the banking file.

Note. You perform this setup step within the PeopleSoft Enterprise Global Payroll for Spain country extension.

See Setting Up Banking.

After you run payroll, funds are sent to the source bank along with instructions for payments. The bank needs the following information:

The name of each employee who is going to be paid.
The amount that each payee is to receive.
The name of the banking institution where the wages are to be sent.

This information is extracted from the core application based on a list of payees corresponding to those in the selected payroll run. The system creates a file with lines for each payee, containing a name, the bank account number, and the payment amount. This file is sent to the bank, which then distributes the funds.

See Also

Setting Up Banks and Bank Branches

Defining Banking Instructions

IBAN Setup

The International Bank Account Number (IBAN) is an account number that uniquely identifies a bank account and is assigned according to International Organization for Standardization (ISO) standards so that it can be used across national borders. PeopleSoft applications can include this information at the bank account level.

As of January 1, 2004, IBAN must be used for all transfers out of Spain and for special transfers.

Part of banking setup includes IBAN definition. To set up IBAN functionality, you must select the IBAN Enabled field on the IBAN Country Setup page. When the IBAN feature is enabled, the system displays the IBAN field on the Source Bank Account page and the Edit IBAN link on the Maintain Bank Accounts page for the country that you indicated.

Note. The PeopleSoft Enterprise HRMS 9.1 Application Fundamentals PeopleBook discusses the IBAN setup in detail.

See Setting Up IBAN Information.

Bank Processing

After you have set up banking information, you can run the banking process.

Note. This chapter describes in detail the banking process.

See Processing Banking.

Setting Up Banking

This section provides an overview of banking setup for PeopleSoft Enterprise Global Payroll for Spain and discusses how to define banking files.

Understanding Banking Setup for PeopleSoft Enterprise Global Payroll for Spain

The majority of the banking setup for PeopleSoft Enterprise Global Payroll for Spain take place in the PeopleSoft Enterprise Global Payroll core application. In the Global Payroll for Spain country extension, however, you define the banking file, which enables you to set the parameters that drive the generation of the EFT payment file. PeopleSoft Global Payroll for Spain delivers a sample banking file: File ID CSB34. This file is set up to generate the same file structure as the one currently prepared following the Norm 34–1. You can create additional banking file IDs to maintain different parameters.

Page Used to Set Up Banking

Page Name	Definition Name	Navigation	Usage
Define Bank File ESP	GPES_BANK_FILE_PNL	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Banking, Define Bank File ESP, Define Bank File ESP	Define bank files.

Defining Banking Files

Access the Define Bank File ESP page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Banking, Define Bank File ESP, Define Bank File ESP).

Group Payments

Select to group all payments for an employee that are associated with the same calendar group. For example, when this check box is selected and segmentation occurs, the system combines payments for the different segments for a payee in a unique line in the file.

Note. Regardless of whether you select this check box, the banking process splits lines related to different accounts.

Maximum Amount

Enter the amount at which the system excludes a transfer from the banking file. Any transfers exceeding this amount also generate a message in the banking process log.

Maximum Amount National

Enter the amount at which transfers to national bank accounts are excluded or split.

If you select Exclude in the corresponding Action field, the system excludes from the banking file any national bank transfers that exceed the value in the Maximum Amount National field.

If you select Split in the corresponding Action field, the system splits the amount of national bank transfers that exceed the value in the Maximum Amount National field into separate lines in the banking file that follow the line for the maximum national amount.

Maximum Amount Foreign

Enter the amount at which transfers to foreign bank accounts are excluded or split.

If you select Exclude in the corresponding Action field, the system excludes from the banking file any foreign bank transfers that exceed the value in the Maximum Amount Foreign field.

If you select Split in the corresponding Action field, the system splits the amount of foreign bank transfers that exceed the value in the Maximum Amount Foreign field into separate lines in the banking file that follow the line for the maximum foreign amount.

Minimum Amount Special

Enter the amount above which transfers are included in the special block of the banking file or excluded from the banking file.

If you select Include in the corresponding Action field, the system includes transfers that exceed the amount in the Minimum Amount Special field in the special block of the banking file.

If you select Exclude in the corresponding Action field, the system excludes from the banking file any transfers that exceed the value in the Minimum Amount Special field.

Note. If you select Exclude, in the Minimum Amount Special field, you will probably need to create a second banking file definition to manage large transfers separately from the rest.

Suffix

Enter the values of positions 14, 15, and 16 in the banking file codes.

Header Operation Code

Enter the values of positions 3 and 4 of the header code.

Special Operation Code

Enter the values of positions 3 and 4 of the special code.

National Operation Code

Enter the values of positions 3 and 4 of the national code.

Foreign Operation Code

Enter the values of positions 3 and 4 of the foreign code.

Processing Banking

This section provides an overview of the banking process and discusses how to create an EFT payment file for a bank.

Understanding the Banking Process

To perform the banking process for PeopleSoft Enterprise Global Payroll for Spain, you must:

Finalize the payroll run on the Calculate Absence and Payroll page.

This provides the data for the banking process.
Run the core Global Payroll Banking Process (GP_PMT_PREP) on the Run Payment Prep Process page to prepare banking payments.

The system populates the GP PAYMENT output table and sets the GP status to P (prepared).

The GP PAYMENT table contains one entry for every net pay distribution from every payment included in a given calendar run. The GP PAYMENT table provides the basis on which a company pays its payees.
Finalize the core Global Payroll Banking Process (GP_PMT_PREP ) on the Calculate Absence and Payroll page.

The process sets the payment status for the selected payees to F (finalized) in GP PAYMENT.
Run the EFT generation process for Spain on the Create EFT Payment File ESP page to create a flat file to send to the bank.

The EFT generation process (GPESBNK5) selects the payees with a payment status of F (finalized) from GP PAYMENT and generates the flat file containing the transfers to be made. At the end of this process, the system sets the GP status to T (transferred).

Note. If you select the Rerun Indicator check box on the Create EFT Payment File ESP page, the EFT generation process includes payments with a status of T.

Transfer Types

During the EFT generation process, the system categorizes each transfer to determine the block of the banking file in which it should be placed. The value of the Country Code field on the Maintain Bank Accounts page determines whether transfers for payees are national or international. The Taxes Calculation field on the Transnational Mobility page determines whether transfers for payees are for residents or nonresidents.

See Also

Entering Bank Account Information

Setting Up Transnational Mobility

Pages Used to Process Banking

Note. All the pages in this section, except the Create EFT Payment File ESP page, are core banking pages and are discussed in the core Global Payroll documentation. This section discusses the Create EFT Payment File ESP page in detail.

Page Name	Definition Name	Navigation	Usage
Run Payment Prep Process (run payment preparation process)	GP_PMT_PREPARE	Global Payroll & Absence Mgmt, Payment Processing, Run Payment Prep Process, Run Payment Prep Process	Run the core Global Payroll Banking Process (GP_PMT_PREP) to prepare banking payments. This process populates the GP PAYMENT table with the data that you need to calculate and finalize the banking process. See Running the Banking Process.
View Net Pay	GP_PMT_NP_VIEW	Global Payroll & Absence Mgmt, Payment Processing, Review Payments by Cal Group, View Net Pay	For employee net pay, view the payment status, the amounts that are going to be paid, and which payments are to be excluded.
View Deductions	GP_PMT_DED_VIEW	Global Payroll & Absence Mgmt, Payment Processing, Review Payments by Cal Group, View Deductions	For deductions, view the payment status, the amounts that are going to be paid, and which payments are to be excluded.
Create EFT Payment File ESP (create electronic file transfer payment file)	GPES_RC_BNK5	Global Payroll & Absence Mgmt, Payment Processing, Create EFT Payment File ESP, Create EFT Payment File ESP	Create a flat output file to send to the bank. This EFT payment file contains the payment details for each employee. It is sent to the bank so that funds can be transferred to employees' accounts. The file includes the employee name, beneficiary name, date, and amount of payment. You can also select whether to override an employee's payment. At the end of this process, the system updates the GP_PAYMENT table by setting field PMT_STATUS from F (finalized) to T (transferred). Note. Before using this page, first run the Global Payroll Banking Process (GP_PMT_PREP) in the core application.

Creating an EFT Payment File for a Bank

Access the Create EFT Payment File ESP page (Global Payroll & Absence Mgmt, Payment Processing, Create EFT Payment File ESP, Create EFT Payment File ESP).

Pay Entity

Enter the pay entity.

Calendar Group ID

Select the calendar group for the payroll run.

Source Bank ID

Displays the ID of the source bank from which the payments are withdrawn.

Account # (account number)

Displays the bank account number for the source bank.

Payment Date

Enter the date of the bank file generation.

Debit Date

Enter the date on which the bank debits the transfers.

File ID

Select the ID of the banking file you want to use for the EFT file. You define banking files on the Define Bank File ESP page.

Path Name

Enter the directory to which you want the EFT file saved.

File Name

Enter a name for the EFT file. The system adds the company code and source bank ID to the name you specify and saves the file in text (.txt) format.

Rerun Indicator

Select to re-create the EFT file for payments that were already transferred.

See Also

Defining Banking Files

Running Banking Reports

This section lists the pages used to run banking reports provided by PeopleSoft Enterprise Global Payroll for Spain.

Pages Used to Run the Banking Reports

Page Name	Definition Name	Navigation	Usage
Missing Bank Account Rpt ESP	GPES_RC_BNK1	Global Payroll & Absence Mgmt, Payment Processing, Missing Bank Account Rpt ESP, Missing Bank Account Rpt ESP	Run the Missing Bank Account report (GPESBNK1), which lists those employees who have no bank account in the system. You can run the report for a selected pay entity or pay group.
Payee Bank Account Report ESP	GPES_RC_BNK2	Global Payroll & Absence Mgmt, Payment Processing, Payee Bank Account Report ESP, Payee Bank Account Report ESP	Run the Payee Bank Account report (GPESBNK2) that lists employees and their bank accounts for a selected pay entity or pay group.
Net Payment Report ESP	GPES_RC_BNK3	Global Payroll & Absence Mgmt, Payment Processing, Net Payment Report ESP, Net Payment Report ESP	Run the Net Payment report (GPESBNK3) that lists all of the transfers with a payment date between the dates selected.
Pending Net Payment Report ESP	GPES_RC_BNK4	Global Payroll & Absence Mgmt, Payment Processing, Pending Net Payment Report ESP, Pending Net Payment Report ESP	Run the Pending Net Payment report (GPESBNK4) that lists all of the pending transfers from a selected date or transfers that were pending between two selected dates.
Bank File Creation Log ESP	GPES_RC_BNK6	Global Payroll & Absence Mgmt, Payment Processing, Bank File Creation Log ESP, Bank File Creation Log ESP	Run the Bank File Creation Log report (GPESBNK6) that lists all of the exclusions and splits that occurred during bank file creation. The report also lists the reason for each exclusion.

Group Payments	Select to group all payments for an employee that are associated with the same calendar group. For example, when this check box is selected and segmentation occurs, the system combines payments for the different segments for a payee in a unique line in the file. Note. Regardless of whether you select this check box, the banking process splits lines related to different accounts.
Maximum Amount	Enter the amount at which the system excludes a transfer from the banking file. Any transfers exceeding this amount also generate a message in the banking process log.
Maximum Amount National	Enter the amount at which transfers to national bank accounts are excluded or split. If you select Exclude in the corresponding Action field, the system excludes from the banking file any national bank transfers that exceed the value in the Maximum Amount National field. If you select Split in the corresponding Action field, the system splits the amount of national bank transfers that exceed the value in the Maximum Amount National field into separate lines in the banking file that follow the line for the maximum national amount.
Maximum Amount Foreign	Enter the amount at which transfers to foreign bank accounts are excluded or split. If you select Exclude in the corresponding Action field, the system excludes from the banking file any foreign bank transfers that exceed the value in the Maximum Amount Foreign field. If you select Split in the corresponding Action field, the system splits the amount of foreign bank transfers that exceed the value in the Maximum Amount Foreign field into separate lines in the banking file that follow the line for the maximum foreign amount.
Minimum Amount Special	Enter the amount above which transfers are included in the special block of the banking file or excluded from the banking file. If you select Include in the corresponding Action field, the system includes transfers that exceed the amount in the Minimum Amount Special field in the special block of the banking file. If you select Exclude in the corresponding Action field, the system excludes from the banking file any transfers that exceed the value in the Minimum Amount Special field. Note. If you select Exclude, in the Minimum Amount Special field, you will probably need to create a second banking file definition to manage large transfers separately from the rest.
Suffix	Enter the values of positions 14, 15, and 16 in the banking file codes.
Header Operation Code	Enter the values of positions 3 and 4 of the header code.
Special Operation Code	Enter the values of positions 3 and 4 of the special code.
National Operation Code	Enter the values of positions 3 and 4 of the national code.
Foreign Operation Code	Enter the values of positions 3 and 4 of the foreign code.

Pay Entity	Enter the pay entity.
Calendar Group ID	Select the calendar group for the payroll run.
Source Bank ID	Displays the ID of the source bank from which the payments are withdrawn.
Account # (account number)	Displays the bank account number for the source bank.
Payment Date	Enter the date of the bank file generation.
Debit Date	Enter the date on which the bank debits the transfers.
File ID	Select the ID of the banking file you want to use for the EFT file. You define banking files on the Define Bank File ESP page.
Path Name	Enter the directory to which you want the EFT file saved.
File Name	Enter a name for the EFT file. The system adds the company code and source bank ID to the name you specify and saves the file in text (.txt) format.
Rerun Indicator	Select to re-create the EFT file for payments that were already transferred.