HR Letter Formats
Free Human Resource Forms, Formats & Questionnaires

Search Results: salary break up xls

Salary Slip Format Without ESI And PF

 I have Attached Salary Slip Without ESI And PF

 SALARY STRUCTURE
 BREAK UP OF THE SALARY  :  Break upto Gross of 71K – Above
Salary Sheet Basic :  Rs.              7,632
HRA @ 50% of basic :  Rs.              3,816
Conveyance :  Rs.                 800
E.A :  Rs.                  –
Helper Allowance :  Rs.              1,145
Others :  Rs.              2,357
A Gross :  Rs.              15,750
Reimbursements Medical :  Rs.              1,250
LTA :  Rs.                  –
B Reimbursements :  Rs.                1,250
C = A+B Monthly Gross :  Rs.              17,000
Leave Salary :
Liabilities P.F. :  Rs.                 780
E.S.I. :  Rs.                  –
Gratuity :  Rs.                 314
Bonus :  Rs.              1,417
Car Fuel/Driver :
Ex-Gratia :  Rs.                  –
D Liabilities :  Rs.                2,510
Choice Pay Sodexho Coupons :  Rs.                  –
Driver Allowance :  Rs.                  –
Petrol Reimburse :  Rs.                  –
E Choice Salary :  Rs.                       –
F = C+D+ E CTC :  Rs.              19,510
Deductions P.F. :  Rs.                 780
E.S.I. :  Rs.                  –
PT  Rs.                 200
Income Tax :  Rs.                  –
F Deductions :  Rs.                    980
G = C-F NET TAKE :  Rs.              16,020
ANNUAL CTC  Rs.            234,124

 

Click Here To Download Salary Slip Without ESI And PF

Search Sample Formats:

9 comments - What do you think?
Posted by Hrformats - January 27, 2012 at 11:40 AM

Categories: HR   Tags: , , , , ,

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

2 comments - What do you think?
Posted by Hrformats - January 25, 2012 at 11:17 AM

Categories: HR   Tags: , , ,

Salary Slip Break for May 2010 for CTC

I Have Attached Salary Slip Break for May 2010 for CTC

Particulars Amount Deductions Net
Rs. Rs. Rs.
Basic Salary 6789
HRA 3394
Other Allowance 3394
Gross salary 13577
Provident Fund – Employer’s Contribution , Employee’s Contribution 12% on Rs.6500/- 780 780
E.S.I – Employer’s Contribution @ 4.75 % on Gross Salary , Employee’s Contribution @ 1.75 % on Gross Salary 645 238 12559
Bonus 566
CTC PER MONTH 15568
Note :
1.Earned Leave will be enchashed as per the Company’s Rules.
2.Gratuity will be payable as per the Payment of Gratuity Act,1972.
3. Income Tax will be applicable as per the Income Tax Act.
4. Allowances include conveyance from place of residence to place of work and cell phone reimbursement
   as per policy of the company.
Particulars Amount
Rs.
CTC PER MONTH 15568
Earned Leave will be enchashed only as per the Company’s Rules. 283
Gratuity will be payable only as per the Payment of Gratuity Act,1972. 326
Super CTC Per Month 16177

Click Here To Download Salary Slip Break

2 comments - What do you think?
Posted by Hrformats - January 20, 2012 at 10:10 AM

Categories: HR   Tags:

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

Be the first to comment - What do you think?
Posted by Hrformats - December 29, 2011 at 6:15 AM

Categories: HR   Tags:

Salary Slip Format With ESI and PF

I have attached the format of Salary slip without ESI and PF

 SALARY STRUCTURE
 BREAK UP OF THE SALARY  :  Break upto Gross of 71K – Above
Salary Sheet Basic :  Rs.              7,632
HRA @ 50% of basic :  Rs.              3,816
Conveyance :  Rs.                 800
E.A :  Rs.                  –
Helper Allowance :  Rs.              1,145
Others :  Rs.              2,357
A Gross :  Rs.              15,750
Reimbursements Medical :  Rs.              1,250
LTA :  Rs.                  –
B Reimbursements :  Rs.                1,250
C = A+B Monthly Gross :  Rs.              17,000 ç Enter The gross here
Leave Salary :
Liabilities P.F. :  Rs.                 780
E.S.I. :  Rs.                  –
Gratuity :  Rs.                 314
Bonus :  Rs.              1,417
Car Fuel/Driver :
Ex-Gratia :  Rs.                  –
D Liabilities :  Rs.                2,510
Choice Pay Sodexho Coupons :  Rs.                  –
Driver Allowance :  Rs.                  –
Petrol Reimburse :  Rs.                  –
E Choice Salary :  Rs.                       –
F = C+D+ E CTC :  Rs.              19,510
Deductions P.F. :  Rs.                 780
E.S.I. :  Rs.                  –
PT  Rs.                 200
Income Tax :  Rs.                  –
F Deductions :  Rs.                    980
G = C-F NET TAKE :  Rs.              16,020
ANNUAL CTC  Rs.            234,124

 

Click Here to Download Salary Slip Format With ESI and PF in Excel

