Categories: HR

Salary Calculation Sheet in Excel

 I have Attached 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 Calculation sheet in excel

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…

2 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