Pay Slip -excel Format - Xls Download - CiteHR
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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
mukesh sharma
mail id is
Community Prime Sponsors - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA.
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.
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

Attached Files
Membership is required for download. Create An Account First
File Type: xls New Microsoft Excel Worksheet.xls (25.5 KB, 2418 views)

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?
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

Attached Files
Membership is required for download. Create An Account First
File Type: xls Salary Slip Narendra.xls (145.0 KB, 4254 views)

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/-
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

Attached Files
Membership is required for download. Create An Account First
File Type: xls salary slip format.xls (46.0 KB, 2720 views)
File Type: xls full & final settlement format.xls (25.0 KB, 1830 views)

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™