Dear Friends
Iam new to this site. can anyone help me as how to calculate House Rent Allowance?
I know the rules, but dont know how to calculate in Excel sheet for all the employees . I need the formula to calculate the HRA Deductions.
I have to submit this record to my company within this week end.
Please help me.

From United States , Oakland
Accounts Executive
Sai Shiridi
Executive - Finance & Accts
+5 Others

Hi vandana, Please find attached herewith the HRA calculation as per delhi and chennai with formulas. with regards, radhisaran100
From India , Madras


Can u send me complete calculation like basic and medical conveyance and etc for deducting during the year as per Hyderabad with formulas Regards raju
From India , Hyderabad

Dear All Please find the attachnemt regards Praveen Kumar
From India , Hyderabad

Attached Files (Download Requires Membership)
File Type: xls Tax Calc.xls (27.0 KB, 775 views)

Find Out The Complete And Fresh Tax Calculator As Attachment.............
From India , Delhi

Attached Files (Download Requires Membership)
File Type: xls Copy of Tax CalculatoR.xls (41.0 KB, 557 views)

Hi Vandana,
Please see hereunder HRA Calculation & Formula
Least of Following :
1) HRA Received :
2) 40% of Basic for Non Metro city
3) 50% of Basic for Metor City
4) Rent paid-10% of Basic.
please let us know if u have any query related to Tax.

From Japan ,
Sai Shiridi
Lets explain with example.
'A' earning the salary with Basic of 13200/- DA.500 and Commisssion on sale 4%, HRA 5280/- and Spl allow of 4750/- Per month actually Mr A is paying Rent 6000/- month
Least of the followinf is to be exempted
1.Rent paid by the company 5280*12 =63360/-
2.40% on Salary i.e,(13200+500+200)*12= 66720/-
Basic+ DA + 4%
3.Actually rent paid - 10% on salary
Dude only thing u have to consider is Def of salary = basic+DA+Comm on sales no other allowance and perqusit are considered.
In this cas 55320/- is Exempted .:lol:

From India , Hyderabad
Deepika Saini
Hi Folk,
I think u missed something that's:-(
DA to be taken only if forming part of salary not the one not forming part of salary.
MOre over it get effected with change in fields:
Change in salary
Change from Metro to non-metro city
Change in rent

From India , Delhi

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views.

Add Reply → Start New →

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2022 Cite.Co™

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server