Categories: HR

Salary Calculation sheet in excel

I Have attached the format Salary Calculation sheet in excel

FOR GENERAL STAFF
INPUT HERE TOTAL CTC   = 9001
XYZ LTD.
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
SR. MANAGER (HR.) BUSINESS HEAD

 

Click Here TO Download Salary Structure2

Hrformats

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