Accounts Executive
Sai Shiridi
Executive - Finance & Accts
+5 Others

PRIME SPONSOR - FACTOHR - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
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.
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Hi vandana, Please find attached herewith the HRA calculation as per delhi and chennai with formulas. with regards, radhisaran100

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
Dear All Please find the attachnemt regards Praveen Kumar

Attached Files
Membership is required for download. Create An Account First
File Type: xls Tax Calc.xls (27.0 KB, 726 views)

Find Out The Complete And Fresh Tax Calculator As Attachment.............

Attached Files
Membership is required for download. Create An Account First
File Type: xls Copy of Tax CalculatoR.xls (41.0 KB, 515 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.
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:
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
PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
Add Reply Start A New Discussion

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™