needcom
35

Hi everyone, Just sharing 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
needcom
35

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, 9165 views)

gprakasammsw
5

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
aussiejohn
658

Gprakasammmsw
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
ashu2aashu
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
needcom
35

Hi,
I have modified the sheet according to some suggestion received.
  • Enabled Selection in the protected sheets.
  • PF Rate input
  • OT Rate input
Many asked to increase the emp capacity, my suggestion to copy sheet and add remaining emps to that one. Also added bank letter and 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, 7725 views)

Kalpesh 94
1

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 with all the complaince guidelines .

From India, Mumbai
bindhyasnair38@gmail.com
for my employee. I have read that the basic is gross salary percentage deduction. can u pls help
From India, Thrissur
Stitchworks
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
prabha.gse
Hi Manoj thanks for the format Regards Prabha
From India, Chennai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.