Ansicht
Dokumentation

RPLQSTC0 - HR-CH: Withholding tax calculation

RPLQSTC0 - HR-CH: Withholding tax calculation

rdisp/max_wprun_time - Maximum work process run time   General Data in Customer Master  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

You use the report to calculate withholding tax for the cantonal tax offices.
Depending on the size of the company, withholding tax must be calculated each month or quarter.

For the canton of Vaud, you can submit the withholding tax electronically. To do this, you create an XML file that you upload to the Internet portal of the cantonal tax authorities. For more information, see www.vd.ch.

Integration

This program evaluates the payroll results of the selected employees by assigning the selected wage types to the list columns and then cumulating them.

You determine which wage types are assigned to which column in the Maintain Cumulation Wage Types Customizing activity. A withholding tax calculation column is then represented technically by a cumulation wage type.

Prerequisites

Before running the report, you have processed the Reporting activity in the IMG for Payroll Switzerland, under Tax → Withholding Tax.

Ensure that the AHV number is stored in the Social Insurance Data: Switzerland (0036) for all those employees subject to withholding tax.

Ensure that a municipality code is stored in the Fiscal Data CH infotype (0036) in the Municipality field for all those employees subject to withholding tax.

Features

Selection

Payroll data is selected in accordance with retroactive parameter 'FR'. That is, all payroll results are evaluated that were created in the reporting period. They are displayed in the list with the employment period for which they were created. This ensures that you do not lose any payroll results even if changes are made with retroactive effect, and that the results are displayed clearly for the withholding tax office.

In the Printer field, you specify the output device for the SAPscript output of the withholding tax statement.
Note: If you schedule the report as a background job, the system uses the output device specified here. If you want to use the output device that you specify in the options for background processing, you have to leave the Printer field blank.

If you want to use electronic withholding tax accounting for the canton of Vaud: In the Output area, choose the XML file for C VD checkbox, and specify Vaud as the canton.

You can choose between the following formats for the XML file:

  • EMP-IS
  • EMP-ACI (from October 2010 onwards).
If you select the Activate ACI checkbox, the XML file is generated in EMP-ACI format. If the Activate ACI checkbox is not selected, the XML file is generated in EMP-IS format.
By default, the report generates an total list for the withholding tax calculation ( "Liste Récapitulative", LR). If retroactive accounting relevant for withholding tax has taken place in the system, the report also generates the corresponding correction lists ("Liste Corrective", LC) automatically.
If you select the Force LC checkbox, the report generates a correction list (LC) instead of the total list (LR). You force a correction list if you have not yet entered an employee in the withholding tax return in the past. In this case, there is no retroactive accounting for this employee and correction lists are therefore not generated automatically. Hence, the information in the correction list replaces the information in the total list. You therefore must create the correction list (LC) for the same period as the original total list (LR).
You use the Monthly or Quarterly checkboxes to determine for which intervals the system automatically generates correction lists (LC). This interval only affects the correction lists that are generated automatically when there is retroactive accounting that is relevant for withholding tax.

Note:Do not create the withholding tax calculation for the canton of Vaud across calendar years. Always create it for a maximum of one year.

Output

The report generates the following lists or files:

  • The check list that is interactively displayed in the SAP List Viewer (ABAP List Viewer) lets you make a number of individual adjustments, for example, sorting or hiding of individual columns, filter functions, and group totals. For the electronic withholding tax calculation, you can select other parameters such as Test Run or Type of Message in the Additional Options File Output for Canton VD (EMP-IS) area.
This list is for internal control purposes. For example, you can use it to create a list of all combinations.
  • Withholding tax calculation in SAPscript format. You send this list to the cantonal withholding tax offices.
For best results, print the list on a Postscript printer, HP laser jet printer, or compatible printers.
  • Withholding tax calculation as an XML file for the canton of Vaud in EMP-IS or EMP-ACI format. You can use the B2A Manager to download the file, display it and process it further.

The control lists are grouped by the following criteria:

Payroll unit, tax liability, tax canton, tax municipality.

At the end of a control level, a recapitulation with subtotal and payment fee is displayed.

A line of withholding tax data is printed per payroll period for each employee subject to withholding tax. If the reporting period has more than one payroll period, a totals line is also printed for each employee.

If data changes because of a retroactive change to the withholding tax scale that becomes effective outside of the reporting period, the system displays a line containing the old result with the comment Reversed (with a negative sign), and the new corrected result with the comment Correction (with a positive sign).

