Vhj7143
Hr Executive
Sunny0809
Student
+1 Other

Hello, i am vikas - recently join small company. please tell me how i can make salary structure of Rs 13000/- Per Month.
1st November 2017 From India, Jalalpur
Particulars Monthly (Rs.) Yearly ( Rs. )
Gross Pay Components

Basic Salary 5200 62400
House Rent Allowance 2080 24960
Special Allowance 2796 33552
Conveyance Allowance 1600 19200
Special Allowance 0 0
 A Monthly Total 11676 140112

Annual benefits
Medical Allowance* 0 0
Leave Traval Allowance** 0 0
Bonus** 700 8400
B Total Annual Benefit 700 8400

Annualized Retirals

Provident Fund - Employer Contribution 624 7488
 C Total Annualized Retirals 624 7488
Total Cost to Company (A+B+C) 13000 156000
1st November 2017 From India, Pune
#Anonymous
How did you calculated or used formula for special allowance and bonus? - Prashanth
1st November 2017 From India, Hyderabad
Particulars Amount Rs. (Per month) Amount Rs. (Per annum)
Basic 4550 54600
H R A 2275 27300
Conveyance Allowance 1600 19200
Medical Allowance 1250 15000
LTA 4000 48000
Employers' PF Contribution 546 6552
Special Allowance 0 0
Total Salary 13000 156000
Employee PF Deduction 546 6552
Employee ESI Deduction 228 2730
TDS* 0 0
Professional Tax 200 2400
Total Deductions 974 11682
Net Salary 12027 144318
3rd November 2017 From India, Bengaluru
Particulars Amount Rs. (Per month) Amount Rs. (Per annum)
Basic 4912 58949
H R A 2456 29474
Conveyance Allowance 1600 19200
Medical Allowance 1250 15000
LTA 4000 48000
Employers' PF Contribution 589 7074
Special Allowance 0 0
Total Salary 14035 168425
Employee PF Deduction 589 7074
Employee ESI Deduction 246 2947
TDS* 0 0
Professional Tax 200 2400
Total Deductions 1035 12421
Net Salary 13000 156004
This is for 13k in hand. The previous one was 13k as gross
3rd November 2017 From India, Bengaluru
What are the %ages you have used to calculate the components Divya?
3rd November 2017 From India, Delhi
What are the %ages you have used to calculate the components Divya?
3rd November 2017 From India, Jalalpur
Prashant B Ingawale can you tell me what are % use ?
3rd November 2017 From India, Jalalpur
Particulars Amount Rs. (Per month) Amount Rs. (Per annum)
Basic =B9*35% =B2*12
H R A =B2/2 =B3*12
Conveyance Allowance =IF(B9-(B2+B3)>1600,1600,CB170-(B2+B3)) =B4*12
Medical Allowance =IF(B9-(B2+B3+B4)>1250,1250,B9-(B2+B3+B4)) =B5*12
LTA 4000 =B6*12
Employers' PF Contribution =IF(B2>=15000,1800,IF(B2<15000,B2*12%,0)) =B7*12
Special Allowance =IF(B9>(B2+B3+B4+B5+B6+B7),B9-(B2+B3+B4+B5+B6+B7),0) =B8*12
Total Salary =C9/12 156000
Employee PF Deduction =IF(B2>=15000,1800,IF(B2<15000,B2*12%,0)) =B10*12
Employee ESI Deduction =IF(B9<=21000,B9*1.75%,0) =B11*12
TDS* 0 0
Professional Tax 200 =B13*12
Total Deductions =B13+B11+B10 =B14*12
Net Salary =B9-B14 =C9-C14
3rd November 2017 From India, Bengaluru
#Anonymous
Divya Mishra can you share the excel working sheet.
3rd November 2017 From India, Hyderabad
Add Reply Start A New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)





About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™