Salary Break Up in Excel Sheet

I have attached standard format for break ups in salary.

NAME OF THE COMPANY
INCREMENT/ PROMOTION DETAILS AS ON _______
Emp. Name : Mr. Emp. Code :
Designation : Sr. Executive Department :
Promoted / Redesignated as : NA Transfer (if applicable)
From To
NA NA
SALARY – OUT OF ESI  (Rs./Month)
Monthly Earnings Deductions
Basic & DA 7846 PF 780
HRA 3139 PT 150
TA 800
CEA 200
Uniform Allowance 500
Sub Total 12485  (C) 930
Other Allowance 5044
Gross Earnings(A) 17529 Take Home(A-C) 16599
Other Benefits TCC (A+B) TCC (P.A.)
PF 780
Bonus 654
19,616 235,392
Medical 654
(B) 2087
Gratuity as per Act: 4608
Gross Emoluments : TCC TCC + GRAT.
235392 240000

 

Click Here To Download Salary Breakup