Feb 6, 2013

House rent allowance calculator in excel

Allowance is a fixed monetary amount paid by the employer to the employee, Whether personal or for the performance of his duties. These allowances generally taxable unless a specific deduction/exemption is provided by law. So in this article we will discuss about House Rent Allowance broadly. So you can understand and calculate it very easily. Please read complete article including the notes given at the end of the article.

House Rent Allowance (HRA) is give by the employer to the employee to meet the expenses in connection with rent of the accommodation.  HRA is exempt under section 10(13A) to the extent of the minimum of the following three amounts :

Actual House Rent Allowance received by the employee
Excees of rent paid for the accommodation occupied by him over 10 % of the salary.
50% of salary where the residential house is situated at Mumbai, CalcuttaDelhi or Chennai and 40% of the salary where the house is situated at any other place.

The minimum of the above three amounts shall be exempt from tax and the balance shall be taxable and thus included in gross salary of employee.

As per circular no. 5/2011 dated 16 August 2011, if the house rent paid per annum Rs. 180000 or 15000 per month or above, it is mandatory to submit PAN number of house onwer or landlord . If PAN number not to be yet submit, the house onwer/landlord must submit a declaration on plain paper with the name and address of land/houseonwer, which submit the employees.

Meaning of Salary for calculation the exemption of HRA

Salary means (Basic + D.A + Commission based on fixed percentage on turnover).
Salary is to be taken on due basis in respect of the period during which the period accommodation is occupied by the employee in the previous year.

Calculation Monthly or Yearly?
The exemption in respect of HRA is based upon the following factors:


HRA received

Place of Residence,

Rent Paid,

HRA exemption should not be calculated on yearly basis, if there was any change in above factors during previous year.
Examples for calculation of exemption/deduction of HRA
X has received following amount during the previous year.

  1. Basic Salary – Rs. (5000*12) – Rs. 60,000/-
  2. Dearness Allowance (D.A) – Rs. (1000*12) – Rs. 12000/-
  3. House Rent Allowance (H.R.A.) – Rs. (2000*12) – Rs. 24000/-
  4. Actual Rent Paid – Rs.(2000*12) – Rs. 24000/-
The minimum of the following amount shall be exempt
  • Actual HRA received (2000*12) – Rs. 24000/-
  • Rent Paid in excess of 10% of salary ( 24000-7200) – Rs. 16800
  • 40% of Salary – Rs. 28800/-
Therefore, Rs. 16800 shall be exempt and the balance Rs. 7200 shall be included in gross salary.
This house rent allowance calculator in excel is developed by my friend Mr. Pranab Banerjee and he is happy sharing it with taxalertindia.
Download HRA Calculator developed by Mr. Pranab Banerjee

Keywords-hra calculation,house rent allowance calculation,hra calculator,house rent allowance calculator,house rent allowance calculator in excel,excel based hra calculator,excel based house rent allowance calculator,hra calculator xls