Administering Inland Revenue Reporting

This chapter provides an overview of Inland Revenue reporting, lists common elements, and discusses how to:

Create tax reports.
Create Employee Provident Fund (EPF) Form A and EPF Summary.
Create Social Security Organization (SOCSO) reports.
Create year-end reports.
Create termination reports.

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

Understanding Inland Revenue Reporting

Global Payroll for Malaysia enables you to capture, generate, and maintain employee and company identification and biographical data that supports the reporting requirements of the Inland Revenue Board (IRB). The system meets the department's requirement to produce the CP21, CP22, CP22A, CP8A, CP39, CP159, CP159A/PCB2, EPF Form A, EPF Summary, SOCSO Form 2, SOCSO Form 8A, SOCSO Form 8B, SOCSO Form 3, and Form E forms.

CP21 Processing

The CP21 report notifies the IRB of an employee's intention to depart from Malaysia for a period exceeding three months. The CP21 form contains four sections: Employer Details, Employee Details, Remuneration Details, and Other Particulars. Employer details come from the Tax Number Table MYS. Employee details come from the Employee Tax Details , the employee's Personal Data and Maintain Termination Data pages. Remuneration details show the employee earnings, grouped according to user-defined parameters. Other particulars require details of the tax payments and deductions that have been made, and the employee's approved EPF contributions.

Global Payroll for Malaysia enables you to run this report on an as-needed basis. To do so, the system uses Structured Query Report Writer (SQR) GPMYTX01 to:

Retrieve the company details from the Tax Number Table MYS.
Retrieve payee information, dependent details, passport or NIC numbers, and spousal information.
Retrieve Remuneration from the View CP21 Details MYS, Salary Details page.
Format the data and print the form.

Global Payroll for Malaysia enables you to view and modify CP21 data online before finalizing the data. You can print the report multiple times.

CP22 Processing

This report notifies the IRB of a new employee. The report provides the following information: employee name and address, nature of employment, date of hire, gross monthly salary, expected duration of employment, marital status, and previous employer's name and address.

The CP22 form contains four sections: Employer Details, Employee Details, Terms of Employment, and Previous Employer. Employer details come from the Tax Number Table MYS. Employee details come from the employee's Maintain Tax Details, Personal Data and Dependent Beneficiary pages. Terms of employment include information about the employee wage, fixed allowances, and any fluctuating earnings. The Previous Employer section displays the name and address of the previous employer.

To produce this report, the system uses SQR GPMYTX02 to:

Retrieve the employee's monthly salary from the JOB table.
Print the report.

CP22A Processing

This report notifies the IRB of employees who have ceased their employment. The report provides the following information: employee name and address, nature of employment, gross monthly salary, duration of employment, and marital status.

The CP22A form contains four sections: Employer Details, Employee Details, Remuneration details and other particulars. Employer details come from the Tax Number Table MYS. Employee details come from the employee's Maintain Tax Details , Termination, Dependent Beneficiary or the Personal Data pages. . The Remuneration section includes information about the employee wage, fixed allowances, and any fluctuating earnings. Other Particulars require details of the tax payments/deductions that have been made, and the employee's contributions to approved Provident or Pension Funds (EPF).

Global Payroll for Malaysia enables you to run this report on an as-needed basis. To do this, the system uses SQR GPMYTX03 to:

Retrieve the employee's gross salary, leave pay, bonus, gratuity, allowances, tax, and EPF contributions from the GPMY_PR_TMP3 table.
Print the details.

Global Payroll for Malaysia enables you to view and modify CP22A data online before finalizing the data. You can print the report multiple times.

CP8A Processing

This annual statement reports total remuneration and tax deductions for an employee. This report is created at the end of the year, or when an employee is terminated. The report contains information about the payee, income, tax deductions, EPF deductions, and arrears payments. This form is give to the employee and the employee submits it to the IRB

To create this report, the system uses SQR GPMYTX07 to:

Extract the company details from the COMPANY table and Tax Number Table MYS.
Build the ORDER BY clause based on the sorting sequence and payee sort order.
Compute the total remuneration and tax paid by using the View CP8A Details pages (GPMY_CP8A_HDR, GPMY_CP8A_DTL1, and GPMY_CP8A_DTL2 tables).
Format the data and print the form.

Global Payroll for Malaysia enables you to view and modify CP8A data online before finalizing the data. You can print the report multiple times.

CP39 Processing

Form CP39 lists all employees and the tax deductions that are made on their behalf. This is generally run and sent to the IRB monthly. To do this, the system uses SQR GPMYTX04 to:

Total the tax remitted to the IRB for all payees for the appropriate month.
Print the report.

CP159 Processing

