Just follow the simple steps below to calculate your take home salary from CTC using this excel calculator: Step 1 Download our Excel Calculator Tool and enter your CTC breakup as per the offer letter in the Input Sheet. The calculator is updated for the Financial Year 2022-23. Step 2 Choose if you want to opt for OLD Tax Slab Scheme ( WITH In the salary calculation sheet (proposed%20Slary_breakup_157 (1) (1).xls ) you have mentioned Basic @59.40 of gross and while calculating Basic you have changed the formula, we have checked by above formula (@59.40 of basic) but it is different from your calculation. whether it should be 58.23% of gross. Our id is. How to calculate Basic, HRA Example. If Mr. Bajaj (non-government employee) has a salary of Rs. 25,000 per month with DA of Rs. 4500 per month, entertainment allowance of Rs. 2250 per month, and pays Rs. 3500 towards professional tax, then his taxable income would be calculated as follows: Basic Salary. 25000 * 12. The contents of the salary break up is as below, you can prepare it at the suitability of your own. HRA would be 50 or 60% of basic. Basic HRA CCA - 825/- is exempted from tax Other Allowance Mobile Reimbursement Medical Reimbursement of 1250/month is exempted from tax Gross Per Month = Sum of all the above. Gross Per Annum= 12*Gross/Month SUM Function. If your Excel spreadsheet contains several cells for an employee that contain different types of pay, use the SUM function to total the employee's gross pay. Click a cell in which you would like to calculate gross pay, then type the following formula in the box: Video of the Day. =SUM (A1:A5) The DA will be calculated on the basis of the All India Consumer Price Index. The DA for Central Government Employees was earlier calculated based on the consumer price index with the base year 2001. The Central Government replaced it with a new consumer price index with the base year 2016 to calculate the DA from September 2020. Professional 🔥 salary sheet in excel | D.A , HRA, TA, PF, ESI, GROSS SALARY | MS Excel#msexcel #data_entry_in_excel #salary_sheet #salary_sheet_in_excelWPS 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. rte9v.

hra calculation formula in excel