Save Big on Taxes with Expert Assisted ITR Filing from ₹799!

Got an ITR notice? Talk to our CA for the right response.
HRA Calculator

How to Calculate HRA in Excel Formula?

We need to define "HRA" before using it in our basic salary to excel calculation. House Rent Allowance is an abbreviation for the whole phrase.

It is a perk we get on top of our regular pay and other perks, so it’s technically part of the gross pay. However, it is relevant only if we are tenants. You Can Know about the Process to Calculate HRA in Excel Formula.

Therefore, one must first compute HRA on base wage to take advantage of the HRA exemption for yearly tax payments. how to calculate hra in excel formula .

The HRA Calculator 

A home rent limit calculator is a financial tool that helps one determine the amount of tax deduction that one is eligible to receive annually on their rent by the Income Tax 1961. Calculating tax breaks might be complicated, but this online calculator helps make it easier.

Human Resource Expense Deduction Formula

Rule 2A of the Internal Revenue Code governs the methodology used to determine the amount of HRA exclusion. The part of an employee’s wage that is not subject to taxation under Section 10(13A) is the lesser of the following amounts:

HRA Is Provided In Reality By An Employer

  • Human Resource Expenses (HRA) in a major city is equal to half of the total of the employee’s base pay plus discretionary allowance (DA). The figure for workers outside major cities is 40% of their combined base pay and DA.
  • 10% of the base salary plus DA will be deducted from the actual rent.
  • Remember that your HRA exemption will only apply to the lowest amount of these provisions.

New Tax System and HRA

There have been several shifts from the former government to the current one. However, it is important to note that several of the deductions and exemptions available under the previous tax scheme would not be available under the new regime. 

The HRA, or Housing Rent Affordability Allowance, is one of them. As a result, the HRA  Calculation deduction will not be available if you choose the new tax system and submit your taxes by its requirements.

When It Comes To HRA, How Do They Choose?

salary slip sample is the primary factor in HRA. The portion of an HRA that is free from taxation under income tax law is the lesser of the following parts:

  • Ten percent of annual earnings minus actual rent paid

Things To Keep In Mind When Seeking The HRA Deduction

  • If your yearly rent exceeds ₹1 Lakh, you will need your landlord’s PAN to qualify for HRA exemption. A written statement from the property owner should be adequate if he does not possess a PAN in his name. However, you may miss the deduction if any of these apply.
  • Housing allowance (HRA) amounts vary by location. For example, it is possible to deduct up to 50% of your HRA if you reside in a metro area like US and up to 40% if you live in a more rural area.
  • You are not eligible for HRA if you own your own home since it is designed to cover the expenses associated with renting.
  • You may qualify for HRA exemption if you live with the parents and can provide a rent invoice in their name. However, when it comes time to file taxes, your parents would need to include that same rent as income.

How Does One Figure Out Their House Rent Amount (Hra)?

The lowest of the following may be deducted from HRA for tax purposes:

  • Ten percent of base wage is less actual rent paid, whichever is more.
  • Employment-related health and retirement benefits (HRA) provided by the company,

Excel Formulas For Determining The HRA Exemption

Now that we have the three HRA amounts, we can determine the lowest one necessary for tax-free HRA withdrawals. The preceding calculations make it easy to see how little is required. If not, the following steps may be taken:

  • First, substitute the results of our calculations into cells C5, C6, and C7.
  • Then, use this equation to determine how much HRA is required.
  • HRA is a percentage added to a worker’s base pay, the total amount shown above. Then, when tax time rolls along, it will be subtracted from what is owed.

Can I Deduct The Interest On My House Loan And Get A Tax Break On My HRA?

  • HRA rent payments are eligible for tax breaks.
  • The interest you pay on your mortgage may be deducted from your taxes.
  • Home loan principal payments are also tax deductible.

How To Deduct Section 80GG Contributions If You Don’t Get HRA?

The best way to minimise income tax while renting but not receiving housing allowance (HRA). What if you don’t get a wage since you are self-employed? Do not panic! You may still make a tax deduction claim by Section 80GG of the Income Tax Act.

Section 80GG of the Income Tax Act allows for a maximum deduction equal to the lesser of the following:

  • Five thousand rupees a month (about sixty thousand rupees a year); or
  • $25,000 (or 25% of your overall gross revenue)
  • Ten percent of gross revenue less actual rent paid

Advantages of Utilising an HRA Deduction Calculator

If you are debating whether to use an online calculator, here are a few advantages of doing so:

  • Your HRA claims will be quickly computed thanks to these calculators. However, unfortunately, it takes a lot more time to do computations by hand.
  • The results shown by calculators are always accurate. Unfortunately, this cannot be stated for computations performed by hand, which always risk including mistakes.
  • When determining your HRA benefits, an HRA calculator considers everything from your base wage to the location you call home.

Can I Qualify For HRA When I Live At Home With My Parents?

If you still live at home with your parents, you may still deduct HRA. You need to sign a lease agreement with my parents & pay them to rent regularly to qualify for the deduction. Tax deductions may be claimed based on these rental invoices in your name. Make sure that you meet the requirements above so that HRA may be included in your compensation.

How Can I Show That I Have Paid My Annual Rent Obligation

Keep all rent receipts for at least a year. Then, when submitting tax returns, you’ll need to provide the same (ITR). If you do not have a rent receipt, you’ll need to provide a copy of the lease and a bank statement showing that the rent was paid.


Simply  HRA Calculation Formula  forming a business limited by shares or a limited liability partnership is not enough. Once you do, you will have to follow the rules of the Ministry of Finance and the Income Tax Act. Here at Vakilsearch, we provide these conveniences only over the Internet. Us on a yearlong retainer, and we’ll take care of the paperwork while you concentrate on running your company.

Read more

Subscribe to our newsletter blogs

Back to top button


Remove Adblocker Extension