How can we save Time, Energy and Resources? Simple, by using the Powerful Tool Microsoft Excel!!
How to send Form
Let us say you want to send Salary Slips to Employees on a monthly basis or Form 16 to Employees on a yearly basis or Form 16A to Deductees on a quarterly basis or any other Personnel specific attachment. Many Companies/Businesses send these Forms in hard copy by couriering it to the receiving Party which calls for the Courier cost and the company’s resources. Sending this via e-mail will save the courier cost and the company’s resources, but still there would be human time and energy involved. Let us look at a Procedure created in Microsoft Excel which can help you minimize the human time and energy by automating the process.
Let us say you have downloaded Form16A from the TDS CPC website and are ready to send it. (Note that Form 16A can be send via e-mail only if it is digitally signed. If it is signed manually then sending a hard copy is mandatory). I have attached herewith a Sample Automated Tool wherein you just need to put in the Deductee Name, PAN Number and E-mail ID alongwith few General Details viz Assessment Year, Quarter, Location of Form 16A and the Deductor details and all the Form 16A’s are sent just with a click of the Command button. Download the Excel Sheet “Sending Form 16A” and follow the Instructions given in the Sheet. You can either change in the data to your Actual Data or test check the Tool with the example fed into it. For test checking the Sheet with the example fed into the Automated Tool, you also need to download the Zipped Folder “Form 16A” and save it on your Desktop. Whether you are trying this Automated Tool with your own data or sample data, make sure you change the E-mail ID’s (belonging to you) so that you can assess the working of the Tool.
Notes:
Enable the Macros/Content, if it is not enabled.
This automated tool has been created to work with Microsoft Outlook. However the same can be amended to work with any other Mail Utility that your Company/Business is using. (Ensure that your Microsoft Outlook is open)
This tool is a sample tool which will work only for 3 examples. Put in the details of three Deductees and press the command button.
This tool sends Attachments in PDF Form. Alternatively the tool can be amended to send Attachments in any format.
You checked the above and it works!!. So now let us see how do you send Form 16 wherein you have two Attachments to be sent to each Employee. Part A is to be downloaded from the TDS CPC website and Part B is to be prepared by the Company/Business. Once you have downloaded Form16 from the TDS CPC website and are ready with Part B; which means you are ready to send Form 16 to Employees (Note that Form 16 can be send via e-mail only if it is digitally signed. If it is signed manually then sending a hard copy is mandatory), download the Sample Automated Tool “Sending Form 16” (attached herewith) wherein you just need to put in the Employee Name, PAN Number, E-mail ID and Employee Code alongwith few General Details viz Assessment Year, Quarter and the Deductor details and all the Form 16’s are sent just with a click of the Command button. Make sure that Part B prepared by your Company/Business is named in the manner as mentioned in the Instructions (If the Name of Part B is in any other Form, the Tool can be amended accordingly). It is pertinent to note that the difference between sending Form 16 and Form 16A is Form 16 has two Attachments in each mail (Part A and Part B) as against Form 16A which has only one Attachment. You can either change in the data to your Actual Data or test check the Tool with the example fed into it. For test checking the Sheet with the example fed into the tool, you also need to download the Zipped Folder “Form 16” and save it on your Desktop. Whether you are trying this Automated Tool with your own data or sample data, make sure you change the E-mail ID’s (belonging to you) so that you can assess the working of the Tool.
Notes:
Enable the Macros/Content, if it is not enabled.
This automated tool has been created to work with Microsoft Outlook. However the same can be alternatively amended to work with any other Mail Utility that your Company/Business is using. (Ensure that your Microsoft Outlook is open)
This tool is a sample tool which will work only for 3 examples. Put in the details of three Employees and press the command button.
This tool sends Attachments in PDF Form. Alternatively the tool can be amended to send Attachments in any format.
The due for sending Form 16 is May 31, 2014 and Form 16A is May 30, 2014.
How to send Form
Let us say you want to send Salary Slips to Employees on a monthly basis or Form 16 to Employees on a yearly basis or Form 16A to Deductees on a quarterly basis or any other Personnel specific attachment. Many Companies/Businesses send these Forms in hard copy by couriering it to the receiving Party which calls for the Courier cost and the company’s resources. Sending this via e-mail will save the courier cost and the company’s resources, but still there would be human time and energy involved. Let us look at a Procedure created in Microsoft Excel which can help you minimize the human time and energy by automating the process.
Let us say you have downloaded Form16A from the TDS CPC website and are ready to send it. (Note that Form 16A can be send via e-mail only if it is digitally signed. If it is signed manually then sending a hard copy is mandatory). I have attached herewith a Sample Automated Tool wherein you just need to put in the Deductee Name, PAN Number and E-mail ID alongwith few General Details viz Assessment Year, Quarter, Location of Form 16A and the Deductor details and all the Form 16A’s are sent just with a click of the Command button. Download the Excel Sheet “Sending Form 16A” and follow the Instructions given in the Sheet. You can either change in the data to your Actual Data or test check the Tool with the example fed into it. For test checking the Sheet with the example fed into the Automated Tool, you also need to download the Zipped Folder “Form 16A” and save it on your Desktop. Whether you are trying this Automated Tool with your own data or sample data, make sure you change the E-mail ID’s (belonging to you) so that you can assess the working of the Tool.
Notes:
Enable the Macros/Content, if it is not enabled.
This automated tool has been created to work with Microsoft Outlook. However the same can be amended to work with any other Mail Utility that your Company/Business is using. (Ensure that your Microsoft Outlook is open)
This tool is a sample tool which will work only for 3 examples. Put in the details of three Deductees and press the command button.
This tool sends Attachments in PDF Form. Alternatively the tool can be amended to send Attachments in any format.
You checked the above and it works!!. So now let us see how do you send Form 16 wherein you have two Attachments to be sent to each Employee. Part A is to be downloaded from the TDS CPC website and Part B is to be prepared by the Company/Business. Once you have downloaded Form16 from the TDS CPC website and are ready with Part B; which means you are ready to send Form 16 to Employees (Note that Form 16 can be send via e-mail only if it is digitally signed. If it is signed manually then sending a hard copy is mandatory), download the Sample Automated Tool “Sending Form 16” (attached herewith) wherein you just need to put in the Employee Name, PAN Number, E-mail ID and Employee Code alongwith few General Details viz Assessment Year, Quarter and the Deductor details and all the Form 16’s are sent just with a click of the Command button. Make sure that Part B prepared by your Company/Business is named in the manner as mentioned in the Instructions (If the Name of Part B is in any other Form, the Tool can be amended accordingly). It is pertinent to note that the difference between sending Form 16 and Form 16A is Form 16 has two Attachments in each mail (Part A and Part B) as against Form 16A which has only one Attachment. You can either change in the data to your Actual Data or test check the Tool with the example fed into it. For test checking the Sheet with the example fed into the tool, you also need to download the Zipped Folder “Form 16” and save it on your Desktop. Whether you are trying this Automated Tool with your own data or sample data, make sure you change the E-mail ID’s (belonging to you) so that you can assess the working of the Tool.
Notes:
Enable the Macros/Content, if it is not enabled.
This automated tool has been created to work with Microsoft Outlook. However the same can be alternatively amended to work with any other Mail Utility that your Company/Business is using. (Ensure that your Microsoft Outlook is open)
This tool is a sample tool which will work only for 3 examples. Put in the details of three Employees and press the command button.
This tool sends Attachments in PDF Form. Alternatively the tool can be amended to send Attachments in any format.
The due for sending Form 16 is May 31, 2014 and Form 16A is May 30, 2014.
No comments:
Post a Comment