Plan Your Finances

The More You Learn, The More You Earn

  • Facebook
  • LinkedIn
  • RSS
  • Twitter
  • Home
  • Investment
  • Insurance
  • Taxes
  • Bank
  • General
  • Contact
  • Disclaimer
  • Privacy Policy
Home » Taxes » Income Tax » How to Convert Form 26AS Text file to Excel File?

How to Convert Form 26AS Text file to Excel File?

Sanyam Jain | Income Tax/ Taxes | April 20, 2019 | Leave a Comment

What is Form 26AS?

Form 26AS is a consolidated Tax Credit Statement issued under rule 31 AB of Income Tax Rules of India to PAN Holders. It shows the amount of Tax Deducted (TDS) from your income and is available as a credit against your tax liability if any.

Let’s say you have a fixed deposit of ₹40 lakhs with Bank of Baroda @ 8% p.a. Bank paid interest of ₹ 72,000  (₹ 80,000- ₹ 8,000) after deducting TDS of ₹ 8,000 under section 194A for the period of 3 months i.e. from April to June and then bank filed TDS return in July. Now after filing TDS return by the bank, a tax credit of  ₹ 8,000 will get reflected in your respective Form 26AS.

In case your tax credit is not reflected correctly in your Form 26AS, verify you PAN numbers and ask the deductor to file the TDS statement/correct statement at TIN Facilitation centers.

Form 26AS contains details of:

  • Tax deducted and collected on behalf of taxpayers.
  • Advance tax/self-assessment tax/regular assessment tax etc deposited by taxpayers (PAN holders)
  • Payment of refund during the financial year.
  • High-value transactions in respect of shares, mutual funds, etc.

Read Fill Form 15G and Form 15H to Avoid TDS on Interest Income

How to View Form 26AS Online?

Option 1:

  • Register for viewing Form 26AS by registering for e-filing on https://incometaxindiaefiling.gov.in/. Registration is immediate, without any cost and does not obligate e-filing,
  • After logging in click on My Account tab
  • There will be an option View Your Tax Credit Statement (Form 26AS)
  • It will take you to DOB verification page
  • In the next step, it will ask your permission to be redirected to the NSDL site where you have to press the confirm button
  • You will be re-directed to your Form 26AS and you can select the assessment year in the top right corner for which you want to see the details.

Please remember that Assessment year is one year ahead of the financial year. For example for FY 2018 – 19, the Assessment Year is 2019 –20

Option 2: Through net banking facility of 19 authorized banks. Login to your net banking account and check if this facility is provided.

Option 3: Through registration with NSDL.

How to Convert 26AS Text file to Excel File?

First of all, open the download text file by putting Date of Birth provided in PAN database in the ddmmyyyy format as password.

Now open the text file in notepad and follow the steps below:

How to Convert 26AS Text file to Excel File How to Convert 26AS Text file to Excel File How to Convert 26AS Text file to Excel File

After clicking on “Finish” Button, the next screen would be:

LikeTweetLinkedInEmailPrint

Sanyam Jain

PlanYourFinances.In is started by Sanyam, a commerce student who loves to share his knowledge and believes in “Sharing is Caring”.

Connect With Me : FacebookTwitterLinkedIn

Related Posts

  • Instant PAN Card FacilityGet Instant PAN Card for Free Online through Aadhaar
  • Company Fixed Deposits Rules and RisksCompany Fixed Deposits Risks and Rules to know before Investing
  • Tax Exemption on Life Insurance Policy under Section 10(10D)Tax Exemption on Life Insurance Policy under Section 10(10D)
  • Form 16 and Form 16AForm 16 and Form 16A Means and Difference
  • Save TDS on Fixed DepositHow to Save TDS on Fixed Deposit Interest?
  • tips for investing in Fixed DepositThings to Know before Investing in Fixed Deposits

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Get more stuff

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

we respect your privacy and take protecting it seriously




  • Popular
  • Recent
  • Comments

    © Copyright 2021 Plan Your Finances

    Share this ArticleLike this article? Email it to a friend!

    Email sent!