Please Review This Payroll Process Xls As Designed By Me- Thankyou

Dear sir/ madam:
I am ruban pursuing M.S.W(H.R) in mar gregorios college. I prepared one payroll process as per my knowledge. I am expecting your suggestion and correction so that i may correct my self. I am waiting for your valuable comments.

Hi,
This is Karra sarma working as Sr. Officer - HR
ur prepared payroll statement is HRA, TRAVEL ALLOWANCE IS WRONG
BASICALY, HRA IS 40%/50% ON basic amount based on non-metro/metro city as per IT Exemption rules
travel allow 800/1650 for Normal Health/Physcially handcop as per IT Exemption Rules
we should not show PF & ESI as earning cloums
as per act, we should deduction PF 12% on Basic+DA/Gross amount & ESI is 1.75% on Gross Salary.
we should not deduction Employer Contribution of PF & ESI from salary. if dedcuted PF & ESI than govt authorites thread to organziation due to wrong practices.
Employer contribution should contributed by Employer only.
and Basic + DA amount mention as per Minimum Wages applicaplitiy as Govt GO
Pls see my payroll statement and feel free call to me or write a email for clarification
Regards/Sarma/9160019220/sarmakpk1981@gmail.com

Hi
There is no universal format for salary structure. However, earnings should be in LHS & deductions in RHS.

Dear ruban,
Seen your salary sheet and comments given by sharma is appreciated. Also would like to add EPs8.33% MAX up to Rs.541/- only rest of amount goes to PF which pls update.
Regards,
ASK

Dear Sarma,
wat about ESI & EPF cieling???
EPF it is fine if ur org allows contribution more than 6500 but in ur pay sheet, there is no cieling for ESI.
pl check

Hi Ruban,
Attached is a Payroll format for your understanding...... please review and if you need anything to insert further, please revert.
Thanks
Taru

Dear Friend
Please change the PF card No. into PF Account No Calculations and other details are okay
Please start with Basic Pay, HRA can be a lump sum or upto 40 to 50% of basic, Not everyone will be on travelling so travel allowance is not required Instead you can make it as Conveyance Allowance.
in Totallity it seems to be okay
All the best dear

Dear Mr.Ruban I have gone thru the xls file and I suggest HRA can be worked out at 50% of basic instead of 25% so as to avoid taxation on HRA.

hello seniors:
As i am studying i prepared it. But i dont know the split ups can any one help out in split up and i am 0 in tax. Can u teach me so that it will be helpfull for me and one more how the attendance will be taken we should take as 30,31 or else 30.5...... These were the doubt i got can u pls clear my doubt. Thanks a lot your suggestion and corrections seniors. Thanks a lot
thanks and regards
Ruban

hello seniors :
Can any one help me out in salary split ups, tax and attendance ......... Seniors help me out