Download Salary Sheet Excel Template 

 

 

Salary Sheet Excel Template

Payroll Assistants need to micro-manage payroll data of employees which include basic salary, HRA, TA, Conveyance, Leave details, provident fund deductions etc.

With the help of our VBA team, we have created an automated Salary Sheet Excel Template. With the help of this Salary Sheet Template, you can calculate the salary of multiple employees within minutes. 

Let us discuss the contents of the template in detail.

Contents of Salary Sheet Excel Template

Salary Sheet template consists of 3 different sheets as mentioned below:

1. Employee Database
2. Consolidation Sheet
3. Employee Salary Slip

Note: After you download the template, don’t forget to enable the content in the security warning pop-up below the ribbon as shown in the images below:

1. Employee Database

Database sheet is the master sheet where data of each employee will be entered. This sheet consists of Following columns:

• Employee Name
• Designation
• Gender
• Basic Salary
• Allowances
• Provident fund

These are required for salary preparation according to Indian Salary structure.
The user needs to enter data only in blue colored cells. The pink colored cells contain predefined formulas. You need not enter data in pink colored cells. See image below:

In this sheet, some data inputs columns have a drop-down menu, which makes easier for the user to select and enter data. Month, Year, Title, Gender etc are the drop-down menu. See image below:

For easy navigation, buttons for each sheet are given on top of the sheet in as shown below:

After entering data in the Database Sheet clicking on the “Consolidation button” will navigate to Consolidation Sheet.

2. Consolidation

Consolidation sheet is the month wise sheet of salary data entered in Database Sheet. This sheet is linked with Database sheet and fills in all data automatically when entered in Database sheet. You don’t need to enter any data into this sheet.
Please note that if month or year entered in database sheet differs then it will not show in the consolidation sheet for that month.
You can print a monthly report of salary for approval from higher management.
Click on the “Go to Salary Slip” button to navigate to Salary Slip.

3. Salary Slip

Lastly, comes the salary slip. The salary sheet is programmed using VLOOKUP Function. Select the name from the drop-down list and data of the respective employee will appear. Click on the print button to print the Salary Slip.

It’s done. This template is very user-friendly and easy to use for everyone. This template can be helpful for Accounts assistants, Office Admin, HR Assistants, Executive Assistants etc for preparing salaries.
If you want to make only Salary slip without keeping the data you can use our ready-to-use

We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries or questions, share them in comments below. I will be more than happy to help you.

Share on Facebook Share on Twitter Share on Google Plus

About Babatunde wealth

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.