Industrial Relations
Hr Executive
+4 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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.

Attached Files
File Type: xls payroll.xls (25.5 KB, 2343 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

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

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

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

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

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

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 @ 2020 Cite.Co™