• Pli Calculator 2019 Excel Download Software
• Pli Calculator 2019 Excel Downloadable
• Pli Calculator 2019 Excel Download Free
• Pli Calculator 2019 Excel Download File

• Salary Structure Format In Excel With Pli - XLS Download. How to calculate and make his ctc. In ms excel with formulas - xls download (Archive).
• Support Office (32/64): Office 365 and Excel / Office 2007, 2010, 2013, 2016 and 2019. Support System (32/64): Windows 7-10, Vista, Windows Server 2008-2019, Citrix System / Windows Terminal Server. It's not compatible with MAC! We guarantee that our software is virus-free, trojan-free, does not obtain user data and does not upload user.

Click here to download the excel calculation tool for PLI Maturity/Loan cases. 2019 at 12:26 AM. PLI RPLI Service Tax Calculator for McCamish by Po. Download this app from Microsoft Store for Windows 10, Windows 8.1. See screenshots, read the latest customer reviews, and compare ratings for Calculator Free.

Dear Sir,
kindly suggest me what is the basic formula for calculation and make the proper ctc of any employee in which i would like to give him take home salary -19000 p.m and ctc 25000 p.m
give me right suggestion how to calculate and make his ctc.
From India, Delhi
Hi Can anybody send me the salary breakup of Rs 16000/-monthly in hand. P C Sharma
From India, Haryana
Dear Sir, can anybody tell me the right formula to calculate gratuity. I also want to know what is the minimum wages at this time. Priyanka
From India, Noida

Pli Calculator 2019 Excel Download Software

Dear Priyanka Calculation for gratuity= No.of yrs worked*basic *15/26 eg if no. of yrs completed is 5.7yrs then we consider 6yrs Hope this will help you. Regards Kavita
From India, Delhi
Hi, Could you please help me with Salary breakups, as our company do not deduct any kind of PF etc. We provide Health Insurance to all our Employees. The salaries of our employees are below taxation limits.
From India, New Delhi
dear All, i need and man power and machineries pricing calculation per days/hours and mapping. thanks 00965 999 7 2005 bshafout@globaltawreed .com

Gratuity Calculator is an excel template with predefined formulas that help you easily calculate your gratuity amount. The end of service amount also known as Gratuity will be calculated according to the new rules of gratuity as per Gratuity Act in India.

Just enter your last drawn salary and total years of service and will automatically calculate your gratuity amount. Let us understand the term

What is Gratuity?

Gratuity is the end of service benefits provided by the employer to the employee for the service rendered to the organization.

An employee is entitled to get gratuity when he/she:

• Resigns
• Retires
• Laid off
• Death or Disablement

According to the Gratuity Act, an employee is paid gratuity if he/she completes a minimum service of 5 years with that particular employer.

Pli Calculator 2019 Excel Downloadable

Furthermore, in the case of death or disablement, there is no minimum eligibility period.

Disablement means the loss of the earning capacity of an employee. It is of two types; temporary disablement & permanent disablement.

Formula To Calculate Gratuity

The formula to calculate Gratuity is as follows:

Last Drawn Salary X Total Years of Service X 15/26

Last Drawn Salary: Basic Salary + Dearness Allowance (DA)

Total Years of Service: Number of years of service in a company. The mathematical rule of point will apply here in calculating the years.

Pli Calculator 2019 Excel Download Free

For example, if Mr. X has completed 5 years and 3 months then it will be considered 5 years and if it is 5 years and 6 months or above then it will be considered as 6 years.

15/26: 15 is wages for 15 days and 26 are the working days of the month. In simple terms, it is approximately a half month’s salary (Basic + DA).

Gratuity Calculator Excel Template

We have created and simple and ready-to-use excel template for Gratuity Calculator (India). Just enter only a few data and it will calculate the gratuity for you.

Pli Calculator 2019 Excel Download File

Additionally, you can download other useful HR Templates like Salary Sheet, Attendance Register, etc.

Let us discuss how to use this calculator to calculate gratuity.

How To Use This Gratuity Calculator (India)?

This template consists of 2 sections;

1. Personal Information
2. Gratuity Calculations

1. Personal Information

In this section, you need to enter the name and your organization type. It can be a government organization or non-government organization.

2. Gratuity Calculations

To calculate gratuity, you need to enter 2 details;

• Last drawn salary and
• Total years of service.

Applying the above-mentioned formula, the template calculates the gratuity for the given years of service.

The last drawn salary will not be a total take-home salary. It is only the basic salary in addition to the dearness allowance.

If your years of service are less than 5 years the gratuity calculator will display NIL.

Disclaimer: This template has been created for educational purpose. Kindly consult required authority before finalizing the gratuity amount.

We thank our readers for liking, sharing and following us on various social media platforms.

If you have any queries or suggestions, please share in the comment section below. We will be more than happy to assist you.