Sign Up Sign In
  • Payroll
  • >
  • Add Overtime amounts to payroll using CSV data

Add Overtime amounts to payroll using CSV data

Go back

This article is for owners and admins who use Humanised

Overview

  • Automatically calculate and add overtime amounts from bulk uploaded overtime times via CSV

Step 1 – Configure company settings for overtime

If you haven’t done this already, go to company settings and set up the following configurations for overtime calculations.

  • Switch on “Overtime” for the organization and select which pay categories will be considered for the overtime rate
  • Set up the overtime categories of your organization. Enter the name of the overtime item you want to use and the rate at which it should be multiplied (normal overtime, double overtime etc)

Example:

 let’s assume you set up two overtime categories, “Normal overtime” (rate =1) and “Double overtime” (rate =2) for your organization

Step 2 – Add overtime columns in CSV

This functionality is there for all our users who receive the total overtime time for the month already calculated by their clients or for all users who prefer to calculate the total overtime time for the month manually and outside the system.

Make sure to name your columns exactly with the names you have set up in company settings and keep in mind your “prefered input format” (Days/hours, days/half days/ decimal values) when filling the total overtime times for each employee for that month.

Example:

OT: Normal overtime or OT: Double overtime

Step 3 – Create a payrun

When you upload the CSV and create a payrun, the system will look for the data you have logged in the column for each employee. If there are any overtime leaves, the overtime amounts will be calculated and added to the pay details for relevant employees.

Example:

let’s imagine you are running a payroll under the following parameters, pay cycle start date – 1st of the month, Pay period – June, no.of days per month – calendar days, and overtime rate is calculated from basic salary only.

If this case if an employee named Kamal has 2 days and 4 hours of Normal overtime and a basic salary of LKR 60,000, Overtime rate per hour will be,

(60,000 basic salary /30 days/ 8 hours)*1 = 250 per hour

Therefore, for 2 days and 4 hours of overtime, his Normal overtime amount will be = LKR 5,000//

If Kamal also has 1 day of Double overtime and a basic salary of LKR 60,000, Overtime rate per hour will be,

(60,000 basic salary /30 days/ 8 hours)*2 = 500 per hour

Therefore, for 1 day of overtime, his Double overtime amount will be = LKR 4,000//

What's next?:

Add overtime amounts to payroll using time attendance data

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