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.
12th February 2011 From India, Madras

Attached Files (Download Requires Membership)

payroll.xls (25.5 KB, 2383 views)

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
13th February 2011 From India, Hyderabad

Attached Files (Download Requires Membership)

salary format 2011 for CL.xls (29.5 KB, 1779 views)

Hi There is no universal format for salary structure. However, earnings should be in LHS & deductions in RHS.
14th February 2011 From India, Pune

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
14th February 2011 From India, Madras

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
14th February 2011 From India, Hyderabad

Hi Ruban, Attached is a Payroll format for your understanding...... please review and if you need anything to insert further, please revert. Thanks Taru
14th February 2011 From India, New Delhi

Attached Files (Download Requires Membership)

Payroll Annexure-2 (2).xls (20.5 KB, 2282 views)

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
14th February 2011 From India, Kumbakonam

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.
15th February 2011 From India, Madras

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
15th February 2011 From India, Madras

hello seniors : Can any one help me out in salary split ups, tax and attendance ......... Seniors help me out
19th February 2011 From India, Madras