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
15th July 2013 From India, Lucknow

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

Attached Files (Download Requires Membership)

msror-SALARY-BREAK-UP.xls (20.0 KB, 1085 views)

Dear Madam, Please find the attached CTC sheet of 4.2 lac for your kind perusal.
17th July 2013 From India, Pune

Attached Files (Download Requires Membership)

CTC_4.2.docx (17.9 KB, 393 views)

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
18th July 2013 From India, Mumbai

Dear Mahendra & babisolmanraju, PF is deducted on Basic Salary i.e. Rs. 14000.00.
18th July 2013 From India, Pune

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
18th July 2013 From India, Delhi

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
23rd July 2013 From India, Guwahati

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/
19th May 2016 From India, Mumbai