Here is sample salary structure in Excel format which will help you in calculating net salary of employee and CTC of the employer. The below salary breakup format in excel consists salary breakup structure, salary breakup percentage and CTC calculator.

**Download Salary Breakup Calculator Excel Sheet**

The salary structure of every employee consists of some basic salary components like basic salary, dearness allowances (DA), house rent allowances (HRA), conveyance allowances, special allowances, EPF, ESI, professional tax.

## Components of salary

**Basic Salary:** Basic salary should be 40% – 60% of gross salary, which will vary from one employer to another employer. In general basic salary should be equal to or more than the minimum wages fixed by the state government of the employer.

**HRA allowances:** House rent allowances should be at least 5% of the basic wage of the employee. Employers can fix their own HRA percentages based on the cost of living in their location.

**Conveyance allowances:** These are fixed allowances. 1600 Rs in urban areas and 800 Rs in rural areas.

**Special allowances:** The difference between basic wage and the total of all the allowances are considered special allowances. Simple basic wage – total allowance excluding special allowances.

### Deductions

The salary of every employee will consist of some deductions like EPF, ESI and professional tax. 12% of employee basic wage will be deducted as PF contribution of employee and 1.75% of employee gross salary will be considered as employee ESIC contribution.

Professional tax varies from one state to another state. Here are the State-wise professional tax rates in India

### What is CTC

CTC means the cost to company i.e the total expenses of an employer for a particular employee which includes gross salary and employer PF and ESIC contributions.

Every employer needs to pay 13.35% of employee basic salary towards EPF account of employee and 4.75% of employee gross salary as ESIC contribution.

Why is the employer PF contribution 13.35% ?

Esi calculation towards employers contribution should be 20000*4.75% so the amount should be 950 but here in the working it is 427.5. How plz explain.

Now the employer contribution is reduced to 3.25% and the employee contribution is 0.75%.

The salary calculation and structure has being explained in a very simple format, which is easy to understand and calculate. Thanks for sharing this format with us. I would appreciate if you can share the calculation whose ctc is 5 lakhs, 8 lakhs and more as well.

Nice n Simple