Download Income Tax calculator for Financial Year FY 2017-18 or Assessment Year AY 2018-19 in Free Excel format. The Income Tax calculator in Excel is very useful in calculating the Income tax.facilities are provided separately for generating earning records based on each month salary data along with automated calculation of perquisite, tax rebate under various section and automated generation of Form 16.
A wonderful hassle free Income tax Excel utility for calculating the tax. This calculator is very useful for Employees of Government and private sectors mainly Banking sectors. This application could be useful in tracking all the Income/salary data.
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
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
- Integration of additional NPS Tier II benefit
- Auto calculation of CCA and HRA
- For banking employees, Dearness Allowance rates are implemented
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..
[button color=”red” size=”big” link=”https://www.rajmanglam.com/wp-content/uploads/2018/02/FINAL-INCOME-TAX-CALCULATOR-TalkBankings-2017-18.xls” target=”blank” ]Download Income Tax Calculator FY 2017-18[/button]
Just provide your comments if any below.