Form CP159 reports, by month, the remuneration that is paid during the year and the projected and actual income tax that is deducted. The employer sends this report directly to the IRB. The report contains three sections: Employer Details, Deductions and Remuneration Summary, and Certification Details. To create this report, the system uses SQR GPMYTX05 to:

Retrieve the gross remuneration, taxable gross, and tax deducted from the GPMY_PR_TMP and GPMY_PR_TMP3 tables for each payee.
Store these values in an array.
Retrieve the company details from the Tax Number Table MYS.
Total the amounts for gross remuneration, taxable gross, and tax deducted.
Print the details in English or Malay.

Global Payroll for Malaysia enables you to view and modify CP159 data online before finalizing the data. You can print the report multiple times.

CP159A/PCB2 Processing

PCB2 is a letter confirming that the employer has made all of the relevant deductions for a given year. It includes the year, employee name, identity card number, income tax reference number, and employee number. This form is given to the employee who submits it to the IRB. To create this report, the system uses SQR GPMYTX08 to:

Retrieve the following information for each employee:
- Name, identity card number, and payee tax reference number.
- Tax deducted for the tax year, from the GPMY_PR_TMP and GPMY_PR_TMP3 tables.
- Receipt date and receipt number, from the GPMY_CP159_RCT table.
Print the details.
Write the data to a .lis file.

EPF Form A Processing

This is a monthly statement of EPF contributions. To produce this report, the system uses SQR GPMYEP01 to:

Set the end date of the contributing month.
Open the output file (if you select Output to Interface file on the EPF Form A page).
Join the JOB, GPMY_EPF_PYE, and NAMES tables to select payees.
Join the GPMY_EPF_ORG, GPMY_EPF_ORG_DT, and GPMY_EPF_TBL tables to select the EPF number details.
Write the file header and employer header records to the output file.
Join the GPMY_PR_TMP3 and GPMY_PR_TMP tables to determine the payee and employer EPF contributions for the month.
Retrieve the employee's national ID type.
Print the report listing payees and contribution amounts.
Prepare the output file.

SOCSO Form 2 Processing

This monthly report shows SOCSO data for all new employees that were hired during the month. To produce this report, the system uses SQR GPMYSO02 to:

Build the WHERE clause for selecting the supplied SOCSO number, if the SOCSO Reference Number field is populated.
Join the GPMY_SOC_ORG_DT, GPMY_SOC_ORG, and GPMY_SOC_TBL tables to extract the company details.
Join the GPMY_SCO_PYE, NAMES, PERSON, and PERS_DATA_EFFDT tables to select the employee details for the specified duration.
Retrieve the employee's national ID type.
Print the report.

SOCSO Form 8A Processing

This monthly report shows SOCSO contributions for all employees and their associated SOCSO reference numbers. You can produce both a printed report and a flat file. To do this, the system uses SQR GPMYSO03 to:

Join the GPMY_SOC_ORG, GPMY_SOC_ORG_DT, GPMY_SOC_TBL, GPMY_SOC_PYE, and NAMES tables to select the payees and organization unit details for the organizational link option, organizational link unit, and SOCSO reference number that is entered on the run control page.
Join the GPMY_PR_TMP3 and GPMY_PR_TMP tables to determine the total SOCSO contributions by all payees in the organizational unit for the given month.
Join the GPMY_PR_TMP3 and GPMY_PR_TMP tables to determine the total number of payees who are contributing in SOCSO for the period.
Retrieve the employees' national ID type.
Check the status of the contributing payees, if they are terminated.
Prepare the data for the output file.
Create the output file.
Print the details.

SOCSO Form 8B Processing

This monthly report shows SOCSO arrears contributions for employees. To create this report, the system uses SQR GPMYSO01 to:

Join the GPMY_SOC_ORG, GPMY_SOC_ORG_DT, GPMY_SOC_TBL, GPMY_SOC_PYE, and NAMES tables to retrieve the payee and organizational link unit details.
Join the GPMY_PR_TMP3 and GPMY_PR TMP tables to determine the total SOCSO arrears contributions for all the contributing payees in the organizational unit for the period.
Join the GPMY_PR_TMP3 and GPMY_PR_TMP tables to determine the total number of payees that made SOCSO arrears payments for the period.
Retrieve the employee's national ID type.
Check the status of the contributing payees if they are terminated.
Print the report.

SOCSO Form 3 Processing

This monthly report shows SOCSO information for all payees who were terminated during the month. To create this report, the system uses SQR GPMYSO04 to:

Build the WHERE clause for selecting the supplied SOCSO number, if the SOCSO Reference Number field is populated on the run control page.
Join the GPMY_SOC_ORG_DT and GPMY_SOC_ORG tables to retrieve the company details.
Join the GPMY_SOC_PYE, PERSONAL_DATA, NAMES, PERSON, and PERS_DATA_EFFDT tables to retrieve the payee details for the duration and SOCSO number specified.
Retrieve the employee's national ID type.
Print the report.

