Process of using Pre-filled XML data in offline excel utility

This year Income Tax e filing portal has provided a new facilities of “Pre-filled XML data in offline Excel utility”on their website.

The process of using the Pre-filled XML data in offline excel utility has been given below:

What is Pre-filled ITR xml ?
Pre-filled XML is a trick/utility by which you can fill your personal and TDS details in offline excel utility automatically.

Following main details are imported in excel utility through downloaded XML from e filing site:

  •  FirstName
  •  Middl name
  •  SurName
  •  PAN
  •  DOB
  •  Status
  •  TDS on Salaries
  •  TDS other than salaries
  •  TCS details

Process of downloading the Pre-filled XML data:

  1. Download the offline Excel utility of required ITR form.
  2. Download the pre-filled XML data from income tax efiling site.
    • Login at income tax india efiling site.
    • Go to download tab.
    • Click “download pre-filled XML.
    • Select the Assessment year in new screen and click submit button.
    • Save the XML file in your computer.
  3. Open the offline Excel utility (downloaded in one above).
  4. Enable macro in Excel utility.
  5. click all the pop-ups open one by one.
  6. On right side of your main page of Excel utility a button is given with title (import your personal details from xml).
  7. Browse the file downloaded as per sr no 2.5 above.
  8. Select and submit, all the details will be filled in ITR form automatically.

Benefit of Pre-filled XML:

The benefit of the pre-filled XML data is that all your  personal details and TDS details will be filled automatically in offline Excel utility. It will reduce chances of entering wrong input data in income tax return.

 

Facebooktwitterredditpinterestlinkedinmail

7 thoughts on “Process of using Pre-filled XML data in offline excel utility

  1. Ambika

    Dear Sir,

    Information was very useful. I need to file TDS return of 3rd quarter. I am not able to download offline Return file( prefiled Xml. Please mail it to above mail id. It will be great help from your side.

    Thanks & Regards,
    Ambika Jain

    Reply
  2. shirish. S

    I have downloaded Previous years Xml files from efiling Income tax website.
    How to load this data into excel utility of that year.
    I need to rectify a IT return of previous year.

    Reply
  3. bsk

    I have a doubt.. please help.. I need to get the investment details I filled last year. Is it possible to get those details (from ITR1) via incometaxindiaefiling.gov.in?

    Please note that I need the investment details I added in previous year… Kindly help

    Reply
  4. Vivek

    I have Previous years Xml files from efiling Income tax website.
    How to load this data into Java utility of that year.
    I need to rectify a IT return of previous year.

    Reply
  5. Saurabh Srivastava

    Dear Sir,

    How to find whether my return has been submitted or not. i submitted my return on 4 aug. as i clicked on submit button the website logged out. And i am not seeing any data on efile return/ form tab.

    Reply

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.