Posts tagged "Salary"

Salary Calculation Template In Excel

I have Attached Sample Salary Calculation Template.

 

Salary Calculation Template
GROSS – Cost to Company Rs. Chq Amt Every Month Rs. Gets Will get in Rs.
Basic + DA 8000.00 Basic + DA     8,000.00 Take Home Amt                   12,040.00
PF 12.00%           960.00 PF, 12%       (960.00) Other accts                      4,780.00
HRA        4,000.00 HRA     4,000.00 Prof tax                         200.00
ESIC 4.75%                    – ESIC, 1.75%                  – Total                   17,020.00
LTA 5.00%           400.00 Conveyance         800.00 Annual CTC                 204,240.00
Medical 5.00%           400.00 Prof Tax       (200.00)
Conveyance           800.00 Helper allowance                  – Name
Outfit           100.00 Family welfare         200.00 Division
Helper allowance                    – Education allowance         200.00 Grade
Family welfare           200.00   12,040.00 Qualification:
Gratuity 4.50%           360.00 DOJ
Bonus 20.00%        1,600.00 Effective
Education           200.00 Added to other accounts Position
S.A. 10.00%                    – PF, 24%     1,920.00 Location
Food coupons                    – ESIC, 6.5%                  –
    17,020.00 LTA, 5%         400.00
  204,240.00 Bonus, 20%     1,600.00
Outfit         100.00
PF deposited in PF department Medical, 5%         400.00
ESIC deposited with ESIC dept Gratuity 4.5%         360.00
Prof tax paid to PT department Food Coupons                  – 549
LTA payable in August     4,780.00 99
Medical if appl.payable in August
Outfit if appl. payable in January
Bonus paid at the time of Diwali
Gratuity will be paid after 5 yrs services
Note: Your Compensation is personal to you and confidential between you and the Company.
         You are requested not to share details of the same with others, within or outside the Company.
            Eventhough LTA, Medical, & Bonus are the part of salary package, These will be  payable only if employee completes one year of service
Authorised Signatory

 

Click Here To Download Salary Calculation Template

Search Sample Formats:

3 comments - What do you think?
Posted by Hrformats - May 29, 2012 at 10:42 AM

Categories: HR   Tags: , , ,

Salary Break Up Calculator

I have attached salary break Up calculator in excel format.

Yearly & Monthly Break Up of  Gross Salary
            Basic                            30%
            HRA                             20%
            City Compensatory All.   30%
            Conveyance                   Rs.800 per month
            Special Allowance          Balance
