PeopleSoft Global Payroll for Germany 9.1 PeopleBook

Setting Up Banking

This chapter provides an overview of banking setup for Germany and discusses how to:

Set up bank information.
Set up defaults for source banks.
Set up banking defaults for payees.
Run local country bank processing.
Process SEPA payments for Germany.

Understanding Banking Setup

This section discusses:

The banking feature for Germany.
Delivered elements.

The Banking Feature for Germany

The banking feature in Global Payroll is optional. If you decide to use the banking feature, start by defining pages in the core application and continue setting it up on the Global Payroll for Germany pages.

To define the banking feature for Germany:

Define the banks and branches on the Bank Table page and the Bank Branch Table page in the core application.
Define the source banks on the Pay Entity Source Bank Link page in the core application.
Define the organization level for the source bank on the Pay Entity Source Bank Link page in the core application.
Define further information about source banks in Global Payroll for Germany.

Depending on the organization level you selected on the Pay Entity Source Bank Link page in the core application, define German-specific information on the corresponding page in Global Payroll for Germany.
Define bank account information for payees.

First, define information on the Bank Account Information page in the core application. Then, further define banking information for a payee in Global Payroll for Germany on either the Payee Source Bank Default page or the Manage Foreign Bank Acct DEU page.
Run the banking process on the Banking Run Control page in the core application.
Create payment files and reports in Global Payroll for Germany.

See Also

Defining Banking Instructions

Delivered Elements

The PeopleSoft system delivers a query that you can run to view the names of all delivered elements designed for Germany. Instructions for running the query are provided in the PeopleSoft Global Payroll PeopleBook.

Setting Up Bank Information

Global Payroll for Germany uses the same bank information pages as PeopleSoft HCM. Set up basic naming and address information for the banks that your company does business with on these pages:

Bank Table page (Set Up HRMS, Common Definitions, Banking, Banks, Bank Table).
Bank Branch Table page (Set Up HRMS, Common Definitions, Banking, Banks, Branch Table).
Source Bank Accounts page (Set Up HRMS, Common Definitions, Banking, Source Bank Accounts, Source Bank Accounts).

See Also

Setting Up Banks and Bank Branches

Setting Up Defaults for Source Banks

Use the Department DEU (GPDE_AL_DEPT) component and the Pay Entities DEU (GPDE_AL_PAYENTITY) component to set up defaults for source banks.

This section discusses how to:

Enter information at the pay entity level.
Enter information at the department level.
Enter information at the pay group level.

Note. All payments are processed through the source banks. Specify the classification criteria for the source banks on the Source Bank Link page in the core application. There, you can define the level of organization for which you are funding your payroll. Levels include pay entity, department, and pay group. For example, suppose that you select Pay Entity as the organizational level for the source bank on the Source Bank Link page in the core application. For every pay entity in your organization, you must set up a source bank default link on the Pay Entity - Local Source Bank Link page in Global Payroll for Germany. You also use these pages to define the payment type.

Pages Used to Set Up Defaults for Source Banks

Page Name	Definition Name	Navigation	Usage
Pay Entities DEU - Local Source Bank	GPDE_AL_PAYENTITY2	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Framework, Organizational, Pay Entities DEU, Local Source Bank	Enter information about source bank and payment type at the pay entity level. You must have already selected Pay Entity as the organization level on the Pay Entity Source Bank Link page and set up Source Bank IDs.
Department DEU - Source Bank	GPDE_AL_DEPT3	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Framework, Organizational, Department DEU, Source Bank	Enter information about source bank and payment type at the department level. You must have already selected Department as the organization level on the Pay Entity Source Bank Link page and set up Source Bank IDs.
Pay Groups DEU - Source Bank	GPDE_AL_PAYGROUP2	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Framework, Organizational, Pay Groups DEU, Source Bank	Enter information about source bank and payment type at the pay group level. You must have already selected Pay Group as the organization level on the Pay Entity Source Bank Link page and set up Source Bank IDs.

