Help Me For Make Salary Structure Of 30,000/- - XLS Download

hi all friends,
i want a salary structure of Rs 30000/-,which is 5000/- included telephone and local conveyance. so please provide me as soon as possible.
Regards,
Deepa

Basic 21,000.00
House Rent Allowance 2,400.00
Conveyance Allowance 5000.00
Medical Allowance 1,000.00
Education Allowance 600.00

Total Pay 30,000.00

Hi,
First of all the clarification required whether the Rs.30000/- is CTC or Gross ie., whether the employer contribution of PF is part of CTC. secondly whether you are deducting PF from the employee or not as the basic may be around 50% . If no then the basic should be a minimum of 50%, then around 20% of gross salary can be HRA., Rs.100/- towards children educational allowance ( to a maximum of Rs.200/-) Rs.800/- towards conveyance allowance., Rs.1250/- can be medical reimbursement, if you are issuing meal coupon it can be @Rs.1300/- pm and then remaining can be special allowance.
I believe the same serves your purpose.
Regards - kamesh

Hi,
If this 30000 is a gross salary then following may be the structure:
Basic: 15000
HRA: 7500
Conveyance Allowance: 800
Children Education Allowance: 200
Medical Reimbursement: 1250
LTA: 1250 (one month's basic, optional)
Books & Periodicals: 1000
Special Alloeance: 3000
Gross: 30000/-
PF: 1800 (employer share)
CTC: 31800/-
If 30000 is CTC, then Special All will be 1200, rest other items remain constnt.
Please note the above is a general standard format, and may differ from co. to co. policy.
Thanks.

Following Clarifications to be made before finalising the structure.
(1)Whether Rs. 30, 000 p.m. is gross or CTC.
(2) Beyond the applicability of ESI, PF and Bonus.-- whether company is willing cover the employee.
(3) The Salary Components have to be finalised considering - Gratuity and IT.
If 30,000 is the gross salary you will have to pay Rs. 2500 as IT if you are not saving upto 1 lac per annum.
Also the basic has to be minimum ---nearly 60 % of the gross considering the liability under Gratuity .

Considering the Take home as 30k, find below the salary strcuture

please furnish your probable Rent Payment so that we can have Tax planning & optimize Contribution to PF

hi,
you can calculate percentagewise like-
basic= 40% of gross
DA = 20% of basic
HRA= 40% or 50% of Basic +DA
Convey=800 non taxable
Medical all= 1250/*- non taxable
other allownace= remainig amnt.
regards,
Prajakta

hi
will any one can formulate salary structure for 35k
QUOTE=Pramod Kumar K T;1314332]please furnish your probable Rent Payment so that we can have Tax planning & optimize Contribution to PF[/QUOTE]

What Mr. Vijay made is very perfect (consider 360000 instead of 340000 and make figures rounded)
well done.....
sunil