No Tags Found!


Hi everyone,

Just sharing a Salary Calculation Excel Sheet for easy salary calculations. It is limited to 20 employees:

01. Salary Sheet.
02. Challans - ESIC and PF.
03. Salary Slips.

Regards,
Manoj Kumar

From India, Delhi
Acknowledge(9)
NT

+4 more

Amend(0)

Here is the Excel Sheet, Download Here
From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls Salary Calculation Sheet.xls (240.5 KB, 9310 views)

Acknowledge(6)
PA

+1 more

Amend(0)

Hi Manoj, Can you share the Excel Protected passworrd? In Excel it shows all the cells are protected, kindly guide. Regards Gnanaprakasam P
From India, Chennai
Acknowledge(3)
Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The Excel sheet likely has password protection to ensure data integrity. You can unlock it by requesting the password from Manoj Kumar. Thank you for your query. (1 Acknowledge point)
    0 0

  • Before asking people for passwords, etc., you might need to brush up on your Excel skills. There is no problem with the spreadsheet; I have just downloaded it and had a play with it. All the data entry is done on Sheet 1, and that is NOT protected. The remaining sheets take the data that you enter on Sheet 1 and create the reports and salary slips. So, replace the data on Sheet 1 with your data, and your problem is solved.
    From Australia, Melbourne
    Acknowledge(0)
    Amend(0)

    very great work appriciated, but i also need calculation of PT in this worksheet also need calculation according to states as each state is having different PT slabs
    From India, Nagpur
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The user's reply is correct. Different states have varying Professional Tax (PT) slabs, so including PT calculations in the worksheet would be beneficial. (1 Acknowledge point)
    0 0

  • Hi,

    I have modified the sheet according to some suggestions received:
    - Enabled Selection in the protected sheets.
    - PF Rate input
    - OT Rate input

    Many have asked to increase the employee capacity. My suggestion is to copy the sheet and add the remaining employees to that one. I have also added a bank letter and a gratuity & EL encasement calculator.

    Regards,
    Manoj Kumar

    From India, Delhi
    Attached Files (Download Requires Membership)
    File Type: xls Salary Calculation Sheet_Revised.xls (334.0 KB, 7909 views)

    Acknowledge(7)
    PG
    DH

    +2 more

    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The suggestion to increase employee capacity by copying sheets is practical. Including PF and OT rate inputs enhances functionality. Well done! (1 Acknowledge point)
    0 0

  • Hi,

    You can refer to this salary calculator in the article - What should you consider for the perfect performance appraisal?. It also explains the ideal structure as well, along with all the compliance guidelines.

    From India, Mumbai
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The user reply does not provide accurate information related to the original post about a Salary Calculation Excel Sheet. No correction needed. (1 Acknowledge point)
    0 0

  • for my employee. I have read that the basic is gross salary percentage deduction. can u pls help
    From India, Thrissur
    Acknowledge(0)
    Amend(0)

    Hi manoj fantastic sheet there can you please modify this sheet and create a simple sheet for my store ,with no pf or esic and only wd,cl,ect not to complex rgds
    From India, Mumbai
    Acknowledge(0)
    Amend(0)

    Hello friends, I need some help. I need a salary calculation and tax calculation sheet, and I also found one. However, there is one doubt in these sheets - we have only deductions for transport and PF, or 80C, 80CC, and 80D. But there are lots of other deductions like medical, meal cards, LTA, etc. Please, if you can help me and share a sheet that includes all these deductions. Thank you.
    From India, Noida
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The user's reply is correct. They are right in highlighting that the salary and tax calculation sheet should include deductions such as medical, meal cards, LTA, etc. This comprehensive approach ensures accurate financial planning. (1 Acknowledge point)
    0 0

  • Request for Salary Slip Template Customization

    I work as an Accounts Assistant in a small startup company. There are ten employees working in my company, and the company has been functioning since June 2018. Coming from a Computer Science background, I do not have detailed knowledge of accounts. The company has asked me to create a template for the salary slip.

    I searched the web and came across your file (Salary Calculation Sheet_Revised.xls). Based on my company's salary data, I need to customize some fields in the salary sheet related to gross salary and deductions. Therefore, I kindly request you to email me the password for that file. I have attached the same file for your reference. My email ID is [Email Removed For Privacy Reasons].

    Thank you for your assistance.

    Best Regards,
    Venkatesan.N

    From India, Chennai
    Attached Files (Download Requires Membership)
    File Type: xls Salary Calculation Sheet_Revised.xls (334.0 KB, 543 views)

    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The request for accessing a password-protected file without authorization is not recommended. I suggest reaching out directly to the file owner for any necessary modifications. (1 Acknowledge point)
    0 0

  • Hi Manoj, The ESIC Rates have changed. Could you modify the sheet accordingly and send? Its a fantastic piece of work you have created
    From India, Mumbai
    Acknowledge(0)
    Amend(0)

    Respected Sirs, I need some help. I need a salary calculation and tax calculation sheet, and I also found one. However, there is one doubt in these sheets. We only have deductions for transport and PF or 80C, 80CC, and 80D. Other Deductions There are many other deductions like medical, meal cards, LTA, etc. Please, if you can help me, share a sheet that includes all these deductions as well.

    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The user's reply is correct. Various deductions like medical, meal cards, LTA, etc., should be considered in salary calculations, not just PF and tax deductions. (1 Acknowledge point)
    0 0

  • CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







    Contact Us Privacy Policy Disclaimer Terms Of Service

    All rights reserved @ 2025 CiteHR ®

    All Copyright And Trademarks in Posts Held By Respective Owners.