Form E Processing

Form E is the annual return that is completed by employers. It identifies all payees, their total remuneration, and total tax deductions for the year. To create this report, the system uses GPMYTX06 to retrieve the Form E value from the GPMY_EPL_TX_DTLS table for each employee.

If the Form E value is less than the tax year, then the payee has been previously declared. The system determines the total annual salary and the total annual tax from the TMP3 table and prints the details.

If the Form E value is 0 or equal to the current tax year, then the payee is being declared for the first time. The system determines the total annual salary and the total annual tax from the TMP3 table and prints the details. It then updates the FIRST_FORME_REPORT field of the GPMY_EPL_TX_DTLS table.

Common Elements Used in This Chapter

Organizational Link Option	Select the entity type. Options are Company, Establishment, Department, Pay Group, or Location.. This is a mandatory field.
Business Unit	Select the business unit. This is a required field when the organizational link option is Location or Department.
Tax Year	Enter the tax year for which the report is generated. This is the year of assessment, which begins on January 1 and ends on December 31.
SOCSO Reference Number	Select the SOCSO reference number for the organizational link option and organizational unit selected. If this field is left blank, all available numbers are used.
Tax Number	Select the tax reference number for the organizational link option and organizational unit.

Creating Tax Reports

This section discusses how to print CP22 and CP39 forms.

Pages Used to Create Tax Reports

Page Name	Object Name	Navigation	Usage
Print CP22	GPMY_RC_GPMYTX02	Global Payroll & Absence Mgmt, Taxes, CP22 Forms MYS	Run the GPMYTX02 SQR to create the CP22 form.
CPF 39 Forms — Payee Extract	GPMY_PR_RC	Global Payroll & Absence Mgmt, Taxes, CP39 Forms MYS, Payee Extract	Set the report parameters.
CPF 39 Forms — Print CP39 Forms	GPMY_RC_GPMYTX04	Global Payroll & Absence Mgmt, Taxes, CP39 Forms MYS, Print CP39 Forms	Run the GPMYTX04 SQR to create the CP39 form.

Printing CP39 Forms

Access the Print CP39 Forms page.

Create File

Select to create an electronic file.

Creating EPF Form A

This section explains how to print the EPF Form A.

Page Used to Create EPF Form A

Page Name	Object Name	Navigation	Usage
EPF Form A	GPMY_RC_GPMYEP01	Global Payroll & Absence Mgmt, Pension, Print EPF Form A MYS, EPF Form A	Set up report parameters for EPF Form A and select whether to read or create the EPF file.

Printing the EPF Form A

Access the EPF Form A page.

In the Report Parameters section, you must indicate whether the system creates the output file to be sent to EPF (by selecting Output to Interface file) or if it reads the input file that is provided by EPF (by selecting Input from Interface file). Enter the file name in either the Output File Name or the Input File name field.

Creating SOCSO Reports

This section lists the pages that are used to create SOCSO reports.

Pages Used to Create SOCSO Reports

Page Name	Object Name	Navigation	Usage
SOCSO Form 8A	GPMY_RC_GPMYSO03	Global Payroll & Absence Mgmt, Social Security / Insurance, Print SOCSO Form 8A MYS, SOCSO Form 8A	Run the GPMYSO03 SQR to create SOCSO Form 8A.
SOCSO Form 8B	GPMY_RC_GPMYSO01	Global Payroll & Absence Mgmt, Social Security / Insurance, Print SOCSO Form 8B MYS, SOCSO Form 8B	Run the GPMYSO01 SQR to create SOCSO Form 8B.
SOCSO Form 2	GPMY_RC_GPMYSO02	Global Payroll & Absence Mgmt, Social Security / Insurance, Print SOCSO Form 2 MYS	Run the GPMYSO02 SQR to create SOCSO Form 2.
SOCSO Form 3	GPMY_RC_GPMYSO04	Global Payroll & Absence Mgmt, Social Security / Insurance, Print SOCSO Form 3 MYS	Run the GPMYSO04 SQR to create SOCSO Form 3.

Creating Year-End Reports

This section lists the pages that are used to create year-end reports and discusses how to update CP8A salary details.

Pages Used to Create Year-End Reports

