Download Automated Excel Based Revised Salary Certificate Form 16 for F.Y.2020-21 & A.Y 2021-22 which can prepare at a time 50 employees Form 16 Part A & B as per Budget 2020 U/s 115BAC

Under Section 203 of the Income Tax Act, 1911, every employer in the public

sector or in the private sector is required to submit a tax certificate in the form

 of 1 form of tax deducted from the source of salary (TDS). Form 116 contains

the calculation of salary, allowable decision and exemption, details of tax

deduction and retention by the employer along with annual tax payable.

Issue Form 16:

The certificate needs to be furnished by the 31st day of May after the end of the

 corresponding financial year. If the employer can issue a duplicate certificate in

 Form 1 lost, then if the cutter loses the original Form-1 lost and requests the

 issuance of the duplicate. The duplicate certificate must be verified as

 duplicate by the cutter.

Part 16 of the form

The CBDT Circular No. 04/2013 dated 17th April 2013, for tax reasons as on

01-04-2012 or onwards will be in two parts as follows:

In Part-A

Part A of Form No. 1 of contains the details of the tax and it needs to be

downloaded from the TDS website (TRACS) and may be issued by the

employer by manually identifying or under digital signature. Part N of

Form No. 1 16 along this line will be created by all the cutters only through

the Trax portal and will be issued after proper attestation and verification.

Part-B

'Section B of the form contains the calculation of the total salary of the employee

 with details of reasonable investigation and exemption. Form 1 has to be

prepared manually by the 16 cutting employer and handed over to the

discharging employee along with a part of Form No. 16

This Excel-based Auto-fill Form 16 for AY 2021-22 (FY 2020-21) is very basic

and easy to understand. The client needs to fill in the data in a popup form and

Excel Form 16 will be automatically updated effortlessly. For ease of filling, the

form is divided into four sections in total. Each section can be filled

independently with the help of the three fill forms provided.

It has an inbuilt pan and tan structure check and every time an off-base pan or

TN structure is created it immediately gives a warning message for any

off-base entry.

Help and rules to enable a quick referencing are also provided in a spring up

box. Excel Form-16 automatically counts the number of arguments allowed

 under Chapter VIA and the applicable annual tax.

Please note that no password is expected to use this application instead of the

 "Fill out Form 16" button to begin filling out this form. Macro is more likely than

Excel not to be able to use this form 16.

Please note, CBDT has revised the format of Part-B of Form 16 issued by the

employer dated 12th April 2019 dated Notification No.3.3 / 2019. The revised

 format is applicable from 12.05.2019

Feature of this Excel Utility:-

1) This Excel Utility can prepare at a time 50 employees Revised Form 16 Part B

2) This Excel Utility can prevent the double-entry of the employee's Pan Number

3) This Excel Utility have all the Income Tax Section as per Budget 2020

4) This Excel Utility can use Old Tax Regime & New Tax Regime U/s 115BAC

5) This Excel Utility can use Government and Non-Government Concern.

6) Automatic Convert the Amount to In-Words without any Excel Formula

7) This Excel utility most easy to generate just like as an Excel File

8) You can prepare more than 100 employees Form 16 Part B

Mtaxsoftware