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

Download Salary Sheet Excel Template

Download Salary Sheet Excel Template

Salary Sheet is a ready-to-use template in Excel, Google Sheets, OpenOffice Calc, and Apple Numbers that helps you easily calculate the salary.

It is a payroll document in which you can 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.

Table of Contents

  • What is A Salary Sheet?
  • Formula To Calculate Salary
  • Download Salary Sheet Template
  • Contents of Salary Sheet Template
    • Employee Database
    • Components of Salary
    • Consolidation Sheet
    • Salary Slip
  • Frequently Asked Questions

What is A Salary Sheet?

A salary Sheet is a document that includes complete details of the amount payable to an employee for work done during a particular period. In addition, it contains details like employees’ basic pay, allowances, deductions, overtime, etc.

The payroll or salary sheet is the Human Resource document companies use to calculate their employees’ salaries. 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.

Generally, Payroll is made daily for wages, weekly, biweekly, or monthly for salaries. However, it differs from one period to another as it is calculated based on actual working days. Thus, each month working days, overtime, leaves, and other variables differ for each employee.

Formula To Calculate Salary

Take-Home Salary = Basic Salary + Allowances – Deductions.

Download Salary Sheet Template

Hr and Payroll staff needs to micro-manage employee payroll data, including basic salary, HRA, TA, Conveyance, Leave details, provident fund deductions, etc.

We have created an automated Salary Sheet Template with predefined formula. You can prepare multiple employees’ salaries within minutes with this template’s help.

This template is available in 4 file formats – Excel, Google Sheets, Open Office Calc, and Apple Numbers. Click on the button below to download the desired format:

Excel Google Sheets Open Office Calc Apple Numbers

Click here to Download All HR & Payroll Excel Templates for ₹299.

The functioning and formulation in all four file formats are the same except for the spellnumber function, as it is not supported in OpenOffice Calc, Google Sheets, or Apple Numbers.

Important Note: Save the file on your Google Drive using the “Make a Copy” option from the File menu to edit and customise the Google Sheet.

Additionally, you can download other HR and Payroll related templates like Salary Slips, Attendance Sheets, Weekly Timesheets, and much more.

Let us discuss the contents of the template in detail.

Contents of Salary Sheet Template

Note: After you download the Excel and open the office 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

The salary Sheet template consists of the following three sheets: Employee Database, Consolidation Sheet, and Employee Salary Slip

Employee Database

The database sheet consists of the master data, where the data of each employee will be entered. Major data in this sheet needs to be entered one time.

The first section includes employee details such as name, designation, salary month, allowed leaves, leaves are taken, and working days.

You can select the month and year of salary from the dropdown list. When the user selects the month and year for the first employee, it automatically displays the same for other employees. We have kept a provision of 20 employees. If you want to increase employee salaries, you can drag the same using the fill handle.

The user can select the total days of the month (30, 31, 28, or 29) from the dropdown list. When the user selects the month and year for the first employee, it automatically displays the same for other employees.

Allowed leaves are different according to the designation and company policy. Hence, you need to enter individually.

Insert actual leaves availed by the employee, and the template automatically calculates the working days. The allowed leaves are deducted from the total leaves, which is how the actual working days are calculated. The template uses the “=IF(G4>=F4, E4-G4+F4, E4)” formula to calculate the working days.

Insert CTC for each employee as per the employee contract. CTC = Direct benefits + Indirect benefits + Saving Contributions. For more information on CTC, click here.

CTC is calculated based on working days. Hence, the template calculates the CTC proportionately according to the working days for that particular month. The template uses “IF(H4=0, “”, ROUND(I4/E4*H4, -1))” formula.

Components of Salary

The Salary has three major components: Basic Pay, Allowances, and Deductions.

Basic Pay/Basic Salary

The basic salary is the fixed amount to be paid to an employee in addition to any allowances or subtraction of any deductions. Bonuses, overtime, dearness allowance, etc., are not a part of basic pay. For more information about Basic Salary, click here.

