Category: Form 16

Categories
Form 16

how to sign form 16 digitally from excel – digital signature in TDS form 16

Hello,

Please read the following guide to understand how to signed digitally multipal TDS Form 16 pdf files using the Excel VBA code made by Ajit Sir.

How to digitally signed form 16 from Excel using VBA Code:-

  1. Open Excel file and Click on Developer tab to go on VBA project screen
  2. Click on Insert option and insert a new module
  3. Copy below VBA code (Add Digital Signature to PDF) and paste in module
  4. Add Pfx File path to call/select digital signature certificate for signing
  5. Add Password of certificate
  6. Add PDF full path and name with .pdf in Inputfile to signed
  7. Add PDF full path and name with .pdf in outfile to Save output
  8. Press F5 OR run macro 2 times to signed
  9. That’s All.
Sub DigitalSignedPDFCode()
Dim SignedPDF, FileCount, PFX_pass, strSignFName, inputpdf, epass, outputpdf
Dim pdfPDDoc As New AcroPDDoc, oJS As Object, oSign As Object, oPpklite As Object
Dim oSignInfo As Object
Dim ResultLogin As Boolean
Dim ResultSign As Boolean
Dim arr() As String
Set pdfPDDoc = CreateObject("AcroExch.PDDoc")
Set oJS = pdfPDDoc.GetJSObject
Set oPpklite = oJS.security.getHandler("Adobe.PPKLite", True)
             
strSignFName = "PFX CERTIICATE PATH"
PFX_pass = "PFX PASSWORD"
inputpdf = "PDF FILE FOR SIGN"
outputpdf = "PDF FILE AFTER SIGNED"             
               
'Page 1
Set oFields = oJS.AddField("SignatureField", "signature", 0, Array(80, 220, 255, 250))
Set oSign = oJS.GetField("SignatureField")
ResultLogin = oPpklite.login(PFX_pass, strSignFName)
oPpklite.setPasswordTimeout PFX_pass, 60
arr = Split("", ",")
ResultSign = oSign.signatureSign(oPpklite, arr, outputpdf)

oPpklite.logout
pdfPDDoc.Close
Set oJS = Nothing
Set oSign = Nothing
Set oPpklite = Nothing
Set pdfPDDoc = Nothing

End Sub

We have all HR and Payroll Calculation and solutions in Excel and we believe and Excel automation, this is one of them. for more details visit www.99Excel.Com or write to us AT : support@99excel.com

Thanks, Team Payroll Automation

Categories
Form 16

How to merge, protect, signed and Email TDS form 16 to employee from Excel sheet

As you know form 16 generating have some manual process but using VBA excel automation you can do it automatic and without error. Following steps you can automate:-

  1. How to merge part A and Part B of form 16 using Excel
  2. How to set password in form 16 pdf file using Excel
  3. How to signed digital signature in from 16 using Excel
  4. Final send TDS form 16 to you employee from excel using outlook.

Watch below video for tutorial and you can purchase this excel utility from www.99Excel.Com OR Call on +91 9654421288.

Categories
Form 16

Part B of Form 16 shall be download from TRACE

Good news for all employers and Payroll professionals!

Recently, Income Tax India (CBDT) systems has amended the rule 31 of Income tax Rules 1962. As per new rule form 16 Part A and Part B (A complete TDS certificate form 16 shall be available from trace website to download and issue to employee.

1st April 2018 on wards, every employer shall issue the form 16 Part B (Annexure) from trace only along with Part A. You can say Now, complete form 16 to be given by income tax only not employer.

But in case, employee are claiming for exemptions under section 10 (Apart form 10(5), 10(10), 10(10A) , 10(10AA) and 10(13A) ) than employer have to fill the form 16 item no. 2f. Complete information given below.

The item nos. 2(t) and 10(k) in Part B (Annexure) of Form 16 required to be filled-in by the deductor manually shall be made available at the bottom of the TRACES generated Form 16 (Part B) and the deductor shall duly fill details, where available, in item numbers 2(t) and lOCk) before furnishing of Part B (Annexure) to the employee. The deductors who opt to uthenticate Part B of Form No. 16 manually will be provided with the download of the Part B of Form No. 16 alongwith these item nos. 2(t) and lOCk) appearing at the bottom of the Form. The deductor shall duly fill details, where applicable, in item numbers 2(t) and 10(k) before furn ishing of Part B (Annexure) to the employee. The deductors who opt to authenticate Part B of Form No. 16 using Digital Signature Certificate (DSC) will be provided with the download of Part B of Form No. 16 without item nos. 2(t) and 10(k) and therefore these details shall be required to be prepared by the employer and issued to the employee, where applicable, before furni shing of Part B to the employee.

Download Notification.

  • Part A of Form 16 shall be download from Trace only.
  • Part B of Form 16 shall be download from Trace only.
  • A Complete form 16 TDS certificate shall be issued by Trace Income tax India only.
  • Employer will update form Part B of Form 16 in case employee are claiming exemption in item no 2(f) of form 16 and any deduction allowed by employer in item no 10(k) o form 16.
  • Part B is mandatory in case employee has submitted PAN to employer and employer has finished in salary return (form 24Q).
  • Authentication or verification of TDS certificate Form 16 both parts downloaded from trace to be done by employer or you can say final issuing correct form 16 tds certificate responsibility of employer only.
  • Employer also will issue form 12BA from own records in case employee is getting perk benefit more than 150000.
  • Manual form 16 part B will not issue from 1st April 2018 onward.

Regards, Kumar Ajit

www.payrollpedia.org