Actual house rent paid by you minus 10% of your basic salary. 50% of your basic salary if you live in a metro or 40% of your basic salary if you live in a non-metro. This minimum of above is allowed as income tax exemption on house rent allowance. Salary here means basic salary which includes dearness allowance if the terms of employment We will use the above formula in Excel to calculate the annual HRA which the employee has to receive. The formula is written by using the values from the cell L of the expenditure data. It will help perform HRA calculation formula in Excel. Obtain HRA on 50 percent of Basic Salary in Excel Dear Mr. Murgesh, Kindly calculate..the 30% basic in the CTC. 40% HRA in the Baic. TA deduction (approx 800/month). PF-12% of Basic. Bonus - 10% Baic. (I think he/she is not application to ESIC deductions). Medclaim - as per company agreement with (Insurance commpany). Other Balance amount to be in special pay. All Staff Incometax Calculation FY 2022-23 AY 2023-24 Excel Free Download tool:-Download Click Here. UMMED TARAD INCOMETAX 2022-23 आयकर गणना प्रपत्र : वित्तीय वर्ष 2022-23. Download Click Here. All Employees ITax Calculation Direct & HRA Calculator. All Employees ITax Calculation Direct & HRA Here are some key reasons why in hand salary calculator is important: 1. Salary Transparency. An in hand salary calculator provides transparency to employees by letting them know the breakdown of their total salary. It portrays various deductions, taxes, and contributions and their impact on the in hand salary. 2. HRA is an allowance given by companies to employees in place of house rent expenses. It is included in the salary component provided by the company, and employees under regulation number 2A of the Income Tax Act are eligible for HRA exemption under section 10 (13A) of the same Act. However, this exemption is not available under the new tax regime. Salary Slip Template is a ready-to-use template in Excel, Google Sheets, OpenOffice Calc, and Apple Numbers that helps to issue salary slip to the employees with ease. This template performs the calculations automatically. Insert the salary and it calculates the PF and EPS amount based on Indian law. Children education allowance is exempt up to Rs. 200 per child per month up to a maximum of two children. Conveyance allowance is exempt up to a maximum of Rs. 1600 per month. Tax on employment and entertainment allowance will also be allowed as a deduction from the salary income. To calculate your HRA exemption, you need to consider three scenarios and select the one with the least amount: Actual HRA Received: Rs. 20,000 per month. Rent Paid minus 10% of Salary: Rent paid (Rs. 15,000) minus 10% of your salary (10% of Rs. 40,000 = Rs. 4,000) = Rs. 11,000. Basic = Gross Pay – DA – HRA – Conveyance – Medical – Other. Otherwise, if your contract mentions the percentage you can do that directly using the following formula. Basic = Gross Pay X Percentage. We used this formula in the example of Manoj. To calculate the take-home amount, you can use the Salary Sheet Excel Template. WpfnuD6.