Hello, i am vikas - recently join small company. please tell me how i can make salary structure of Rs 13000/- Per Month.
From India, Jalalpur
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
From India, Pune
467Gross 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
From India, Pune
How did you calculated or used formula for special allowance and bonus? - Prashanth
From India, Hyderabad
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
From India, Bengaluru
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
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
From India, Bengaluru
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
From India, Bengaluru
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
From India, Bengaluru
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
From India, Bengaluru
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.
Salary-Note.doc
SALARY SHEET CALCULATION.xls