Groww Capital Gains Report: How to Download and Read Every Column

Q: Does Groww already split LTCG, STCG and Intraday for me?

Yes. The detail rows are grouped into three sections — Intraday trades, Short Term trades (holding ≤ 12 months) and Long Term trades (holding > 12 months) — using the same column layout. The summary block at the top of the sheet aggregates each section's P&L. You can use those totals directly for ITR Schedule CG.

Q: Does the Capital Gains Report include F&O trades?

No. The Capital Gains Report is named "Stocks Capital Gains Report" for a reason — it covers equity delivery and equity intraday only. If you trade Futures or Options on Groww, you need to download the F&O Tax P&L separately from the same Reports menu. The Groww parser in VriddhiQ currently supports equity only; F&O support is planned but not yet shipped.

Q: Are charges already deducted from the Realised P&L column?

No. The per-row Realised P&L equals Sell Value minus Buy Value — it does not subtract brokerage, exchange charges, STT, GST or DP charges. Those are shown only in aggregate in the Charges block at the top of the sheet. For ITR purposes, capital gains under Sec 48 deduct only brokerage and exchange charges as cost of transfer; STT-on-delivery is NOT allowable.

Q: Why doesn't Groww show the FMV as on 31-Jan-2018?

Groww's Capital Gains Report does not include the Sec 112A grandfathering FMV column that some other brokers (Kotak, AngelOne) show. For shares acquired before 1-Feb-2018, you must look up the FMV (highest traded price on NSE/BSE on 31-Jan-2018) separately and use the higher of actual cost or that FMV — capped at the sale consideration — for your LTCG calculation. The Buy Value column shows actual cost only.

If you invest through Groww and want to file your own ITR, the Capital Gains Report is the file you need for equity gains. Groww does something useful: the detail rows are already grouped into three sections — Intraday, Short Term and Long Term — using identical column layouts. The summary block at the top of the sheet pre-computes each section's P&L.

There is one important limitation worth knowing up front: this report covers stocks only. Futures, options and other segments are in a separate Tax P&L report. If you trade F&O on Groww, you'll need both files at ITR time. This guide focuses on the Capital Gains Report — the equity slice.

Reading time: ~9 minutes. Skip to the column reference or the gotchas if you already have the file open.

Your ITR numbers in 60 seconds

Open the file and look at the Summary block (rows 5–28 of the only sheet). Groww pre-computes the figures you need:

Summary field	Where it goes in ITR
Realised P&L — Intraday P&L	Schedule BP — Speculative Business Income
Realised P&L — Short Term P&L	Schedule CG Sec 111A (STCG)
Realised P&L — Long Term P&L	Schedule 112A (LTCG)
Turnover — Intraday	Sec 44AB threshold check (speculative)
Charges — Total	Info only — see Gotcha #2
Others — Dividends	Income from Other Sources
Others — Buyback P&L	See Gotcha #5

For most equity-only investors, the three Realised P&L lines are sufficient — these match the totals you'll get if you sum the Realised P&L column inside each of the three detail sections below.

Caveat: the per-trade Realised P&L is gross of charges. Charges aren't shown per row anywhere in this file. See Gotcha #2.

How to download your Groww Capital Gains Report

Open the Groww app or log in at groww.in.
Tap Profile (top-right) → Reports → Capital Gains.
Select the financial year (for FY 2025-26 returns, choose FY 2025-26).
Tap Download — you receive a single .xlsx file named Stocks_Capital_Gains_Report_<dates>.xlsx.

The file is small (typically 15–30 KB) because Groww uses one sheet and no per-trade charge breakdown. If you trade F&O too, you'll separately need the F&O Tax P&L Report from the same Reports menu.

What's in the file

A single sheet named "Sheet1" with four distinct regions:

Region	Rows (approximate)	Contents
Header	0–3	Client name, code, statement period
Summary	5–28	Charges, realised P&L per holding-period bucket, turnover, dividends, buyback
Realised trades — Intraday	32–N	Same-day equity trades
Realised trades — Short Term	N–M	Equity sold within 12 months of purchase
Realised trades — Long Term	M–P	Equity sold after 12 months of purchase
Realised trades — Buyback	P+	Usually empty — see Gotcha #5
Disclaimer	Last	Standard broker disclosure

Each of the four trade sections uses the same 11-column layout described next.

Column-by-column reference

Realised trades — common 11-column layout

