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.

From India, Madras

Attached Files
File Type: xls payroll.xls (25.5 KB, 2353 views)

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/[email protected]

From India, Hyderabad

Attached Files
File Type: xls salary format 2011 for CL.xls (29.5 KB, 1730 views)

Hi There is no universal format for salary structure. However, earnings should be in LHS & deductions in RHS.
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
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
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
From India, New Delhi

Attached Files
File Type: xls Payroll Annexure-2 (2).xls (20.5 KB, 2194 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

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.
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

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

If you are knowledgeable about any other fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 Cite.Co™