Last Modified on 01/04/2016

ITR Forms in Excel format with formulas for AY 2015-16 & 2016-17

Salient features of ITR forms with Excel formulas compiled by Finotax:

  1. These forms are for physical filing of Income Tax Returns in paper form. However, you may use these forms as an aid for e-filing of your return.
  2. Each ITR form is available in an Excel file containing:
    1. Excel worksheet for ITR form with formulas.
    2. Excel Worksheet for Acknowledgement form in look alike ITR-V / Acknowledgement form with formulas for Auto Compile.
    3. Annexure for Schedules IT, TDS1 and TDS in Excel format (to be used if the rows provided in the form are found insufficient).
  3. The forms have formats similar to the PDF format forms issued by Income Tax Department.
  4. All ITR forms are compiled on a single worksheet for ease of filling and printing.
  5. The forms require minimum data / information input by you.
  6. The formulas in the form will automatically calculate / compute your Income Tax Liability as per your Status and Age (Auto calculated from your Date of Birth).
  7. By using these forms, your return will be compiled accurately within minutes without any cutting / overwriting.
  8. Applicable Check Box selections (viz. Sex, Category, Yes / No choices etc.) can be ticked by a click of the mouse.
  9. Only cells / fields required to be used for entering data / information can be selected by the user to avoid any accidental deleting of format / contents of the cells.

Manner of Filing Tax Return

Mandatory filing of return electronically

From the assessment year 2015-16 onwards the following assessees (other than an individual of the age of 80 years or more at any time during the previous year):

  • Any assessee having total income of more than five lakh rupees
  • Any assessee having a refund claim in the return
  • A resident assessee having any assets (including financial interest in any entity) located outside India or signing authority in any account located outside India
is required to furnish the return in any one of the following manner :
  1. by furnishing the return electronically under digital signature;
  2. by transmitting the data in the return electronically under electronic verification code;
  3. by transmitting the data in the return electronically and thereafter submitting the verification of the return in Return Form ITR-V;
  4. Returns on ITR-3, ITR-4, ITR-5, ITR-6 and ITR-7 forms are to be furnished electronically in all cases.

Where the Return Form is furnished in the manner mentioned at (iii) above, the assessee should print out two copies of Form ITR-V. One copy of ITR-V, duly signed by the assessee, has to be sent by ordinary post to Post Bag No. 1, Electronic City Office, Bengaluru - 560100 (Karnataka). The other copy may be retained by the assessee for his record.

Get ITR Forms with Excel Formulas for AY 2015-16 & 2016-17 (for Filing of Return in Paper form)

Important : Please go through 'Tips to prepare your tax return' before starting to use ITR forms in Excel format compiled by us.

DescriptionAY 2015-16AY 2016-17
SAHAJ ITR 1 Form set (ITR - 1 + ITR - V)Not compiledDownload
ITR 2A Form set (ITR - 2A + ITR - V)DownloadDownload
ITR 2 Form set (ITR - 2 + ITR - V)DownloadDownload
ITR 4S Form set (ITR - 4S + ITR - V)Not compiledDownload
ITR 3, ITR 4, ITR 5, ITR 6 and ITR 7Return on these forms is mandatorily required to be filed electronically.
ITR V Acknowledgement formDownloadDownload

About forms compiled by Finotax.com :

  • The forms can be downloaded for free by users of this site for their personal use. The forms are not available for publishing on any web site / blog.
  • The forms compiled in Excel format are protected by password to prevent accidental deletion of inbuilt formulas and to check their unauthorized publication. The password of the forms will not be shared with any person.
  • Report of any errors / omissions in forms will be promptly attended to. Other requests will be entertained on merits.
  • The forms are amended on an ongoing basis to
    1. Remove errors / omissions noticed by us / advised by the users of forms.
    2. Incorporate changes made in the forms by the form issuing departments / agencies.
    3. Make the form more user friendly.
    It is, therefore, advisable to download the forms afresh from this site whenever you wish to use them.

Disclaimer

Due diligence is exercised in compiling the forms. However, inadvertent errors / omissions are not ruled out. This site makes no claim that the forms made available for download are correct and / or up-to-date. Please download and use the form(s) at your own risk and responsibility. This site will not be responsible for any loss or damage caused / arising to any person or persons or any body whosoever by using the form downloaded from this site.

Popular Content