Skip to main content

How to use ITR using excel utility to upload E-filing income tax return

Invest in ELSS Funds Online and Save Tax




Every year the Income tax department is trying to make the process of filing tax returns easier for taxpayers. Here is a step by step guide on the procedure of uploading and filing income tax returns online.

There are two ways to file income tax return online. One is to download the applicable I-T form from the income tax website, fill the form offline, save it, generate an xml file and then upload it. Another way of doing it is to enter the relevant data directly in an online form and submit it

However, the latter method is available only for ITR 1 and ITR 4 and not for forms for other categories of individual taxpayers.

This e-filing method can be used to file any ITR applicable to individuals whereas e-filing totally online method is available as an alternative only for filing ITR 1 and ITR 4.

Visit website – www.incometaxefiling.gov.in

<img class="alignnone size-full" src="http://discountwalas.com/wp-content/uploads/2017/06/taxreturn/image-1.jpg" width="630" height="369" />

Download the ITR form applicable to you depending on the types of income you have received in the financial year for which the return is to be filed. The form is available in two alternative software formats-excel and java. The ITR forms are available under the "Downloads" tab given on the website for the relevant year. You can download whichever software you are comfortable in using.

<img class="alignnone size-full" src="http://discountwalas.com/wp-content/uploads/2017/06/taxreturn/image-2.jpg" width="630" height="380" />

Prepare the return by filling all the relevant information in the form which is available in two alternative software formats-excel and java. Tip: The cells with text in red colour have to be filled mandatorily and data has to be entered in green coloured cells by the taxpayer. While filling up the sheets some white background cells automatically pick up data as they are system calculated based on data entered by you in other cells. Also, while filling the form, click the validate button once  (after filling the sheet) to ensure all the relevant sections have been filled.

Some excel functions have to be enabled before filing up the ITR form in excel format. The side buttons i.e. validate and other buttons of the excel file will work only if 'Macros' and 'ActiveX' function of the Excel workbook is enabled. The Macros can be enabled by visiting File > Excel options > Trust Centre > Trust Centre Settings > Macro Settings > Enable All Macro > Click 'OK' button twice to save this setting. The 'ActiveX settings' is also enabled in the similar fashion  like macros in the Trust Centre settings.

The ITR form will have multiple sheets – some relate to general information and computation of tax whereas others relate to different types of income and tax rebates. Open each sheet and fill the ones that are applicable to you depending on the types of income you have earned in the year for which the return is being filed. The general information sheet will have to be filled in all cases. Most of the fields (with white colour background) in the tax computation sheet get filled automatically once you fill the income sheets relating to those fields.

After you have entered all the information in the different worksheets (which are applicable to you) of excel file, save the sheet and then click 'Generate XML' button to generate xml version of your return. It is advisable to open the XML file generated and check that all the information filled in the form by you is showing correctly.

Now visit the e-filing website again to upload and file the return. If you are a first time user or filing your returns for the first time then click on 'New Registration' and register yourself by providing the relevant information. One should make sure that email ID and mobile number is correctly mentioned while registering. This is because the I-T department sends all communication to you on your email. If you have already registered yourself then click on the 'Registered user'.

<img class="alignnone size-full" src="http://discountwalas.com/wp-content/uploads/2017/06/taxreturn/image-4.jpg" width="630" height="326" />

Enter your user ID i.e. your PAN, password, Date of birth and enter 'Captcha' to sign in.


<img class="alignnone size-full" src="http://discountwalas.com/wp-content/uploads/2017/06/taxreturn/image-5.jpg" width="630" height="656" />

Click on 'e-file' tab and select the 'Upload Return' option.

<img class="alignnone size-full" src="http://discountwalas.com/wp-content/uploads/2017/06/taxreturn/image-6.jpg" width="630" height="435" />




After clicking the 'Upload Return' option, the website will direct you to page where you will be required to enter few details while uploading your ITR for the relevant year. Enter details required: the relevant assessment year, ITR form name, digital signature. PAN detail will be pre-filled.

