Coinbase Employee RSU Tax Loss Harvesting: COIN Down 49% from Peak — Rs 5.5 Lakh in Indian Losses

Coinbase (COIN) is the canonical crypto-correlated stock — it moves with Bitcoin and Ethereum more than with any traditional software sector benchmark. The company listed via direct listing in April 2021 at $381, peaked briefly at $429 within days, and then tracked the crypto market's wild swings: down 90% to $40 during the FTX crisis of November 2022, then recovering to approximately $220 by 2026 as crypto markets stabilised.

This creates an unusual RSU situation for Coinbase India employees: unlike companies where all pre-2024 lots are underwater, Coinbase has both significant loss lots (2021, early 2022 vests) and significant gain lots (late 2022, 2023 vests when COIN was $40-100). Strategic lot selection — selling only the right lots — is what separates an optimised tax outcome from a careless one.

Coinbase has India engineering and product teams, primarily in the context of Coinbase's international expansion and blockchain development. This case study follows Meera, a Senior Product Manager at Coinbase's remote India team.

---

Meera's Profile

• Role: Senior Product Manager, Coinbase (remote, Bengaluru)
• Joined Coinbase: September 2021
• RSU grant: 400 COIN shares over 4 years, quarterly vesting
• Current platform: E*TRADE at Work (Morgan Stanley at Work)
• Current COIN price: $220
• INR/USD rate: Rs 84

---

Lot Inventory

After 30% sell-to-cover for TDS, Meera holds 195 net shares:

Lot	Vest date	Net shares	Vest FMV	Cost basis (INR/sh)	Current (INR/sh)	P&L (INR)	Type
L-1	Dec 2021	17	$335	Rs 24,780	Rs 18,480	−Rs 1,07,100	LTCL
L-2	Mar 2022	17	$300	Rs 22,200	Rs 18,480	−Rs 63,240	LTCL
L-3	Jun 2022	17	$72	Rs 6,048	Rs 18,480	+Rs 2,11,344	LTCG
L-4	Sep 2022	17	$58	Rs 4,872	Rs 18,480	+Rs 2,31,336	LTCG
L-5	Dec 2022	17	$42	Rs 3,528	Rs 18,480	+Rs 2,54,184	LTCG
L-6	Mar 2023	17	$68	Rs 5,712	Rs 18,480	+Rs 2,17,056	LTCG
L-7	Jun 2023	17	$85	Rs 7,140	Rs 18,480	+Rs 1,92,780	LTCG
L-8	Sep 2023	17	$80	Rs 6,720	Rs 18,480	+Rs 2,00,160	LTCG
L-9	Dec 2023	17	$155	Rs 13,020	Rs 18,480	+Rs 92,820	LTCG
L-10	Mar 2024	17	$225	Rs 18,900	Rs 18,480	−Rs 7,140	LTCL
L-11	Jun 2024	14	$235	Rs 19,740	Rs 18,480	−Rs 17,640	STCL
L-12	Sep 2024	14	$185	Rs 15,540	Rs 18,480	+Rs 41,160	STCG

Harvestable losses:

• LTCL: Rs 1,77,480 (L-1, L-2, L-10)
• STCL: Rs 17,640 (L-11)

Significant gains (do not sell for harvesting):

• LTCG lots: L-3 through L-9 (aggregate unrealised LTCG: Rs 13,99,680)
• STCG: L-12 (Rs 41,160)

---

The Strategic Insight: What NOT to Sell Matters as Much as What to Sell

Unlike the Zoom or Twilio cases where every lot is a loss, Meera's portfolio has massive embedded gains in L-3 through L-9. These lots should not be touched in a harvesting exercise — selling them would trigger significant LTCG. The mistake a naive approach makes: selling the entire holding to "start fresh." The correct approach: sell only L-1, L-2, and L-10 (all losses), harvest those losses, and leave the gain lots untouched.

This distinction is why lot-specific identification matters for Coinbase employees — and why a platform that shows average cost basis (rather than individual lot basis) leads to poor decisions.

---

FY 2025-26 Capital Gains

Meera's other capital gains:

• LTCG from CSPX (S&P 500 UCITS ETF, sold after 3 years): Rs 1,80,000
• STCG from Indian equity fund (15 months): Rs 40,000

Tax without harvesting:

• LTCG Rs 1,80,000 at 12.5%: Rs 22,500
• STCG Rs 40,000 at 20%: Rs 8,000
• Total: Rs 30,500

---

Harvesting Plan: L-1 and L-2 (LTCL Lots)

To eliminate LTCG of Rs 1,80,000, Meera needs Rs 1,80,000 in LTCL. L-1 + L-2 together generate Rs 1,70,340 — almost enough. Adding L-10 (Rs 7,140 LTCL) gives Rs 1,77,480 total, leaving only Rs 2,520 in residual LTCG generating Rs 315 in tax.

Action	Lot	Shares	Sale proceeds	Cost basis	LTCL
Sell L-1	Dec 2021	17	Rs 3,14,160	Rs 4,21,260	Rs 1,07,100
Sell L-2	Mar 2022	17	Rs 3,14,160	Rs 3,77,400	Rs 63,240
Sell L-10	Mar 2024	17	Rs 3,14,160	Rs 3,21,300	Rs 7,140
Repurchase 51 COIN at $220		New basis: Rs 18,480/sh

