USStockTax_sample_Schedule_CG_FY2025-26.csv
Schedule CG (ITR-2), capital gains on foreign shares, FY 2025–26| # | Ticker | Qty | Buy date | Buy $ | Buy rate | Buy ₹ | Sell date | Sell $ | Sell rate | Sell ₹ | Days | Type | Gain ₹ | Rupee part ₹ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | VOO | 5 | 15/1/2025 | 545.00 | 86.40 | 2,35,440.00 | 7/4/2025 | 465.00 | 85.60 | 1,99,020.00 | 82 | STCG | -36,420.00 | -2,180.00 |
| 2 | AAPL | 100 | 10/3/2023 | 120.00 | 82.10 | 9,85,200.00 | 14/6/2025 | 150.00 | 85.60 | 12,84,000.00 | 827 | LTCG | 2,98,800.00 | 42,000.00 |
| 3 | MSFT | 10 | 12/2/2025 | 410.00 | 86.70 | 3,55,470.00 | 18/9/2025 | 510.00 | 88.10 | 4,49,310.00 | 218 | STCG | 93,840.00 | 5,740.00 |
| 4 | NVDA | 25 | 6/6/2023 | 44.00 | 82.40 | 90,640.00 | 20/11/2025 | 180.00 | 88.40 | 3,97,800.00 | 898 | LTCG | 3,07,160.00 | 6,600.00 |
| Total short-term (taxed at your slab rate) | 57,420.00 | |||||||||||||
| Total long-term (section 112, 12.5%) | 6,05,960.00 | |||||||||||||
Opens in Excel, Google Sheets or your CA's software. One row per sale with the date and exchange rate used, so each figure can be checked. Example portfolio; exchange rates are illustrative.