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.
If you'd like to edit individual employees, you may refer back to this guide.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article