Income Tax

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 17th 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

Download Excel form 16 AY 2017-18

Download Excel form 16 AY 2016-17

Share

View Comments

Recent Posts

  • Income Tax

Information in loose papers not corroborated with assessee, can’t be said to belong to assessee

When information contained in loose papers not corroborated with assessee, there is absolutely no room for presumption that it belongs…

16 hours ago
  • Income Tax

Setting aside remand order of CIT(A) without interfering with direction to delete addition, did not revive AO’s order

When CIT(A) order to remand case to AO was set aside without interfering with direction to delete addition, order of…

18 hours ago
  • arbitration

Whether Arbitral Tribunal can grant a prohibited claim in a contract – Larger Bench to decide

Whether a prohibited claim in a contract applies only to the employer and not to the Arbitral Tribunal – Matter…

2 days ago
  • contract-law

Court can examine contractual employee termination on sole ground of ineligibility

Where a contractual employee is terminated on the sole ground of ineligibility, the Court is entitled to examine its correctness…

2 days ago
  • EPFO

Upon deceased acquiring family, as specified earlier GPF nomination became invalid – SC

Upon deceased acquiring family, GPF nomination in favour of mother became invalid and in absence of fresh nomination, mother and…

2 days ago
  • GST

Auto Suspension of GST Registration due to Non-Furnishing of Bank Account Details

GSTN Advisory on Auto Suspension of GST Registration due to Non-Furnishing of Bank Account Details as per Rule 10A As…

2 days ago