Download Income Tax calculator for Financial Year FY 2016-17 or Assessment Year AY 2017-18 in excel format exclusively design for government employees including bank employees and central government employees. This Advance Excel based Income Tax calculator is having all the features as per Income Tax department including ready made auto generated Form 16. A HR or personnel department may utilize this excel format for auto generating the Form 16 along with earning record of any number of employees automatically without much work pressure.
Click Here To Download Income Tax Calculator For FY 2017-18, AY 2017-18
Read : How to file Form 10E For Arrears Tax Relief ? Download
The Major features of Income Tax Excel based Calculator are :
- Easy interface for calculation and generation of Form 16
- Separate entry for Earning record through salary slip, deduction, Declaration of Investment form, Calculation sheet for income tax and form 16
- Automatic calculation of Taxation on HRA portion
- Automatic calculation of benefit u/g 87A
- Home loan interest benefit and all other rebate as per the budget are considered in calculator
Read : Income Tax Last Date for Filling IT Returns
How To Use the Income Tax calculator ?
Follow the below mention steps to use the calculator for accurate calculation of Income Tax on their Income or salary.
- Download the Income Tax calculator from the below mention link
- Provide all the salary details as per the salary slip on the first page i.e. Salary
- Provide the EPF or NPS deduction or Additional EPF or NPS Tier II contribution if any along with per month deduction of Income tax submitted to income tax department
- Collect the Investment option under various section inclusive the arrears or any other income to Others sheet
- Automatic calculation of Tax in the Tax sheet
- Automatic calculation of Form 16 in Form 16 page. Enter the Quarter wise acknowledgement number of e returns filled.
- That’s done..
Read : How To e-Verify Returns Using Bank or Demat Account ?
[button color=”red” size=”big” link=”https://www.rajmanglam.com/wp-content/uploads/2017/02/Final-Income-Tax-Calculator-AY2017-18-rajmanglam.xls” target=”blank” ]Download Income Tax Calculator FY 2016-17[/button]
Just provide your comments if any below.