Try for Free Sign In
  • Payroll
  • >
  • Add No pay deduction to payroll using CSV data

Add No pay deduction to payroll using CSV data

Go back

This article is for Owners and admins who use Humanised

Overview

  • Automatically calculate and add no pay deductions from bulk uploaded no pay times via CSV

Step 1 – Configure company settings for no pay

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

  • Switch on “include leave calculations in payroll” toggle and select “Bulk file upload” from below.
  • Switch on “No pay” for the organization and select which pay categories will be considered for the no pay rate

Step 2 – Add no pay column in CSV

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

Make sure to name your column as “No pay” and keeping in mind your “prefered input format” (Days/hours, days/half days/ decimal values) when filling the total, no pay time for each employee for that month.

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 no pay leaves, the no pay deduction 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 no pay rate is calculated from basic salary only.

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

60,000 basic salary /30 days/ 8 hours = 250 per hour

Therefore, for 2 days and 4 hours of no pay, his deduction will be = LKR 5,000//

What's next?:

Add Overtime amounts to payroll using CSV 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 2025 ©. All Rights Reserved.

Payroll
Process staff payroll on time accurately with Humanised Payroll.
Time & Attendance

Track work hours, sync with payroll, ensure accuracy & compliance effortlessly.

Expenses Management
Monitor and process expense reimbursements, auto-linked to payroll.
Digital Contracts
Valid, compliant HR and employment contracts for Sri Lankan small businesses.
Free Contract Templates
A range of HR & employment contract templates for you to download and customize as per your business’s needs.
Payroll Service Companies in Sri Lanka
A comprehensive list of the island’s payroll service providers including top Chartered Accountancy firms.

View All Resources

For Accountants

Simplify payroll for clients with automated, compliant, and secure processing.

Need Support?

Visit our support section and find helpful articles on managing your organisation.

View All Blogs

About Us

Contact Us

Sign In
Try for Free