Reg: Pay Rolls - Xls Download

Hello All,
Can anybody give me the details of payrolls that,
How to calculate the payrolls,What all are the percentages to calculate basic salary,(Employee PF, Employer PF, Other benefits, Gratuity, HRA, Spacial Allowance Etc...), How to give the break ups in the pay slips........??????????????
Still I have lot doubts regarding payrolls.
Please help me in this regard.
Thanks,
Mahadeva

Dear Mahadeva,
Now a days Co.work on CTC(Cost to Company) concept. Rule of Bk-up varies from company to company as per their policy but generally basic is kept at 40-50 % of CTC, HRA is 40-50 % of Basic.
Employer & employee PF is at 12% of basic respectively, 4% of basic as gratuity.
Your query is not very clear still trying to answer you but request you to mail me clear question you have.You want to know about CTC bk-up or about how pay slips are generated ? Plz clarify for exact answer.
Rgds,
Shilpi

What Shilpi has given is very true, this is the procedure all the organisations are following these days.
S.Gaur

Shilpi,
Could you please explain on the taxable and non-taxable components of CTC also? How does components like sodexho gets calculated or counted? Thank you

Dear Mahadev,
Taxable & Non - Taxable comes when you decide for your components of CTC but like you said Sodexho Coupons these are benefits given to employee so this is non taxable for employee but employer has to bear fringe benefit tax for it. Similiary any benefits in terms of Reimbursement if provided to employee it is non-taxable.
Medical, LTA, Telephone Expenses or any reimbursement are non Taxable whereas Fixed and variable salary like Basic, HRA,Spl.allow, Performance pay are taxable Income for employee.
Hope it will help you to understand salary components.
Rgds,
Shilpi

Hi,
I am attching a salary break up document which I have collected from HR Cite I hope it will be useful to u.
Regards
Deepa

I am attaching the CTC calculator which I have developed for my company.
You will find it handy & helpful in developing your system.
S.Gaur

Dear Mr. Gaur ji,
It very handy and useful for every one for CTC calculation of Salaries.
Keepit up.
Regards,
:)
PBS KUMAR

Dear Sir,
Can you please tell me the PF contributions of both EMPLOYEE AND EMPLOYER.
suppose if my basic is 16,000/- then what is the contribution procedure?
Please reply soon,
Regards,
K. Ravi Kumar
E-mail: [Login to view]
Ph: 09989111149
HYDERABAD.

Hello Shilpi,
Thanks for your efforts in clarifying my doubts,
Can I have your contact details so that I can explain my doubts clearly!!!!!!
Sorry!!!! that I am responding late but I was unable to access citeHR yesterday.
Thanks,
Mahadeva