New Form 16 Part B in excel format AY 2019-20(FY 2018-19) free download

New Form 16 Part B excel utility (as per notification 36-2019)
Submit your email to download the file

Enter your email address:

Now it is the time to issue form 16 to all employees and file income tax returns for the assessment year 2019-20. Form 16 consists of 2 parts, Part A which is generated from the income tax website after uploading TDS annual return. Part B is issued by the employer.

As per Notification No 39-2019, the Income tax Department has revised the form 16 Part B with effect from 12th May 2019.

In this Form 16 Part B excel utility, you can generate Part B.

Features of this Utility:

  • Auto Calculate the tax
  • Bulk Generate Form 16 Part B
  • Bulk PDF generation
  • You can also generate form 12BA

How to use Form 16 Part B Utility?

Download the utility from the link provided below. There are 4 sheets in this Excel utility.
Update basic information like company details and signatory details in Company Master sheet.
after updating company Master shoes you can update Data Sheet for part B. Required calculation formulas are updated in this, however you can modify these formulas.

Printing Form 16 part B

When the data sheet is updated part B is ready for printing. Now you can open Form 16 part B sheet and enter the serial number to generate form 16 part B. You can also create bulk PDF in this utility.

You can also create form 12BA in the excel utility. This excel utility is not protected and you are free to make any changes to this utility as per your requirement.

You may also like: Contact Management software in excel

GST Invoice software in Excel – Free Software

12 thoughts on “New Form 16 Part B in excel format AY 2019-20(FY 2018-19) free download”

  1. akshay

    unable create bulk PDF in this utility
    plz help

    1. Excelhub

      Please use excel version 2010 and above..

  2. PANDYA PRANAV

    FORM 16 PART B AY 2018-19 YOU HAVE READ EXCEL UTILITY PREAPER SAME AS ASSESSMENT YEAR 2017-18. PLS CONTACT FOR ME ON MY MOBILE NO. 9824160413

    1. Excelhub

      SAME HAS BEEN RECTIFIED.. YOU CAN DOWNLOAD AND CHECK NOW.

  3. Pingback: Contact Management software in excel - Excelhub.org

  4. AMIT

    AFTER ENTER EMAIL NO FILE DOWNLOAD. PLEASE PROVIDE ME AT MY MAIL.

    1. Excelhub

      Hi,
      you can check your email, the procedure for download is given in that.

  5. Sharanappa Pujari

    Dear sir I want form no 16 of incometax AY 2018-19 Please send my e mail address

    1. Excelhub

      Hi,
      You can subscribe to our site and you will receive email to download the file.

  6. Parag

    Pls let me know how come company details on form 16

  7. CA Anita Bhadra

    Excellent !

    Very very helpful

Leave a Comment

Your email address will not be published. Required fields are marked *