Tag: excel ctc automatic

Categories
Salary and CTC Breakup

CTC Salary Calculator in Excel with Complete Payroll Setup

Click here to download automatic Complete Payroll Calculator in Excel. This Excel Software includes most likely all part of Payroll Calculation. It’s Includes following Features:-

  • You can calculate Cost to company CTC Automatic once you put total ctc.
  • You can restructure allowances and CTC components as per your need.
  • Income Tax  to be calculate automatic.
  • You can set your investment Declaration or Proofs Planing as per requirement.
  • This sheet will calculate House rent allowance ( HRA Rent Exemption calculation) under section 10(13A) automatic as per your rent paid and selected city.
  • You can customize your structure like add / less : PF (Employees’ Provident Fund), Employment State Insurance ( ESIC), Gratuity, Mediclaim, any other benefit, Bonus, Minwages.
  • You can control to deduct PF on Basic OR PF on Allowances or PF on min wages of PF or you can select No if you are not eligible for pf deduction.
  • You can Se-off loss / income from house property u/s 24(b) as per Income Tax Act.
  • You can add reimbursement components as per bills planing to get more benefit in tax.
  • This sheet will give you Net payment Automatically as per your Inputs.
  • Best part of this software is that, you can generate  your salary pay slip from CTC in one click and change payslip in excel as per needs.
  • We have added logo on slip so that you can change it.
  • You can generate any month salary slip from excel format in one click even you can generate full and final slip.
  • This sheet is Free to download

  • Paid Support Available at :
  • Email: ajityadav121@gmail.com

Click here to Download Automated Excel Sheet to calculate cost to company (CTC), Income Tax Calculation along with all investment planning (Deduction U/C VI-A)  and all Major Exemptions allowed + reimbursement  in Salary.

This sheet will allowed to planning your tax saving, make salary structure as per your choice and know the Net in hand Automatically.

Thanks! Ajit

Categories
free payroll sheet India Payroll Salary and CTC Breakup Salary Breakup Calculator Excel

Free Payroll Software in Excel with automatic CTC and tax calculation

Click here to download automatic Complete Payroll Calculator in Excel. This Excel Software includes most likely all part of Payroll Calculation. It’s Includes following Features:-

  • You can calculate Cost to company CTC Automatic once you put total ctc.
  • You can restructure allowances and CTC components as per your need.
  • Income Tax  to be calculate automatic.
  • You can set your investment Declaration or Proofs Planing as per requirement.
  • This sheet will calculate House rent allowance ( HRA Rent Exemption calculation) under section 10(13A) automatic as per your rent paid and selected city.
  • You can customize your structure like add / less : PF (Employees’ Provident Fund), Employment State Insurance ( ESIC), Gratuity, Mediclaim, any other benefit, Bonus, Minwages.
  • You can control to deduct PF on Basic OR PF on Allowances or PF on min wages of PF or you can select No if you are not eligible for pf deduction.
  • You can Se-off loss / income from house property u/s 24(b) as per Income Tax Act.
  • You can add reimbursement components as per bills planing to get more benefit in tax.
  • This sheet will give you Net payment Automatically as per your Inputs.
  • Best part of this software is that, you can generate  your salary pay slip from CTC in one click and change payslip in excel as per needs.
  • We have added logo on slip so that you can change it.
  • You can generate any month salary slip from excel format in one click even you can generate full and final slip.
  • This is Free to download
  • Paid Support Available at :
  • Email: ajityadav121@gmail.com
  • Call/WhatsApp: +91 9654421288

Click here to Download Automated Excel Sheet to calculate cost to company (CTC), Income Tax Calculation for CY financial year along with all investment planning (Deduction U/C VI-A)  and all Major Exemptions allowed + reimbursement  in Salary.

This sheet will allowed to planning your tax saving, make salary structure as per your choice and know the Net in hand Automatically.

Thanks! AKumar

Click here to download
Categories
Payroll Salary and CTC Breakup

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.

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.

Download CTC Calculator

Call Me: +919654421288 for paid consultant.