Wednesday, April 4, 2012

Form 15G and Form 15H with auto fill facility in Excel

Excel based form 15G and 15H is available for download.  User can enter data of form 15G upto 500 assessees and print  form 15G through changing certificate numbers.  The below screen shows the required data to be filled before printing any form. 
  • Company Name.
  • Address of the Company.
  • Name of Owner
  • Designation
  • Financial Year 
  • Serial Number. (as Certificate Number in form 15G)
  • Pan Number 
  • Name
  • Father Name
  • Address 
  • Amount of such Loan
  • Date on which Amount was given on Loan.
  • Date of Credit of Interest.
  • Rate of Interest.
As end of the year is near and to avoid from income tax form 15G and 15H is required for everyone.   These forms are generally useful for everyone. 

Certificate Number is circled in below picture. If user change it from 1 to 2, data of Serial Number available in Data Sheet will be auto captured.  However 15G and 15H excel based forms can be as per required of users. 
Download (Click Here)

Intense Debate Comments