Running Banking and Recipient Processes

This chapter provides an overview of banking and recipient processing and discusses how to:

Set up additional deduction recipient information.
Manage electronic funds transfers (EFTs).
Generate recipient payment report files.

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

Understanding Banking and Recipient Processing

The banking process of Global Payroll combines payroll data, pay entity source bank data, and payee or recipient bank data. The EFT file creation process extracts data compiled by the banking process according to the type of EFT file that you are creating, merges it with data provided by the Australian country extension, and creates the file for transmission.

Note. In this chapter, the payee of group tax is the Australian Tax Office (ATO). The ATO is a recipient just as a health fund or the beneficiary of a garnishment is a recipient. Unless otherwise stated, the term recipient includes the ATO.

Setting Up Additional Deduction Recipient Information

To set up additional deduction recipient information, use the Deduction Recipients AUS (GPAU_RECIPIENT) component.

You set up your deduction recipients using the Deduction Recipients page (select Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Banking, Deduction Recipients). You can then add membership ID information about those recipients on the Deduction Recipients AUS page, if needed.

Note. Use the Deduction Recipients AUS page only if you need to attach membership information to deduction elements. Otherwise, use the generic Add Deduction Recipients page.

Pages Used to Set Up Additional Deduction Recipient Information

Page Name	Object Name	Navigation	Usage
Payee Recipient	GPAU_RCPPYE_EXT	Global Payroll & Absence Mgmt, Payee Data, Net Pay / Recipient Elections, Add Deduction Recipients AUS, Payee Recipient	Link a payee to a deduction recipient and enter the payee’s membership number with that recipient.
Deduction Recipient	GPAU_RCPPYE_SUPER	Click the Super Reporting link on the Payee Recipient page.	Enter Super Reporting details for the payee.
Deduction Recipients	GPAU_RECIPIENT_EXT	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Banking, Deduction Recipients AUS, Deduction Recipients	Enter Australia-specific additional information about recipients that are set up in the core application for Global Payroll.
SuperEC Detail	GPAU_RECIPNT_SPREC	Click the SuperEC link on the Deduction Recipients page.	Enter receiver, target fund, and sender information according to SuperEC standards.

Adding Additional Recipients

Access the Payee Recipient page.

Recipient ID

Identifier for the recipient of the deduction element.

Membership ID

Membership ID associated with the recipient ID.

Element Name

Name of the deduction element.

Entering Additional Recipient Information

Access the Deduction Recipients page.

Group Tax Recipient

Select if the recipient is the ATO, the recipient of group tax.

File Layout

Select the appropriate file layout from those that you have created in Application Designer for report files that you submit to recipients. When you run the Recipient File - Electronic report, the Application Engine process uses the file layout that you enter here.

Note. The GPAU_RCPFILE Application Engine process uses only the GPAU_RCPNT FILE recipient schedule file. You can make minor changes to that file—for example, field order. However, if you make major file layout changes, you must create additional Application Engine programs to process them.

Pay Entity

Enter the pay entity that receives this commission. If the commission is deducted from the payment due to the recipient, the debit to the pay entity’s source bank account is reduced by the commission amount.

Calculate Optn (calculate option)

Select from the following values:

Ded Comm (deduct commission): The system deducts the commission amount from the payment due to the recipient.

Rpt Only (report only): The system reports the commission amount in the EFT file but does not deduct it from the payment.

Type

Select Flat Amt (flat amount) or Percentage.

Amount

Enter the flat amount or percentage to be calculated.

Group Number

Enter the unique identifier that the recipient has supplied for the pay entity. For payment to recipients excluding the group tax recipient and payee level recipients, the group number is part of the unique lodgment reference that is part of each recipient EFT file.

Note. The lodgment reference for net pay is the employee ID plus payment date. For recipient payments, it is the group number plus payment date. For group tax payments, it is the EFT code plus payment date.

Super Reporting

Super Fund Administrator	Select to designate the recipient as a Super Fund administrator.
Super EC	Click to access the SuperEC Detail page.
Super Reporting Format	Select a reporting format. Valid values are Agest, ComSuper, and SuperEC.
ComSuper Agency ID	Enter the ComSuper agency ID.

Managing Electronic Fund Transfers

The Australian standard Cemtex file for EFT is created by a process that provides multiple options to control the file's content. You can create an EFT file that contains:

Group tax.
Net pay distribution.
Recipient deduction.
Net pay and recipient.

The following diagram shows the tables that contribute data to the Cemtex file that is incorporated into the EFT file.

Tables that contribute to the Cemtex file

Note. You must finalize the Banking process (GP_PMT_PREPARE) before you can create the Cemtex file. After the Cemtex file is created, the system changes the PMT_STATUS field in the GP_PAYMENT table from P (prepared) to T (transferred).

Page Used to Manage Electronic Fund Transfers

Page Name	Object Name	Navigation	Usage
Fund Transfer - Electronic	GPAU_EFT_CMX	Global Payroll & Absence Mgmt, Payment Processing, Create EFT Payment File AUS, Fund Transfer - Electronic	Enter the parameters for the electronic file creation.

Generating the EFT Code

The system enters the pay entity’s EFT code in the header of group tax EFTs as part of the lodgment reference. (The payment date makes each lodgment reference unique to a particular EFT file.)

The pay entity’s EFT code is calculated by the system from your ABN, ABN branch, and ATO office code when you enter that information on the Pay Entities AUS page (select Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Framework, Organizational, Pay Entities AUS). After it is calculated, the system displays it on that page. You cannot change the EFT code directly, but the system recalculates and displays it again if you change the ABN, branch, or office code.

Creating the EFT Cemtex File

