How to migrate employee income tax group?
Column Name | Description | Remark |
|---|---|---|
| Employee Number | Employee Identified Number | Compulsory. |
| Employee Name | Employee Name | Compulsory. |
| Effective Year | Effective Year | Compulsory. Effective year of the income tax group assigned to. |
| Effective Month | Effective Month | Compulsory. Effective year of the income tax group assigned to. |
| Status | Status | Compulsory. Define the employee status with Resident, Non Resident, Return Expert Program (REP) or Knowledge Worker (IRDA). |
| Marital Status | Marital Status | Compulsory. |
| Disable Individual | Disable Individual | Compulsory. Y/N |
Disable Spouse | Disable Spouse | Compulsory. Y/N |
| No of Full Relief for Children Under Age 18 | No of children under age 18 with 100% relief | Optional. |
| No of Half Relief for Children Under Age 18 | No of children under age 18with 50% relief | Optional. |
| No of Full Relief for Children Above Age 18 and Studying included Matriculation and Certificate | No of Children Above Age 18 and Studying included Matriculation and Certificate with 100% relief | Optional. |
| No of Half Relief for Children Above Age 18 and Studying included Matriculation and Certificate | No of Children Above Age 18 and Studying included Matriculation and Certificate with 100% relief | Optional. |
| No of Full Relief for Children Above Age 18 and Studying Full Time in Diploma Level Onwards Malaysia or Degree Level Onwards Abroad | No of Children Above Age 18 and Studying Full Time in Diploma Level Onwards Malaysia or Degree Level Onwards Abroad with 100% relief | Optional. |
| No of Half Relief for Children Above Age 18 and Studying Full Time in Diploma Level Onwards Malaysia or Degree Level Onwards Abroad | No of Children Above Age 18 and Studying Full Time in Diploma Level Onwards Malaysia or Degree Level Onwards Abroad with 50% relief | Optional. |
| No of Full Relief for Disabled Children | No of Disabled Children with 100% relief | Optional. |
| No of Half Relief for Disabled Children | No of Disabled Children with 50% relief | Optional. |
| No of Full Relief for Disabled Children Studying in Diploma or Higher Level Malaysia or its Equivalent Abroad | No of Disabled Children Studying in Diploma or Higher Level Malaysia or its Equivalent Abroad with 100% relief | Optional. |
| No of Half Relief for Disabled Children Studying in Diploma or Higher Level Malaysia or its Equivalent Abroad | No of Disabled Children Studying in Diploma or Higher Level Malaysia or its Equivalent Abroad with 50% relief | Optional. |
| Tax Paid by Employer Setup | Tax paid by employer setup | Optional. Select from list. Either by Formula or Fix Value. Only applicable to tax paid by employer. |
| Percentage of Tax Paybable by Employer | Percentage Tax Paid By Employer | Optional. Only applicable to tax paid by employer. |
| Fixed Amount of Tax Paybable by Employer | Fixed Amount Tax Paid By Employer | Optional. Only applicable to tax paid by employer. |
| Rounding of Tax Paid by Employer | Rounding of Tax Paid by Employer | Optional. The rounding only applied to percentage tax paid by employer. |
| Period 1 | Employer Pay Tax Period 1 | Optional. |
| Period 2 | Employer Pay Tax Period 2 | Optional. |
| Period 3 | Employer Pay Tax Period 3 | Optional. |
| Period 4 | Employer Pay Tax Period 4 | Optional. |
| Period 5 | Employer Pay Tax Period 5 | Optional. |
| Period 6 | Employer Pay Tax Period 5 | Optional. |
| Percentage of Auto Zakat | Auto Zakat Percentage Paid | Optional. Only applicable to auto zakat. |
| Auto Zakat | Auto Zakat Deduction Code | Optional. Only applicable to auto zakat. |
4. Save
the migration file as per default Microsoft Excel (*.xls/.xlsx) format.