Creating Payment Files (ISO 20022) and Reports in Global Payroll for Switzerland

Within the Swiss payroll application, employee payment information gets transferred – beginning 01/2018 (Post Finance) and 07/2018 (other receiving banks) - using the Swiss derivative of ISO 20022. ISO 20022 replaces former DTA (data exchange by file) and the EPO (electronic payment order) format.

GP Switzerland supports the following payment types:

  • Type 3 = domestic (EUR/CHF) (incl. Garnishments and ext. Transfers)

  • Type 4 = domestic (<> EUR/CHF)

  • Type 5 = foreign EUR (=SEPA)

  • Type 6 = foreign (<> EUR)

Global Payroll Switzerland has long experience in preparation and communication of XML files for legal authorities. Thus GP Switzerland uses the existing framework (Swiss XML dashboard) to create Swiss ISO 20022 XML.

The required setup for dashboard is (almost) the same as for any other XML created by dashboard. For the setup, follow the steps below.

Note: This step is run once the CHE banking process runs successfully.

Step

Action

Navigation Path

1

Prepare Dashboard for Swissdec standard domain.

Global Payroll & Absence Mgmt, > Authority Correspondence, > Month, > Prepare Files

2

Click Run. Then check the Process Monitor to make sure the process runs to success.

Global Payroll & Absence Mgmt, > Authority Correspondence, > Month, > Prepare Files

3

Validate the created file.

Global Payroll & Absence Mgmt, > Authority Correspondence, > Month, > Prepare Files

4

Review results.

Global Payroll & Absence Mgmt, > Authority correspondence, > Month, > Print View (select BI Publisher)

5

Use the Save button.

Save file to a directory of your choice and upload to your source bank portal.

Global Payroll & Absence Mgmt, > Authority correspondence, > Month

See also Robust File Management.

Page Name

Definition Name

Usage

Prepare Files Page

GPCH_EG_RSTATUS

Prepare ISO 20022 XML.

Process Files Page

GPCH_EG_FSTATUS

Validate, review and download ISO 20022 XML.

Use the Prepare Files CHE page (GPCH_EG_RSATUS) to prepare the ISO 20022 XML.

Navigation:

Global Payroll & Absence Mgmt, > Authority Correspondence, > XML based reporting CHE, > Monthly

This example illustrates the fields and controls on the Prepare Files page.

Prepare Files Page

Field or Control

Description

Domain ID

For Monthly Processing, this will prompt only for monthly domains.

Report Period

For Monthly Processing, this is always monthly.

Current Pay End Date

Defaults to the earliest open End date in the selected year. You can only save, if payment pre CHE ran for this period.

Run

Starts Job GPCH_AE_XML which launches for monthly menu Job GPCH_MONTH.

ISO-Prty

The values fills TAG TP/PRTY. If empty TAG doesn’t get created.

This example illustrates the fields and controls on the Process Detail page.

 Process Detail page

Use the Process Files CHE page (GPCH_EG_FSATUS) validate, review and save the ISO 20022 XML.

Navigation:

Global Payroll & Absence Mgmt, > Authority Correspondence, > XML based reporting CHE, > Monthly

This example illustrates the fields and controls on the Process Files page.

 Process Files page

Field or Control

Description

Validate

Validates the XML vs. most recent ISO 20022 schema (currently pain.001.001.03.ch.02.xsd).

Save

Saves the file to your target directory other than for all other domains save navigates directly to the robust file management page.

Print

Print contents of XML via BI Publisher.

Delete

Delete the row for this month.

Reporting

A BI PUBLISHER report (GPCH_ISO20022) is delivered to print payment information. The data source of this report is the ISO 20022 XML.

BI Publisher ViewGen Parameters

 BI Publisher ViewGen Parameters

This example illustrates the fields and controls on the BI PUBLISHER report (GPCH_ISO20022) for mode Summar ( = used for approval = 1 page) .

BI PUBLISHER report (GPCH_ISO20022)

This example illustrates the fields and controls on the BI PUBLISHER report (GPCH_ISO20022) for mode Detail ( = used for detail review = 1 cover page + n detail pages) .

BI PUBLISHER report (GPCH_ISO20022) for mode Detail