The template auto-calculates the basic salary based on CTC. Usually, it is 40% or 50% of the basic salary. The basic Salary is proportionate to the working days. It uses the following formula to calculate the basic salary “=IF(H4=0, “”, ROUND ($J4/E4*H4*50%, -1))”.

Next comes the allowances section. Allowances are an employer’s financial benefits above the Basic Salary to his employees. These allowances differ based on company policy, industry, job profile, and department. The template adds all the following amounts to form the gross salary.

Dearness Allowance

DA or dearness allowance is an allowance that the employer pays its employees against the price rise in the economy to reduce the impact of inflation. Employers provide DA as the cost of living adjustment allowance in India, Pakistan, and Bangladesh. Government employees, public sector employees, and pensioners get to DA.

DA is auto-calculated. DA (Dearness Allowance) is 4% to 10% of basic pay, depending on the contract. It uses the following formula to calculate DA “=IF(H4=0,” “, ROUND (J4/E4*H4*10%, -1))”. For more information on Dearness Allowance, click here.

House Rent Allowance

HRA stands for House Rent Allowance. House Rent Allowance is the amount an employer allocates to the employee as a portion of their CTC salaries. The employer decides the house rent allowance depending on different criteria like the city of residence and salary grade.

It is 50% of the basic pay for employees in a metro city, whereas, for employees in a non-metro city, it is 40%. Generally, when these rules aren’t applicable, it is 10 % of the basic salary. For more information on House Rent Allowance, click here.

House Rent Allowance is auto-calculated. Usually, it is 25%-30% of CTC. Insert the percentage in the formula as per the employment contract. It uses the following formula to calculate HRA “=IF (H4=0, ” “, ROUND (J4 / E4 * H4 * 25%, -1))”.

Conveyance Allowance

Allowance or money to compensate for an employee’s travel expenses between their residence and workplace is Conveyance Allowance. It is also known as transport allowance.

You need to insert the conveyance allowance in the formula as per the employee contract. The conveyance working column calculates the conveyance amount based on employee attendance.

It uses the following formula to calculate the conveyance allowance “=IF(H4=0, ” “, ROUND (N4/E4*H4, -1))”. Furthermore, if the employee’s working days are 0, then it will display 0.

To learn more about Conveyance Allowance, click here.

Medical Allowance

Medical Allowance is a fixed allowance that an employer pays its employees as a part of their salary to meet their regular medical needs. The employer credits a fixed amount as a medical allowance and the salary to the employee’s account every month.

Medical allowance is calculated based on applicability to employees as per the contract. Therefore, it will calculate if you have selected yes in the medical allowance column at the end. Otherwise, it will display 0.

Furthermore, if the employee’s working days are 0, it will display 0. It uses the following formula to calculate the medical allowance “=IF(H4=0, ” “, ROUND(P4/E4*H4,-1))”.

For more information on medical allowance, click here.

Special Allowance

The Special Allowance is auto-calculated by deducting the basic pay and other allowances. The special allowance is a fixed allowance given to employees to meet certain requirements over and above the basic salary.

The template uses the following formula to calculate special allowance “=IF(H4=0, ” “, ROUND(J4-T4,-1))”. You can insert it manually if it is different for each employee.

Children’s Education Allowance, Hostel Allowance, Miner’s Allowance, Outstation Allowance, Offshore Allowance, etc., are some special allowances.

Bonus Pay

Insert the bonus payment amount if it applies to any employee for any particular month. Bonus pay is an employer’s reward to his employee for their excellent work. Usually, in countries like India, Pakistan, and Bangladesh, companies pay bonuses yearly based on the organisation’s overall financial performance and are paid during festive seasons.

TA – Travel Allowance

Insert TA for the employee on spent by the employee for that particular month. TA stands for Traveling Allowance. Travelling allowance is the amount paid or allotted to an employee by the employer for travelling to another place for business purposes.

