PeopleSoft Global Payroll for Mexico 9.1 PeopleBook

Processing Banking

This chapter provides an overview of the banking process and discusses how to:

Define the banking process.
Generate the EFT payment file and banking report.

Understanding the Banking Process

In Global Payroll, banking setup starts in the core application and continues with processing in Global Payroll for Mexico. Before reading this chapter, it is strongly recommended that you read the banking feature in the Global Payroll core documentation.

Before running the banking process for Mexico, you must set up basic banking information in the core application, such as:

Defining bank information, such as bank name, address, and ID.
Defining EFT formats.
Identifying source banks and linking source banks to pay entities.
Defining deposit schedules.
Defining recipients.

See Defining Banking Instructions.

After running a payroll, funds are sent to the bank, along with instructions for payment. The bank needs to know who is going to be paid, how much they are to be paid, and which bank the wages are paid to. This information is extracted from the core application and stored in the Mexican payroll files, based on a list of payees corresponding to those in the last payroll run. A file is created with a line for each payee, containing a name, bank account number and amount of money. This file must be sent to the bank that then distributes the funds.

Note. Global Payroll for Mexico supports six major Mexican banks: Banamex, Bancomer, Bancrecer, Banorte, Bital, and Scotiabank.

To process banking in Global Payroll for Mexico:

Launch the banking process on the Run Payment Prep Process MEX page.

The banking process includes launching PS_JOB which groups two different Application Engines: the core Global Payroll application and the Global Payroll for Mexico application. The GP_PAYMENT and GPMX_PAYMENT output tables are populated.
Launch the process to build the EFT file and generate the banking report on the Create EFT Payment File MEX page.

An SQR, called GPMXBA01, is run. An EFT file is generated, containing the details of each payment from the payroll run. The EFT file must be sent to the bank so that the funds can be transferred to payees' bank accounts. This SQR also generates a report with payment details for validation purposes. You can review and store the payment details.

Note. Each bank in Mexico has a different flat file format. Global Payroll for Mexico has the flexibility to generate these different formats for six of the major banks in Mexico; .Banamex, Bancomer, Bancrecer, Banorte, Bital, and Scotiabank.

Defining the Banking Process

This section provides an overview of how to define the payment preparation.

Page Used to Define Banking in Mexico

Page Name	Definition Name	Navigation	Usage
Run Payment Prep Process MEX	GPMX_BANK_POPULATE	Global Payroll & Absence Mgmt, Payment Processing, Run Payment Prep Process MEX, Run Payment Prep Process MEX	Launch the processes that populate the GP_PAYMENT and GPMX_PAYMENT records.

Defining the Payment Preparation

Access the Run Payment Prep Process MEX page (Global Payroll & Absence Mgmt, Payment Processing, Run Payment Prep Process MEX, Run Payment Prep Process MEX).

Note. The fields on the Payment Preparation MEX page are the same as the Run Payment Prep Process page in the core application, except that there is an additional button (Clear Data) on the Payment Preparation MEX page. For more information about the Run Payment Prep Process page in the core application, refer to PeopleSoft Global Payroll 9.1 PeopleBook.

See Defining Banking Instructions.

Clear Data

Select when you want to recalculate the Mexican banking process. If you select Clear Data, you can clear the GPMX_PAYMENT output table and fill it again if there are any changes to the calculation.

Generating the EFT Payment File and Banking Report

This section discusses how to run the banking report.

Page Used to Generate the EFT Payment File and Banking Report

Page Name	Definition Name	Navigation	Usage
Create EFT Payment File MEX	GPMX_BANK_EFT	Global Payroll & Absence Mgmt, Payment Processing, Create EFT Payment File MEX, Create EFT Payment File MEX	Create an electronic flat file to be transferred (EFT) to the bank and generate a printed report.

Generating Payment Files and Bank Reports

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

Calendar Group ID

Select the Calendar Group ID for which you want to generate a payment file.

Pay Entity

Select the pay entity for which you want to generate a payment file.

Bank Format

Select the bank. Values are Banamex, Bancomer, Bancrecer, Banorte, Bital, and Scotiabank. Depending on which bank you select, additional fields may appear on this page. Each bank may require different information about the bank file transfer. The following table lists the additional fields that appear depending on the bank format you select.

Version and Format

For the Banamex bank format, you can build two versions of an EFT file: DOS or Windows. If you select the Windows version, you will also select the format: Pagomatico or Third Party.

Bank Format	Additional Fields that Appear
Banamex	File Name, Bank Cust ID, Reference Number A, Reference Number C, Reference Number E, Version, Format, Message
Bancomer	File Name, Secondary Reference
Bancrecer	File Name, Reference Number, Reference Number A
Banorte	File Name, Message
Bital	File Name
Scotiabank	File Name, Bank Cust ID, Reference Number C, Reference Number D, Message

Note. Once the GP_PAYMENT table and the GPMX_PAYMENT table are populated, you can launch an SQR that generates the flat file for banking along with a printed report of payment details.

Calendar Group ID	Select the Calendar Group ID for which you want to generate a payment file.
Pay Entity	Select the pay entity for which you want to generate a payment file.
Bank Format	Select the bank. Values are Banamex, Bancomer, Bancrecer, Banorte, Bital, and Scotiabank. Depending on which bank you select, additional fields may appear on this page. Each bank may require different information about the bank file transfer. The following table lists the additional fields that appear depending on the bank format you select.
Version and Format	For the Banamex bank format, you can build two versions of an EFT file: DOS or Windows. If you select the Windows version, you will also select the format: Pagomatico or Third Party.