Excel Utility & Instructions for E Filing of ITRs for AY 2016-17

Excel Utility & Instructions for efiling of ITR 1 Sahaj, ITR 2, ITR 2A, ITR 3, ITR 4, ITR 4S Sugam , ITR 5, ITR 6 & ITR 7 (AY 2016-17) enabled at Income Tax website

The excel utility for e filing of most of the new forms of Returns of Income (ITRs) for AY 2016-17 has been made available by the Income Tax Deptt and now the same can be downloaded from the IT Deptt’s efiling website. Alternately, the same can be downloaded from the link below:

1.  Excel Utility – ITR 1 Sahaj (AY 2016-17)

For Individuals having Income from Salary & Interest.

2.  Excel Utility – ITR 2 (AY 2016-17)

For Individuals & HUFs not having Income from Business or Profession.

3.  Excel Utility – ITR 2A (AY 2016-17)

For Individuals & HUFs not having Income from Business or Profession and Capital Gains and who do not hold foreign assets.

4.  Excel Utility – ITR 3 (AY 2016-17)

For Individuals/HUFs being partners in firms and not carrying out business or profession under any proprietorship.

5.  Excel Utility – ITR 4 (AY 2016-17)

For Individuals & HUFs having income from a proprietory business or profession.

6.  Excel Utility – ITR 4S Sugam (AY 2016-17)

For Individuals/HUF/Partnership Firm having income from presumptive business.

7.  Excel Utility – ITR 5 (AY 2016-17)

For persons other than,- (i) individual, (ii) HUF, (iii) company and (iv) person filing ITR-7.

8.  Excel Utility – ITR 6 (AY 2016-17)

For Companies other than companies claiming exemption under section 11

9.  Excel Utility – ITR 7 (AY 2016-17)

For persons including companies required to furnish return under sections 139(4A) or 139(4B) or 139(4C) or 139(4D) or 139(4E) or 139(4F).

For Instructions on how to fill and e file the ITR, please download and unzip the relevant file. However, for example, we are reproducing the instructions relating to ITR 1 Sahaj and ITR 4S Sugam, as under:

Instructions – ITR 1 Sahaj/ ITR 4S Sugam (AY 2016-17)
1. Overview :
Fill up applicable schedulesNavigate to each schedule applicable and fill the data.
Validate each sheetClick on the ‘Validate’ Button on each filled sheet .Correct errors (if any) identified by the validate feature.
Click on Calculate TaxFill the necessary details in applicable schedules and click on ‘Calculate Tax’ for computation of tax.
Please make sure you click the ‘Calculate Tax’ button before generation of XML.
Generate XMLAfter all required schedules have been filled ,validated and tax has been calculated (using ‘Calculate Tax’ buttton), click on Generate XML which will recheck all sheets.
Save XMLTo save the XML in the desired path, click on the ‘Save XML’ button.
Upload the XMLTo upload the saved XML, Go to E- Filing website -> Login -> e-File -> Upload Return.
2. Before you begin :
Read the instructions for filling up the form available Income Tax Deptt website
The ITR Utility is an Excel Workbook that consists of a number of individual, integrated worksheets. Each of the sheets contains one or more schedules for data entry. Initially, all the sheets are visible to the user. A number of these sheets are optional. The user can decide which sheets are applicable to their case and accordingly select Y or N to hide or show the sheets. Similarly , by selecting the sheets which the user needs for printing, it is possible to control how many sheets should be printed (in case all sheets are not required to be printed). Later on, these settings can always be changed.
3. Structure of the ITR utility :
Various sheets and schedules per sheet form part of the Utility.Each sheet includes a number of distinct, titled sections/schedules.
Each sheet is identified by the sheet tabs located at the bottom of the Excel window. These tabs are labeled with abbreviation forms of the schedules of the sheet.
4. Filing and Using the Excel utility :
Every section/schedule is color coded to facilitate the user. The different types of cells in the sheets are as follows:
a) The mandatory fields are marked in red. The data entered will have a  green background color (Certain fields are mandatory under specific conditions only).
b) Data entry cells for optional/non-mandatory fields have a black font and a green background color.
c) Fields whose values are auto-calculated /auto-populated by the utility  have a blue font and a white background color. Linked fields, where no data entry is done by the user, but a value is picked up from an existing cell elsewhere in the sheet, these have  a blue font for the labels and a white background.
All amounts are in Indian Rupee.
All date fields must be entered in dd/mm/yyyy format.
For percentage fields, only enter the the value upto two decimal places. (percentage symbol is not required).
Adding more rows : Schedules such as TDS, TCS, IT etc  allow users to enter data in tabular format. Using the ‘Add rows’ button provided below these tables, the assessee can add as many rows as required.
Note: Rows once added and not required (or empty rows) should not be deleted, even if they are blank. The utility does not generate XML for rows left blank.
5. Validating the sheets :
Validate the filled sheet using the ‘Validate’ button. Correct errors (if any) identified by the validate feature.
6. Navigation :
There are two navigation buttons in the utility : ‘Next’ and ‘Previous’. The user can navigate between the sheets by either clicking on next or previous buttons as required.
7. Calculate Tax :
For the Tax to be computed the user must click on the ‘Calculate Tax’ button after filling the necessary details in applicable schedules.
8. Generating the XML :
Verify all the information entered in the ITR Utility.
Click on the ‘Generate XML’ button. This will revalidate all the sheets, and direct the user to the confirmation page which shows the various schedules (and the no of rows per schedule) being generated.
Once verified, the assessee can then click on ‘Save XML’ option to generate and save the XML.
After successfully generating, a message will be displayed with the name and location of the saved XML.
This XML can then be uploaded in the efiling portal.
9. Printing :
The print button in the utility provides an option to print  after previewing.
10. Importing :
a) Import Previous Version
If the user has a filled ITR in a previous version, the user can import the data from the previous version to the current version.To import click on the  ‘Import Previous Version’ button in the utility and browse the path of the previous version of  filled ITR.
b) Import Personal and Tax Details
The user can  import the personal and Tax details into ITR1 / ITR4S excel utility by following the given steps.
Step 1 : Login into the e-Filing portal using valid login credentials.
Step 2 : Go to the ‘Downloads’ menu and click the ‘Download Prefilled XML’ link. Select the ‘Assessment Year’ and download the Prefilled XML in the desired location.
Step 3 : Open the utility and click on the ‘Import Personal/Tax Details from XML’ button.
11. How to submit an ITR using Excel utility?
1.Download the ITR preparation utility for the assessment year under ‘Downloads’.
2.Prepare the Income Tax  return using the utility. Validate, Generate and Save the XML in the desired path.
3. Login to e-Filing portal and go to e-File –> Upload Return.
4.Select the appropriate ITR, Assessment Year and XML (using browse button).
5.Upload Digital Signature Certificate(DSC) if applicable. Please ensure the DSC is registered with e-Filing.
6.Click on ‘SUBMIT’ button.
7.On successful submission, ITR-V/Acknowledgement would be displayed. Click on the link and download the ITR-V/Acknowledgement.
If ITR is uploaded with DSC, the Return Filing process is complete. The return will be further processed and the Assessee will be notified accordingly. Please check your emails on these notifications. OR

The return is not uploaded with a DSC, an ITR-V Form should be printed, signed and submitted to CPC, Bangalore using Ordinary Post or Speed Post ONLY within 120 days from the date of e-Filing. On receipt of the ITR-V at CPC, the return will be further processed and the Assessee will be notified accordingly. Please check your emails on these notifications.

Leave a Reply