Gratuity Valuation Tool

1Employee census data

Upload the employee data file the valuation will be run on, or load a sample census to explore the tool.

Click to upload or drag and drop a CSV file

Required columns — see format below

Column	Required	Format	Example
EmployeeID	Yes	Text	E001
Name	Yes	Text	A. Sharma
DateOfBirth	Yes	YYYY-MM-DD	1985-04-12
DateOfJoining	Yes	YYYY-MM-DD	2014-07-01
Gender	Yes	M / F	F
MonthlySalary	Yes	Number (Basic + DA, ₹/month)	68000
RetirementAge	No	Number (defaults to assumption below)	58

2Valuation date & actuarial assumptions

Financial and demographic assumptions used in the Projected Unit Credit calculation. Defaults are illustrative — the appointed actuary should set assumptions with reference to the entity's own experience and current market data.

Entity / client name

Reporting standard

Valuation date

Discount rate (p.a.)

Market yield on government bonds of currency & term consistent with the obligation.

Salary escalation rate (p.a.)

Expected future salary increases — inflation, seniority, promotion.

Attrition / withdrawal rate (p.a.)

Flat annual rate applied at all ages (simplified — a select/ultimate scale can be substituted).

Normal retirement age

Mortality basis

For statutory certification, substitute the published IALM (2012–14) Ult. table.

Gratuity Act divisor

Statutory ceiling

Cap gratuity payable at the statutory ceiling

Ceiling amount (₹)

Optional — prior-year figures (for full DBO reconciliation & funded status)

Opening DBO (₹) — leave blank if first valuation

Benefits paid during the year (₹)

Past service cost (plan amendment, ₹)

Fair value of plan assets, opening (₹)

Expected return on plan assets (p.a. %)

Contributions during the year (₹)