This layout is identical across Intraday trades, Short Term trades, Long Term trades, and Buyback trades.

Column	What it is	ITR usage
Stock name	Company name as held in Groww	Identification (use ISIN for canonical match)
ISIN	International Securities ID	Required for Schedule 112A
Quantity	Shares sold in this lot	Quantity
Buy date	FIFO-matched purchase date (DD-MM-YYYY)	Date of acquisition
Buy price	Avg buy price per share	Cost per unit
Buy value	Qty × Buy price	Raw cost basis
Sell date	Date of sale (DD-MM-YYYY)	Date of transfer
Sell price	Avg sell price per share	Sale per unit
Sell value	Qty × Sell price	Full value of consideration
Realised P&L	Sell value − Buy value (gross — no charges deducted)	Pre-charge gain — see Gotcha #2
Remark	Notes (usually blank, occasionally bonus / split / IPO)	Verify cost basis if non-blank

Dates are in DD-MM-YYYY format, not the more common DD/MM/YYYY or YYYY-MM-DD — minor detail but worth noting if you're parsing the file yourself.

The Short Term section captures equity sold within 12 months of purchase. The Long Term section captures equity sold after 12 months. Groww does the holding-period classification for you — verify only if a trade is right at the 12-month boundary.

Import your Groww report into VriddhiQ

VriddhiQ reads the Groww Capital Gains Report directly — FIFO lot matching, STCG/LTCG already classified by Groww, ISIN-based symbol resolution. F&O parser is not yet shipped for Groww (planned).

Import your Groww report free

Summary block — Charges section (info only)

The Charges section at the top of the sheet lists each charge line annually:

Charge	What it is	Tax treatment
Exchange Transaction Charges	NSE / BSE transaction fees	Allowable as cost of transfer (Sec 48)
SEBI Charges	SEBI turnover fee	Allowable
STT	Securities Transaction Tax	Not allowable for equity delivery; allowable for intraday and F&O as business expense
Stamp Duty	State stamp duty on trades	Allowable (recently centralised by SEBI)
IPFT Charges	Investor Protection Fund Trust charges	Allowable (small amount)
Brokerage	Groww's brokerage	Allowable as cost of transfer
DP Charges	Depository Participant charges (for delivery sells)	Allowable
Total GST	GST on brokerage + exchange charges	Allowable
Total	Sum of all the above	—

These totals are annual aggregates across all your trades. The report does not distribute them per trade. For ITR Schedule CG, you generally don't add a separate charges deduction at the row level — the broker has already computed gains gross of charges, and you handle deductions through the choice of cost basis and the small allowable items above.

For Intraday (speculative business), charges including STT are fully deductible from speculative business income — but again, you'd allocate them against the intraday section only.

Five Groww-specific gotchas

1. Equity only — F&O lives in a separate report

The file is named "Stocks Capital Gains Report" because it covers equity delivery + equity intraday. It does not include:

Futures (index / stock / commodity)
Options (call / put / index / commodity)
Currency derivatives
Mutual fund redemptions (separate MF capital gains statement)

If you trade F&O on Groww, download the F&O Tax P&L Report separately from the same Reports menu. You'll need both files at ITR time.

VriddhiQ-specific note: the Groww parser in VriddhiQ currently supports the Capital Gains Report only (equity intraday + STCG + LTCG). F&O parser for Groww is on the roadmap but not yet shipped. If you have F&O trades on Groww, you can either wait for parser support or enter them manually.

2. Realised P&L is gross — charges are only in the summary

This is the single biggest pitfall of the Groww report. Each detail row shows:

Realised P&L = Sell Value − Buy Value

No brokerage, no STT, no GST, no DP charges are subtracted. If you sum the Realised P&L column across all rows in a section, you'll get the pre-charge gross gain — which matches what goes into ITR Schedule CG (Sec 48 allows specific cost-of-transfer deductions, not a blanket charges netting).

For intraday (speculative business income), you can claim all charges including STT as business expense — but that's a Schedule BP deduction, not a row-level adjustment to the P&L number.

For delivery (capital gains under Sec 48), STT-on-delivery is not deductible as cost of transfer. Brokerage and exchange charges are allowed but they're already part of how Groww would adjust cost basis if at all — read the next gotcha for what Groww does and doesn't compute.

What this means in practice: copy the Realised P&L totals from the Summary block straight into Schedule CG. Don't try to net charges against equity capital gains row-by-row.

