Indian Income Tax Exemption from Salary with Excel Based Income Tax preparation Software for Assessment Year 2014-15


You can Relief Form Income Tax under some Income Tax Section which is given below with the Some of Automatic Excel Based Income Tax preparation Software for the Assessment Year 2014-15

House Rent Allowance (HRA) – Supporting documents for rent payments to the landlord are required to be submitted to claim the tax exemption on HRA. However, if the HRA received per month is Rs 3,000 or less, the employee need  produce any supporting documents for such rent payments, at the time of assessment/enquiry, shall still have the right to call for the supporting documents. Download Automatic HRA Exemption Calculator in Excel from the  link   (New)House Rent Calculator

 It is worthwhile to note that as per the latest circular, if the annual rent paid by the employee exceeds Rs 2,00,000 per annum, it is mandatory for the employee to report the PAN of the landlord to the employer. In case the landlord does not have a PAN, a declaration to this effect from the landlord along with his name and address should be submitted.  If the exemption is not considered by the employer, an option to claim it in the tax return is available.

Leave Travel Allowance (LTA) – LTA can be exempted from tax twice in a block of four calendar years. The current block of four years is 2010-13.The exemption is only for travel expenses incurred towards self and eligible family members based on some specified conditions. The exemption is not available for foreign trips. If the employee does not avail of LTA, either one or on both the occasions during the block of four calendar years, only one trip can be carried forward to be availed in the succeeding block. The latest circular issued by the tax authorities casts an obligation on the employer to preserve the supporting documents for LTA exemption. Hence, employees have to submit the actual proof of travel to the employer to avail of the tax exemption at the withholding stage.Download the Automatic Income Tax Calculator with Form 16 Part A&B and Part B for Financial year 2013-14 Automatic Form 16 Part A&B and Part B+ Arrears Relief + Form 10E For AY 2014-15

Medical expenses – Reimbursement towards medical expenses incurred in connection with family members to the extent of Rs 15,000 is exempted from tax.  Family members include parents, brothers and sisters or any of them wholly or mainly dependent on the individual. The definition of family members does not cover parents-in-law. Unlike other exemptions, it may not be feasible to claim this relaxation in the tax return as the benefit is available only in respect of reimbursement by the employer. Download From below link the All in One TDS on Salary with all Income Tax Section for the Financial Year 2013-14

New All in One TDS+HRA Calculation + Arrears Relief + Form 10E + Form 16 For AY 2014-15

Housing loan certificate – Employees could reflect a loss from house property on incurring interest expenditure on housing loan.  Repayment of principal amounts could provide a deduction within the total limit of Rs 1,00,000 along with other eligible investments under Section 80C.  At the time of submitting the proof to the employer, only a provisional certificate for the housing loan is likely to be available. However, in case of prepayments or change in the EMI amount after the submission of the provisional certificate, the total interest and principal repayment amount, as indicated in the provisional certificate, will change. This will require an adjustment to the housing loan interest and principal repayment in the tax return, possibly resulting in additional tax payment/refunds. This needs to be considered by the employees while filing their tax returns.

Download the Automatic Form 16 Part B for the Financial Year 2013-14 (Part B ) Master of only Form 16 Part B for AY 2014-15

The deduction under Section 80C is limited to Rs 1,00,000 and covers investments such as contribution towards provident fund account, LIC policy and public provident fund. Some of these are listed below –

Premium for life insurance policy for self, spouse and any child shall be eligible for deduction.  For policies issued after 1 April 2012, deduction shall be restricted to the premium amount not exceeding 10 per cent capital sum assured. Provide your employer with these details to substantiate that these limits are being maintained to ensure that the benefit is granted.


Contribution to a Public Provident Fund account in the name of self, spouse and any child is eligible for deduction under Section 80C. The maximum contribution to this account during the financial year cannot exceed Rs 1,00,000.  The annual accretion to the account is not taxable. A copy of the PPF passbook and payment receipt should be provided to the employer. These days, online payments have also been enabled.

Five-year bank fixed deposits (FDs): FDs with a scheduled bank with a lock in period of five years are eligible for deduction under section 80C. However, it needs to be kept in mind that the interest on these FDs is taxable and should be included in the return.

Equity-linked savings schemes qualify for deduction under Section 80C. An account statement from the mutual fund house or an acknowledgment receipt for the investment need to be submitted to the employer to claim this deduction. Long-term capital gain and dividend on these funds and scheme are exempted from tax where securities transaction tax is paid. However, these funds and schemes have a lock-in period of three years.

Employees may submit details of tuition fees for full-time education of any two children to any university, college, school or other educational institution situated in India whether at the time of admission or thereafter.   Deduction under Section 80C is available for such payments. Full-time education includes play-school, pre-nursery and nursery classes. Further, the amount eligible for deduction shall include any payment of fee except the amount paid as development fee or donation or capitation fee.

Medical insurance premium: Premium paid in any mode other than cash for self, spouse and dependent children can be deducted up to Rs 15,000 per annum; an additional Rs 5,000 can be claimed if they are senior citizens.  In addition to this, premium paid for parents’ health cover can be claimed as deduction up to Rs 15,000, with an additional deduction of up to Rs 5,000 for senior citizens. Further, deduction can be claimed up to Rs 5,000 (paid in any mode including payment by cash) on account of preventive health checkup within the overall limit of Rs 15,000/20,000. Receipts of insurance premium/ health checkup expenditure need to be submitted to the employer to claim this deduction.

Interest on education loan: Deduction can be claimed for interest paid on an education loan taken from an approved institution for higher education of self/spouse/ children/student for whom employee is a legal guardian. It is available for eight years starting from the financial year in which the individual starts paying interest.

Donations to certain funds/charitable institutions: Section 80G provides for deduction on account of donations made to various funds, charitable organizations, etc. However, for tax withholding purpose, the employer considers only the donations made to the Prime Minister’s National Relief Fund, the Chief Minister’s Relief Fund or any other fund notified by the tax authorities in this regard.  Other donations must be claimed separately on the tax return.


Thanks for your comments and follow my blog

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s