HRA Excel Template for House Rent Allowance Exemption
Calculate your HRA exemption and taxable HRA in Excel using Basic Salary, qualifying Dearness Allowance, HRA received, rent paid and residential location. This HRA exemption Excel calculator provides a convenient spreadsheet-based way to calculate House Rent Allowance exemption.
Download the HRA Excel Template to calculate your HRA exemption and taxable HRA in Excel.
What This HRA Exemption Excel Calculator Includes
The workbook brings the key features needed for an HRA exemption calculation in Excel into one simple spreadsheet.
HRA Exemption Calculator
Enter Basic Salary, qualifying DA, HRA received, rent paid, months and city to calculate exempt and taxable HRA.
Monthly or Annual Input
Choose Monthly or Annual input and let the workbook annualise the figures where applicable.
City Reference
Use the dedicated City Reference sheet to check the applicable HRA exemption percentage.
Step-by-Step Guide
The How to Use sheet explains the inputs, calculation process and final HRA exemption result.
How to Calculate House Rent Allowance Exemption in Excel
The HRA calculator Excel template applies the least-of-three-limits method to determine the eligible House Rent Allowance exemption.
Actual HRA Received
The actual HRA received for the relevant period.
Rent Minus 10%
Rent paid minus 10% of the relevant salary.
Salary Percentage Limit
The applicable percentage of relevant salary based on the residential location.
The workbook then shows the eligible exemption and calculates the balance HRA as taxable HRA. Use figures for the same calculation period when entering monthly or annual amounts.
How to Use the HRA Calculator Excel Template
Follow these simple steps to use the HRA exemption calculation Excel template.
Open the HRA Calculator sheet and select Monthly or Annual input.
Enter Basic Salary and DA, if DA forms part of retirement benefits.
Enter the HRA received and actual rent paid for the selected period.
Enter the applicable number of months and select your City of Residence from the dropdown.
Review the three exemption limits calculated automatically in the calculation section.
Check the final Exempt HRA and Taxable HRA results.
HRA Exemption Calculation Example in Excel
For example, assume monthly Basic Salary is ₹60,000, HRA received is ₹30,000 and rent paid is ₹25,000. The workbook can annualise these figures and calculate the applicable HRA exemption.
| Basic Salary | ₹60,000 per month |
| DA qualifying for HRA salary | ₹0 |
| HRA Received | ₹30,000 per month |
| Rent Paid | ₹25,000 per month |
| Number of Months | 12 |
| Residential Location | Delhi |
| Salary for HRA purposes | ₹7,20,000 annually |
| Limit 1 — Actual HRA | ₹3,60,000 |
| Limit 2 — Rent − 10% Salary | ₹2,16,000 |
| Limit 3 — Applicable Salary Percentage | ₹3,60,000 |
The example illustrates how the lowest of the three applicable limits determines the exemption. Your actual result will depend on the figures and period entered in the workbook.
Download HRA Excel Template
Download the HRA Excel Template to calculate House Rent Allowance exemption and taxable HRA in Excel. This HRA exemption Excel calculator is useful for checking your HRA exemption calculation and maintaining a spreadsheet-based calculation record.
Calculate HRA Exemption Online
Prefer an instant calculation instead of using an Excel spreadsheet? Use our Online HRA Exemption Calculator to calculate your House Rent Allowance exemption and taxable HRA directly in your browser.
Use Online HRA Exemption Calculator →HRA Excel Template FAQs
An HRA Excel template is a spreadsheet tool that helps calculate House Rent Allowance exemption and the taxable portion of HRA based on the required salary, rent, HRA and location details.
It calculates the applicable HRA exemption using the three-limit method and shows the resulting exempt HRA and taxable HRA.
Yes. The workbook allows you to select Monthly or Annual input and provides the corresponding calculation results.
You need relevant salary details, HRA received, rent paid, applicable months and your residential location.
Yes. You can use our Online HRA Exemption Calculator for an instant browser-based calculation.
No. It is an estimation and planning utility. Actual tax treatment should be verified against the applicable law, rules and individual circumstances.
Sources & References
The HRA calculation methodology and related tax references used in this Excel template are based on the applicable provisions of the Income-tax Act, 2025 and Income-tax Rules, 2026.
