How Should Mentain Salary Details? - Xls Download

Dear All,
Am new in HR field am confused how should i mentain salary structure of our emplyoee in my organisation HR dep also new?please help me how should i prepare their revised salary,CTC,pf,Bonus?
13th October 2008 From India, Mumbai

Hi Pallavi,
Do you have technology deployed at your firm? If yes you could maintain it on the payroll module.
Else you could make use of excel. But that would be a tedious process unless you have a defined salary structure for employees at specific levels.
Regards....
13th October 2008 From India, Mumbai

Hi Pallavi, Attached is a sample salary structure for your reference. Thanks
13th October 2008 From India, Faridabad

Attached Files (Download Requires Membership)

Sample Salary - 10Lac.xls (36.5 KB, 2160 views)

Hi Sumit,
Thanks for your reply,it very useful for me but i have one doubt how should mentain revised salary record n which S/W is good that our organisation is thinking about to purchsa S/W package.

13th October 2008 From India, Mumbai

Hi Pallavi,
I hope my information with regards to a technology / software were useful.
I would strongly recommend Smileserm (IBM award winner 2008). Its a fantastic software with the option of even customising it to your organisation.
You could call on 09820389180 and they could arrange an online demo for you.
Hope it helps!
All the best.
13th October 2008 From India, Mumbai

Hi Pallavi,
There are a lot of software packages and I can suggest you the best fit as per your requirement and budget, if you can give me a bullet point idea...
Please do write back for any other queries also!
Thanks
14th October 2008 From India, Faridabad

Hi Sumit,
Thanks, actually our organisation establised in 2006 that we have right now 25 employee among that some is on contract basi and some in permantat basis so before me all record mentained by manually there was no HR so now i have mentain in excel but its very tedious,i cant make very neatly there salary break -up, and revised salary etc. so please tell me which s/w is best that i can suggest to my company for purchse and i have no ideas about PF and all that things

14th October 2008 From India, Mumbai

Dear Pallavi

FYI
Annexure Name :Grade:Designation: Location :WEF :Monthly Payments Amount (Rs.) Basic (Max upto 25% of ATC) 1500HRA (60% of Basic ) / If CLA (will include monthly house rent & 10% interest on deposit paid by comp.) 900Transport Allowance800Adhoc Allowance 2165Food Coupons-Driver Reimbursement-Gross Per Month (GPM)5365GPM5365Gross Per Annum (GPA) = {GPM*12}64380PF180Annual Payments ESIC94Ex-Gratia 1500Medical Reimbursement0PT40Leave Travel Allowance-Tot Deduction314RetiralsNet5051Provident Fund as per Act (Employer's Contribution)2160Superannuation Fund -(Optional & only for PRIL employees)-Annual Total Cost (ATC)= {GPA +Annual Payments + Retirals}68040Annual Total Employment Cost (ATEC)={ATC +Reimbursable benefits}68040Affiliation PerksHouse Loan Interest Subsidy - On confirmation -Gratuity (As per Act) accruable after 5 yrs (maximum payout - 350000/-) 866Hospitalisation (Medical Insurance) floating cover for self+ spouse+ 2 children+ parents, Applicable for non ESIC members-Averaged Premium amount0ESIC (Employer's contribution - Applicable if GPM is less than or equal to Rs. 10000/-)3058Group Term Life Insurance-Premium amount160Life Security Plan-Premium amount-Total Cost to Company excluding Variable Pay 72124Total Cost to Company (TCTC)={ATEC + Affiliation Perks+Variable Pay}72124Name = XName :Deputy Manager - Human Resources

Aparajita
14th October 2008 From India, Guwahati

Dear I am attaching a file, and i hope it will help you
14th October 2008 From India, Delhi

Attached Files (Download Requires Membership)

salary_structure-ctr_856(1).xls (60.5 KB, 268 views)

Dear all, Can you inform me the amount i will i get after withdrawal. 500/- per month have been deducted during 11 months. basic was 4500/- with regards samir
14th October 2008 From India, Calcutta