Sample Data

Actuarial Valuation of Gratuity & Leave Liability under AS-15

Individual employee’s sample data in Excel as on date of valuation (D.O.V) March 31, 2009.


click to enlarge

Note:

  • Worksheet should not contain more then 8 column, hidden row, hidden column, formula, remarks (resigned from the company etc), blank cell, blank row/ column etc.
  • Worksheet should be in MS Office 2003 or lower format. MS Office 2007 don’t work. Use “save as type” while using “save” option and select “word 97 -2003 & 6.0”.
  • If you are getting done the valuation first time then Pl send same information in different worksheet as on closing date (31st March 2008) of previous financial year to get the values at the time of beginning of current valuation period. This is mandatory for revised AS15. Charges will be extra to carry out valuation for beginning of period.
  • Date should be in Excel date format -mm/dd/yy. In date format comma, dot & dash should not be used.
  • Please prepare single work sheet of employees detail for Gratuity & Leave valuation purpose as per example..
  • Create 2 columns for salary in same work sheet for gratuity salary and leave salary
  • Do not provide information like HRA, Bonus, Conveyance, DA etc. Create single column of monthly salary amount on which calculation to be carried out.
  • Do not provide information like father’s name, designation, employee code, nature of job etc under employee’s detail.
  • Provide more than 1 excels work sheet if different certificate is to be issued for different category/ division/ group & period. Valuation charges will depend upon number of certificates/ valuation.
  • Actuarial Consultant for Actuarial valuation of Gratuity Liability
  • Actuarial Consultant for Actuarial valuation of Leave encashment Liability
  • Actuarial Consultant for Actuarial valuation of earned leave/ leave benefits
  • Actuarial Consultant for Actuarial valuation of sick leave benefits
  • Actuarial Consultant for Actuarial valuation of Pension
  • Actuarial Consultant for Actuarial valuation of Interest rate guarantee for provident fund
  • Actuarial Consultant for Actuarial valuation of LTC
  • Actuarial Consultant for Actuarial valuation of Long term service awards
  • And other defined benefits plan

Actuarial Consultants