Search
Generic filters

Salary Certificate Excel Template

Salary Certificate is a ready-to-use Excel template which helps you to create 2 types of salary certificates; with CTC and complete salary break-up.

So, we need to type such letters. This excel template consists of predefined write-up of letter. All you need to do is enter employee and employer credentials and letter is ready to print.

Salary Certificate for Bank Loan

Salary Certificate is an HR document that employer issues to employee on his/her request that confirms his/her salary. So, The employee uses this certificate in external organizations like banks, financial institutions, and government organizations.

Above all, It consists of employee details along with salary details. Usually, the HR department issues these certificates in two ways; one is only the CTC and another that mentions the complete salary break-up.

Purpose of Salary Certificate template

Moreover, This certificate is proof of monthly income of an employee. It is requested for the following purposes:

  • Opening Bank Accounts.
  • Loan Application.
  • Credit Card Application.
  • Tax Payments.
  • Government Procedures.

Components of Salary Certificate

Usually, this document consists of following details but all details are not mandatory. Hence, companies can include details according to their requirement.

Name of the employee
Employee ID
Designation
Department
CTC or Complete Salary Break-up
Employment Status
Date Of Joining

As discussed earlier, this document is in two forms, one is only with CTC and another with complete salary break-up.

Furthermore, If complete salary break-up is to be provided, it includes following in addition to above details:

Basic Salary
List of Allowances
List Of Deductions
Take-Home Salary

In the end, the letter consists of a declaration that company will not be responsible on behalf of the employee in any case.

Salary Certificate Format

We have created a simple and easy Salary Certificate Format with predefine formulas and formatting. The salary certificate format is available in Excel. Just enter the require credentials and it is ready to print.

This template auto-populates as per details entered in the previous sheet. You don’t need to make any entries in this sheet.

In addition to the above, the letter consists of pre-draft text. In case you want to change you can do it by going to the respective cell. Else just set print area and print the document.

However, The format will be the same but the template automatically prepares a letterhead with company information. Only you have to enter the company logo before printing.

Download Salary Certificate Excel Template
Share on facebook
Share on linkedin
Share on email
Share on whatsapp

Download Guide

Compatible with : Microsoft Office Excel, Libra Office, WPS Office, Google WorkSheet
  • Download The Template XLSX File Format
  • Use the Template

Download Instruction :

All Excel templates and tools are sole property of xlsxtemplates.com. User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from PPTXTemplates.com  Completely Free. All our templates are designed by Professionals

Recently Uploaded Excel Templates: