Import capital gain data via Excel template

Income Tax || Import capital gain data via Excel template

Step 1: Navigate to the Transaction section and select "Capital Gain".

      

Step 2: Choose the special Excel sheet made for Capital Gain from the options.

      

Step 3: Fill in all the info about your capital gains into the Excel sheet.

      

Step 4: Click the button to bring in data from Excel and say "Yes" when asked if you want to find your Excel file.

      

Step 5: Find your Excel file on your computer and open it up.

      

Step 6: Wait for the program to finish bringing in the data.

      

Note: Ensure to select the correct head of capital gain (Share/mutual fund) according to the data entered in Excel before importing.
If you don't adhere to these instructions, you may encounter an error message: 

      

So, please ensure that data is imported according to the correct head of capital gain.

    • Related Articles

    • Income Tax || Data Feeding - Capital Gain

      What is Capital Gains Tax in India: Capital Gains Tax is a tax on the profit or gain that an individual or a business entity earns from the sale of capital assets. The capital assets can include property, stocks, bonds, gold, or any other asset. The ...

    • Income Tax || Capital Gain Excel Import → Syntax Error

      Root Cause of the Error → The error occurs when a client enters a special character (') in the Capital Gain Excel template. Solution → Open the Capital Gain Excel template intended for import into the software. Identify and remove any instances of ...

    • Zen IT || Excel Import → Type Mismatch, Error in excel import

      Root Cause of the Error: The error stems from either erroneous data entry in the Excel sheet or alterations to the format of the specific Excel file. Solution → Validate Date Format: Verify that dates adhere strictly to the format "dd/MM/yyyy". ...

    • Zen IT || AIS Import Process

      What is the Annual Information Statement (AIS) ? The Annual Information Statement (AIS) serves as a comprehensive snapshot of a taxpayer's information as displayed in Form 26AS. Taxpayers are afforded the opportunity to furnish feedback regarding the ...

    • Income Tax || Section 54 Exemption for Capital Gain

      SECTION 54 EXEMPTION FOR CAPITAL GAINS A person wanted to shift his residence due to certain reason, hence, he sold his old house and from the sale proceeds he purchased another house. In this case the objective of the seller was not to earn income ...