Form 16 Part B excel utility
Submit your email to download the file
Now it is the time to issue form 16 to all employees and file income tax returns for the assessment year 2018-19. Last date for issue of form 16 for employer is 15th June 2018. 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. In Form 16 Part B excel utility, you can generate Part B.
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