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.