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
HOW TO UNPROTECT THIS EXCEL SALARY SHEET