Attach the ITR XML file using the browse button. (The same file which you have generated after filling the required information in excel/java utility software.)

Click on 'digital signature certificate' yes, if you are using this option. While using a digital signature, one should ensure that the signature is registered with the e-filing website

<img class="alignnone size-full" src="http://discountwalas.com/wp-content/uploads/2017/06/taxreturn/image-7.jpg" width="630" height="358" />



If you are using 'digital signature' option and click on the 'Submit' button, after all the information is entered, then the website will ask you to upload the pre-registered signature. Once the signature is uploaded successfully, the process of submitting ITR online is completed. The acknowledgement receipt will be sent to your email id. You're not required to send the signed physical copy.

If you are not using digital signature then you will be required to verify your return using any of the options provided by the income tax department. Process of uploading return in xml format is the same as described above. Once the return is successfully uploaded in the XML format, go to 'My Account' tab and click 'e-filed returns' option. Here the website will show you the status of all the returns uploaded and filed (old and new) by you along with the status (processed, uploaded or pending for e-verification).



<img class="alignnone size-full" src="http://discountwalas.com/wp-content/uploads/2017/06/taxreturn/image-8.jpg" width="630" height="262" />

Once the return is uploaded, a person is required to verify his return using electronic verification code, Aadhaar OTP or by sending the signed acknowledgement copy (ITR-V) to CPC, Bengaluru.


Inline image 1


If you wish to e-verify your return then go to 'My account' tab and select 'e-verify' option. A person can e-verify his return by using either Aadhaar OTP option or electronic verification code option.
<img class="alignnone size-full" src="http://discountwalas.com/wp-content/uploads/2017/06/taxreturn/image-9.jpg" width="630" height="319" />

Once the verification process is chosen and completed then the process of filing ITR completes. The I-T department will then process your verified returns and sent you an email confirmation stating the same.





Invest Rs 1,50,000 and Save Tax up to Rs 46,350 under Section 80C. Get Great Returns by Investing in Top Performing Tax Saving ELSS Funds. Save Tax Get Rich

Top 10 Tax Saving Mutual Funds of 2018

Best 10 ELSS Mutual Funds to Invest in India of 2018

1. Tata India Tax Savings Fund 

2. Mirae Asset Tax Saver Fund

3. DSP BlackRock Tax Saver Fund

4. Sundaram Diversified Equity Fund

5. Birla Sun Life Tax Relief 96

6. ICICI Prudential Long Term Equity Fund

7. Invesco India Tax Plan

8. Reliance Tax Saver (ELSS) Fund

9. Axis Tax Saver Fund

10. BNP Paribas Long Term Equity Fund


Invest in Best Performing Tax Saver Mutual Funds of 2018

Invest Best Tax Saver Mutual Funds Online

Download Top Tax Saver Mutual Funds Application Forms


For further information contact SaveTaxGetRich on 94 8300 8300

OR

You can write to us at

Invest [at] SaveTaxGetRich [dot] Com

OR

Call us on 94 8300 8300


Popular posts from this blog

Jeevan Labh

 The Life Insurance Corporation of India has announced Jeevan Labh , its limited-premium, with-profits endowment plan .   It comes with a premium paying terms of 10, 15 and 16 years for corresponding policy tenures of 16, 21, and 25 years respectively. ----------------------------------------------- Invest Rs 1,50,000 and Save Tax under Section 80C. Get Great Returns by Investing in Best Performing ELSS Mutual Funds Top 10 Tax Saving Mutual Funds to invest in India for 2016 Best 10 ELSS Mutual Funds in india for 2016 1. BNP Paribas Long Term Equity Fund 2. Axis Tax Saver Fund 3. Franklin India TaxShield 4. ICICI Prudential Long Term Equity Fund 5. IDFC Tax Advantage (ELSS) Fund 6. Birla Sun Life Tax Relief 96 7. DSP BlackRock Tax Saver Fund 8. Reliance Tax Saver (ELSS) Fund 9. Religare Tax Plan 10. Birla Sun Life Tax Plan Invest in Best Performing 2016 Tax Saver Mutual Funds Online Invest Online Download Application Forms For further information contact Prajna Capital on 94 83...

Liquidity Adjustment Facility

Liquidity adjustment facility (LAF) is a money market tool used by the central bank of a country (in India it is the Reserve Bank of India ), to infuse funds into the country's banking system when liquidity dries up. Again, in case there is excess liquidity, the central bank uses some tools to help banks manage their surplus liquidity. Usually the RBI uses the repurchase facility (called Repo ) to give short-term loans to banks to meet their temporary liquidity shortage. On the other, hand RBI uses reverse repo facility to help banks park their excess liquidity with it. Banks usually use various securities, which are approved by the RBI, as collateral when they take money from the RBI to meet their short term liquidity requirement     Best Tax Saver Mutual Funds or ELSS Mutual Funds for 2015 1. ICICI Prudential Tax Plan 2. Reliance Tax Saver (ELSS) Fund 3. HDFC TaxSaver 4. DSP BlackRock Tax Saver Fund 5. Religare Tax Plan 6. Franklin India TaxShield 7. Canara...

Tata Dynamic Bond Fund exit load

Tata Mutual Fund has revised the exit load of Tata Dynamic Bond Fund to 0.50 per cent if redeemed on or before 180 days. Currently, there is no exit load. The effective date is March 25, 2015. Best Tax Saver Mutual Funds or ELSS Mutual Funds for 2015 1. ICICI Prudential Tax Plan 2. Reliance Tax Saver (ELSS) Fund 3. HDFC TaxSaver 4. DSP BlackRock Tax Saver Fund 5. Religare Tax Plan 6. Franklin India TaxShield 7. Canara Robeco Equity Tax Saver 8. IDFC Tax Advantage (ELSS) Fund 9. Axis Tax Saver Fund 10. BNP Paribas Long Term Equity Fund You can invest Rs 1,50,000 and Save Tax under Section 80C by investing in Mutual Funds Invest in Tax Saver Mutual Funds Online - Invest Online Download Application Forms For further information contact Prajna Capital on 94 8300 8300 by leaving a missed call --------------------------------------------- Leave your comment with mail ID and we will answer them OR You can write to us at PrajnaCapital [at] Gmail [dot] Com OR Leave a missed...

Home Loans that Save Time and Money

Download Tax Saving Mutual Fund Application Forms Invest In Tax Saving Mutual Funds Online Buy Gold Mutual Funds Leave a missed Call on 94 8300 8300   Home Loans that Save Time and Money  You can deposit surplus money in these special home loan schemes and reduce your loan tenure significantly in the process   IF YOU are thinking of taking a home loan and are confident of generating a surplus every month after paying the regular EMI, you can opt for loan schemes with an overdraft facility that not only cut interest payments significantly, but also reduce the loan tenure. State Bank of India, Standard Chartered Bank, HSBC and Central Bank of India offer such home loan products. Under the scheme, as a home loan borrower, you can deposit any surplus that you have into the home loan account, though you retain the option of withdrawing the sum, if required. By depositing an amount higher than your EMI , you save on interest outgo. The principal amoun...

General insurance

  General insurance has evolved to become as important as life insurance. A look at some categories which can no longer be over-looked…    Insuring your belongings can help you cushion yourself against financial losses. While life insurance takes care of your loved ones, it is equally important to safeguard your treasured possessions. Here's a quick look at the 'must-haves' under general insurance…     Travel insurance Accidents can happen anytime – worse if they happen when you are in a foreign land. You may get sick and meeting your medical bills in a foreign currency can be quite frustrating! Besides, there may be other tricky situations such as accidents, loss of baggage or passport, trip cancellation, flight delays, plane hijack, etc. Whether you travel for leisure, business or studies, travel insurance comes handy to safeguard your trip against contingencies and that too, at a fraction of the cost of your trip.     Home insurance For most of us, the home is the...
Related Posts Plugin for WordPress, Blogger...
Invest in Tax Saving Mutual Funds Download Any Applications
Transact Mutual Funds Online Invest Online
Buy Gold Mutual Funds Invest Now