Automated Income Tax Salary Certificate Form 16 Part B for F.Y 2015-16 [ This Excel Utility can prepare at a time 50 employees Form 16 Part B]

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. This Excel based automatic form 16  can be
used both by companies or non companies for issue of form 16 to their

As per Rule 31(2) of
Income Tax Rules, 1962 the following particulars are required in the 
form 16:

1. Permanent Account Number (PAN) of the

2. Tax
Deduction Account Number of the employer

3. Basic Statistical Return (BSR) Number if the
tax is deposited through a bank. This is also called as “Challan Identification Number”.

4.  Book Identification Number if tax
deducted is deposited without a challan in case of Government employer.

5.  Receipt Numbers of all the quarterly
statements/returns of tax deducted at source under the head salaries.
The form 16 is required to be furnished to
employees annually latest by 31st May of the assessment year  for the
financial year for which tax has been deducted.

Issue of Form 16
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:

All deductors (including
Government deductors) shall issue the Part A of Form No. 16, by generating and
subsequently downloading through TRACES Portal, in respect of all sums deducted
on or after the1st day of April, 2012 under the provisions of section 192 of
Chapter XVII-B.Part A of Form No 16 shall have a unique TDS certificate number. Part-A
can be issued manually after verifying the same by using a digital signature or
by manual signature.
other words, 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 (Annexure)’ of Form No. 16 shall be
prepared by the deductor manually and issued to the deductee after due
authentication and verification alongwith the Part A of the Form No. 16.
excel based auto fill Form 16 is very simple and user friendly. The user is
required to fill the data in a White Cell  and Excel Form 16 is updated automatically
with ease. For comfort in filling,
It automatically calculates
the amount of allowable deductions under Chapter VIA and applicable income tax
on the total income also gets auto calculated as per the Finance Budget 2015-16
and all Amended Income Tax Section have in this Excel Utility.

Download Automated Master of Form 16 Part B for Financial Year 2015-16 [ This Excel Utility can prepare at a time 50 employees Form 16 Part B for Financial Year 2015-16 and Assessment Year 2016-17]

Macro should be enabled
to use this form. Users are advised to read help file first.

Leave a Reply

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