Excel Auto Salary TDS Certificate Form 16 for AY 2018-19 Download

Excel Auto Salary TDS Certificate Form 16 for AY 2018-19 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. 

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 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 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 2018-19 (FY 2017-18) 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.

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

Excel Auto Salary TDS Certificate Form 16 for AY 2018-19 Download
Download Excel Form 16 for AY 2018-19

Excel Auto Salary TDS Certificate Form 16

Download Excel form 16 AY 2017-18

Excel Auto Salary TDS Certificate Form 16

Download Excel form 16 AY 2016-17

----------- Similar Posts: -----------


  1. RAJESHREE July 5, 2016
    • administrator July 5, 2016
  2. RAMEAH July 22, 2016
  3. HAROON December 15, 2016
  4. Sagar May 21, 2018
  5. Deepak Salve November 22, 2018
  6. SHILPA RAJAPUT December 7, 2018
    • administrator December 8, 2018

Leave a Reply