Managing Electronic Fund Transfers

This topic discusses ways to manage 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.

This 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 Name

Definition Name

Usage

Fund Transfer - Electronic Page

GPAU_EFT_CMX

Enter the parameters for the electronic file creation.

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 HCM > 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.

Use the Fund Transfer - Electronic page (GPAU_EFT_CMX) to enter the parameters for the electronic file creation.

Navigation:

Global Payroll & Absence Mgmt > Payment Processing > Create EFT Payment File AUS > Create EFT Payment File AUS

This example illustrates the fields and controls on the Create EFT Payment File AUS page. You can find definitions for the fields and controls later on this page.

 Create EFT Payment File AUS 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.

Field or Control

Description

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.