• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Download Salary Certificate Format Excel Template

Download Salary Certificate Format Excel Template

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

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

Additionally, this template consists of 4 different formats of Salary Certificate other than Excel; Word, PDF, Google Doc, and Open Office Writer. All documents are free to use and editable. Just download the desired format and start using it.

Table of Contents

  • What is a Salary Certificate?
  • Purpose of Salary Certificate
  • Components of Salary Certificate
  • Salary Certificate Excel Template
    • Salary Certificate With Only CTC
    • Salary Certificate With Salary Break-up
  • Contents of Salary Certificate Excel Template
    • Data Input Sheet
    • Salary Certificate Templates

What is a Salary Certificate?

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

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

Purpose of Salary Certificate

This certificate is proof of the 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 the following details but all details are not mandatory. Hence, companies can include details according to their requirement.

Name of the employee
Employee ID( if applicable)
Designation
Department
CTC or Complete Salary Break-up
Employment Status (Temporary or Permanent)
Date Of Joining

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

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

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

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

Salary Certificate Excel Template

We have created a simple and easy Salary Certificate Format with predefined formulas and formatting. The salary certificate format is available in Excel, Word, PDF, Google Doc, and Open Office Writer. Just enter the required credentials and it is ready to print.

Additionally, this template consists of 2 different formats of Salary Certificates; One is with Only CTC and another with salary break-up.

Click here to download the Salary Certificate Excel Template.

Additionally, you can download other HR document templates like Resume and Cover Letter, Employee Termination Letter and Professional Resignation Letter from our website.

Download PDF, MS Word or Google Doc format for Employee Termination Letter from the desired type of format given below.

Salary Certificate With Only CTC

Salary Certificate

PDF Word Google Doc Open Office Writer

Salary Certificate With Salary Break-up

Salary Certificate

PDF Word Google Doc Open Office Writer

You can use PDF format with a PDF editor and change the details, for using Word and Google Doc file just change the bold text as per your need.

Let us understand the contents of this template and how to use it.

Contents of Salary Certificate Excel Template

This template consists of 5 sheets. 1 data input sheet and 4 salary certificate formats.

Data Input Sheet

Data Input sheet consists of the 3 sections.

Salary Certificate

Employer Details consist of the following heads:

Company Name
Company Address
Contact Numbers
Email ID
Name of Issuing Authority
Designation of Issuing Authority

Salary Certificate

Employee details consist of the following heads:

Employee Name
Address
City/State
Pin Code

Salary Certificate

Salary Details the following heads:

Date of Certificate
Designation
Department
Location (If Applicable)
Date of Joining
Gender
Immediate Supervisor Name
Immediate Supervisor Designation
CTC
Basic Salary
H.R.A.
Conveyance Allowance
D.A.
Others
Insurance
P.F.
Professional Tax
TDS
Other Deductions

You are almost done. Go to the next sheet and print the letter.

Salary Certificate Templates

Salary Certificate

This template auto-populates as per the 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-drafted text. In case you want to change it you can do it going to the respective cell. Else just set the print area and print the document.

Moreover, If you are a small organization and don’t have a preprinted letterhead then no need to worry. Just navigate to the respective sheet with the letterhead printing option and print the certificate.

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.

Salary Certificate

Furthermore, if you are looking to send a pdf version of your letter to the company, you can use inbuilt Microsoft to PDF option from the print menu.

Print to PDF

Thus, this template can be helpful to HR assistants, HR heads as well as HR professionals to create a different type of salary certificates according to their requirement in minutes.

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. We will be more than happy to assist you.

« Download Employee Promotion Letter Excel Template
Download Absconding Letter Excel Template »

Filed Under: HR Templates

You are Here: Home / Excel Templates / HR Templates / Download Salary Certificate Format Excel Template

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

HR Templates

  • Salary Sheet Excel Template
  • Daily Work Schedule Excel Template
  • Weekly Timesheet Excel Template
  • Corporate Salary Slip Excel Template
  • Employee Attendance Sheet Excel Template
  • Employee Performance Evaluation Excel Template
  • Employee Provident Fund Calculator Excel Template
  • Job Candidate Tracker Excel Template
  • Employee Resignation Schedule Excel Template
  • Employee TA Reimbursement Excel Template
  • Employee Contract Renewal Schedule Excel Template
  • Employee Overtime Calculator Excel Template
  • Simple Age Calculator Excel Template
  • Employee Mileage Log Excel Template
  • Multiple Employees Weekly Timesheet Excel Template
  • 9 Ready-To-Use Salary Slip Excel Templates
  • Salary Sheet With Attendance Register In Single Excel Template
  • Weekly Timesheet With Payslip Excel Template
  • Salary Breakup Report Excel Template
  • Gratuity Calculator (India) Excel Template
  • Taxable Gratuity Calculator Excel Template
  • Employee Training Log Excel Template
  • Employee Vacation Tracker Excel Template
  • Salary Arrears Calculator Excel Template
  • Resume/Cover Letter Excel Template
  • Professional Resignation Letter Excel Template
  • Employee Termination Letter Excel Template
  • Employee Promotion Letter Excel Template
  • Salary Certificate Format Excel Template
  • Absconding Letter Excel Template
  • Employee Disciplinary Memo Excel Template
  • Casual Leave Application Excel Template
  • Employee Transfer Letter Excel Template
  • Employee Show Cause Notice Excel Template
  • Promotion Request Letter Excel Template
  • Transfer Request Letter Excel Template
  • Job Rejection Letter Excel Template
  • Promotion Rejection Letter Excel Template
  • Transfer Refusal Letter Excel Template
  • Transfer Rejection Letter Excel Template
  • Employee Welcome Letter Excel Template
  • Employee Thank You Letter Excel Template
  • Layoff Notice Letter Excel Template
  • Employment Verification Letter Excel Template
  • Job Offer Letter Excel Template
  • Accommodation Request Letter Excel Template
  • Loan Application Letter Excel Template
  • Workplace Harassment Complaint Letter Excel Template
  • Internship Request Letter Excel Template
  • Additional Facility Request Letter Excel Template
  • Salary Increment Request Letter Excel Template
  • Employee Of The Month Certificate Excel Template

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • Calculators
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2025. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT