Categories: HR

Salary Calculation Template In Excel

I have Attached Sample Salary Calculation Template.


Salary Calculation Template

GROSS – Cost to Company		Rs.	Chq Amt Every Month	Rs.	Gets	Will get in Rs.
Basic + DA		8000.00	Basic + DA	8,000.00	Take Home Amt	12,040.00
PF	12.00%	960.00	PF, 12%	(960.00)	Other accts	4,780.00
HRA		4,000.00	HRA	4,000.00	Prof tax	200.00
ESIC	4.75%	–	ESIC, 1.75%	–	Total	17,020.00
LTA	5.00%	400.00	Conveyance	800.00	Annual CTC	204,240.00
Medical	5.00%	400.00	Prof Tax	(200.00)
Conveyance		800.00	Helper allowance	–	Name
Outfit		100.00	Family welfare	200.00	Division
Helper allowance		–	Education allowance	200.00	Grade
Family welfare		200.00		12,040.00	Qualification:
Gratuity	4.50%	360.00			DOJ
Bonus	20.00%	1,600.00			Effective
Education		200.00	Added to other accounts		Position
S.A.	10.00%	–	PF, 24%	1,920.00	Location
Food coupons		–	ESIC, 6.5%	–
		17,020.00	LTA, 5%	400.00
		204,240.00	Bonus, 20%	1,600.00
			Outfit	100.00
PF deposited in PF department			Medical, 5%	400.00
ESIC deposited with ESIC dept			Gratuity 4.5%	360.00
Prof tax paid to PT department			Food Coupons	–	549
LTA payable in August				4,780.00	99
Medical if appl.payable in August
Outfit if appl. payable in January
Bonus paid at the time of Diwali
Gratuity will be paid after 5 yrs services

Note: Your Compensation is personal to you and confidential between you and the Company.
You are requested not to share details of the same with others, within or outside the Company.
Eventhough LTA, Medical, & Bonus are the part of salary package, These will be payable only if employee completes one year of service


Authorised Signatory

Hrformats

Mangesh Rane says:

September 26, 2014 at 12:00 PM

Need be required diwali bonus calcultion as per the bonus act
HASAN says:

October 20, 2014 at 11:19 AM

Need be required diwali bonus calcultion
Shahla says:

October 23, 2015 at 6:09 AM

for IT company