Access the Fund Transfer - Electronic page.

The GPAU_EFT_CMX Application Engine process extracts the salary data from the Payroll Results table and creates the Cemtex file for transmission to the bank. You can create files for net pay only, recipients only, both net pay and recipients, or for specific deductions.

Payment Type	Select from Group Tax, Net Pay And Recipient, Net Pay Distribution Only, and Recipient Deduction Only. The EFT file that the system creates contains only payments of the type specified.
Entry Description	Included in the header of the EFT file, this indicates the type of data in the file; for example, payroll.
Calendar Group ID	Enter the ID for the calendar group for which the file is created.
Stream Number	You can create the EFT file for only the payees in the stream that you enter here. Stream processing is applicable to only Net Pay Distribution Only, Net Pay, and Recipient.
Process Streams	This check box is automatically selected if you select the Perform Stream Processing option on the Calendar Group ID page. It indicates that you must select a stream number.
Payment Date	This is the date of the actual transfer of the funds. It is written to the EFT file header.
Debit Date	The system extracts recipient payments where their deposit schedule date is equal to the deposit date. If the recipient does not have a deposit schedule, their debit date is equal to the day that the Banking process was run.
Period End Date	This is the end date for the pay period.
Recipient Calculate Option	Select All Recipients, Deduction, or Select Recipient Only.Select a single deduction or a single recipient ID for the second and third options, respectively. For group tax, the recipient is KAATO, the Australian Tax Office. Note. You do not have to select anything here for the Net Pay Distribution Only option.

Note. If the GPAU_EFT_CMX Application Engine process returns No Success due to the error “Credit and Debit Transactions Sharing the same Bank Account : 1,” the file is still generated. The system transfers monies to the source account in the instance that an employee does not have a valid account due to effective dates or inactivity. The user can then run the file again or send the file knowing that the monies will be returned to the source bank.

Generating Recipient Payment Report Files

It is common for organizations to transmit a file to a recipient so that they can update their records. For example, an organization may pay a recipient weekly and at the end of the month deliver a file with all the payment details. Recipients generally specify the information that they want and the report file layout. After you have created the file layout, link it to the recipient on the Deduction Recipients page (select Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Banking, Deduction Recipients AUS).

The PeopleSoft system provides the GPAU_RCPNT_FILE sample file layout. The GPAU_RCPFILE process retrieves the file layout that is specified on the Deduction Recipients page.

Note. This electronic file depends on first running the GPAU_EFT_CMX Application Engine process for recipients.

Page Used to Generate Recipient Payment Report Files

Page Name	Object Name	Navigation	Usage
Recipient File - Electronic	GPAU_RUNCTL_RCP_FL	Global Payroll & Absence Mgmt, Payment Processing, Create Recipient File AUS, Recipient File - Electronic	Enter the parameters for generating recipient payment files.

Creating the Recipient Payment Report File

Access the Recipient File - Electronic page.

Debit Date

The system extracts payment data for the deposit date that you enter here.

Payment Date

This is the date, from the EFT file header, that the bank passed the payment to the recipient. It’s written to the output report file.

Calculate Option

These are the same options as for the EFT creation process: All Recipients, Deduction, and Select Recipients Only.

Select a single deduction or a recipient ID for the second and third options, respectively.

Note. The GPAUPY52 recipient file report is a Structure Query Report (SQR) version of the data extracted for the electronic recipient file. When you run the Recipient File Creation Application Engine process from the Process Scheduler Request page, you automatically generate the SQR. If you want the SQR only, you can select its check box and leave the Application Engine check box cleared.

Reporting Net Payment

The Net Payment report extracts data from the Cemtex Transaction table and the Header table and from the Personal Data and Job records.

Select detail or summary reporting.

Detail Reporting

The following table shows sample results of detail reporting:

Empl ID	Empl Rcd#	Name	Amount	Payment Method	Bank Name	BSB Number	Account Number	Payment Status
KA0001	0	Taylor, Jane Elizabeth	2976.65	Bank Transfer	ANZ	012002	152545689	Finalized
KA0002	0	Kerr, Elizabeth	4298.16	Bank Transfer	IMB	641800	765908765	Finalized

Total Amount	7274.81
Number of Pays	2

Summary Reporting

The following table shows the same data reported at the summary level:

Total Amount	7274.81
Number of Pays	2

Recipient ID	Identifier for the recipient of the deduction element.
Membership ID	Membership ID associated with the recipient ID.
Element Name	Name of the deduction element.

Group Tax Recipient	Select if the recipient is the ATO, the recipient of group tax.
File Layout	Select the appropriate file layout from those that you have created in Application Designer for report files that you submit to recipients. When you run the Recipient File - Electronic report, the Application Engine process uses the file layout that you enter here. Note. The GPAU_RCPFILE Application Engine process uses only the GPAU_RCPNT FILE recipient schedule file. You can make minor changes to that file—for example, field order. However, if you make major file layout changes, you must create additional Application Engine programs to process them.
Pay Entity	Enter the pay entity that receives this commission. If the commission is deducted from the payment due to the recipient, the debit to the pay entity’s source bank account is reduced by the commission amount.
Calculate Optn (calculate option)	Select from the following values: Ded Comm (deduct commission): The system deducts the commission amount from the payment due to the recipient. Rpt Only (report only): The system reports the commission amount in the EFT file but does not deduct it from the payment.
Type	Select Flat Amt (flat amount) or Percentage.
Amount	Enter the flat amount or percentage to be calculated.
Group Number	Enter the unique identifier that the recipient has supplied for the pay entity. For payment to recipients excluding the group tax recipient and payee level recipients, the group number is part of the unique lodgment reference that is part of each recipient EFT file.