Import Capital Gain Data Using the Broker Template

ExpressITR || Steps to Import Capital Gain Data Using the Broker Template

Importing Capital Gain Data Using Broker Template

The Broker Template feature in Express ITR enables the structured and accurate import of Capital Gain data. Transactions imported through this functionality are automatically classified under the appropriate income heads, including Capital Gains and Business or Profession Income, wherever applicable.
This feature ensures standardized data formatting, minimizes manual intervention, reduces the risk of errors, and enhances overall efficiency in return preparation.

Step 1: Access Client Profile
  1. Log in to the Express ITR application.
  2. Select the required client from the Client List.
  3. Navigate to the ITR Summary section.
  4. Click on Return Flow to proceed.


Step 2: Navigate to Capital Gain Section
  1. Click on the Capital Gain tab.



  2. The Capital Gain data entry screen will be displayed.
Step 3: Initiate Import Process
  1. Click on the Import CG Statement option.


  2. The import interface will open for data upload.



Step 4: Import Capital Gain Data
Users can import data using any of the following methods:
Idea
Method A: Import via Broker Credentials
Enter the required details based on the respective broker:
  1. Zerodha / Groww – User ID and Password




  2. Upstox – Registered Mobile Number



  3. Angel One – Registered Mobile Number or Client ID



  4. Kotak Securities – Upload broker file using drag-and-drop


Upon successful authentication, the system will automatically fetch and import the Capital Gain data.

Idea
Method B: CAMS / KFINTECH Mailback Statement
CAMS and KFINTECH provide a facility to generate a consolidated account statement (Mailback Statement) for mutual fund investments.
Steps to Import:
  1. Request the consolidated statement using the registered email ID.




  2. Download the password-protected Excel file received via email.
  3. Unprotect the file using the password defined at the time of request.
    Quote
    Important:  The password required is the Excel sheet unprotect password set during the request process. It is not the broker login password.
  4. Upload the unprotected file using the Browse File option in the application.



Idea
Method C: Upload Broker Template File (Recommended)
  1. Select and upload the predefined Broker Template Excel file.





Key Advantages:
  1. Ensures uniform data structure
  2. Enables accurate classification of transactions
  3. Facilitates automatic population of Capital Gain records
The system will process and populate the data automatically upon successful upload.

Step 5: Validate and Complete Import
  1. Click on the Import button after selecting the file.




  2. Review the confirmation message and click OK.



Output
Upon successful import, the data will be reflected under:
  1. Capital Gains
  2. Business or Profession Income (where applicable)
This confirms that all broker transactions have been successfully imported and appropriately classified.

Conclusion
The Broker Template feature provides a reliable and efficient method for importing Capital Gain data into Express ITR. It improves data accuracy, reduces manual effort, and streamlines the overall return preparation process.

    • Related Articles

    • Express ITR || Steps to Import Capital Gain Data Using Excel

      Steps to Import Capital Gain Data Using Excel Step 1: Access the Client Profile Open the client’s profile in the Express ITR application. Navigate to the ITR Summary section within the profile. Click the button under Return Flow to open the relevant ...

    • Income Tax || Export and Import Capital Gain Data via Zerodha Excel Template

      Steps to Export and Import Capital Gain Data via Zerodha Excel Template Exporting Capital Gain (Tax P&L) Data from Zerodha Step 1: Access the Tax P&L Section Log in to your Zerodha account. Click on the Reports tab. Step 2: Select Tax P&L Choose the ...

    • ExpressITR || Capital Gain Data Feeding Process

      Follow these steps to efficiently input capital gain data for a client in the Express ITR application: Step 1: Access the Client Profile Open the client’s profile and navigate to the ITR Summary section within the profile. Click the button under ...

    • Express ITR || Steps to Export Capital Gain Data in Excel

      Steps to Export Capital Gain Data in Excel Step 1: Access the ITR Summary Open the client’s profile in the Express ITR application. Navigate to the ITR Summary section within the client profile. Click the button under Return Flow to view additional ...

    • Income Tax || Import capital gain data via KDK 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 ...