Please Help Me To Prepare Salary Break Up - XLS Download

Dear Seniors,
I Sangeeta Singh, working in Real Estate company as HR Officer. Now i have to prepare Salary Annexure & Salary Slip for Manager Level with CTC - 4,20,000.
Please help me... I want to learn norms of DA, Education Allowance, Gratuity, Superannuation and LTA.
Regards,
Sangeeta Singh
HR Officer

Dear Singh,
Please find the attached file and hope it will resolve your query.

Dear Madam,
Please find the attached CTC sheet of 4.2 lac for your kind perusal.

Dear Prashant,
Your salary breakup sheet is very useful but i found some extra deduction(pf contribution), please clear this.
Thanks and Regards
Mahendra Patole

Dear Mahendra & babisolmanraju,
PF is deducted on Basic Salary i.e. Rs. 14000.00.

nice work thanks for sharing evan i m good in aspects but formula and all r difficult to calculate its a standard format im planning to use to company

Dear Prashant Ingawale,
Statutory Contributions can not be shown in CTC and another thing is if it is CTC Employer Contribution in total alongwith PF Admin Exp. it will be 13.61.
Kindly Correct me.
Hrkpati

Structuring salaries is an very difficult process that every HR manager has to go through.
HR managers that i know are uninformed about the technical aspects of the salary structures .
Here's an link to the article that i referenced to because it is a informative guide explaining all the components of the salary and has the compliance guidelines related to the components as well .
http://quikchex.in/salary-structures-india-need-know/