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 | ||||||||||
Categories: HR Tags: Calculation, Salary, Sample, Template
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 | ||||||
Categories: HR Tags: Break, CALCULATOR, Salary, Up
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 |
Categories: HR Tags: Certificate, Format, Salary
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
Other Related Letter Formats
Resignation Letter Due to Low Salary
Salary Increase Negotiation Letter Sample
Salary Hike Sample Letter
Salary Increment Letter to Employee for Performance
Salary Increment Letter After Completing One Year
Salary Increment Letter Format to Boss
Salary Increment Appraisal Letter Format
Salary Negotiation Email in Response to Job Offer
Tips For The Successful Salary Negotiation
Salary Negotiation Letter after New Job Offer
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
Categories: HR Tags: Certificate, Format, Salary
Salary Calculation Sheet in Excel
I have Attached Salary Calculation Sheet in Excel
Categories: HR Tags: Calculation, Excel, Salary, Sheet
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:
Salary Calculation Sheet in Excel
I have Attached Salary Calculation Sheet in Excel
Categories: HR Tags: Calculation, Excel, Salary, Sheet
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 |
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
Other Related Letter Formats
HR Revision Policy Regarding Salary Increment
Salary Increase Negotiation Letter
Salary Increment Letter to Employee for Performance
Salary Increment Letter After Completing One Year
Salary Increment Letter Format to Boss
Salary Increment Letter Format
Salary Increment Appraisal Letter Format
Salary Negotiation Email in Response to Job Offer
Tips For The Successful Salary Negotiation
Salary Negotiation Letter after New Job Offer