Entering Information at the Pay Entity Level

Access the Pay Entities DEU - Local Source Bank page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Framework, Organizational, Pay Entities DEU, Local Source Bank).

Source Bank Setup

Source Bank ID	Enter the source bank ID that you require. Source banks are the money sources from which payroll disbursements are drawn.
Payment Type	Select the payment type that you want to use: Advance Payments, BVV, Capital Accumulation, Company Pensions, Direct Life Insurance, External Transfer, Garnishments, Social Insurance, or Taxes.

Note. The Pay Entity is automatically populated from the Global Payroll core application.

Entering Information at the Department Level

Access the Department DEU - Source Bank page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Framework, Organizational, Department DEU, Source Bank).

Note. The department is automatically populated from the Global Payroll core application. On this page, enter information about the source bank ID and the payment type.

Entering Information at the Pay Group Level

Access the Pay Groups DEU - Source Bank page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Framework, Organizational, Pay Groups DEU, Source Bank).

Note. The pay group is automatically populated from the Global Payroll core application. On this page, enter information about the source bank ID and the payment type.

Setting Up Banking Defaults for Payees

This section discusses how to:

View bank account information for payees.
Assign payee bank accounts to default source banks.
Manage foreign bank account information.

Pages Used to Set Up Banking Defaults for Payees

Page Name	Definition Name	Navigation	Usage
Maintain Bank Accounts	PYE_BANKACCT	Global Payroll & Absence Mgmt, Payee Data, Net Pay / Recipient Elections, Maintain Bank Accounts, Maintain Bank Accounts	View bank account information for a payee. You must have already set up bank account information for a payee.
Override Source Bank DEU	PYE_BANKACCT	Global Payroll & Absence Mgmt, Payee Data, Net Pay / Recipient Elections, Override Source Bank DEU, Override Source Bank DEU	Assign a payee's bank account to a default source bank. First, complete the Source Bank Account page.
Manage Foreign Bank Acct DEU	PYE_BANKACCT	Global Payroll & Absence Mgmt, Payee Data, Net Pay / Recipient Elections, Manage Foreign Bank Acct DEU, Manage Foreign Bank Acct DEU	Add or update bank account data for a payee and record foreign bank transfers.

Viewing Bank Account Information for Payees

Access the Maintain Bank Accounts page (Global Payroll & Absence Mgmt, Payee Data, Net Pay / Recipient Elections, Maintain Bank Accounts, Maintain Bank Accounts).

Assigning Payee Bank Accounts to Default Source Banks

Access the Override Source Bank DEU(Global Payroll & Absence Mgmt, Payee Data, Net Pay / Recipient Elections, Override Source Bank DEU, Override Source Bank DEU).

Bank Accounts

Type

Select the type of account.

Bank Details

Bank ID	Select the name of the person's bank.
Account Number	Enter account number for the person.
Account Name	Enter the account name for the person.
Edit IBAN	Displays the IBAN number for the account. Click the Edit IBAN link to access the International Bank Account Nbr page where you can generate and edit the IBAN for the bank account.
AC Account Name (alternate character account name).	Appears if you enabled alternate character (AC) functionality on the Primary Permission List Preferences page.

Managing Foreign Bank Account Information

Access the Manage Foreign Bank Acct DEU page (Global Payroll & Absence Mgmt, Payee Data, Net Pay / Recipient Elections, Manage Foreign Bank Acct DEU, Manage Foreign Bank Acct DEU).

This page displays the information that you entered on the Bank Account Information page.

Running Local Country Bank Processing

Use the Bank File Content DEU (GPDE_BK_TRANSFER) component and the Payment Types DEU (GPDE_BK_TRN_SETUP) component to run local country bank processing.

This section discusses how to:

View accumulators assigned to payment types.
Define files created by the bank transfer report.
Report on bank transfers.
Create bank lists.