Withholding tax arrears payments that are subsequently entered manually due to instructions from the tax office are displayed in a separate line with the comment Arrears.

Each line contains the following data:

  • Employee's AHV number, last name, and first name.
  • Residence canton and place of residence, read from infotype 0006. The residence canton and place of residence do not have to match the tax canton and tax municipality if the latter are determined in accordance with the work location.
  • Cantonal rate description
  • Employment period
  • Mutation data: If an employee enters or leaves the company, changes canton, or changes tax liability, indicators 'E' or 'A' are output. If the rate changes, the indicator 'TW' is output.
  • Gross pay, bonuses/incidental benefits, rate and tax amount are determined from the employee's payroll data. The total result is calculated by adding gross pay to the bonuses/incidental benefits.
  • If no rate is specified for the payroll period, the number of children is derived from the number of child bonuses.

The report outputs the values that are also contained in the XML file. You can then use the B2A Manager to download the file. The report output is structured as follows:

  • Employer notification (only for format EMP-ACI):
This category shows all the values that the system has determined for the respective employer, the corresponding employees, and their withholding tax calculation.
  • General messages
This category includes all messages that are related to the determination of data for withholding tax calculation.
  • Statistics
The category shows the total number of personnel numbers and well as the share of successfully processed personnel numbers.

Activities

Further Processing with the B2A Manager

If you have generated XML files for the canton of Vaud, you can use the B2A manager to process these further. The procedure depends on the selected format.

  1. Start transaction PB2A.
  2. For the country group, enter the value 02 (Switzerland).
  3. Under Selection: Switzerland, enter the values Area= WTax and Document Type=VEMP, and confirm your entries.
    The table showing the open processes contains one row for each generated withholding tax calculation, that is, for each employer.
  4. To download the XML file, select the entry in status New/Ready for Download, and choose Execute.
  5. Transfer the file to the required recipient (for example, by mail or by uploading it to a portal of the recipient).
  6. Optional: Choose a suitable subsequent status. You can use the available status information for process management.
  7. Once the recipient has confirmed that he or she received the message and is able to process it: Change the status to OK/WTax Calculation Complete. The process is then completed in the B2A Manager.
  1. Choose B2A Manager.
  2. For the country group, enter the value 02 (Switzerland).
  3. Under Selection: Switzerland, enter the values Area= WTax and Document Type=VACI, and confirm your entries.
The table showing the open processes contains one row for each generated withholding tax calculation, that is, for each employer. The Description column contains the declaration period as well as an indicator showing whether it is a total list (LR) or correction list (LC).
  1. To download the XML file, select the entry in status New/Ready for Download, and choose Execute.
    A Save As dialog is displayed. The suggested file name meets the requirements of the EMP-ACI standard.
The file name must be structured as follows:
ZZ_123456789_AAAA_XXXX_YYYY
ZZ: List type, either LC or LR
123456789: Employer Number
AAAA: Year of declaration period, e.g. 2009
XXXX: Start of declaration period (day and month)
YYYY: End of declaration period (day and month)
Example: A total list for the declaration period from 10/01/09 to 12/31/09 of an employer with number 123456 must have the following file name: LR_123456_2009_0110_3112.XML
The status in B2A manager automatically changes to In Process/XML File Downloaded.
  1. Transfer the file to the cantonal tax authorities (by mail or electronically) and change the status to In Process/Transferred Successfully.
  2. Optional: If you have to generate a correction list because of an employee that has not been registered yet, proceed as follows:
    1. Change the status to Processing/Create Correction List and choose Execute.
      Report RPLQSTC0 is called with the selection parameters used originally but the Force LC checkbox is selected.
    2. Execute the report.
    3. Start the B2A Manager again.
    4. Change the status of the original entry to OK/WTax Calculation Complete. The process is then completed in the B2A Manager. A new entry has been created for processing the correction list.
  3. Optional: If you have received an XML file with new tax numbers from the tax authority, proceed as follows:
    1. Change the status to In Process/Import New Tax No. and choose Execute. Report RPUQSTC3 is called to import the tax numbers.
    2. Execute the report.
  4. Change the status to OK/WTax Calculation Complete. The process is then completed in the B2A Manager.

Example

Further Information

For detailed information about working with the B2A Manager, refer to the report documentation H99_B2A-Manager






PERFORM Short Reference   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 14371 Date: 20240520 Time: 120422     sap01-206 ( 184 ms )