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...
this is for your ref

Attached Files
Membership is required for download. Create An Account First
File Type: xls Payroll(1).xls (18.0 KB, 4206 views)

Community Prime Sponsors
FactoHR.com - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS.
Talentedge.com "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA.
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?
--NIRANJAN RAI
hi dear' yaa i got it. so m sending salary slip.

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

Thanks Amit, Here is my contibution... I felt the slips need to be neatly done... hope my format looks good

Attached Files
Membership is required for download. Create An Account First
File Type: xls Template.xls (38.5 KB, 3251 views)

Hello!
Usually the bifurcations are done in following manner:
Basic Salary : 40% of Gross salary (maximum limit is 40% of Gross Salary)
House Rent Allowance : 20% of Gross salary (must be 50% of basic salary)
City Compensatory Allowance : 20% of Gross salary
Conveyance Allowance : 10% of Gross salary
Medical Allowance : 5% of Gross salary
Other Allowances : 5% of Gross salary
Total : 100%
Exemption for I-Tax:
HRA
Conveyance
In case if you Co prefers medial reimbursements instead of medical allowances, medical reimbursements up to Rs. 12,500 is non taxable only against submition of bills.
Hope this is what you are looking for and it will help you to clear the doubt.
Pallavi R
Dear Friends i am attached salary slip hope it is usefull to you manish

Attached Files
Membership is required for download. Create An Account First
File Type: xls SALARY SLIP.xls (22.0 KB, 2928 views)

Hi, Find attached the Payslip Model Regards, Esther

Attached Files
Membership is required for download. Create An Account First
File Type: doc Payslip Model.doc (31.0 KB, 3373 views)

Can anyone post a salary slip where the working days are 30 but paid days are 25 ( employee is absent for 5 days). How can i show the deductions. Can i show it directly on the deductions side or i have to cut it from the earnings structure ???
Please help,
Thank you.
Al the payslips are help full but I stay in South Africa and we don't substract all the taxes and stuff like you do. Is there anyone in South Africa that can help me find a payslip that works with exel.
Please HELP
Hi,
The HRA and Basic pay are connected for HRA Computation as explained below:
eg. your basic pay is Rs. 6000, HRA is Rs. 3000 and monthly rent paid by you @ Rs.2500/-. The HRA computation is worked out as follows:
HRA Computation

i) HRA received 36,000 ii) Rent paid 2500*12 30,000 ii) Rent paid Less 1/10 of salary 7,200 -------------- 22,800 iii) 2/5 of salary 28,800 Least of (i), (ii), (iii) is exempt 22,800
Regards,
Saraswathi

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™