The travelling allowance includes modes of travel, accommodation, meals, and other incidentals. To learn more about Travel Allowance, click here.

All the above things compile the gross salary. Gross Salary is the total of all the components of your monthly payout before any deductions.

Followed by the allowances, the templates consist of deductions. Employee Deductions are the amounts subtracted from an employee’s gross pay to reach net pay. For example, the template deducts all the following amounts from the gross salary.

Employee Contribution To Provident Fund

As per Indian Labor Law, an employee has to contribute a part of the salary towards the provident fund. Currently, it is 12%. Therefore, the template uses the following formula to calculate “=ROUND (MIN (1800, IF (AG4=”Yes”, SUM(K4: L4) * 12%, 0)), -1)”.

Employee Provident fund is a type of retirement benefits scheme for salaried employees. Under this scheme, the employee makes a stipulated contribution from his salary. The government decides this percentage.

Salary Advance

Insert the amount of salary advance for each employee if applicable. When an employee draws in full or portion of salary in advance, it refers to a Salary advance. While calculating the salary, the employer deducts the same from the salary.

Professional Tax

If the professional tax is applicable, then insert the monthly amount of professional tax. Professional Tax is a tax a government levies on professionals based on their salary/monthly income. Usually, it is around Rs. 200 a month, which amounts to the maximum payable of Rs. 2500 in a year in India.

Tax-Deducted At Source

Insert the actual TDS amount. TDS stands for Tax Deducted at Source. It is the income tax that an employer deducts from the employee’s salary. The employer deposits this collected tax to the IT Department. Click here for more information on TDS, TDS Threshold, TDS Return, etc.

Subtracting the total deduction amount from the gross salary compiles the net payable salary to the employee.

General Information

Select the gender and prefix of the employee from the dropdown list. Also, select the authorized signatory of the department for each department if it differs from the dropdown list.

Select “Yes” if PF is applicable. Select “Yes” if the employee has submitted the medical bills. If the user selects “No”, the template will not add the medical allowance to the salary.

Given above are details preparing the salary according to the Indian Salary structure.

The user needs to enter data only in blue-coloured cells. The pink-coloured cells contain predefined formulas. You need not enter data in pink colored cells. See the image below:

Salary Sheet Excel Template

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

Salary Sheet Excel Template

The template consists of buttons at the top of the sheet for easy navigation in, as shown below:

Salary Sheet Excel Template

After entering data in the Database Sheet, click the “Consolidation” button. It will navigate you to the  Consolidation Sheet.

Consolidation Sheet

The consolidation sheet consists of a month-wise sheet of salary data entered into 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.

If you enter the month or year in the database sheet wrong, it will not display in the consolidation sheet for that particular month.

You can print a monthly report of salary for approval from higher management. Once the signing authority approves the salary, you can pay the employee by cheque or direct bank transfer.

Click on the “Go to Salary Slip” button to navigate to Salary Slip Sheet to print individual salary slips for employees.

Salary Slip

The salary slip sheet uses the VLOOKUP Function to program the sheet. On the extreme right, select the employee’s name 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.

Salary Sheet Excel Template

Your Payroll process is complete. This template is very user-friendly and easy to use for everyone. This template can be helpful for Accounts assistants, Office admins, HR Assistants, Executive Assistants, etc., for preparing salaries.

If you want to make only a Salary slip without keeping the data, use our ready-to-use Corporate Salary Slip Template.

Frequently Asked Questions

What Are Payroll Expenses?

Payroll Expenses include salaries, wages, bonuses, commissions, EFB, PF, EPS, company contributions such as a company-paid health plan, and the company-paid portion of taxes.

An employer pays the payroll expenses to its employees in the form of salary/wage for their services/work and associated expenses such as employee benefits and state and federal payroll taxes.

What is Gross Salary?

Gross Salary is the salary amount, including all benefits and allowances, before any deductions. In simple terms, Gross Salary is the total of all the components of your monthly payout before any tax deductions. Gross Salary = Basic Salary + Allowances + Benefits. For more information on components of Gross Salary, click here.

