Salary Break Up in Excel Sheet

July 11, 2012

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

6 Comments

  1. Dear Sir,

    This salary break up i didn’t understand, as my salary of Rs.11500PM, how to break up salary, please send the details as soon as possible,

    Thanks and Regards,

    Yours,

    Naveen

Leave a Reply

Previous Story

Mindset and How to Develop a Growth Mindset

Next Story

Employees Provident Fund Form No 19 and 10C

Latest from HR

Go toTop

Don't Miss