Revised Excel Auto Salary TDS Certificate Form 16 for AY 2019-20 Download

Revised Excel Auto Salary TDS Certificate Form 16 for AY 2019-20 Download

Under Section 203 of Income tax Act, 1961, Every employer whether in Government sector or in private sector, is required to issue in form 16, a certificate for tax deducted at source  (TDS) from salary. The Form 16 contains the computation of the income, allowable deductions and rebates, income-tax payable along with details of tax deducted and deposited by the employer.

Please note, CBDT has, vide Notification No.36/2019 dated 12th April, 2019 revised the format of Part-B of Form 16 to be issued by the employer. The revised format is applicable from 12.05.2019

Issue of Form 16:
The certificate is required to be furnished by the 31st day of May after the close of the relevant Financial Year . The employer may issue a duplicate certificate in Form 16 if the deductee has lost the original form-16 and makes a request for issuance of duplicate one. The duplicate certificate must be certified as duplicate by the deductor.

Form 16 Parts
As per CBDT Circular No. 04/2013 dated 17^th April, 2013, issue of form 16 for deduction of tax at source made on or after 01-04-2012 shall be in two parts as under:

Part-A
Part A of Form No. 16 contains the details of the tax deposited and is required to be downloaded from TDS Website (TRACES), and can be issued by the employer by manually signing or under a digital signature . Thus Part A of Form No. 16 shall be issued by all the deductors, only by generating it through TRACES Portal and after duly authenticating and verifying it.

Part-B
‘Part B of the Form contains the computation of the total income of the employee including the details of deductions and rebates allowed. Form 16 is required to be prepared by the deductor employer manually and issued to the deductee employee along with the Part A of the Form No. 16.

ABCAUS excel based auto fill Form 16 for AY 2019-20 (FY 2018-19) is very simple and user friendly. The user is required to fill the data in a pop up form and Excel Form 16 is updated automatically with ease. For comfort of filling, the form has been divided into total of four sections. Each section can be filled independently with the help of three fill forms as provided.

Video Tutorial:

It has an inbuilt PAN and TAN Structure check and each time a wrong PAN or TAN structure is written, it immediately gives a message to alert for any wrong entry that could be made.

Help and rules have also been made available in a pop-up box to enable a quick referencing. The Excel Form-16 automatically calculates the amount of allowable deductions under Chapter VIA and applicable income tax .

Please note that no password is needed to use this application, instead click  “fill Form 16” button to start filling this form. Macros must have been enabled in excel to use this form. Download macros help here Click Here >>  Users are advised to read the help/watch video before using this utility.

Please note, CBDT has, vide Notification No.36/2019 dated 12th April, 2019 revised the format of Part-B of Form 16 to be issued by the employer. The revised format is applicable from 12.05.2019

CBDT has also extended the due date for issue of Form 16 for financial year 2018-19 from 15th of June, 2019 to 10th of July , 2019 Click Here >>

Also Read:

Blind reliance on 26AS Statement to declare income or claim TDS puts you to what risks? >>

Section 234F Late fee  for filing ITR-When statistics overrules the mathematics >>

Download Excel Form 16 for AY 2019-20 issued up to 11.05.2019

Download Excel Form 16 for AY 2019-20 issued on or after 12.05.2019

Forms for Previous Years:

Download Excel Form 16 for AY 2018-19

• Advisory on Filing Opt-In Declaration for Specified Premises, 2025
• FAQs for HSNS Cess Act, 2025 and HSNS Cess Rules, 2026
• Refusing to condone delay can result in a meritorious matter thrown out at threshold
• Prior period income cannot be considered as income of the current year
• SC condoned delay of 972 days in filing appeal due to restructuring in Department