Adding employees by bulk (Indonesia)

Modified on Tue, 18 Mar at 12:13 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 - K)

Full Name*
Employee ID
Nick Name
Email Address
[Note: An email address is required to grant employee's online access]
Gender*
Date of Birth*
[Note: make sure your format is dd/mm/yyyy]
Country of Nationality*
KTP/Passport*
Religion
Will this employee be drawing salary, fee or allowances?
[Note: Choose Yes or No. If you select Yes the employee will show on the payroll table as long as the join date is within the payroll month.]
Give this employee online access?
[Note: If Yes is selected, the email field in column D must be filled.]
Mobile Country Code
[Example: Indonesia (+62)]
Mobile Number*
Address 1*
Address 2*
Postal Code*

Current Employment Details (Column Q - T)

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

Working Hours Settings (Column U - AO)

Basic Salary Type & Working Hours Type

Monthly Basis and Fixed AND Hourly Basis & Fixed
- Proceed to complete columns AG to AM
- Format = 08:00 means 8 hours per day
Monthly Basis and Dynamic- Proceed to column AN to AO
- Enter the total hours per week and total days per week
Hourly Basis and Dynamic- Proceed to enter column Y to AF
- Pay Rate (column Y) do not input the $ sign. Just the number only.

Payroll Info (Column AP - AY)

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]

Tax and Contribution (Column AZ - BJ)

Contribution for BPJS Kesehatan
BPJS Kesehatan Number
Jaminan Hari Tua (JHT)
Jaminan Kecelakaan Kerja (JKK)
Jaminan Kematian (JK)
Jaminan Pensiun (JP)
BPJSTK Number *
Salary Type *
Does this employee have NPWP?
[Note: Employee will have to pay 20% higher tax if without NPWP]
NPWP Number
Tax Category *

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

(ID) Employe....xlsx
164 KB