Page Name	Object Name	Navigation	Usage
Tax Receipt Table MYS	GPMY_TAX_RCPT	Global Payroll & Absence Mgmt, Year-End Processing, Tax Receipt Table MYS	Record the receipt number and total amount remitted to the IRB. This data is used by the CP159 and PCB(II) reports.
Create CP159 Data	GPMY_PR_RC_CP8A	Global Payroll & Absence Mgmt, Year-End Processing, Create CP159 Data MYS,	Create the CP159 report parameters.
View CP159 Details MYS — Personal Data	GPMY_CP159_DTLS	Global Payroll & Absence Mgmt, Year-End Processing, View CP159 Details MYS, Personal Data	View and edit the CP159 data that is produced from the Create CP159 Data process.
View CP159 Details MYS — Salary Details	GPMY_CP159_EDIT	Global Payroll & Absence Mgmt, Year-End Processing, View CP159 Details MYS, Salary Details	View and edit the CP159 data that is produced from the Create CP159 Data process.
Print CP159	GPMY_RC_GPMYTX05	Global Payroll & Absence Mgmt, Year-End Processing, Print CP159 Forms MYS,	Set the report parameters and launch the CP159 report process.
Create CP8A Data	GPMY_PR_RC_CP8A	Global Payroll & Absence Mgmt, Year-End Processing, Create CP8A Data MYS	Create the CP8A report parameters.
View CP8A Details MYS — Personal Data	GPMY_CP8A_DTLS	Global Payroll & Absence Mgmt, Year-End Processing, View CP8A Details MYS, Personal Data	View the CP8A data online before printing the report.
View CP8A Details MYS — Salary Details	GPMY_CP8A_EDIT	Global Payroll & Absence Mgmt, Year-End Processing, View CP8A Details MYS, Salary Details	Edit the CP8A data that is produced from the Create CP8A Data page.
Print CP8A Forms	GPMY_RC_GPMYTX07	Global Payroll & Absence Mgmt, Year-End Processing, Print CP8A Forms MYS	Print the CP8A form.
Finalize CP8A Details	GPMY_CP8A_FINAL	Global Payroll & Absence Mgmt, Year-End Processing, Finalize CP8A Details MYS	Finalize the CP8A data.
Payee Extract	GPMY_PR_RC	Global Payroll & Absence Mgmt, Year-End Processing, Print Form E MYS, Payee Extract	Set the launch parameters and launch the Form E report process.
Print Form E	GPMY_RC_GPMYTX06	Global Payroll & Absence Mgmt, Year-End Processing, Print Form E MYS, Print Form E	Set the launch parameters and launch the Form E report process.
Payee Extract	GPMY_PR_RC	Global Payroll & Absence Mgmt, Year-End Processing, Print PCB 2 (II) MYS, Payee Extract	Set the parameters and launch the PCB 2 (II) report process.
Print PCB 2 (II)	GPMY_RC_GPMYTX08	Global Payroll & Absence Mgmt, Year-End Processing, Print PCB 2 (II) MYS, Print PCB 2 (II)	Set the parameters and launch the PCB 2 (II) report process.

Updating CP8A and CP159 Detail Pages

Access the Personal Data and Salary Details pages.

Finalized

Select this option to finalize the values on this page. On some pages it is automatically selected when you run the finalize process. Once finalized, the page cannot be updated.

Calc Value (calculation value)

Update calculation values, if necessary.

Creating Termination Reports

This section lists the pages that are used to create termination reports.

Pages Used to Create Termination Reports

Page Name	Object Name	Navigation	Usage
Create CP21 Data	GPMY_CREATE_CP21	Global Payroll & Absence Mgmt, Termination Processing, Create CP21 Data MYS	Extract the data for the CP21 report from the result tables.
Personal Data	GPMY_CP21_DTLS	Global Payroll & Absence Mgmt, Termination Processing, View CP21 Details MYS, Personal Data	View the CP21 data before printing the form.
Salary Details	GPMY_CP21_EDIT	Global Payroll & Absence Mgmt, Termination Processing, View CP21 Details MYS, Salary Details	View the CP21 data before printing the form.
Print CP21	GPMY_RC_GPMYTX01	Global Payroll & Absence Mgmt, Termination Processing, Print CP21 Forms MYS	Run the GPMYTX01 SQR to produce the CP21 form.
Create CP22A Data	GPMY_CREATE_CP21	Global Payroll & Absence Mgmt, Termination Processing, Create CP22A Data MYS	Extracts the data for the CP22A report from the result tables.
Personal Data	GPMY_CP22A_PERS	Global Payroll & Absence Mgmt, Termination Processing, View CP22A Details MYS, Personal Data	View the CP22A data before printing the form.
Salary Details	GPMY_CP22A_SAL	Global Payroll & Absence Mgmt, Termination Processing, View CP22A Details MYS, Salary Details	View the CP22A data before printing the form.
Print CP22A Forms	GPMY_RC_GPMYTX03	Global Payroll & Absence Mgmt, Termination Processing, Print CP22A Forms MYS, Print CP22A Forms	Run the GPMYTX03 SQR to produce the CP22A form.

Finalized	Select this option to finalize the values on this page. On some pages it is automatically selected when you run the finalize process. Once finalized, the page cannot be updated.
Calc Value (calculation value)	Update calculation values, if necessary.