Web6 okt. 2016 · HRA The amount received as the HRA from the employer. Actual rent paid less 10% of the basic salary and 50% of the basic salary if staying in a metro city and 40% in a non-metro city. Basic Pay Basic Pay is 50% of Gross salary (Gross * 0.5). Deductions Deductions are the sum of PF, ESI, and PT etc. WebMr X, employed in Mumbai, has taken up an accommodation on rent for which he pays a monthly rent of ₹ 25,000/-. He receives a Basic Salary of ₹ 45,000/- monthly along with DA of ₹ 7,000/- monthly which forms a part of the salary. He also receives HRA of ₹ 1 lakh from his employer during the year.

Salary Calculator - Take Home Salary Calculator India - Niyo

Web3 jan. 2024 · Improved version of Excel Salary Sheet Vids . Please if you feel difficulty to understand. Please visit below vids link for more clarity.Excel : Salary Sheet... WebDear 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. incident in newbury today

In Hand Salary Calculator: Calculate Your Earnings and Take-Home Pay

Web12 apr. 2024 · Gross salary = Basic salary + HRA (House rent allowance) + DA (dearness allowance) + MA (medical allowance). On an excel sheet, the formula is =SUM(D2:G2) … WebThere are two methods that can be used to calculate the amount of HRA that can be claimed as a deduction: the actual rent paid method and the 10% of basic salary … Web14 jan. 2024 · You need to use a cursor so that you can loop on records in the table. Here is what I did - #create a table for sample data create table tsalary0918(Basic number,HRA number,DA number,CA number,Medical number) #inserting sample data insert into tsalary0918 values (100,100,100,100,100) #checking if data is inserted select * from … inbodyments