Sign Up Sign In
  • Payroll
  • >
  • Run a payroll using a bulk CSV upload

Run a payroll using a bulk CSV upload

Go back

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
non cash benefits: name of the benefit. Eg:- non cash benefits:Company Housing
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

Properly filled CSV template
Figure 1 - Properly filled CSV template

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.
Start payroll using CSV
Figure 2 - Create payrun using CSV
  • 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
Add update pay items
Figure 3 - Add and update pay items

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?:

Rerunning a payrun explained

Related Topics

Unable to find what you are looking for?

Raise a support ticket here. One of our team members will get back to you soon.

Open a Ticket

Copyrights 2023 ©. All Rights Reserved.

Payroll
Process staff payroll on time accurately with Humanised Payroll.
Leave Coming Soon
Streamline leave management and ensure happier staff and productivity boosts.
Digital Contracts Beta
Valid, compliant HR and employment contracts for Sri Lankan small businesses.
Timesheets Coming Soon
Timesheet uploads to accurately record hours worked, auto-linked to payroll.
Expenses
Monitor and process expense reimbursements, auto-linked to payroll.

Struggling to Run Staff Payroll On Time?

Humanised is a cloud-based payroll software for Sri Lankan small businesses.

Try it for free
Small Business Guide on 12 Pay Items to Consider in The Payroll Process in Sri Lanka
A full exploration of each pay item to consider when running payroll for your staff.
Run Your Payroll in 5 Seconds Coming Soon
Process your payroll end-to-end from salary calculations to generating your bulk bank transfer file in mere seconds.

View All Resources

Payroll Service Companies in Sri Lanka
 
A comprehensive list of the island’s payroll service providers including top Chartered Accountancy firms.
Free Contract Templates
A range of HR & employment contract templates for you to download and customize as per your business’s needs.
Blogs.
Digital Contracts in Sri Lanka
A Valid, Legal and Accepted Electronic Document in HR and Business Agreements Locally
Cloud-Based or Desktop Payroll Software
Explore What Best Fits Your Payroll Requirement

View All Blogs

For Accountants

Sign In
Sign Up