Salary and CTC Breakup Calculator in Excel Automatic

Download free automatic salary and CTC breakup calculator in Excel.

CTC (cost to company) of an employee OR for all employee’s in a organization is always difficult task. As you know, CTC mean salary breakup should be as India laws.

I have create a VBA based Excel sheet to calculate CTC cost to company salary breakup automatic as per all rules.

What’re Features in this Sheet?

  • You can calculate CTC breakup one by one individually meanwhile you can calculate all employee ( up to 5000) breakup in 1 Click.
  • Reset option for reset all sheet as blank.
  • Employee Type and State name selection required for calculating.
  • This sheet will be calculate Basic, HRA and Special Allowance as per Minimum wages Act as applicable Indian States.
  • User can update minimum wages in Second attached sheet even ever required.
  • Basic Salary and other calculations based on excel formulas which can be changed if required.
  • Bonus will be calculate 20% as per Bonus Payment Act 1965.
  • Gratuity will be calculate as per Gratuity Payment Act 1972.
  • User can change HRA % 50 to 40% in case required.
  • User can rename the other allowances head name if required.

How to CTC Calculation sheet?

  1. Click on Reset button.
  2. Select State and Employee Skill.
  3. Type Annual CTC Amount.
  4. CTC Salary Breakup will be calculate Automatic.


  • Your Excel Macros should be Enable (Know more)
  • Minimum wages list should be update
  • Change Allowance name, Bonus % as applicable
  • Employee Skill and State name required
  • Click on Calculate button in case you are calculating CTC in bulk.

Call Me: +919654421288 for paid consultant.