Automated House Rent Exemption Calculator in Excel with Automated Master of Form 16 Part B for FY 2014-15

House Rent Allowance Exempt – 10(13A)

The least of the following three is exempted under HRA:
  •             Actual HRA received : Rs. X
  •            Amount rent paid in excess of 10% of Salary : Rs.Y
  •            50% of Basic Salary (including DA) in Metro Cities or 40% of Basic Salary (including DA) in other cities : Rs.Z

Download Automatic House Rent Exemption Calculator U/s 10(13A)

Least of X, Y Z is exempted. Read with Rule 2A of IT Rules 1962
NOTE: According
to the notification issued by the Income tax department, now landlord’s
PAN card is a must to get income tax deduction against HRA allowance.
One will have to submit PAN card as a proof if he is applying for more
than 15000 per month.

 

Download Automated Form 16 Part B for FY 2014-15 ( This Utility Can Prepare at a time 100 employees Form 16 Part B] 

S.No
I.T. Sec.
Nature of Deduction
Amount of Deduction
 1
 80 CCE
Limit on Deduction u/s.80C, 80CCC & 80CCD
Maximum
overall Deductions allowed u/s. 80C, 80CCC & 80CCD is Rs. 1,00,000
(Employer contribution is deductible without any limit from fy 2011-12)
 1a)
 80 C
Life
Insurance Premium, PF, PPF, NSC, ELSS, Units of Mutual Fund referred to
u/s.10(23D), Tuition Fees(max. 2 Children), Repayment of Principal of
Housing loan, Bank Fixed Deposit of 5 yrs period, notified Bonds of
NABARD, Deposit in an account under Senior Citizens Savings Scheme
rules, 5 year time deposit in an account under Post Office Time Deposit
Rules, 1981 etc.
Maximum
overall Deductions allowed u/s. 80C, 80CCC & 80CCD is Rs. 1,00,000
(Employer contribution is deductible without any limit from fy 2011-12)
 1b)
 80 CCC
Premium paid towards approved Pension Fund (like LIC’s Jeevan Suraksha) max. 1 lakh.
Maximum
overall Deductions allowed u/s. 80C, 80CCC & 80CCD is Rs. 1,00,000
(Employer contribution is deductible without any limit from fy 2011-12)
 1c)
 80 CCD
Contribution to Central Government Pension Schemes. Up to 10% of salary with matching contribution from Government.
Maximum
overall Deductions allowed u/s. 80C, 80CCC & 80CCD is Rs. 1,00,000
(Employer contribution is deductible without any limit from fy 2011-12)
 2a)
 80 D
 Medical
Insurance Premium paid by an individual/HUF by any mode of payment
other than cash to effect or keep in force an insurance on the health of
the assessee (self) or his family (spouse & dependent children) for
policies taken from General Insurance Corporation /other approved
Insurance Regulatory and Development Authority or any contribution made
to the Central Government Health Scheme.
 Up to Rs.15,000
 2b)
 80 D
 Medical
Insurance Premium paid by an individual/HUF by any mode of payment
other than cash to effect or keep in force an insurance on the health of
his/her parent or parents for policies taken from General Insurance
Corporation /other approved Insurance Regulatory and Development
Authority or any contribution made to the Central Government Health
Scheme.
 Up to Rs.15,000
 2c)
 80 D
 For Senior Citizens
 Up to Rs.20,000
 3
 80 DD
(a) Any
expenditure for Medical, Nursing & Rehabilitation incurred on
dependant suffering from permanent disability including blindness,
mental retardation, autism, cerebral palsy or multiple disabilities
(b) Deposits under LIC, UTI’s Scheme & other IRDA approved insurers for the benefit of physically handicapped dependent
 Rs. 50,000 (Rs.1,00,000 if the disability is severe exceeding 80%)
 4a)
 80 DDB
Actual
expenditure incurred on Medical treatment of Self or dependant or a
member of HUF suffering from terminal diseases like Cancer, AIDS, Renal
failure etc.
  Up to Rs.40,000
 4b)
 80 DDB
 For Senior Citizens(self or dependent on whom expenditure on medical treated is taken)
 Up to Rs.60,000
 5
 80 E
 Interest
on loan taken from Financial/Charitable Institutions for
Self/Spouse/Children for pursuing Higher Education (for a max. period of
8 yrs)
 Actual Interest repaid
 6a)
 80 G
Donations made to National Defence Fund, Prime Minister’s Relief Fund, approved Funds of repute
 6b)
 80 G
Donations
made to Jawaharlal Memorial Fund, PM’s Drought Relief fund, Any
approved Charitable Institution/Trust, Religious Institutions, a
corporation established by the Government for promoting interest of the
members of a Minority Community
50% of Donation restricted to 10% of Adjusted Gross Total Income
 7
 80 GG
Deduction
in respect of rents paid, provided the assessee is not in receipt of
HRA and no house is owned by self, spouse, minor child or HUF in the
place of work subject to filing of declaration in Form No.10BA
25% of income or rent paid in excess of 10% of income or ceiling of Rs.24,000 p.a whichever is less
 8
 80 U
Persons suffering from Permanent Physical Disability as specified in Rule 11D
 Rs.50,000 (Rs.1,00,000 in case of severe disability)

Leave a Reply

Your email address will not be published. Required fields are marked *