Form 16 in Excel Format for AY 2020-21 with Auto Calculations

Under section 192 of the income tax act,1961 every employer should deduct TDS from employee salary. These deducted TDS details are acknowledged in form 16 (TDS certificate). Here you can download the latest auto income tax calculator for FY 2019-20 (AY 2020-21) or simply form 16 in Excel format for AY 2020-21.

Latest changes in Income Tax Rules (Ay 2020-21)

1. A rebate of 12,500 Rs has given to the salaried employees up to a taxable income of 5 Lakhs i.e if your taxable income is below 5 lakhs then you don’t need to pay any income tax.

(For example, if your taxable income is 5 lakhs then you don’t need to pay any income tax, earlier employees need to pay 5% tax on amount more than 2.5 Lakhs. Now due to this rebate, you are exempted from the tax. But if your taxable income is 5,50,000 then you are liable to pay income tax. You need to pay a 5% tax on 2.5 Lakhs and 20% tax on the remaining 50000).

2. Standard deduction has increased to 50000 Rs, earlier it was 40000 Rs.

3. The limit of interest income for TDS has increased to 40000 Rs, earlier it was 10000 Rs.

4. The limit of rental income for TDS has increased to 2.4 Lakhs, earlier it was 1.8 Lakhs.

Income Tax Slab Rates for FY 2019-20 (AY 2020-21)

Individuals below 60 YrsSenior Citizens 60-80 YrsSuper Senior Citizens Above 80 Yrs
Taxable IncomeTax RateTaxable IncomeTax RateTaxable IncomeTax Rate
Up to 2.5 LakhsNilUp to 3 LakhsNilUp to 5 LakhsNil
2.5 – 5 Lakhs5%3 – 5 Lakhs5%5 Lakhs – 10 Lakhs20%
5 -10 Lakhs20%5 – 10 Lakhs20%Above 10 Lakhs30%
Above 10 Lakhs30%Above 10 Lakhs30%  

Form 16 Related Questions

Difference between form 16 and form 16A

Form 16 and form 16A both are TDS certificates, whereas form 16 is used to file returns on income from salary and form 16A is used to file returns on income other than salary, for example, interest from fixed deposits in banks, income from house rents etc.

Difference between form 16 and form 26AS

Form 26AS is the annual statement of income tax returns it consists of details of form 16, form 16A and refunds. Form 26AS shows complete details about IT returns of the employees.

Can we download form 16 online

Yes, if the tax is deducting from the income then you can download your form 16 or form 16A online at TRACES website. If you are a first time user then you need to register at TRACES website (Tax Reconciliation Analysis and Correction Enabling System). If you are an employee then you can get form 16 from your employer.

Last date to file income tax returns for ay 2020-21

The last date to file income tax returns for ay 2020-21 is 31 July. Any delay in filing income tax returns leads to 1% interest per month on pending tax dues. For more details read this article on interests on late payment of income tax.

1 thought on “Form 16 in Excel Format for AY 2020-21 with Auto Calculations”

  1. If ESI deducted on Salary and salary is also less than 20000 how the form 16 Format we genrate

    Please advice

    Thanks
    Mahendra Singh

    Reply

Leave a Comment