Yearly Grand Totals Monthly
Gross Salary                                     200,000     16,667
Basic                                      60,000      5,000
HRA                                      40,000      3,333
City Compensatory All                                      60,000      5,000
Employers Contribution 12% of basic or Rs. 780/- whichever is less                                        7,200         600
Conveyance                                        9,600         800
Special Allowance                                      23,200         200,000      1,933     16,667
Less : Deduction
P.F. ( Employees Contribution 12% of Basic or Rs 780/- whicever is less                                        7,200         600
P.F. ( Employers Contribution 12% of Basic or Rs 780/- whicever is less                                        7,200         600
Professional Tax                                        2,500           16,900         200      1,400
Net Salary Payable         183,100     15,267
Add Performance Bonus 30000
        213,100
Enter Values only in Yellow Cells

 

Click Here To Download Salary Break Up Calculator

Search Sample Formats:

3 comments - What do you think?
Posted by Hrformats - May 29, 2012 at 10:40 AM

Categories: HR   Tags: , , ,

Salary Certificate Format

I have Attached Salary Certificate Format

ABC LTD.
Kolkata
PAY SLIP FOR THE MONTH OF
Name
Worked Days Absent
Absent due to late
EARNINGS DEDUCTION
BASIC P.F (From Employee side)
HRA ESI (From Employee side)
Special Allowance Professional Tax
Conveyance Allowance Loan
Other Allowance Income Tax
Other Deduction
Total Earnings Total Deductions
Net Pay Total Earnings-Total Deductions

 

Click Here To Download Salary Certificate Format

Be the first to comment - What do you think?
Posted by Hrformats - May 17, 2012 at 7:20 AM

Categories: HR   Tags: , ,

Salary Increment Letter Format

 I have Attached Salary Increment Letter Format

Date:

 

Dear Mr.      ,

 

In recognition of your performance and contribution to the organization during the appraisal period 2008-2009, your monthly CTC is being revised to Rs.      /- (Rupees and no paise) w.e.f.

 

Your revised Compensation and Benefits Structure is given below for your reference.

 

COMPENSATION AND BENEFITS STRUCTURE

 

Components

Monthly          Rs.

Annual              Rs.

Basic

House Rent Allowance

Professional Development Allowance

Conveyance

Helper Allowance

Medical Reimbursement

Meal Vouchers

Other Allowance

Monthly Gross

Annual Gross

Mobile reimbursement

 

  • Apart from the above CTC you are eligible to claim official tour expenses as per the company policy.
  • Mobile expenses exceeding Rs.700 will be deducted from your monthly salary.
  • You will be provided a SIM card with CUG connection. You are requested to handover the SIM card while leaving the organization.

 

Kindly sign and return the duplicate of this letter as a token of your acceptance.

Wishing you the best for the next year. Do keep up your good performance.

 

Cheers!

 

 

Prasadh M S

Executive Director

 Click Here To Download Salary Increment Letter Format

1 comment - What do you think?
Posted by Hrformats - April 18, 2012 at 11:17 AM

Categories: HR   Tags: , , ,

Salary Certificate Format

 I have Attached Salary Certificate Format

 

SALARY CERTIFICATE

 

 

          This is to certify that [NAME], Junior Assistant has drawn Salary for the month of November 2006.  This Salary Certificate is issued for the purpose of  his  daughter’s  School Admission.

GROSS SALARY             = Rs.8.000/-

DEDUCTIONS                 = Rs.960/-

NET SALARY                  = Rs.7,040/-

 

(Rupees Seven thousand forty only)

 

 

 

For

 

 

 

Hr – Manager

 Click Here To Download Salary Certificate Format

Search Sample Formats:

Be the first to comment - What do you think?
Posted by Hrformats - February 4, 2012 at 9:57 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

1 comment - What do you think?
Posted by Hrformats - January 27, 2012 at 11:43 AM

Categories: HR   Tags: , , ,

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:

10 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 Sheet Format

 I have Attached Salary Sheet Format

COMPANY NAME
MONTH :
DATE:
S. No EMPLOYEE NAME NET SALARY
1 YYYYYYYY 4230
2 BBBBBBB 7020
3 YUUUUUUU 6141
4 ABCDEFG 4486
21876

 

Click Here To Download Salary Sheet Format

Be the first to comment - What do you think?
Posted by Hrformats - January 24, 2012 at 10:38 AM

Categories: HR   Tags: , ,

Salary Hike Sample Letter

I Have Attached Salary Hike Sample Letter

To: Mr./ Ms. XYZ  (Dept. Manager)
Copy To: HR
From: ABC (Designation)
Date:  …………
Subject: Salary Raise Request

 

 

 

 

 

 

 

 

Dear Sir / Ma’m,

I appreciate the opportunity I have had during the last four years of serving as a vital member of the technical support team. This past year has been an especially challenging business environment, but my accomplishments have continued to build on my earlier achievements, and I have high expectations for this success to continue for the foreseeable future.

Here are some highlights of how I have helped the department and the company in the past year / last four years:

  • Developed a proposal that brought a client from the brink of terminating our IT consulting services to renewing at a higher level than ever before, adding a net gain of $500,000.
  • Partnered with several team members to attract new consulting project opportunities totaling $1.2 million.
  • Conceptualized, proposed, and produced a research study that serves as a valuable tool for our industry
  • Served on the team of two company-wide task forces that identified redundancies, cut costs, and save the company several million dollars.
  • Participated in and attended four professional meetings, increasing the visibility of the company within the industry.
  • Mentored and trained three interns who handled many routine functions within the department, freeing up team members to focus on new client development and current client retention.
  • Proposed new projects, and completed all new tasks and assignments when requested to do so.

I look forward to continuing to play a key role within the department, however given all of my accomplishments so far, my salary is still below industry averages. I request you to look into the matter at the earliest and I am confident that you will offer a salary increase that reflects these issues and my standing in the department.

 

Signature

(Your Name)

Click Here To Download Salary Hike Sample

Search Sample Formats:

1 comment - What do you think?
Posted by Hrformats - January 9, 2012 at 7:24 AM

Categories: HR   Tags: , , ,

« Previous PageNext Page »