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
Categories: HR Tags: Calculation, Salary, Sheet
Employee Information Sheet
A format for collecting the data from the Employee at the time of his joining which should include his Personal details, Job details, Experience, Organization worked earlier, salary drawn earlier, Reference etc.
Categories: HR Policies Tags: Employee, Information, Sheet
Employee Information Sheet
I have attached the Employee Information Sheet.
Categories: HR Tags: Employee, Information, Sheet
Daily Attendance Calculation Sheet
Here I am posting one good “Daily Attendance Sheet Format” which helps in calculating the daily attendance of the employees in the small firms.
You have to just put 1 in present days, c-offs and 0.5 in Half-days accordingly. While in beneficial leaves you have to manually calculate.
Please go through the Legend for each beneficial leaves, offs, holidays, absent etc…
Surely it will be helpful to everyone.
Categories: Attendance Format Tags: attendence, Calculation, Sheet