This chapter provides overviews of banking and discusses how to:
Set up banking.
Process banking.
Run banking reports.
Process SEPA payments for Spain.
This section discusses:
Banking setup.
IBAN setup.
Bank processing.
In PeopleSoft Global Payroll, the majority of banking setup starts in the core application and continues with processing in PeopleSoft 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 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 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
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 HCM 9.1 Application Fundamentals PeopleBook discusses the IBAN setup in detail.
See Setting Up IBAN Information.
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.
This section provides an overview of banking setup for PeopleSoft Global Payroll for Spain and discusses how to define banking files.
The majority of the banking setup for PeopleSoft Global Payroll for Spain take place in the PeopleSoft 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 Name |
Definition Name |
Navigation |
Usage |
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. |
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. |
This section provides an overview of the banking process and discusses how to create an EFT payment file for a bank.
To perform the banking process for PeopleSoft 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
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.
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
This section lists the pages used to run banking reports provided by PeopleSoft Global Payroll for Spain.
Page Name |
Definition Name |
Navigation |
Usage |
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. |
|
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. |
|
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. |
|
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. |
|
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. |
See Also
PeopleSoft Global Payroll for Spain Reports
PeopleSoft Global Payroll for Spain enables you to process payments using the Single Euro Payment Area (SEPA) formats and standards through an integration with PeopleSoft Financial Gateway. If you process payments using SEPA, you must set up and process banking using a different set of steps.
This section discusses how to:
Set up SEPA processing.
Process SEPA payments.
Send SEPA payments to PeopleSoft Financial Gateway.
Before you can process SEPA payments using Global Payroll for Spain, in addition to the normal banking setup you must:
Ensure that an active SEPA application package is defined for Spain on the Banking Country Setup page.
Ensure that a SEPA SQL statement is defined for Spain on the Banking Preparation Definition page.
Define payment process settings on the Installation Settings page.
Set up Integration Broker for both Global Payroll for Spain and Financial Gateway.
Set up banks for Spain in your PeopleSoft Financials system.
See Also
(CHE, DEU, ESP, FRA, NLD) Setting Up SEPA Processing
You process payments for SEPA using the same Global Payroll Banking Process (GP_PMT_PREP) that you use for non-SEPA banking. When a row of data exists for Spain on the Banking Country Setup component, however, GP_PMT_PREP executes SEPA logic.
Global Payroll for Spain uses the delivered CORE_BANK:SQL application package to process SEPA payments. The system references the banking preparation definition for Spain and for each defined sequence processes the SEPA SQL statement using the country, calendar run ID, and employee ID range selected on the Run Payment Prep Process run control page. The system loads the results into the GP_PAYMENT_FG record.
Note. This new SEPA logic supersedes the country-specific processes that you would normally run in PeopleSoft Global Payroll for Spain for non-SEPA banking. Therefore, when processing SEPA payments for Spain, you do not have to run the EFT generation process (GPESBNK5).
Delivered Sequences
PeopleSoft Global Payroll for Spain delivers two Banking Preparation Definition sequences. They are:
Employee SEPA
Recipient SEPA
See Also
(CHE, DEU, ESP, FRA, NLD) SEPA Processing
You send generated SEPA payment details from PeopleSoft Global Payroll for Spain to PeopleSoft Financial Gateway. Financial Gateway then dispatches the payments to banks in compliance with SEPA rules and standards. You send SEPA payments to PeopleSoft Financial Gateway using the Payment File Generation page. This page enables you to:
Identify the rows of GP_PAYMENT_FG that are to be prepared to be sent to Financial Gateway.
Insert the prepared payment rows into staging tables and publish them to Financial Gateway through Integration Broker using the PAYMENT_REQUEST message.
Generate Oracle Business Intelligent Publisher (BI Publisher or BIP) reports.
See Also
(CHE, DEU, ESP, FRA, NLD) Sending SEPA Payments to PeopleSoft Financial Gateway