Before You Begin
- Your HDFC Securities login credentials (Customer ID + password)
- Financial Year: April 2025 – March 2026 (FY 2025-26)
Step-by-Step Download Instructions
- Go to hdfcsec.com and log in to your account.
- Click on My Portfolio in the top navigation, then navigate to Reports.
- Under Reports, select Capital Gains Statement (also labeled as Tax P&L in some views).
- Set the date range: 01-Apr-2025 to 31-Mar-2026.
- Click Generate, then click the Download Excel button to save the file.
What's in the Report
The HDFC Securities Capital Gains report covers:
- Equity delivery buy-sell lots with FIFO-matched holding period and realized P&L
- F&O contract-wise settlement P&L
- Intraday trade summary (speculative income — must be reported separately from capital gains)
- Charges: brokerage, STT, exchange transaction charges, stamp duty, and GST
Note: For clients with mutual funds held via HDFC SKY or direct AMC investments, download the CAMS or KFintech statement separately — those are not included in this report.
Upload to FirstReports
Once you have the file, upload it to FirstReports. The platform auto-detects the HDFC Securities export format, parses every row, and merges the data with reports from your client's other brokers — producing one consolidated STCG / LTCG / F&O statement ready for ITR filing.