Note. After you set up information in the Global Payroll core application, you can use this information when running processes in Global Payroll for Germany to create actual payment files and payment reports. These processes include writing SQR reports and extracting data from the output file that the system creates in the core application in the banking run control process.

Pages Used for Local Country Bank Processing

Page Name	Definition Name	Navigation	Usage
Payment Types DEU	GPDE_BK_BNKTRN	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Banking, Payment Types DEU, Payment Types DEU	View the accumulators that are assigned to payment types. Assign banking-related earnings/deductions to these accumulators before you use them.
Bank File Content DEU	GPDE_BK_XFERDTA	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Banking, Bank File Content DEU, Bank File Content DEU	Define the files that are created by the Bank Transfer report. You must define which earning or deduction must be transferred and to which file it must be written.
Create Bank File DEU	GPDE_RC_BK01	Global Payroll & Absence Mgmt, Payment Processing, Create Bank File DEU, Create Bank File DEU	Creates one or several files containing all data records in their required formats. Copy the files that this report creates to newly formatted diskettes to be used for the data transfer with banks.
Create Bank List DEU	GPDE_RC_BK02	Global Payroll & Absence Mgmt, Payment Processing, Create Bank List DEU, Create Bank List DEU	Provides information about all payments made to employees through a financial institution, such as a bank or post office.

Viewing Accumulators Assigned to Payment Types

Access the Payment Types DEU page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Banking, Payment Types DEU, Payment Types DEU).

Payment Type

The payment type that you selected to access this page.

Element Name

The accumulator assigned to the payment type.

Payment Types and Accumulators Used in Bank Transfer Process

Global Payroll for Germany supports the following payment types:

Payment Type	Description
1	Wages and Salaries.
3	Taxes.
4	Social Insurance.
6	Capital Accumulation.
7	Direct Life Insurance.
8	Garnishment.
9	External Transfer.
V	Advanced Payment.
B	BVV.
U	U1/Sick Leave.
L	U2/Maternity Leave.

The following accumulators hold the amounts for the various payment types:

Accumulator	Description
DE_BK_PAYMT1	Bank Transfer Wages/Salaries.
DE_BK_PAYMT3	Bank Transfer Taxes.
DE_BK_PAYMT4	Bank Transfer Social Insurance.
DE_BK_PAYMT6	Bank Transfer Capital Accumulation.
DE_BK_PAYMT7	Bank Transfer Direct Insurance.
DE_BK_PAYMT8	Bank Transfer Garnishment.
DE_BK_PAYMT9	Bank Transfer External Transfer.
DE_BK_PAYMTV	Bank Transfer Advanced Payment.
DE_BK_PAYMTB	Bank Transfer BVV.
DE_BK_PAYMTU	Bank Transfer U1/Sick Leave.
DE_BK_PAYMTL	Bank Transfer U2/Maternity Leave.

The accumulators are not important for the payroll calculation process, but they are used for the bank transfer. Only the earnings/deductions that are referenced by the accumulators are transferred.

Defining Files Created by the Bank Transfer Report

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

Date

The date on which the last bank diskette was created.

Seq. (sequence)

The system automatically assigns a sequence number. This value defines the number of files that are created.

Source Bank

Enter a source bank that you defined on the Source Bank page in the core application.

Deposit Schedule

Enter a deposit schedule that you defined on the Deposit Schedules page in the core application.

Wages and Salaries

Select this check box if you want wages and salaries to be transferred.

Income Tax and Church Tax

Select this check box if you want these taxes to be transferred.

Capital Accumulation Benefits

Select this check box if you want these benefits to be transferred.

Advance Payments

Select this check box if you want these payments to be transferred.

Social Insurance Contributions

Select this check box if you want these contributions to be transferred.

Direct Life Insurance

Select this check box if you want direct life insurance to be transferred.

BVV

Select this check box if you want BVV to be transferred.

External Transfers

