How to use Excel Income Tax Return Form ITR-1 Sahaj

How to use  Excel  Income Tax Return Form  ITR-1 (Sahaj) : –
i Overview
ii Before you begin
iii Structure of the ITR utility
iv Filing and Using the Excel utility 
v Validating the sheets
vi Navigation
vii Calculate Tax
viii Generating the XML
ix Printing
x Importing
xi How to submit an ITR using Excel utility?

i Overview :
Fill up applicable schedules Navigate to each schedule applicable and fill the data.
Validate each sheet Click on the ‘Validate’ Button on each filled sheet .Correct errors (if any) identified by the validate feature.
Click on Calculate Tax Fill 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 XML After 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 XML To save the XML in the desired path, click on the ‘Save XML’ button.
Upload the XML To upload the saved XML, Go to -> Login -> e-File  -> Upload Return.

ii Before you begin :
Read the instructions for filling up the form available in the following 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.    

iii 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.

iv 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 autocalculated /autopopulated 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.

v Validating the sheets :
Validate the filled sheet using the ‘Validate’ button. Correct errors (if any) identified by the validate feature.

vi 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.  

vii 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.

viii 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.

ix Printing : 
The print button in the utility provides an option to print  after previewing.
x 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 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.

xi 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.
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.

Click here to Download  Excel ITR -1 (Sahaj)

Leave a Comment