ExcelDataPro

Free Excel Pro Templates

You are here: Home / Excel Templates / HR Templates / Download Salary Sheet Excel Template

Download Salary Sheet Excel Template

Download Salary Sheet Excel Template

Salary Sheet Excel Template is a payroll document in which you can record payroll data for multiple employees along with Salary slip in Microsoft Excel prepared according to Indian rules of Employment which includes provident fund and employee allowances.

What is Salary Sheet?

Salary Sheet is a document that includes complete details of the amount payable to an employee for work done during a particular period of time. It includes details like basic pay, allowances, deductions and overtime etc of employees.

Salary sheet or Employee sheet is the Payroll or Human Resource document used to calculate salaries of employees in any company.

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.

Click Here to Download Salary Sheet Excel Template.

Click here to Download All HR & Payroll Excel Templates for Rs 199.

You can download an advanced version of the same where both attendance and payroll calculation are merged together for easy preparation of staff salary.

Salary Sheet With Attendance Register

You can download the same in Apple Numbers from the link below:

Salary Sheet Apple Numbers Template

You can download other HR and Payroll related templates like Salary Slip, Attendance Sheet, Weekly Timesheet and much more.

You can download HR Apple Numbers Template from the link below:

HR Apple Numbers Template

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:

Salary Sheet Excel Template

Salary Sheet Excel Template

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:

Salary Sheet Excel Template

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:

Salary Sheet Excel Template

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

Salary Sheet Excel Template

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.

Salary Sheet Excel Template

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 Corporate Salary Slip Template.

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.

