Download this ready to use and easy to download printable Salary Sheet in Excel, Google Sheets, OpenOffice Calc, and Apple Numbers that helps you to perform the salary calculations with ease.
This salary sheet template is a payroll document which helps you to record payroll data for multiple employees along with a Salary slip prepared according to Indian rules of Employment, which includes provident fund and employee allowances. If you are from country other than India, You will have to make customization in this excel template or explore other printable salary sheets.
Understanding Salary Sheet
A salary Sheet is a human resource document that includes complete details of the amount payable to an employee for work done during a particular period. It includes details like basic pay, allowances, deductions, and overtime, etc. of employees.
A salary sheet or payroll sheet is useful to calculate the salaries of their employees. It is also known as payroll or payroll sheet. HR maintains financial records of employees like wages, salaries, deductions, bonuses, holidays, leaves, sick leave, etc. in Payroll.
Computing Salary Payable
The basic idea around salary payable is to compute the total liability of a company or employer towards employees or workers
Take-Home Salary = Basic Salary + Allowances – Deductions.
Contents of this Salary Sheet Template
Now let us take some time to understand this template for salary computation and printing salary slips. Note that, this template is useful for users from India or working for a company which complies with India Rules and Regulations. Below are the names of the sheets and their components that comes with this template in Excel [XLSX] format –
Employee Database
The database sheet consists of the master data where data of each employee will be entered. Major data in this sheet needs to be entered one time.
Components of Salary
There are three major components of the Salary: Basic Pay, Allowances, and Deductions. You can also customize this section as per your requirement. There can be additional benefits offered by the companies.
Consolidation Sheet
The consolidation sheet consists of a month-wise sheet of salary data entered in the Database Sheet. This sheet links the Database sheet to each cell and automatically fetches the date from the Database sheet. You don’t need to enter any data into this sheet.
Salary Slip
The salary slip sheet uses the VLOOKUP Function to program the sheet. On the extreme right, select the name of the employee from the drop-down list. The template displays the salary data of the respective employee. Click on the print button to print the Salary Slip.
Check out : Salary benchmarking | Salary Compensation | Salary Market Compensation Tool
Download printable salary sheet excel template
Now, Let us discuss on the how to download and use the printable salary sheet calculator in Excel format. To download and use this free printable salary sheet excel template, follow the steps below –
- Firstly, You should have Microsoft Office/ Microsoft Excel installed in your system.
- After installing Excel or Spreadsheet, download the zip file of this template, extract the template using WinRAR or 7Zip decompressing software.
- Once extracted, you can open the file using Excel and start entering data or customizing the template.
- Furthermore, To download fonts and typefaces compatible with Microsoft Excel > Calligraphic.net