Salary Calculation Sheet in Excel

January 25, 2012

 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

Previous Story

Warning Letter Format

Next Story

Forms under AP Factory Rules

Latest from HR

Go toTop

Don't Miss