Exporting Capital Gain (Tax P&L) Data from Zerodha

1. Log in to your Zerodha account.
   
2. Click on the Reports tab.
   

1. Choose the Tax P&L option from the reports menu.
   

1. Choose the financial year for which you want the data.
   
2. Select the appropriate quarter range for the report.
   

1. Click on the arrow button to display the segment-wise capital gains report.
   
2. Scroll down and click on Download Tax P&L report for all segments to download the complete report.
   

      

Important Note: Intraday transactions (where the holding period is 0) are excluded from the capital gains section during the import of the Zerodha Excel template.

These transactions are segregated and categorized under the 'Business & Profession Income' head.

      

Importing Capital Gain Data via Zerodha Excel Template

1. In your tax software, go to the Transaction section and select Capital Gain.
   

      

1. Select the appropriate head, such as Shares or Mutual Funds based on your data.
   
2. From the Excel Import drop-down menu, choose Zerodha as the template type.
   

      

1. Click the button to import data from Excel.
   

      

1. When prompted, confirm with "Yes" and locate your Zerodha Excel file on your computer.
   

      

1. Open the Excel file and allow the software to process and import the data.
   
2. Wait for the process to complete.
   

      

Important Notes

1. Correct Head Selection: Ensure you select the proper head (e.g., Shares or Mutual Funds) that matches the data in the Excel file.
2. Error Handling: If you select the wrong head, you may encounter an error message. Double-check your selection to avoid such errors.