[SG] Running Your First Payroll [Step 2 of 4]

Modified on Fri, 08 Mar 2024 at 05:46 PM

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 - W]

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. ID Type*
‣ NRIC FIN (Foreign Indentification No.)
‣ Immigration File Ref. No.
‣ Work Permit No.
‣ Malaysian I/C
‣ Passport No.
I. NRIC/FIN/Passport Number*
J. Passport Expiry Date (dd/mm/yyyy)
K. Residency Status*
‣ Singaporean
‣ Singapore PR
‣ Foreigner (S-Pass, EP, PEP, Work Permit)
L. PR Start Date (dd/mm/yyyy)
M. Race*
‣ Chinese
‣ Indian
‣ Malay
‣ Eurasian
‣ Other
N. Race (Other)
O. Religion*
‣ Buddhist
‣ Christian
‣ Catholic
‣ Freethinker
‣ Hindu
‣ Muslim
‣ Sikh
‣ Taoist
‣ Other
P. Religion (Other)
Q. Will this employee be drawing salary, fee or allowances?*
‣ Yes
‣ No
R. Give this employee online access?* [Email field in column D must be filled]
‣ Yes
‣ No
S. Mobile Country Code
T. Mobile Number
U. Address 1
V. Address 2
W. Postal Code




Current Employment Details (Column Y - AA)

X. Designation* (Example: Marketing Executive, HR Executive, Sales Manager etc)
Y. Employment Status*
‣ Probation
‣ Confirmed
‣ Interns Temp / Contract Staff
‣ Resigned
‣ Dismissed
Z. Date Joined* (DD/MM/YYYY)




Working Hours Settings (Column AA - AV)

AA. 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.]
AB. 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]
AC. Working Hours in a Day*


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


AD. Start Time (HH:MM)
AE. End Time (HH:MM)
AF. Pay Rate (hourly rate)
AG - AM. Monday to Sunday
‣ Yes
                ‣ No


[Column AN - AT] is only applicable if Working Hours type is Fixed


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


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


AU. Total Hours Per Week
AV. Total Working Days Per Week


Employee Payroll Info (Column AW -
AW. Salary Currency*
AX. Salary Amount
[Note: If Basic Salary type is Hourly, enter the hourly rate in this field)
AY. Payment Frequency*
‣ Salary paid once a month
‣ Salary paid twice a month
AZ. Payment Mode*
‣ Interbank GIRO
‣ Cheque
‣ Cash
BA. Bank
‣ Bank of China Limited
‣ Far Eastern Bank
‣ HSBC Corporate
‣ HSBC Personal
‣ Maybank
‣ Standard Chartered
‣ State Bank of India
BB. Branch Code
BC. Account Number
BD - BH. Statutory Funds [CDAC ECF MBMF SINDA SDL]
‣ Yes
‣ No
BI. Payslip Email Notification
‣ Yes
‣ No
BJ. Receive Passworded Payslip
‣ Yes
‣ No
BK. Payslip Password
[Default password is employee's 
National ID / NRIC / 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: 



Step 3: 

Select Add Employees


Step 4:

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


 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

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article