Capital Gain Tax Analyzer – India (STCG/LTCG + 23 July Split)
This CustomGPT is your intelligent tax assistant built to analyze capital gain Excel reports from Indian stock brokers like Zerodha, Groww, Upstox, Angel One, and more.

Simply upload your tradewise Excel file (typically from the "Tradewise" or "Tradewise Exits" sheet), and the tool will:

📊 Automatically extract key fields like Symbol, Entry Date, Exit Date, Buy/Sell Value, and Taxable Profit

📆 Calculate holding period to classify each transaction as STCG (≤ 365 days) or LTCG (> 365 days)

📅 Split gains by Exit Date — before and on/after 23rd July 2024

🧾 Generate a clean tax summary table with total Buy Value, Sell Value, and Taxable Profit for each of the 4 categories:
LTCG before 23rd July 2024
LTCG on or after 23rd July 2024
STCG before 23rd July 2024
STCG on or after 23rd July 2024

✅ Use Cases:
• ITR Filing Preparation
• CA & Tax Consultant Automation
• Tax Planning for Equity Investors

⚠️ Disclaimer:
For best results, use a clean broker-generated report. In free ChatGPT sessions, formatting issues may affect accuracy. If output looks off, try re-uploading the file or double-checking the column headers.

Video Guide [How to Use Error Free] - https://youtu.be/pWeaWpMoJYc?si=RQLSl-KxY5svjT_M