income tax calculator excel free download

The maximum limit to get exemption under these sections is 1,50,000 Rs.

Exemptions under section 80C, 80 CCC and 80 CCD such as investments in a provident fund such as EPF and PPF, payment towards life insurance premiums, equity-linked savings scheme (ELSS), payment towards home loan, payments towards Sukanya Samridhi Yojana scheme, National Savings Scheme, and Senior Citizens Savings Scheme.

Deductions under entertainment allowances and tax on employment.

Gross salary of employee and allowances like house rent allowances, leave travel allowances, leave encashment and gratuity, etc.

Part B of Form 16 consist following details

Summary of TDS paid or credited quarterly.

Assessment year for which TDS deducted.Period of employment with the employer.Name and address of employee and employer.Part A of form 16 consist of the following details The basic difference between part A and part B of form 16 is, part A consists of general information of employee and employer like their address, PAN & TAN details, etc., whereas part B consists of salary and TDS details of the employee. Download Form 16 in Excel Format (Latest Ay 2021-22) with Auto Calculations Form 16 in Excel format for Ay 2021-22 (Fy 2020-21)įorm 16 in Excel format for Ay 2020-21 (Fy 2019-20)įorm 16 in Excel format for Ay 2019-21 (Fy 2018-19)ĭifference between form 16 A and form 16Bįorm 16 consists of two parts, they are part A and part B. Form 16 will be issued once a year by the employer to the salaried employees. Based on the data available in form 16 salaried employees can easily file their ITR (income tax returns).įorm 16 is also known as the income tax calculator and it consists of Two parts part A and part B.

Form 16 is a certificate that consists of details of TDS (Tax Deducted at Source), other incomes, tax benefits, and tax calculations under section 203 of the income tax act 1961.

Income tax calculator excel free download