Salary Calculator India excel sheet

Let’s take an example for a better understanding of salary structure to calculate the in hand salary from CTC

Since October has 31 days, the per-day pay is calculated as Rs 30,000/31 = Rs 967.74. This is a variant of the Calendar day basis. In this method, the pay per day is calculated as the total salary for the month divided by the total number of calendar days minus Sundays .

Take Home Salary = Gross Salary – Income Tax – Employee’s PF Contribution(PF) – Prof. Tax . Gross Salary = Cost to Company (CTC) – Employer’s PF Contribution (EPF) – Gratuity. Gratuity = (Basic salary + Dearness allowance) × 15/26 × No. of Years of Service.