Why Brokerage Charges Matter in XIRR (And Why Most Calculators Get It Wrong)

When you calculate your investment returns, are you accounting for every rupee that left your account? Most investors focus only on the money they invested and the current value of their holdings. But there's a hidden cost that quietly eats into your returns: brokerage charges and transaction fees.

The Hidden Costs in Every Trade

Every time you buy or sell a stock, mutual fund, or any other security, your broker deducts several charges:

• Brokerage — ₹0 for equity delivery at Zerodha; ₹20 flat per executed order for intraday and F&O
• STT (Securities Transaction Tax) — 0.1% on both buy and sell for delivery; 0.025% on sell side for intraday
• Exchange charges — NSE charges ~0.00322% on delivery trades
• GST — 18% on brokerage + exchange charges
• SEBI charges — ₹10 per crore traded
• Stamp duty — 0.015% on the buy side for delivery

Zerodha's ₹0 delivery brokerage is real — but it only removes one line item. STT, exchange charges, SEBI fees, GST, and stamp duty still apply on every delivery trade.

A Real Example

Let's say you bought ₹1,00,000 worth of stocks on delivery at Zerodha:

What most calculators assume:

• Investment: ₹1,00,000
• Current Value: ₹1,20,000
• "Returns": 20%

Reality (what your ledger shows):

• Money debited from account: ₹1,00,187
  • Stock purchase: ₹1,00,000
  • Brokerage: ₹0 (delivery is free)
  • STT (buy side): ₹100
  • Exchange charges: ₹32
  • SEBI charges: ₹1
  • GST on exchange charges: ₹6
  • Stamp duty: ₹15
  • Other charges: ₹33

When you sell at ₹1,20,000, you'll pay STT again (₹120) plus exchange charges and GST on the sell side. Your actual profit isn't ₹20,000 — it's closer to ₹19,600. That's 2% lower returns than what a holdings-based calculator shows.

Why Manual XIRR Calculators Miss This

Most XIRR calculators ask you to input:

1. Amount invested
2. Date of investment
3. Current value

But they miss the crucial detail: the actual cash flow from your bank account. When you manually enter "₹1,00,000 invested," you're ignoring the ₹187 that disappeared in STT, exchange charges, SEBI fees, GST, and stamp duty.

The Compounding Effect

These charges might seem small, but they add up:

• 50 delivery trades in a year with ₹150 average charges = ₹7,500 in fees
• Over 5 years = ₹37,500 in hidden costs
• For a ₹10 lakh portfolio, that's a 3.75% drag on your returns — and that's without any intraday or F&O activity

And here's the kicker: the more frequently you trade, the bigger the impact. Day traders and F&O traders can see their actual returns cut in half by transaction costs.

What Your Ledger Tells You

Your broker's ledger is a complete record of every single rupee that entered or left your trading account:

Money IN:

• Bank transfers to broker account

Money OUT:

• Bank withdrawals from broker account
• Every purchase (including all charges)
• Every sale (net of all charges)
• DP charges
• Annual maintenance charges
• GST on services

Your ledger doesn't care about "invested amount" or "current holdings." It only cares about one thing: actual cash flow. And that's exactly what XIRR is supposed to measure.

The Ledger-Based Difference

When you calculate XIRR from your ledger:

1. Every charge is automatically included - No need to manually track or calculate fees
2. Actual cash flows - You use the exact amounts debited/credited to your account
3. Nothing is missed - DP charges, AMC, even interest credits are all captured
4. True returns - You see exactly how much money you're making after ALL costs

Example: Same Portfolio, Different Returns

Manual XIRR calculation:

• Invested: ₹5,00,000 (your Excel entry)
• Current Value: ₹6,50,000
• XIRR: ~12.5%

Ledger-based XIRR:

• Total debits from bank: ₹5,00,000
• Total purchases (with charges): ₹5,02,350
• Current holdings: ₹6,50,000
• Net account value: ₹6,47,650
• XIRR: ~11.8%

That's a 0.7% difference—and this is just one example. The gap widens with more frequent trading.

Why This Matters More Than You Think

For Long-Term Investors

Even if you're a buy-and-hold investor, those entry and exit charges matter. A 0.5% difference in returns might not sound like much, but over 20 years, that's a significant amount of money.

For Active Traders

If you're trading regularly, brokerage charges can be your biggest enemy. You might think you're making 15% returns, but your ledger might show you're actually making 8%. That's the difference between beating the market and underperforming it.

For F&O Traders

F&O trading has higher brokerage charges and STT (especially on options at expiry). Many F&O traders are shocked when they calculate their actual returns from the ledger—they're often negative even when they "made money" on individual trades.

The Bottom Line

Your broker's ledger is the single source of truth for your returns. It captures:

• ✅ Every rupee you transferred in
• ✅ Every rupee you withdrew
• ✅ Every charge, fee, and tax
• ✅ Every transaction, including failed ones
• ✅ Interest credits (if any)
• ✅ Dividend credits
• ✅ Corporate action adjustments

When you calculate XIRR from your ledger, you get your true, after-cost returns. No guesswork, no estimates, no missing charges.

Ready to See Your Real Returns?

Don't let brokerage charges hide in the shadows. Upload your broker ledger and discover what you're actually earning after all costs.

Your returns might be lower than you think—but at least you'll know the truth.