3. No FMV-Jan-2018 column for pre-2018 holdings

For shares acquired before 1-Feb-2018, LTCG under Sec 112A grandfathering is calculated on the higher of the actual purchase cost or the FMV (highest traded price) on 31-Jan-2018 — capped at the sale consideration. This is the same rule applied across all brokers.

Unlike Kotak (which has explicit FMV-Jan-2018 columns) or AngelOne (which adjusts Cost Of Acquisition in-place), Groww shows only the actual Buy Value. If you hold pre-Feb-2018 shares being sold this year, you have to:

Identify which rows have a Buy date before 1-Feb-2018
Look up the FMV-Jan-2018 (NSE bhavcopy or any historical-price database)
Use max(actual cost, FMV-Jan-2018) — capped at the sale value — as the cost in your LTCG calculation
Manually adjust the Long Term P&L total before filing

For ITR Schedule 112A you'll enter both: actual cost, FMV-Jan-2018, and the sale value — the ITR utility handles the grandfathering math, but only if you supply all three values. The Buy date column in the Groww report tells you which rows need this treatment.

4. DP Charges are real money — and are a delivery-only line

Groww charges DP (Depository Participant) fees on every delivery sell, not on intraday trades. They appear as a separate line in the Summary block (DP Charges), and they are not negligible — typically ₹13.5–₹20 per sell transaction.

For ITR Schedule CG, DP charges count as cost of transfer (Sec 48) — they're allowable. But because Groww shows them only in aggregate, you can't allocate them per row. The cleanest approach: leave the row-level Realised P&L as Groww calculates it, and recognise that DP charges are a small drag on actual realised gains that doesn't appear in the tax calculation.

If you want to allocate DP charges per delivery sell for an internal audit (not for ITR), divide the total DP charge by the number of delivery sells — Groww's DP charge is a flat per-transaction fee, so this gives a reasonable per-row allocation.

5. Buyback trades section — Budget 2024 changed the rules

The Buyback trades section is typically empty for most users, but if you participated in a company buyback during the year, it will be populated.

Important — buyback taxation changed mid-2024:

Before 1 Oct 2024: company paid buyback tax; shareholder received the proceeds tax-free. The transaction looked like a normal sale on the broker's books with a P&L number that was effectively cosmetic.
From 1 Oct 2024 onwards (Finance Act 2024): buyback proceeds are taxed as deemed dividend in the shareholder's hands at slab rates. The original cost of the bought-back shares is treated as a capital loss that can be carried forward.

For FY 2025-26, the new regime applies to all buybacks. The Buyback trades section in the Groww report may not reflect this split correctly — verify with your CA whether the rows shown should be treated as:

Dividend income (the full proceeds) under Income from Other Sources, plus
A capital loss equal to the original cost, set off against other capital gains.

This is one of the few places where you should not trust the Groww classification at face value. Cross-check against the company's buyback documentation (price, record date, shares accepted).

Frequently asked questions

Q: Where do I download my Groww Capital Gains Report? A: In the Groww app or at groww.in, open the menu → Reports → Capital Gains. Select the financial year and download. You get a single Excel file covering stocks only — F&O is a separate report.

Q: Does Groww already split LTCG, STCG and Intraday for me? A: Yes. Detail rows are grouped into three sections — Intraday, Short Term (≤ 12 months) and Long Term (> 12 months) — using the same column layout. The Summary block at the top aggregates each section's P&L.

Q: Does the Capital Gains Report include F&O trades? A: No — equity only. For Futures and Options, download the F&O Tax P&L Report separately from the same Reports menu. The Groww parser in VriddhiQ currently supports equity only; F&O parser support is planned.

Q: Are charges already deducted from the Realised P&L column? A: No. The per-row Realised P&L is gross — equal to Sell Value minus Buy Value. Charges (brokerage, STT, GST, DP fees, stamp duty) are shown only in aggregate in the Summary block. For ITR purposes, Sec 48 deducts only brokerage and exchange charges as cost of transfer; STT-on-delivery is not allowable.

Q: Why doesn't Groww show the FMV as on 31-Jan-2018? A: Groww's Capital Gains Report doesn't include the grandfathering FMV column that Kotak and AngelOne show. For pre-Feb-2018 holdings, you must look up the FMV separately (NSE bhavcopy) and use the higher of actual cost or that FMV — capped at the sale consideration — for LTCG.