1
Hi Dear, I am having a format which is using by me in our organisation. hope it help you to make the best one .... kindly see the attachment as doc file
From India , Ghaziabad
From India , Ghaziabad
Hi, Please find the attached document.It calculates automatically and make the changes accordingly. Regards Leons Louis
From India , Kottayam
From India , Kottayam
Hi Leons Louis, Thanx a lot.. It has solved my problem.. Saurabh.. Hi Sachin, Thanx a lot.. It has solved my problem.. Saurabh.. Hi Chethan, Thanx a lot.. It has solved my problem.. Saurabh..
From India , Shillong
From India , Shillong
can any anyone provide me info abt how to calulate CTC? whether based on Gross pay or Net pay?
From United States , Belmont
From United States , Belmont
Please do find attached spread sheet which will give you some thoughts on how to calculate the CTC
:-)...
Hope this was informative to you.
Regards
Raghu
BASIS OF SALARY STRUCTURE
Payslip Components Basis
Basic 35% of Gross subject to minimum of Rs.6,500/-
House Rent Allowance 40% of the Basic
Children Education Allowance Rs. 200/- pm Fixed
Technical Journals Upto 150000 250
> 150000 upto 300000 500
>300000 upto 500000 750
>500000 upto 2000000 1000
>2000000 2000
Transportation Allowance Rs. 800/- pm Fixed excepting where car
reimbursements are made
Variable Allowance Balance Salary
Flexible Benefit Plan Components
LTA
Upto 200000 0 0
> 200000 & < 250000 750
= or >250000 & < 350000 1000 9000
= or >350000 & < 400000 1250 12000
= or >400000 & < 600000 1500 15000
= or >600000 & < 800000 2000 18000
= or >800000 & < 1100000 3000 24000
= or >1100000 & < 1500000 4000 36000
= or > 1500000 5000 48000
60000
Medical Reimbursement Rs. 1250/- pm Fixed
Telephone Expenses Upto 150000 0
> 150000 upto 300000 500
>300000 upto 500000 1000
>500000 upto 1500000 2000
>1500000 3000
Food Coupons Rs.1,100 pm at the Option of employee
From United States ,
:-)...
Hope this was informative to you.
Regards
Raghu
BASIS OF SALARY STRUCTURE
Payslip Components Basis
Basic 35% of Gross subject to minimum of Rs.6,500/-
House Rent Allowance 40% of the Basic
Children Education Allowance Rs. 200/- pm Fixed
Technical Journals Upto 150000 250
> 150000 upto 300000 500
>300000 upto 500000 750
>500000 upto 2000000 1000
>2000000 2000
Transportation Allowance Rs. 800/- pm Fixed excepting where car
reimbursements are made
Variable Allowance Balance Salary
Flexible Benefit Plan Components
LTA
Upto 200000 0 0
> 200000 & < 250000 750
= or >250000 & < 350000 1000 9000
= or >350000 & < 400000 1250 12000
= or >400000 & < 600000 1500 15000
= or >600000 & < 800000 2000 18000
= or >800000 & < 1100000 3000 24000
= or >1100000 & < 1500000 4000 36000
= or > 1500000 5000 48000
60000
Medical Reimbursement Rs. 1250/- pm Fixed
Telephone Expenses Upto 150000 0
> 150000 upto 300000 500
>300000 upto 500000 1000
>500000 upto 1500000 2000
>1500000 3000
Food Coupons Rs.1,100 pm at the Option of employee
From United States ,
Hi,
I am Deepika, I am working in a software development company, as a HR just now i joined here they told me to prepare a salary slip. Can any one help me in this company there is different strategy. Kindly help me in this meter.
Regards
Deepika
From India , Bangalore
I am Deepika, I am working in a software development company, as a HR just now i joined here they told me to prepare a salary slip. Can any one help me in this company there is different strategy. Kindly help me in this meter.
Regards
Deepika
From India , Bangalore
Salary slip.JPG
SALARY ANALYSIS TEMPLATE.doc
SALARY STATMENT.xls