Salary Calculation Sheet in Excel

 I have Attached Salary Calculation Sheet in Excel

FOR GENERAL STAFF
INPUT HERE TOTAL CTC   = 9001
XYZ LTD.
Name: Grade: Revised
Design: D.O.J.: Grade:
E.Code: Design:
Deptt.: D.O. Inc.: w.e.f.:
SALARY BREAK UP
(Amt.in Rs.)
S.No. Description Existing Increment Revised salary Remarks
salary w.e.f. w.e.f.
1 Basic Pay 4428
2 HRA 40% of Basic Pay 1771
3 Conv.Allow 15% of Basic Pay 664
4 C.E.A 5% of Basic Pay 221
5 Uniform Maint. Allow 500
GROSS AMOUNT 7584
6 P.F. 531
7 Bonus 886
TOTAL CTC 9001
SR. MANAGER (HR.) BUSINESS HEAD

 

Click Here To Download Salary Calculation sheet in excel