Salary Slip And Full And Final Settlement Format - XLS Download

HI,
I HOPE THIS HELPS MY FREINDS.
COMPENSATION AND PAY ROLL ARE MY WEAKEST AREA.
BUT HOPE MY FRIENDS FIND THE SAME USEFUL
THANK YOU
OCTAVIOUS
For various links to my posts, kindly visit the links provide herein below
https://www.citehr.com/99968-major-hr-links.html
25th September 2007 From India, Mumbai

Attached Files (Download Requires Membership)

salary_structure_186.xls (52.0 KB, 12120 views)

payslip_813.xls (20.5 KB, 8037 views)

full_and_final_835.xls (34.0 KB, 11273 views)

Hi Octavious,
You have a done good job in making the formats which are correct. Basic salary which is 59% of the ctc is on the higher side as industry standards veers towards 45-50% and also you can include the tax free components like meal vouchers of Accor or Sodexho which is exempted upto Rs 50 per day.
Would recommend that you read the Tax manual on components on Salaries Heads to provide better insight.
In Full n final settlement, you have to include the PF deduction on leave encashment ( PL/EL) which is statutory requirement.
Chak De India!!
Rajat Joshi
26th September 2007 From India, Pune

Dear Rajat,
My field of expertise is Strategic HR and Employee Relation.
Compensation and Benefit is the last thing I would ever deal in with, as I am very bad with numbers.
The above postings are some material I collected over a period of time from various sources.I would request if you could then download the same and rectify it, as it would help lots of people, because I am not the right person do do the same, but form your advise I believe that you have good and very in depth knowledge regarding the same.
With Regards
OCTAVIOUS
27th September 2007 From India, Mumbai

Hi, Thanks for your attachments they were helpful ..can u provide me with some appraisal formats for my sales guys....assessment sheets...... Regards, Muskan
2nd October 2007 From India, Indore

Dear Octavious,
Great to know that and it is enlightening to read your postings as well.!
If you ask me frankly , you have done a fairly good job notwithstanding your equations with numbers! :D Guess if one trys sincerly everything is within reach and become savvy as well.
Well, i have attempted to redefine the compensation structure in sheet comp-structure for the salary structure of Rs 2.75 Lacs p.a. which is fairly okay and balances with the FBT and Indian Tax laws after all there are two things certain -----> Death and TAXES!! :)
Fuel and entertainment expenses should be kept out of purview of the structure as they attract FBT - the logic is simple either the employee pays tax by way of perks or FBT by the company but not both!.
Best Regards,
Rajat Joshi
5th October 2007 From India, Pune

Attached Files (Download Requires Membership)

salary_structure-ctr_856.xls (60.0 KB, 3823 views)

Hi Octavious,
Iam really thankful to you for mailing the material with salary break up. Even Iam not not an expert in compensation management. I was really in need of information for structuring the breakup for 2lacs, 1.25 lacs, 85k & 70 K. I had even posted my query but it was futile as i din get any useful & reasonable responses.
Thanks a lot once again..
keep sharing..
17th October 2007 From India

Dear All,
Greetings for the day.........
i will be thankful to you if anyone responds to me for my query
As i want to the esi and pf deductions and even the half yearly and annual
returns that will be done by any common organisation. :?
18th October 2007 From India, Madras

Greetings: Does anybody have a Full and Final Settlement Policy? Please do share one with me as I am in need of one very urgently. Thank you very much in advance. Abdul Rozak
28th May 2008

Can any one help me with a copy of Check list of payroll processing pls. what has to be taken care while processing salary for a month.
6th June 2008 From India, Bangalore

can yu anyone help me to getting job in HR .prevoiusly i was working due to some health reason i quit the job
6th June 2008 From India, Lucknow