1 comment - What do you think?
Posted by Hrformats - December 26, 2011 at 9:24 AM

Categories: HR   Tags:

Salary Calculation sheet in excel

I have attached the format Salary Calculation sheet in excel

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

 

Click Here to Download Format salary%20structure2%20-%20exe

 

 

 

 

 

 

 

 

 

 

1 comment - What do you think?
Posted by Hrformats - December 22, 2011 at 11:34 AM

Categories: HR   Tags: , ,

CTC Breakup of 16 Lakh

Find the attached file of Salary Breakup for Rs.1600000L CTC.

Click Here To Download CTC Breakup for 1600000L

3 comments - What do you think?
Posted by Hrformats - September 21, 2011 at 6:02 AM

Categories: Salary Format, Salary Management   Tags:

New Staff Induction Check List Format

Please Find The Attachment Employee Induction Check List

Click Here To Download Employee Induction Check List

 

COMPANY NAME
EMPLOYEE INDUCTION CHECK LIST
EMPLOYEE DETAILS (HR DEPARTMENT)
Employee Name :
Designation :
Employee Code :
Department/Location :
Date of Joining :
Date of Induction :
Personal Documentation Department Responsible Status
Photograph Y N
Educational & Experience Certificates Y N
Emergency Contact Details Y N
Joining Report Y N
Proof of Permanent & Present Address Y N
Birth Certificate & National ID Card Y N
NOC/Releiving Letter, if applicable Y N
Referee Details Y N
Employment Terms & Conditions Department Responsible Status
Letter of Employment Issued & Signed Y N
Probationary Period & Confirmation Y N
Hours of Work & Breaks Y N
Payment Day & Procedures Y N
Leave Entitlements & Benfits Y N
Grievance & Disciplinary Procedures Y N
Termination/Separation Procedures Y N
Health, Safety & Security Department Responsible Status
Awareness of Safety & Hazards Y N
Reporting of Accidents & Hazards Y N
Emergency Procedures Y N
First Aid Procedures Y N
Personal & Workplace Hygiene Y N
Security Norms & Procedures Y N
Introduction to the Company Department Responsible Status
Organizational History & Background Y N
Vision/Mission of the Company Y N
Functional Organogram Y N
Local & International Structure, if applicable Y N
Top Management Authorities Y N
Organizational Culture Y N
Introduction to Products Y N
Salary, Welfare & Benefits Department Responsible Status
Salary Structure & Others Y N
Attendance & Salary Administration Y N
Bank Account Opening Y N
Issuance of Mobile Sim/Telephone Y N
Travelling, Conveyance & Allowances Y N
Insurance & Medical Facilities Y N
Canteen Facility & Meal Breaks Y N
Leave Policy & Procedures Y N
Performance Management System Y N
Increment, Promotion & Pay Reviews Y N
Loan/Financial Assistence Y N
Recognition, Awards & Incentives Y N
PF, Gratuaty & Retirement Scheme Y N
Code of Conduct Department Responsible Status
General Appearance & Dress Code Y N
Attendance & Punctuality Management Y N
Poor Performance & Negligence Y N
Telephone, Computer & Internet Use Y N
Office Cleanliness & Responsibility Y N
Water & Light Saving Y N
Tobacco & Alcohol Subatances Y N
Sexual Harassment Y N
Get-Together/Celebration Events Y N
Use of Job Specific Equipment, Tools, Assets Y N
Care of Issued Items Y N
Safety Precautions Y N
Stationary & Assets Department Responsible Status
Laptop/PC/Mobile Set/Pendrive Y N
Identity & Business Card Y N
Stationary & Supplies Y N
Work Station & Desk Y N
Mail ID, Mobile Number Y N
Induction to the Job  & Procedure Department Responsible Status
Introduction to Managers/Supervisors Y N
Introduction to Other Staffs Y N
Introduction to HR Team/Top Management Y N
Explain the Job & Responsibilities Y N
Personal Relation at Work Y N
Initial Training Plans after Induction Y N
Training & Development Y N
Performance Evaluation Procedure Y N
Departmental Functions & Aims Y N
Customer Service & Quality of Work Y N
Grievance Handling Procedures Y N
Mentoring & Counseling Y N
Note: This Form should be sent to all concerned personnel including the Inductee, atleast 2 days before the scheduled date of Induction & make sure of being present of all concerned on the same.
Signature of Manager/Supervisor Date Signature
Signature of Departmental Head Date Signature
Signature of HOD-HR/Manager Date Signature

Be the first to comment - What do you think?
Posted by Hrformats - October 14, 2013 at 10:46 AM

Categories: HR   Tags:

Format for Consolidated Pay Slip

Find attached Sheet of Salary Break Up.

Click Here To Download Salary Break UP

1 comment - What do you think?
Posted by Hrformats - September 3, 2011 at 8:20 AM

Categories: Salary Management   Tags: , ,

Format for Consolidated Pay Slip

Find attached Sheet of Salary Break Up.

Click Here To Download Salary Break up

1 comment - What do you think?
Posted by Hrformats - May 26, 2011 at 9:02 AM

Categories: HR   Tags:

« Previous Page — Next Page »