Formula In Excel Pakistan ((exclusive)) - Gratuity Calculation

(or any period exceeding six months). To account for the standard 26-day working month used in wage calculations, the formula is: Last Drawn Gross Salary Years of Service

While manual calculations are prone to error, Microsoft Excel provides a robust platform for automating this process. In this comprehensive guide, we will walk you through the legal framework, the logic behind the calculation, and the exact Excel formulas you need to compute gratuity accurately in the Pakistani context.

The mathematical formula is:

If an employee is terminated specifically for proven misconduct (theft, harassment), the employer is not legally bound to pay gratuity. Payment Deadline: Gratuity should ideally be settled within of separation. with provincial logic or information on tax exemptions for these payments? Understanding Gratuity in Pakistan: A Simple Breakdown

This should include your basic pay plus all regular, non-contingent allowances (e.g., dearness allowance). Bonuses and irregular payments are typically excluded. gratuity calculation formula in excel pakistan

Some organizations give proportional gratuity for a part-year served beyond the last full year (e.g., 6 months or more). To add this:

Note: This second formula assumes a "30 days wages" calculation which effectively rounds up to a full month's salary per year. We will use this standard approach for our Excel guide as it is the most widely accepted in Pakistani corporate culture. (or any period exceeding six months)

Key Components Explained:

Under Pakistani labor law, an employee is entitled to for every completed year of service (or any period exceeding six months). To account for a standard 26-day working month, the official calculation is: The mathematical formula is: If an employee is