Understanding the Banking Process for IndiaThis chapter provides overviews of the banking process for India and banking setup and discusses how to generate electronic funds transfer (EFT) files and reports.
Understanding the Banking Process for IndiaThe following list briefly summarizes the direct deposit banking procedure that you use for net payments to payees in India:
Set up bank accounts and schedule disbursements.
Run payroll.
Run the Global Payroll Banking Process Application Engine process (GP_PMT_PREP).
Run the Banking for India Structured Query Report (SQR) process (GPINBK01), which automatically generates the EFT file and SQR.
Subsequent sections provide more details about these steps.
Understanding Banking Setup
To set up banking, you must use core PeopleSoft Global Payroll pages. The setup involves:
Setting up basic bank information using the Bank Table page.
Setting up bank branch information using the Branch Table page.
Setting up source bank account information using the Source Bank Accounts page.
Linking the source bank ID to a pay entity using the Source Bank Link page.
Entering bank account information for payees using the Bank Account Information page.
Generating EFT Files and Reports
This section provides an overview of EFT file and report generation and discusses how to prepare the EFT flat file.
Understanding EFT File and Report Generation
The EFT process prepares the EFT flat file that you transmit to the appropriate bank and launches the SQR program that prints the banking report.
Note. The EFT flat file and SQR banking report are delivered with a configuration to satisfy the banking needs for customers using the Industrial Credit and Investment Corporation of India (ICICI) financial institution. If the company uses a financial institution other than ICICI, you must modify the delivered process to meet the company's needs. You can use the delivered ICICI configuration as a guide when developing the EFT and reporting process.
Process Flow
This diagram illustrates the payroll EFT and report generation process flow for India:
Payroll EFT and report process flow for India
The following steps correspond to the numbers in the preceding diagram:
Process and finalize payroll in the Global Payroll core application.
Run the Global Payroll Banking Process.
This process populates the GP_PAYMENT output record.
Note. Select the Finalize check box on the Payment Preparation page when you run the Global Payroll Banking Process. If you do not, no data will be available for the next step.
Run the Banking for India process.
This process selects all rows in GP_PAYMENT that have a status of finalized for the specified calendar group ID, run type name, and source bank ID.
The process populates the following records, which form the header, transaction, and trailer of both the EFT file and the printed report:
GPIN_BANK_RNCTL: This record stores the run control information such as calendar run ID, operator ID, and run control ID.
GP_PAYMENT: This record stores information about the payment details for each payee.
PYE_BANKACCT: This record contains payee bank account information for use with direct deposit, and so on.
PERSON_NAME: This record stores details about the name of each payee.
SRC_BANK: This record contains information about the source bank.
BANK_EC_TBL: Main bank table containing bank name and address.
BANK_BRANCH_TBL: Bank branch ID and address information.
GP_NET_DIST: Net distribution top (EMPLID, EMPL_RCD) level.
GP_NET_DIST_DTL: Net distribution effective date and account level.
You can run this process as many times as you want. The Banking for India process consolidates the data from the records into one EFT file that you send to the source bank. The naming convention is SRC_BANK_ID.DAT. The SQR program prints the banking report in the standard character set using data from the same records as the EFT file. The number of records is equal to the number of source banks.
See Also
Page Used to Generate EFT Files and Reports|
Page Name |
Definition Name |
Navigation |
Usage |
|
GPIN_PAYMENT |
Global Payroll & Absence Mgmt, Payment Processing, Run Payment Prep Process IND, Run Payment Prep Process IND |
Prepare the EFT flat file. |
Preparing the EFT Flat File
Access the Run Payment Prep Process IND page (Global Payroll & Absence Mgmt, Payment Processing, Run Payment Prep Process IND, Run Payment Prep Process IND).
|
Calendar Group ID |
Select the calendar group ID that is associated with the pay run for which you want to process banking. |
Click the Run button to run the GPINBK01 process request. PeopleSoft Process Scheduler runs the Banking for India process at user-defined intervals.
See Also