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
Bonus Calculation
I am attaching bonus calculator which has formula in the excel sheet. All that you need to do is to put the month-wise attendance and the actual salary details.
Categories: HR Tags: Bonus, Calculation
Accident Free Man Days Calculation
Accident Freeman-days = (Man days Worked for the month/No. of calendar day for month)x No. of accident free calendar days of current month. and finally calculate the data from each months summery.
Please go through the attached xls file.
Categories: HR Policies Tags: Accident, Calculation, Free, Man
ESIC, PF Calculation
Please find attached PF and ESI Basic information notes.
Categories: ESIC Challan, HR, PF Challan Tags: Calculation, ESIC
PF Calculation Queries
Please find attached PF Calculation (Samples).
Categories: HR Tags: Calculation, PF
Attrition Calculation Worksheet
Sharing Attrition Calculation Worksheet.
Categories: HR Tags: Calculation, Worksheet
Attrition Calculation
Attrition rate is been calculated on the basis of available Manpower and number of resigned employees in the month…
The formula is…
Attrition Rate = Number of Resigned/Available Manpower*100
For example if in the previous month the manpower was 100. During that month 10 resigned and 20 recruited.. So the available manpower would be 100-10+20 = 110
Attrition rate = 10/110*100
Categories: HR Tags: Attrition, Calculation
Tax Calculation
Please find enclose herewith Tax Calculation File.
Categories: Tax Format Tags: Calculation, Tax
Categories: Tax Format Tags: Calculation, Format, Tax
Age Character Calculation
Have a look on the attached file to calculate Age & Character of a person with his/her Date of Birth.
Categories: HR Tags: Age, Calculation, Character