😤 The Frustration
"I calculated my XIRR in Excel, but it's completely different from what my broker app shows. Which one is correct? Am I doing something wrong?"
— Every Indian investor at some point
If you've ever seen different XIRR values across different apps, calculators, or Excel — you're not crazy. There are legitimate reasons why this happens.
5 Reasons Your XIRR Doesn't Match
1️⃣ Different Data Sets
The #1 reason for mismatch. Are you comparing the same transactions?
- App may show portfolio-level XIRR (all stocks combined)
- Excel might have scheme-level XIRR (individual stock)
- Missing transactions: dividends, splits, bonus shares
- Different date ranges being compared
2️⃣ Current Value Mismatch
XIRR needs an "ending value" — but when was it captured?
- App shows real-time NAV/price
- Your calculation uses yesterday's closing price
- Even a 1-2% price difference changes XIRR significantly
3️⃣ Trade Date vs Settlement Date
In India, stocks settle T+1. Which date matters?
- Your tradebook may use trade date
- Some apps use settlement date (T+1)
- For long-term portfolios: minor impact
- For short-term trading: noticeable difference
4️⃣ Charges & Taxes Not Included
Are brokerage, STT, and SEBI charges factored in?
- Apps often show gross returns (before charges)
- True XIRR should include all costs
- Difference of 0.3-0.8% is common
5️⃣ Excel XIRR Guess Parameter
Excel's XIRR function takes a "guess" parameter that affects results.
- Default guess is 10%
- For extreme portfolios, wrong guess = wrong result
- Try different guesses: 0%, 50%, -50%
- If results vary wildly, your cash flows may have multiple solutions
Which XIRR Should You Trust?
✅ The Golden Rule
Trust the calculation where you can see every transaction with exact dates and amounts. If an app shows a number but won't show you the math, question it.
How TrueXIRR Solves This
- Complete transparency — See every transaction used in calculation
- Broker-specific parsing — Handles Zerodha, Groww, Angel One, Upstox formats
- Real-time + historical — Enter current value yourself for accuracy
- No hidden adjustments — What you upload is what we calculate
Get Your True XIRR
Stop wondering which number is right. Calculate XIRR from your actual tradebook with full transparency.