Pay Slip -excel Format - Xls Download

Dear All
please give me suitable suggestion
i m working with a contractor, principle employers want gratuity amount payed on monthly basis
how to calculate gratuity on monthly basis
regards
mukesh sharma
mail id is [Login to view]

Hi Friends,this is Manisha. The information i saw is very much help full to me, but let me know some details...
I would like to know what is the deduction method of P.T for diff salary structures. Is P.F is of 12% for all the organizations or else depends? May I know will it start from 12%?

Dear Frnz
It is nice to see the pay slips in various formats. But In some pay slips there is no Deduction of PT. More over the rate of PT varies from state to state. More over there is no DA in payslip where in I believe as it is verymuch necessary as per labour rules. More over the PF deduction of employeer might be restricted max to 6500 so the calculations has to be changed.
Cheerz
Jeeva

can any one let me know whether BAsic, DA and HRA are to be having %age in the full pay.
At most times i noticed Basic to be 40%, Da to be 10% and HRA to 20% of basic pay.
Is that according to industry standards or not?
I want some quick response.. plz help out.

swetesh modi
wanksons chemical ind pvt ltd
Panoli
persnoal officer

Dear All. Thanks for the various types of Payslips. But in none of the payslips there is no heading of Basic & DA divided. But as per the shops act I beleive DA is necessary

Thanks friends.....
we have got to se more than one salary slip....
now we have a fair idea of that...
but i wanted to know are HRA and other parts depend on the basic pay? how are they related?
viney

Dear Ms Sohini,
how are you?

Thanks a lot for sending us the overview about your Salary slip.

But i sent salary slip format please see this format and repli me as soon as

Best Regards

Narendra Singh

HI,
If ur Salary is Rs.20,000/- pm then the Bifurcation will be as follows
Basic :Rs.10,000/-
HRA :Rs.4,000/-
Conveyance : Rs.800/-
Medical Allowance :Rs.1,250/-
Other Allowance : Rs.3,950/-
Regards
Kiran

here is enclosed two .xls files containing salary slip format & full & final settlement statement. hope these will help you in your company.
thanks
sunil chaudhary
9816720009