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
Acknowledge(0)
Amend(0)
From India, Jalalpur
Acknowledge(0)Amend(0)
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
Acknowledge(2)
Amend(0)
470Gross 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
Acknowledge(2)Amend(0)
How did you calculated or used formula for special allowance and bonus? - Prashanth
From India, Hyderabad
Acknowledge(1)Amend(0)
From India, Hyderabad
Acknowledge(1)Amend(0)
Particulars | Amount Rs. (Per month) | Amount Rs. (Per annum)
Basic | 4550 | 54600
HRA | 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
Acknowledge(1)Amend(0)
Basic | 4550 | 54600
HRA | 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
Acknowledge(1)Amend(0)
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
Acknowledge(1)Amend(0)
This is for 13k in hand. The previous one was 13k as gross
From India, Bengaluru
Acknowledge(1)Amend(0)
What are the %ages you have used to calculate the components Divya?
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
What are the %ages you have used to calculate the components Divya?
From India, Jalalpur
Acknowledge(0)Amend(0)
From India, Jalalpur
Acknowledge(0)Amend(0)
Salary Structure Calculation
Particulars Amount Rs. (Per month) Amount Rs. (Per annum)
Basic =B9*35% =B2*12
HRA =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
Please review the corrected text for any further adjustments.
From India, Bengaluru
Acknowledge(3)
Amend(0)
Particulars Amount Rs. (Per month) Amount Rs. (Per annum)
Basic =B9*35% =B2*12
HRA =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
Please review the corrected text for any further adjustments.
From India, Bengaluru
Acknowledge(3)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
SALARY SHEET CALCULATION.xls
Employee Benefits.doc