If gross salary is equal to minimum wage, how can we accommodate such employees in % wise bifurcated Excel ? - CiteHR
Prime Sponsor - FactoHR.com - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
Hello Everyone !
In my organisation salary amount varies from min wage to 1.5 lakh per month for different employees. Currently we are managing it through manual entries in salary register. But now we want to switch to fix % for basic (where basic should not be less than minimum wage), HRA, CCALL, etc. but those formulas give unrealistic data in cases where wage is either too high or just minimum wage.
For example, in case of minimum gross salary, Rs. 8,554 - it considers basic salary Rs. 3,422 which is unacceptable from legal point of view.
Same way if gross is 1,00,000 - it calculates 40,000/ - as basic salary. this results in increased liability of bonus and gratuity .
Please help me with some excel format which can help me solve these issues.
Thank you in advance...
Viral Sheth
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
It will not be possible to create a uniform formula in excel sheet covering pay fixation of all employees as the range is too wide and the parameters are different. Probably, you may have define certain pay bands and fix salary using certain standards applicable to each band. It would be better to consider making some programme based calculation rather than excel sheet for this purpose.
Thank you KK for your responce.
But can you please elaborate ..... which kind of program you are referring to ?
Can you please suggest name of such program for better understanding ?
Thank you once again.
There are various standard software available in e-market for payroll management or you may get one programme made for you to meet specific requirement of your salary computation. The latter is a better option.
Prime Sponsor - Talentedge.com "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™