Why Your XIRR Doesn't Match App Numbers

😤 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.

Calculate My True XIRR →