Additionally: harvest L-11 (STCL Rs 17,640):

Action	Lot	Shares	Sale proceeds	Cost basis	STCL
Sell L-11	Jun 2024	14	Rs 2,58,720	Rs 2,76,360	Rs 17,640
Repurchase 14 COIN at $220		New basis: Rs 18,480/sh

Set-off:

Item	Amount	Type
CSPX LTCG	+Rs 1,80,000	LTCG
Indian equity MF STCG	+Rs 40,000	STCG
L-1 LTCL	−Rs 1,07,100	LTCL
L-2 LTCL	−Rs 63,240	LTCL
L-10 LTCL	−Rs 7,140	LTCL
L-11 STCL	−Rs 17,640	STCL

LTCL vs LTCG: Rs 1,77,480 against Rs 1,80,000 → residual LTCG Rs 2,520 → tax Rs 315.

STCL Rs 17,640 can offset STCG: Rs 40,000 − Rs 17,640 = Rs 22,360 taxable STCG → tax Rs 4,472 (at 20%).

Tax after harvest: Rs 4,787 Tax before harvest: Rs 30,500 Tax saved: Rs 25,713

---

The Coinbase-Specific Complication: Crypto Price Correlation

Meera's gain lots (L-3 through L-9) are large — Rs 13.99 lakh in aggregate unrealised LTCG. If she sells these in the future to rebalance:

• If COIN continues at $220: L-3 through L-9 generate Rs 13.99 lakh in LTCG when she eventually sells. At 12.5%, that is Rs 1,74,960 in future tax.
• After harvesting L-1, L-2, L-10, L-11: Meera has no significant LTCL carry-forward (the Rs 1,77,480 harvested was fully used). She will need other loss sources to offset the gain lots when she sells.

The multi-year strategy: If Meera expects to sell L-3 through L-9 gradually over 3-4 years, and if she has other UCITS ETF gains that generate annual LTCL opportunities, the Coinbase gain lots are manageable. The critical action in FY 2025-26: harvest the loss lots now (they won't get better if COIN appreciates further), and preserve the gain lots for strategic, gradual liquidation.

---

E*TRADE at Work: The Average Cost Problem

E*TRADE at Work allows Meera to see individual lot cost basis — but only in USD. The platform's default for gain/loss reports often shows average cost basis, which is precisely the wrong metric for strategic lot selection.

If Meera uses average cost basis:

• Average basis: Rs 12,042/share (sum of all cost bases ÷ 195 shares)
• At Rs 18,480 current price: every share appears profitable — Rs 6,438/share gain
• Total unrealised "gain" on 195 shares: Rs 12,55,410

This is accurate at the portfolio level but catastrophically misleading for tax planning. It obscures the Rs 1,77,480 in LTCL sitting in L-1, L-2, and L-10 — losses that are real, harvestable, and will expire in 8 years if unused.

Only lot-specific analysis reveals the harvest opportunity. Only Rovia performs this analysis in INR at vest-date RBI reference rates.

---

Rovia for Coinbase India Employees

Transfer: ACAT from E*TRADE at Work to Rovia. All 12 lots transfer in-kind in 5-10 business days.

Dashboard: Rovia separates the portfolio into loss lots (L-1, L-2, L-10, L-11) and gain lots (L-3 through L-9, L-12) in INR. Total harvestable losses and total embedded gains displayed separately — preventing the average-cost confusion that obscures the opportunity.

Strategy: "Minimise taxes" mode recommends selling L-1, L-2, L-10, and L-11 (the loss lots) while explicitly flagging L-3 through L-9 as "do not sell" due to large embedded gains.

Execute: Targeted lot sales only. Immediate repurchase of 65 COIN shares at $220 — position maintained at same size, cost basis reset on the loss lots.

ITR documents: Schedule CG worksheet shows per-lot entries for L-1, L-2, L-10 (LTCL), and L-11 (STCL). Carry-forward schedule shows nil LTCL (all absorbed) and nil STCL (partially absorbed, residual used). CA can file ITR-2 directly from this worksheet.

---

Summary for Coinbase India Employees

Metric	Value
COIN peak price	$429 (Apr 2021)
COIN current price	$220
Decline from peak	−49%
Meera's harvestable LTCL	Rs 1,77,480
Meera's harvestable STCL	Rs 17,640
Embedded LTCG in gain lots	Rs 13,99,680
Tax saved FY 2025-26	Rs 25,713
E*TRADE at Work average-cost trap	High risk for Coinbase employees
Rovia lot-specific INR analysis	Essential for this portfolio

Coinbase is different from the other companies in this series. The loss is real but modest; the gains are also real and large. The opportunity is not just about harvesting losses — it is about ensuring the loss lots are harvested before the carry-forward window closes, while the gain lots are preserved and eventually sold at LTCG rates after strategic planning. Rovia's lot-level INR view makes both sides of this equation visible for the first time.