Salary statement including pf,pt & esi deduction

vijayalaxmi (Sr.Accountant) (71 Points)

28 December 2013  

Hi,

I am not thorough with excel can any one prepare a format of salary statement in excel(including excel formulas) and please send it to me please. It should be in the sequence like CTC,Salary deduction for absent employees,basic salary, gross salary, PF,ESI,PT, Other deductions like salary advances,Net salary. 

thanks