Utilizing 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 - O]

A. Full Name*
B. Employee ID*
C. Nick Name
D. Email Address
[Note: An email address is required to grant employee's online access in column R]
E. Gender*
F. Date of Birth*
G. Country of Nationality*
H. IC/Passport*
I. Will this employee be drawing salary, fee or allowances?
‣ Yes
‣ No
J. Give this employee online access?* [Email field in column D must be filled]
‣ Yes
‣ No
K. Mobile Country Code
L. Mobile Number
M. Address 1
N. Address 2
O. Postal Code

________________________________

Employment Details [Columns P - S]

P. Designation * (Example: Marketing Executive, HR Executive, Sales Manager etc)
Q. Employment Status*
‣ Probation
‣ Confirmed
‣ Interns
‣ Temp / Contract Staff
‣ Resigned
‣ Dismissed
‣ Consultant
R. Date Joined * (dd/mm/yyyy)

S. Effective From *

________________________________

Working Hours Settings (Column T - AO)

T. Basic Salary Type*
‣ Monthly
[Commonly used for executive level employees. Salary calculates based on total
working days]
‣ Hourly
[Commonly used for blue collar employees. Salary calculates based on total
working hours.]
U. Working Hours Type*
‣ Fixed
[Note: Fixed work hours require employees to clock-in/out within a designated
time slot. Example: 9am - 6pm, Mon to Fri.]
‣ Dynamic
[Note: Dynamic work hours measures total number of working hours in a week]
V. Working Hours in a Day*

[Column X - AG] only applicable if Basic Salary Type is Hourly AND Working Hours Type is Dynamic

W. Start Time (HH:MM)
X. End Time (HH:MM)
Y. Pay Rate (hourly rate)
Z - AF. Monday to Sunday
‣ Yes
‣ No

[Column AG - AM] is only applicable if Working Hours type is Fixed

AG - AM. Monday to Sunday [HH:MM]
[Note: This is the start time of business operation hours]

[Column AN - AO] is only applicable if Basic Salary Type is Monthly AND Working Hours Type is Dynamic

AN. Total Hours Per Week
AO. Total Working Days Per Week

________________________________

Employee Payroll Info (Column AP - BI)

AP. Salary Currency*
AQ. Salary Amount
[Note: If Basic Salary type is Hourly, enter the hourly rate in this field)
AR. Payment Frequency*
‣ Salary paid once a month
AS. Payment Mode*
‣ Interbank GIRO
‣ Cheque
‣ Cash
AT. Bank

AU. Branch Swift Code *
AV. Account Number

AW. Remove Signatures From Payslip

‣ Yes
‣ No
AX. Payslip Email Notification
‣ Yes
‣ No
AY. Receive Passworded Payslip
‣ Yes
‣ No
AZ. Payslip Password
[Default password is employee's IC / Passport No]

________________________________

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:

In the table, simply copy all rows from the template sheet and paste them in the table provided.

________________________________

Now that you've successfully imported all your employees, we can go ahead and indicate how you'll be paying your employees by updating your company payroll info.

Running Your First Payroll [Step 3 of 4]

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

Did this answer your question?