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?
- Click on Reset button.
- Select State and Employee Skill.
- Type Annual CTC Amount.
- CTC Salary Breakup will be calculate Automatic.
Important:
- 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.