Comments

  1. If I add an extra row entry on the database sheet, example being adding an employee with all the relevant information on the respective cells, it doesn’t update on the consolidation sheet. How do I achieve this?

    Reply

    • Hi, you might have added the extra row at the end and might not cone in the range or the consolidation sheet a row needs to be added. For the time being Check the above solution. Currenlty not on computer system. Will check and revert soon.

      Reply

    • You are welcome Sherif. We are glad to know that our templates are useful to peoples. To get templates directly to your inbox you can subscribe to our mailing list. Thanks

      Reply

    • Hi Vijay, thanks for your valuable feedback. This could be as some features differ in MAC. We are working on this issue. Will soon update it once configured.

      Reply

    • Dear Ejazullah,
      Glad to know that our template is useful to our viewers.
      CTC basically stands for Cost to the company. The Cost to company is the total cost that an employee is incurring in a company. This includes the cash components plus other benefits like Bonus, Food etc. which are in general not seen in your regular Monthly Salary. In general, it means take home salary or salary package of an employee.
      You can subscribe to our weekly update to get updated every week with our newly posted template.
      Thanks
      Fahim
      ExcelDataPro.com
      Content and Marketing Manager

      Reply

  6. sir, what to do if i need to enter the esi for employer and employee pf for employer and employee and employer welfare fund

    Reply

    • Hi,
      You can add columns according to your need for ESI, PF, EWF. Add the columns and rows as such that it doesn’t affect your totals. Glad to know that our templates are helpful to our readers. You can subscribe to our mailing list to get notified for new templates issued every week directly to your inbox.
      Thanks
      Fahim
      Content Manager
      ExcelDataPro.com

      Reply

    • how to add more rows in database which shows in consolidation and in salary slip, for example I am trying to add more rows in database with relevant information of employees but it is not showing in consolidation and in salary slip. Kindly suggest how to add in both?
      Reply

      Reply

  9. Hi, I am unable to add row in database, for example i added row in database with relevant information of employees, but it is not showing in consolidation and in salary slip. Kindly suggest how to add the in both?

    Reply

  10. Dear Fahem,

    I have small advertising office, how to manage it in excel in it i need
    1- Company That provide advertising material like Flex for hording Billboards
    2- Labor fit this hording Flex in Labor more then 40 peoples some time 5 person go fit and some time different 3 go and fit this i want every budget divide them equal all labor project based instead salary. some time they need daily expense that we pay.
    3- Motor vehicle expenses
    4- other expenses
    5- old flex and material that removed from billboard

    please help me i am thankful to you

    Reply

    • It saves in same file in data base sheet. If you use save as option, you can save it on your desired location.

      Reply

  12. Hi
    Its very helpful, i wanted to show template to my students of HR, I just forwarded your URL to them.
    Though I downloaded your sheet first but later on I preferred to share website address to them.

    Reply

  13. Hai sir,
    this excel sheet was protected by password please share that password,
    its a very useful workbook
    Thank you very much

    Reply

  18. Dear sir ,
    thank you for your Efficient format of Salary/ payroll. i wonder to edit some column, like need to delete some rows that i do not need while i prepare my salary worksheet without any effect in salary slip and consolidation sheet. would you please instruct me how do i delete those unnecessary row and column.

    For ex. i do not need – DA, HRA , Conveyance, Conv Working Medical Expenses Special column in Total gross salary and
    Contribution to PF in total deduction.

    Best Regards
    Rajesh Suwal
    977-9851065203

    Reply

    • Thanks for the appreciation dear. Happy to know that it was helpful to you.
      Coming back to your query, When you delete the columns you need to configure the formulas accordingly in salary slip as well as consolidation sheet. This is the solution.

      Another simple solution to your query can be that you hide the columns you don’t want in the database sheet as well consolidation sheet. In Salary slip, you can set those amounts as zero or blank.

      Hope this would solve your problem.

      Thanks and Regards

      Reply

  20. Thank You Sir, Your Tamplet of Salary Sheet working is too perfect & easy understandable. Sir i have one query about overtime working calculation in salary sheet.Please suggest us overtime working formulas.

    Thanking You

    Reply

  21. Hi
    I have hundred number of employees.. and i want to generate a salary slip automatically. please help me to understand your format which you have consider here. i have only database in attendance form. what i want is, by use of this attendance format make salary slip easier. plz help to sort out.

    Reply

    • This format has the only database and payroll information from which you can make the salary slip. If you have any attendance sheet you can interlink to fetch the data from it. For 100 employees you need to change the vlookup range in the formulas.

      Reply

  23. please to update how to check the company payroll list till monthly return in step by step.It make my work easy

    Reply

  24. GOOD DAY YOU HAVE SIMPLE SHEET FOR STAFF ATTENDANT WITH THEIR DATA AND SALARY ON ONE SHEET, DATA ON DUTY FOR MULTI STAFF IF POSSIBLE SO PLEASE SEND MY EMAIL ID

    Reply

    • No Dear. We don’t any such sheet which has both attendance and salary together. We have both the sheets different on our website. Link for Attendance Sheet is given below for your ready reference:
      https://exceldatapro.com/attendance-sheet/
      You can use linking of the cell function to merge both sheets together. Thanks

      Reply

  25. Hi,
    Fahim Lashkaria says
    I have download this salary template but we required with deduction of ESIC and Add Overtime calculation also.
    will you help me how to add this 2 column in this salary template

    Reply

    • You can add columns manually and then you need to configure the respective cells in consolidation sheet and salary slip. If you can do it then Ok. Otherwise, you can contact our development department for a paid work.

      Reply

  26. June 11, 2018 at 8:57 am

    Hi,
    Fahim Lashkaria says
    I have download this salary template but we required with deduction of ESIC and Add Overtime calculation also.
    will you help me how to add this 2 column in this salary template

    Reply

    • Dear Amr, I have already replied to your comment. You need to add these columns and adjust the total according to your need in the Database sheet. If you want us to do the same for you, you need to contact through email to us and send complete details to us. Please note that any such work will be chargeable.

      Reply

  27. Dear Mr.Fahim,

    Can you please help me about company leaves record in excel sheet, excel format, template and easy record all staff of leaves.

    Reply

  28. TDS is to be calculated separately ?? do we have any sheet where there is tax and sheet which is linked to tds column to calculate TDS amount automatically

    Reply

    • Akshay, most of the formulas being regularly used for the business have been explained in our Functions section. Apart from that, ready-to-use templates for all the hr documents, accounting documents, financial analysis etc are ready for download on our website. Hope this could help. If you cannot find anything here do let us know we will try to help you. Thanks
      Functions: https://exceldatapro.com/functions/
      Excel Templates: https://exceldatapro.com/templates/

      Reply

  31. Dear Sir Kindly Let Me Know how to create a macro where Cell — A1&B1&C1&D1&E1 need to add in another cell without the code on that cell eg. K1

    Reply

    • I could not understand query dear. Please explain in detail or send the file through email. It will be easier for me to guide you.

      Reply

  32. Good day Sir,
    This template was really helpful, please i need information about how to change the range in the vlookup formula.
    The range seems to cover only 50 employees, i will appreciate if you can send me a formular to cover range of 150 employees, or give me a step by step method to increase employee range.
    Thank you

    Reply

    • Hi Rachael, Glad to know that our template was helpful to you. Our purpose of helping people is served and we are really happy to know that. To cover 150 employee range you need to see which cell is the last one and change the address to that cell address. That’s it.

      Reply

    • Dear salary structure depends on company to company as there are different allowances and different deductions. So I will not be able to tell you that. Your HR department can guide you through this or entering your CTC you can have a basic idea of your salary structure.

      Reply

  34. Dear sir,
    Good template.

    I am having 200 employees which is not showing when selecting salary slip in name column and not pulling data automatically showing NA
    one more thing what is linked cell Q

    Reply

  35. Dear Sir,
    Thanks for your template it was very useful for me. But I was wondering if somehow it is possible to add one more sheet in order to have a total yearly salary sheet as well?

    Reply

Leave a Reply

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