Salary Calculation sheet in excel
I have attached the format Salary Calculation sheet in excel
| 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 | ||||
Click Here to Download Format salary%20structure2%20-%20exe
i want 15000 rs salary slip