Salary Certificate Format template in Excel, OpenOffice Calc, and Google Sheet to issue a Salary Certificate to employees in just one click.
Additionally, you can issue two types of salary certificates: Salary Certificate With Only CTC and Salary Certificate With Salary Breakup.
Moreover, this template comes in other editable document formats: Word, and OpenOffice Writer. It also consists of a blank Printable PDF format in which can you can manually enter employee data.
Select the employee name from the dropdown list and the template automatically fetches the employee data. Select and print the desired format.
All these documents are free to use and editable. You can download your desired format, insert the data and print it. You can easily navigate with the table of contents below to your desired section.
Table of Contents
Download Salary Certificate Format (Excel, OpenOffice Calc & Google Sheet)
To simplify your hassle, we have created a ready-to-use Salary Certificate Template with predefined formulas and formatting. A fully automated Salary Certificate Generator.
You can manage employee salary data monthly and issue salary certificates with CTC and complete salary breakup with just a click of a button.
What is Salary Certificate?
Salary Certificate is a Human Resource document to verify an employee’s employment, salary, pay grade, location, etc. The employer issues this letter upon request to his/her employees for a specific purpose. It is similar to a Salary Slip every month. But consists of a specific purpose.
The employer issues two types of Salary Certificates depending on the requirement. One mentioning only the CTC of the employee other with a complete salary breakup.
Components of a Salary Certificate
A normal salary certificate consists of:
- Employee name
- Employee id
- Designation
- Department
- Location
- Annual CTC
Whereas a salary certificate with complete salary breakup consists of:
- Basic Pay
- Allowances (Medical, Conveyance, HRA, Travel Allowance, etc)
- Gross Pay
- Deductions (TDS, EPF, Professional Tax, Insurance, etc)
- Net Pay
How To Use Salary Certificate Excel Template?
5 step process to easily generate a salary certificate in minutes:
- Enter salary data of employee in Employee Sheet or import from Salary Sheet.
- Enter the reason for issuing the letter.
- Go to desired Salary Certificate Format (With CTC or With Salary BreakUp)
- Select Employee ID from the dropdown list.
- Print the Desired format (With or WIthout employee photo).
Components of Salary Certificate Template
The Salary Certificate Template in Excel, OpenOffice Calc, and Google Sheet consists of 3 sheets: Employee Register, Salary Certificate Format With Only CTC, and Salary Certificate Format With Salary Breakup.
Let us understand the functioning of this template in detail.
Employee Register
The Employee Register consists of monthly salary data of employees. It consists of 5 sections.
Company Details
The company details section consists of the following:
- Company name
- Company Address
- Phone and Email
- Authority
- Designation
The template displays the Company name, address, phone, and email as a letterhead in the template. It displays the name of the company, signing authority, and designation at the end of each letter.
Employee Basic Information
The employee information section consists of the following:
- Employee ID
- Prefix
- Employee Name
- Designation
- Department
- Location
CTC Details
This section consists of the following:
- CTC per Annum
- CTC Monthly
- Basic Salary
CTC monthly is CTC per annum divided by 12 months.
Allowances Section
Allowances section consists of the following:
- House Rent Allowance
- Conveyance Allowance
- Medical Allowance
- Special Allowance
- Others if any
Total allowance and Gross salary columns consist of predefined formulas. Hence, they are auto-populated, and no need to enter any data in these columns.
Deduction Section
The deduction section consists of the following:
- Insurance
- Professional Tax
- Tax Deducted at Source – TDS
- Employee Provident Fund
Similar to the allowance section, the Total Deductions and Net salary columns consist of predefined formulas. Hence, they are auto-populated, and no need to enter any data in these columns.
In addition to that, this section also consists of another column for inserting the reason for issuing the Salary certificate. This will be displayed in the subject of the Salary Certificate.
Additionally, all these details are to be entered only once. Whenever, an employee leaves the company, is promoted, demoted, or a recruit these will details change.
Salary Certificate Template (With CTC and With Salary Breakup)
In both sheets, you don’t need to enter anything. On the top right-hand side, select the Employee ID from the dropdown list.
That’s it. The template fetches the data of the respective employee. The sheet has been programmed with Vlookup. Your salary certificate is ready to print.
There are 4 types of salary certificates that you can print:
- On Letterhead with employee photo.
- On letterhead without employee photo
- Without letterhead with employee photo.
- Without letterhead without employee photo.
Moreover, when the user gives the print command, you can choose pages 1,2,3, or 4 depending on your requirement.
Download Salary Certificate Format (Word, OpenOffice Writer & Google Docs)
You can download the same salary certificate formats in document formats like word, Openoffice Writer and Google Docs. Hence, just change all the bolded details and your letter is ready to print.
Furthermore, please note that you need to program the letterhead in the header section if you want to print on predefined letterhead. Double click on the header section and edit as per your need.
Salary Certificate With CTC On Letterhead
You can choose any 1 from the below as per your requirement. One consists of the employee photo and another is without an employee photo.
Salary Certificate With CTC
Choose one from the below as per your requirement: with employee photo or without employee photo.
Salary Certificate With Salary Breakup on Letterhead
You can choose one from the below as per your requirement. One consists of the employee photo and another is without an employee photo.
Salary Certificate With Salary Breakup
Choose one from the below as per your requirement: With employee photo or without employee photo.
Printable Salary Certificate Format
Click on the button below to download the printable format and fill in the details. Thus, you can print on your letterhead or plain paper.
Printable Salary Certificate With CTC
There are two types of certificates you can download. One with an employee photo and one without the employee photo.
Printable Salary Certificate With Salary Breakup
Similarly, here also are two types of certificates you can download. One with an employee photo and one without the employee photo.
Usage of Salary Certificate
Generally, Financial Institutions ask for salary certificates for opening an account, applying for a credit card, applying for a personal/home loan, or other financial services. The reason is to verify the current net income of the employee.
Similarly, government offices also demand such documents to avail certain schemes, or for issuing other documents.
In addition to the above, it is also used internally within big companies while making the transfer of employees to other departments. This helps the management to scrutinize the salaries of employees accordingly.
Frequenty Asked Questions
If you like this article, kindly share it on different social media platforms so that your friends and colleagues can also benefit from the same. Sharing is Caring.
Additionally, please send us your queries or suggestions in the comment section below. We will be more than happy to assist you.