Run a payroll using a bulk CSV upload
On this page
This article is for Owners and admins who use Humanised
Overview
-
Learn how to run a payroll by uploading all pay details in one go (bulk CSV upload)
Step 1 – Update employee details and company settings (if applicable)
-
Onboard any new employees
-
Fill in any missing mandatory data
-
Update any new increments
-
Update any new pay items (incentives, variable allowances etc)
-
Remove any irrelevant payruns
-
If there are any changes to payroll policy, make those changes in organizational settings
Now you’ll have an up-to-date database to run payrolls from.
Step 2 – prepare the CSV file
Use this template and fill in the payroll tab with your employee’s salary details for the relevant month
1. Employee name & employee ID
Humanised uses the employee’s name and employee ID to make sure correct salary details are identified for the corresponding employee. You can export a sheet with these details of all existing employees from the contacts section
2. Pay item tags
Humanised uses a few tags to identify different types of pay items. You can use the following format to add new pay items using these tags.
a. Basic Salary
Simply type basic salary as the column header Eg:- basic salary
b. Fixed allowance
fixed allowance: name of the allowance. Eg : – fixed allowance:Mobile Allowance
c. Variable allowance
allowance: name of the allowance. Eg:- allowance: Travel Allowance
d. Non – cash benefits
e. Lump sum payments
lump sum: name of the payment. Eg:- lump sum: Bonus
f. Deductions
deduction: name of the deduction. Eg:- deduction: Loan Installment
g. No pay time
no pay. Eg:- No pay
h. Overtime (time)
OT: overtime type. Eg:- OT: Normal Overtime
i. Extra fields in pay slip
You can add up to 6 extra fields that will appear at the bottom of your payslip. Payslip: Total Leave entitlement
3. Save as CSV
Once you are done, save the excel sheet in CSV UTF 8 file format. This is the file you will upload to humanised
Step 3 – Create draft payrun
-
Go to payroll and click on “Start payroll using CSV” button.
-
Go to payroll and click on “Start payroll using CSV” button.
-
A page will load named, “Payrun using CSV”
-
Upload the CSV file you just prepared
-
Humanised will display all you data in a table, where you can rectify and errors or mistakes before creating the payrun. (This is only to edit the uploaded data, draft payruns can be updated seperately)
-
Click on “create draft” and and fill the form that appears with the month, year, type of payrun and a name for the payrun for your convenience.
-
Click on “create draft” and and fill the form that appears with the month, year, type of payrun and a name for the payrun for your convenience.
First the system will calculate EPF, ETF and APIT automatically according to your preset preferences. Then it’ll make the necessary deductions and statutory calculations to come up with the “net salary” and “cost to company” for each employee and for the whole organization. If there are any stamp duties, pro-rated salaries or any other additional calculations set up by you all those will also get added as pay items to relevant emplyees
Step 4 – Review and complete payrun
-
You can review the draft payrun to ensure everything is in order. Click on “edit” to make changes to any employee’s pay details
-
Add or update pay items
-
Click on “Save”, and “Generate payroll” in the next window
Step 5 – Pay your employee salaries!
The payroll summary page will load with the following information.
-
Use the bank transfer file to pay your employee salaries
-
Remit EPF, ETF and APIT amounts to relevant institutions
-
Send payslips via email
-
Download the payroll summary
What’s next?:
Was this article helpful?
Your feedback helps us improve these guides.
Thanks for the feedback — glad it helped.
Still need a hand?
A real human on our team will look at your ticket and come back to you — typically within a few working hours.
Open a support ticket