Adding employees by bulk (Thailand)

Modified on Tue, 25 Mar at 5:40 PM

Utilising HReasily's bulk import employee function will definitely help speed up the process for you! The following guide will help you through the various columns that needs to be filled in the template.

Yet to download the template? Download Now

Basic Info (Columns A - Y)

Employee ID
Nickname
First Name (English)
First Name (Thai)
Last Name (English)
Last Name (Thai)
Columns with dropdown must select from the dropdown.
Give this employee online access: Yes | No (email required)
Address is required

Current Employment Details (Column BB - BE)

Employment Status - Recommended to start with Probation and the Effective From will mean the Join Date

Working Hours Settings (Column BF - CB)

Basic Salary Type & Working Hours Type

Monthly Basis and Fixed AND Hourly Basis & Fixed
- Proceed to complete columns BH to CB
- Format = 08:00 means 8 hours per day

Hourly Basis and Dynamic- Proceed to enter column CC to CL
- Pay Rate (column AE) do not input the $ sign. Just the number only.

Monthly Basis and Dynamic- Proceed to column CT to CU
- Enter the total hours per week and total days per week as 7

Payroll Info (Column CV - CZ)

Salary Currency
Salary Amount
Salary Effective Date
[Note: please key in this field with format dd/mm/yyyy]
Payment Frequency
Payment Mode *
[Note: Bank details will be mandatory if you choose Interbank GIRO]

Bank Details (Column DA - DD)

Bank
Branch Name
Branch Code
Account Number

Social Security Fund Details (Column DE - DG)

Social Security Fund Conditions
Social Security Fund ID
Social Security Fund Branch

Provident Fund Details : Optional (Column DH - DM)

Provident Fund Branch
Provident Fund Conditions
PVF ID no.
Type
Employee Contribution (%)
Employer Contribution (%)

Tax Details (Column DN - DP)

Tax ID
Tax Condition
Flat Rate (%)

Past Income From Previous Employer Details (Column DQ - DT) :

(In case of YTD migration from previous employer)

Year to Date Taxable Income
Year to Date Income Tax
Year to Date Social Security Fund Contribution
Year to Date Provident Fund Employee contribution (If any)

Tax Allowance Details (Column DZ - FC) :

Recommended to input tax allowance based on data which the employee declared in their "Lor. Yor. 01 Form".

Payslip Option Details (Column FD - FE) :

Payslip Email Notification
Received Passworded Payslip

Importing Bulk Employee List

Now that you've got your template all filled up, it's time to import it into HReasily.

Step 1:

Go to Staff Directory

Step 2:

Select MANAGE EMPLOYEES

Step 3:

Select Add Employees

Step 4:

Copy the rows from the template file and paste the details into the table.

 Its recommended to copy column by column instead of the whole sheet.

If you'd like to edit individual employees, you may refer back to this guide.

Attachments (1)

xlsx

(TH) Employe....xlsx
205 KB

Was this article helpful?