Step 1: Please remember to Enable Macros before using this sheet.
To Enable macros in the excel do the following setting.
- Go to Menu of the excel >> Click File >> Click Options >> Click Trust Center >> Click Trust Center Settings.
- Then in Macro Settings >> Click the Option Enable all macros >> Click OK
Step 2: Fill the details in the respective sheets related to Form 16 Part B.
- Deductor Details: Fill in the details of Deductor and Responsible person.
- Form 16 Details: Fill in the Form 16 Part B details of all the employees whose Form 16 you want to generate. This is a mandatory step.
- Perquisite (12BA): Fill in the Perquisite details of the employees. This is an optional sheet. Fill this sheet only if you wish to generate Form 12 BA.
- Salary Annexure: Fill in the details of Salary annexure of employees. This is an optional sheet. Fill this sheet only if you wish to generate Salary Annexure along with Part B of Form 16.
Data in Form 16 Details Sheet
Step 3: Right Click on this Excel Sheet and select your Company Logo and Scanned Signature from the menu to append on Form 16.
- Select the Images menu.
- Company Logo ideal size should be: 450 X 600 pixel
- Signature size ideal should be: 250 X 1000 pixel
Step 4: Generate Your Form 16.
- Select the Generate Form16 menu.
- Select the options as provided before generation.
- Select the rows that you wish to generate Form 16 Part B.
- Click on "Generate Form 16" button to generate the Form 16.
- 12BA and Salary Annexure will automatically be generated for employees having these data.
Step 5: Generated Form 16 saved.
- All Form 16 generated in the PDF format.
- Form 16 generated with PAN name. For example AAAPC1111Z.pdf.
- All Form 16 generated in the Excel_Output folder of your system in the below path. C:\Skorydov\SmartForm16\Excel_Output
Step 6: To Know How to generate TRACES Part-A Click Here
Please sign in to leave a comment.