Categories: HR

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

Hrformats

View Comments

Recent Posts

Letter to Announce an Employee Training Session for skills improvement

Whenever a company announces employee training session for skills development then it is supposed to…

3 months ago

Example Immediate Resignation Letter for Various Reasons

If you are planning to immediately resign from your job but you can have your…

3 months ago

Sample Letter to Accept to Serve in a Honorary Position

If you have been invited to serve in an honorary position at any institution and…

3 months ago

Warning Letter for Policy Violations Template, Example

Violating the policy of the company will not be accepted by any organization and if…

3 months ago

Sample Warning Letter to Restaurant Manager Example

Whether it is poor performance or unprofessional behavior that you have experienced at the restaurant…

3 months ago

Sample Grievance Letter to Supervisor for Retaliation

If there is retaliation that you have observed in a particular team or department then…

3 months ago