### 😤 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 →](/content/site-root.html)