Select this check box if you want external transfers to be transferred.

Garnishments

Select this check box if you want garnishments to be transferred.

Reporting on Bank Transfers

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

Transfer Sequence

Specify the sequence in which the data is transferred to the bank. Set up the format of this data using the Bank Transfer Disk page.

Deposit Schedule

Select a deposit schedule that you defined on the Deposit Schedules page.

Diskette Type

Select the type of disk that you are using to store the files that the report creates.

Note. Click Run on this page to initiate the Bank Transfer Diskette (GPDEBK01) process. This report creates no printable output file, which is why there is no PDF file published on CD-ROM with the documentation.

Creating Bank Lists

Access the Create Bank List DEU page (Global Payroll & Absence Mgmt, Payment Processing, Create Bank List DEU, Create Bank List DEU).

Enter the current pay end date, pay entity, pay group, and source bank ID. Then, click Run to initiate the Banklist (GPDEBK02) process.

Processing SEPA Payments for Germany

PeopleSoft Global Payroll for Germany 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.

Setting Up SEPA Processing

Before you can process SEPA payments using Global Payroll for Germany, in addition to the normal banking setup you must:

Ensure that an active SEPA application package is defined for Germany on the Banking Country Setup page.
Define payment process settings on the Installation Settings page.
Set up Integration Broker for both Global Payroll for Germany and Financial Gateway.
Set up banks for Germany in your PeopleSoft Financials system.

Note. Because Global Payroll for Germany uses a delivered country-specific application package (GPDE_SEPA:CPopulateDEandFGRec), it is not necessary to define a SEPA SQL statement for Germany on the Banking Preparation Definition page.

Processing SEPA Payments

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 Germany on the Banking Country Setup component, however, GP_PMT_PREP executes SEPA logic.

Global Payroll for Germany uses the GPDE_SEPA:CPopulateDEandFGRec application package defined in the Banking Country Setup component to load results into the GP_PAYMENT_FG record for the country, calendar run ID, and employee ID range selected on the Run Payment Prep Process run control page.

Note. This new SEPA logic supersedes the country-specific processes that you would normally run in PeopleSoft Global Payroll for Germany for non-SEPA banking. Therefore, when processing SEPA payments for Germany, you do not have to run the Bank Transfer Diskette (GPDEBK01) or Banklist (GPDEBK02) processes.

Sending SEPA Payments to PeopleSoft Financial Gateway

You send generated SEPA payment details from PeopleSoft Global Payroll for Germany 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 XML reports. The delivered report for PeopleSoft Global Payroll for Germany is GPDE_FG_REPT.

Payment Type	The payment type that you selected to access this page.
Element Name	The accumulator assigned to the payment type.

Date	The date on which the last bank diskette was created.
Seq. (sequence)	The system automatically assigns a sequence number. This value defines the number of files that are created.
Source Bank	Enter a source bank that you defined on the Source Bank page in the core application.
Deposit Schedule	Enter a deposit schedule that you defined on the Deposit Schedules page in the core application.
Wages and Salaries	Select this check box if you want wages and salaries to be transferred.
Income Tax and Church Tax	Select this check box if you want these taxes to be transferred.
Capital Accumulation Benefits	Select this check box if you want these benefits to be transferred.
Advance Payments	Select this check box if you want these payments to be transferred.
Social Insurance Contributions	Select this check box if you want these contributions to be transferred.
Direct Life Insurance	Select this check box if you want direct life insurance to be transferred.
BVV	Select this check box if you want BVV to be transferred.
External Transfers	Select this check box if you want external transfers to be transferred.
Garnishments	Select this check box if you want garnishments to be transferred.

Transfer Sequence	Specify the sequence in which the data is transferred to the bank. Set up the format of this data using the Bank Transfer Disk page.
Deposit Schedule	Select a deposit schedule that you defined on the Deposit Schedules page.
Diskette Type	Select the type of disk that you are using to store the files that the report creates.