What is Net Pay or Take Home Salary?

The net pay or the take-home pay is the salary/wages of an employee that remains after all deductions(taxes, health insurance, benefits, etc.) have been subtracted. In simple terms, Net pay is the amount an employee receives after all taxes/deductions during a particular pay period.

How To Calculate Overtime?

Overtime Pay means the amount compensated for hours or days worked more than the maximum limit mentioned in your contract or set by federal or provincial law. Click here to get the formula for calculating Overtime.

How much percentage of CTC is the Basic Salary?

The basic salary is usually 40% – 50% of CTC.

How much percentage of Basic Salary is Dearness Allowance(DA)?

Dearness Allowance is usually 5% to 10% of the Basic Salary.

On which amount is the PF deduction calculated?

PF is calculated on Basic Salary.

Download Daily Work Schedule Excel Template »

Filed Under: HR Templates

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

About Shabbir Bhimani

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

Comments

  1. Michael says

    January 21, 2017 at 3:04 pm

    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
    • Fahim Lashkaria says

      January 21, 2017 at 3:49 pm

      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
      • Puja says

        March 29, 2018 at 8:19 am

        Dear I want to add few employees in database but the salary slip is not showing their names.Please help.

        Contact No: 9540830111

        Reply
        • Fahim Lashkaria says

          March 29, 2018 at 8:26 am

          Hi Puja,

          You need to change the range in the vlookup formula for the additional employees to show them in consolidation sheet as well as the salary slip.

          Reply
          • MUJEEB UR REHMAN says

            May 5, 2018 at 12:47 pm

            SIR PLEASE HOW I CHANGE FORMULA VLOOKUP IN SALRY SLIP I HAVE 1000 EMPLYEES ON 146 SHOW SLIP

          • Fahim Lashkaria says

            May 7, 2018 at 11:57 am

            Contact Via Email

          • puja says

            May 8, 2018 at 3:55 am

            Sir i would be happy if could do this for me as i dont know excel much

            Regards,
            Puja
            9540830111

          • Fahim Lashkaria says

            May 8, 2018 at 11:48 am

            contact me on email please. fahim.lashkaria@gmail.com

          • ABDULRAHMAN PATEL says

            November 14, 2019 at 2:35 pm

            Hello Sir i would appreciate if you can create Automated Payroll System on excel and need it in a simple way. for reference i can share you the link of the video which i liked and im looking forward to get it …. https://youtu.be/FkavkGtE6NI ..

            If you can create same as this kindly contact me on my mail … arpatel@aectrading-ksa.com

            my whatsapp is : +966560913057

          • Fahim Lashkaria says

            November 14, 2019 at 3:29 pm

            We already have a salary sheet which is somewhat similar to this. You can also check out Salary sheet with attendance on the link below:

            https://exceldatapro.com/salary-sheet-with-attendance-register/

            If you want to make something customized please contact info@exceldatapro.com and our team will assist you.

    • Anwarul Islam says

      December 15, 2020 at 10:37 am

      Excellent work!

      Reply
      • Fahim Lashkaria says

        December 19, 2020 at 12:31 pm

        Thanks, Anwarul Islam

        Reply
      • CLIFF OMONDI OCHOMO says

        February 11, 2021 at 11:33 am

        Hello ,kindly help with the customization for outside of India countries

        Reply
        • admin says

          February 13, 2021 at 1:18 pm

          Which country customization and what kind of customization are you looking for?

          Reply
  2. Sherif Fouad Mohamed says

    March 1, 2017 at 8:54 am

    Thanks a lot,Its so useful

    Reply
    • Fahim Lashkaria says

      March 1, 2017 at 9:03 am

      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
      • bhagyesh says

        June 17, 2020 at 12:38 pm

        sir i bhagyesh Trivedi on salary sheet name filter do not show continue its hide on column and in database sheet how to add pf contribution sheet. please send me solution for that. contact number 9925594683 and email id trivedibhagyesh76@gmail.com

        Reply
        • Fahim Lashkaria says

          June 17, 2020 at 3:56 pm

          HI Bhagyesh. Insert the column and adjust the contribution cell with the formula. Thanks

          Reply
  3. nilanjana dasgupta roy says

    March 1, 2017 at 11:20 am

    Download Salary Sheet Excel Template

    Reply
  4. vijay says

    March 16, 2017 at 12:45 pm

    I couldnt use it at MacBook Air.

    otherwise its awesome .

    Rgds
    Vijay

    Reply
    • Fahim Lashkaria says

      March 16, 2017 at 12:49 pm

      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
  5. Ejazullah says

    March 26, 2017 at 9:55 am

    Dear Sir,
    Thanks for your tamplate it is very usefull & fruiteful for us, but one thing i want to clear that is CTC stand for what?

    Reply
    • Fahim Lashkaria says

      March 26, 2017 at 10:58 am

      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
      • Nawaj says

        October 23, 2017 at 5:16 pm

        Sir thank you so much for salary sheet. Sir can you send full vba strings in pdf on my mail.

        nawaj.dr@gmail.com

        Reply
        • Fahim Lashkaria says

          October 23, 2017 at 5:19 pm

          All things are open in the file you can see them by using alt f11

          Reply
      • Arul Rajan says

        August 23, 2019 at 6:27 pm

        But sir you dint include the Employer contribution for EPF and ESIC in CTC

        Reply
        • Fahim Lashkaria says

          August 23, 2019 at 6:55 pm

          This article was made earlier so it might have not included. You can include and adjust the formula accordingly. Currently working on a new file. Will update in that.

          Reply
  6. Lakshmi. Ajesh says

    April 1, 2017 at 5:17 pm

    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
    • Fahim Lashkaria says

      April 2, 2017 at 8:55 am

      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
  7. prathibha says

    June 1, 2017 at 9:13 am

    sir i want how to calculate wf in excel sheet

    Reply
    • Fahim Lashkaria says

      June 1, 2017 at 9:24 am

      Hi pratibha. What is this wf?

      Reply
  8. Pratik J Shah says

    July 14, 2017 at 5:05 pm

    Really Good One.
    Thanks

    Reply
    • Pooja says

      October 7, 2017 at 6:22 am

      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. Pooja says

    October 7, 2017 at 7:30 am

    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. shan says

    October 7, 2017 at 8:52 am

    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
  11. Poonam says

    October 10, 2017 at 6:31 am

    Please tell us what is the saved file path. From where we can see the file after we press save button.

    Reply
    • Fahim Lashkaria says

      October 10, 2017 at 6:36 am

      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. upsc-2017 says

    November 15, 2017 at 4:33 pm

    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
    • Fahim Lashkaria says

      November 15, 2017 at 5:15 pm

      Happy to know it helped you and your students. Thanks for sharing url too. Other HR templates are available at below link hope it might also help: https://exceldatapro.com/templates/hr-templates/

      Reply
  13. Manjesha M says

    November 23, 2017 at 5:14 am

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

    Reply
    • Fahim Lashkaria says

      November 23, 2017 at 11:16 am

      There os no password to it. Just unprotect it from review menu.

      Reply
      • sudhansu says

        February 14, 2018 at 7:55 pm

        Sir,
        While try to unprotect the sheet it asking for password..
        Plz provide us the password..

        Thanks

        Reply
        • Fahim Lashkaria says

          February 16, 2018 at 6:18 am

          THe salary sheet is does not have any pw. thus, you can use it freely.

          Reply
  14. Nazeba says

    November 30, 2017 at 7:00 pm

    wow! it is really helpful to me for the very first time.
    thanks

    Reply
    • Fahim Lashkaria says

      November 30, 2017 at 7:03 pm

      Happy to know that it helped you. If you like it, share it with our friend. Thanks

      Reply
  15. HAMMAD TAHIR says

    December 17, 2017 at 12:38 pm

    how to add previous years to the database. i want to add 2013 and 2014 in the database

    Reply
    • Fahim Lashkaria says

      December 18, 2017 at 9:03 am

      To add previous years go to data validation tool under data tools and add your desired years.

      Reply
  16. Sammit Shrestha says

    December 26, 2017 at 8:20 am

    we don’t provide PF. How do i remove PF deduction from net salary??

    Reply
    • Fahim Lashkaria says

      December 26, 2017 at 8:22 am

      Remove the column and reconfigure the formula.

      Reply
  17. Mustafa says

    January 12, 2018 at 4:16 pm

    Sir, what is Conv Working.
    Please excuse me for being so ignorant.

    Reply
    • Fahim Lashkaria says

      January 13, 2018 at 8:46 am

      Conv means Conveyance

      Reply
  18. Rajesh Suwal says

    February 1, 2018 at 12:55 pm

    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
    • Fahim Lashkaria says

      February 1, 2018 at 3:25 pm

      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
  19. James B says

    February 5, 2018 at 1:03 pm

    Nice work

    Reply
    • Fahim Lashkaria says

      February 6, 2018 at 6:11 am

      Thanks for the appreciation.

      Reply
  20. Adv.Nagesh Swami says

    February 10, 2018 at 1:45 pm

    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
    • Fahim Lashkaria says

      February 13, 2018 at 5:55 am

      Glad to know our templates are helpful to you. Thanks for the appreciation. You can use this employee overtime calculator in excel for overtime click the link below:

      https://exceldatapro.com/overtime-calculator/

      Reply
  21. Vikas says

    March 30, 2018 at 9:51 am

    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
    • Fahim Lashkaria says

      March 30, 2018 at 11:20 am

      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
  22. Surendra says

    April 14, 2018 at 12:19 pm

    THIS IS AWESOME BUT I WANT TO A SIMPLE SHEET FOR STAFF ATTENDANT AND SALARY ON ONE SHEET FOR MULTI STAFF IF POSSIBLE SO PLEASE SEND MY MAIL ID sb.botalda@gmail.com

    Reply
    • Fahim Lashkaria says

      April 14, 2018 at 2:03 pm

      Sure. I can design for you your required template. Contact me on +91 9687858563

      Reply
  23. sha says

    April 21, 2018 at 5:15 pm

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

    Reply
    • Fahim Lashkaria says

      April 23, 2018 at 5:29 am

      Save the file consolidation file monthly as a new worksheet in the same file or a different file.

      Reply
  24. mailyn says

    June 10, 2018 at 2:27 pm

    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
    • Fahim Lashkaria says

      June 11, 2018 at 9:57 am

      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. Jayant says

    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
    • Fahim Lashkaria says

      June 11, 2018 at 9:52 am

      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. Amr farag says

    June 14, 2018 at 2:25 pm

    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
    • Fahim Lashkaria says

      June 17, 2018 at 7:39 am

      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. Shahbaz says

    July 18, 2018 at 10:55 am

    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
    • Fahim Lashkaria says

      July 19, 2018 at 7:34 am

      Attendance sheet given in below link has all leave records.
      https://exceldatapro.com/attendance-sheet/

      Reply
  28. Aarti Solanki says

    September 17, 2018 at 12:24 pm

    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
    • Fahim Lashkaria says

      September 18, 2018 at 7:55 am

      Yes TDS to be calculated separately according to the govt norms.

      Reply
  29. sarath says

    October 3, 2018 at 12:45 pm

    Hi, I Need to add O.T (over time) cell. how can i create it possible?

    Reply
    • Fahim Lashkaria says

      October 6, 2018 at 5:37 am

      add a column and configure the formulas.

      Reply
  30. akshay says

    October 13, 2018 at 9:03 am

    sir , i was beginner of excel , so can u provide formulas for simple learnable payment sheet…..

    Reply
    • Fahim Lashkaria says

      October 14, 2018 at 2:25 pm

      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. Kumar Jha says

    October 28, 2018 at 5:38 am

    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
    • Fahim Lashkaria says

      November 5, 2018 at 10:26 am

      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. Rachael says

    October 29, 2018 at 1:47 am

    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
    • Fahim Lashkaria says

      November 5, 2018 at 10:29 am

      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
  33. BHAGYASHRI says

    November 24, 2018 at 11:39 pm

    I WANT TO KNOW SALARY STRUCTURE IF GROSS SALARY IS 15000

    Reply
    • Fahim Lashkaria says

      November 26, 2018 at 1:05 pm

      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. Pankaj says

    December 30, 2018 at 2:08 pm

    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
    • Fahim Lashkaria says

      December 31, 2018 at 3:41 pm

      You need to edit the vlookup formula for that

      Reply
  35. Nasser says

    July 18, 2019 at 10:54 am

    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
    • Fahim Lashkaria says

      July 18, 2019 at 11:58 am

      You are welcome. Glas to know it was helpful to you. You can add sheets according to your need.

      Reply
  36. Priya says

    July 31, 2019 at 12:59 pm

    Hello Sir
    Emplyees/labour name and ctc are changed every month so which formula would be use for change the ctc with name, designation, year and month.

    Reply
    • Fahim Lashkaria says

      July 31, 2019 at 2:10 pm

      This template is for those who use static data. In the case of labor continuously changing you need to enter the amount manually.

      Reply
  37. hussain says

    August 6, 2019 at 12:26 am

    how i can get this template i cant pay

    Reply
    • Fahim Lashkaria says

      August 6, 2019 at 2:41 pm

      Payment received and Templates sent. Thanks

      Reply
  38. madhan s says

    January 18, 2020 at 2:30 pm

    Sir

    I want complete break up ( salary structure ) private limited organisation .

    Example : ( 20000 salary ) ( 26 days calculation) = Basic ,Da , Hra ,Special allowance )

    I don’t know week off how to mention (sunday 5 days salary )

    kindly consider and given this break up sir

    email id : mathanani91@gmail.com
    Con : 9585566659

    Reply
    • Fahim Lashkaria says

      January 18, 2020 at 4:34 pm

      You can change anything you want according to your needs on this sheet. Thanks

      Reply
  39. Naushad aNwar says

    March 5, 2020 at 4:52 pm

    i want to print all employees salary at once via vba code rather than selecting one by one from combo box. kindly help me pls.

    Reply
    • Fahim Lashkaria says

      March 7, 2020 at 12:20 pm

      You can add code.

      Reply
  40. Altaf Hussain says

    March 6, 2020 at 1:18 pm

    I have made sheet in excel link is as follows kindly download and suggest if there is some requirements
    https://up-load.io/users/altaf880

    Reply
    • Fahim Lashkaria says

      March 7, 2020 at 12:18 pm

      File unable to download

      Reply
  41. Kuldeep Saini says

    June 5, 2020 at 3:25 pm

    Hi Sir,

    This Sheet was wonderful,
    I have a suggestion
    1. in the data base sheet . Employee ID Should be there,
    2. In the Salary Sheet . Vlookup Link with Employee ID Insteed of Name
    because an org have more then one person of same name

    Reply
    • Fahim Lashkaria says

      June 5, 2020 at 4:04 pm

      Thanks for the suggestion. Will look into it.

      Reply
      • Kuldeep Saini says

        June 5, 2020 at 4:09 pm

        Dear Sir,

        Please let me know after changes

        Reply
        • Jhun says

          June 29, 2020 at 8:34 am

          im waiting for the update.

          Reply
          • Fahim Lashkaria says

            June 29, 2020 at 1:59 pm

            What kind of update dear.

  42. Avijit Das says

    February 20, 2021 at 2:20 pm

    Sir can u send me the new revised central minimum salary excel calculation format along with the salary slip format please.

    Reply

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