Dividends Are Part of Your Returns — Most XIRR Calculators Ignore Them

If you've ever held dividend-paying stocks, you've earned real income from your investments. But if you've checked your XIRR on most portfolio tools, that income probably isn't reflected anywhere in the number.

Most XIRR calculators silently ignore dividends — not by design flaw, but because of where dividends go. xirrledger lets you fix this by uploading your Zerodha dividend report.

Person adding to savings — dividends and passive income from investments counted in XIRR

Quick Answer: Dividends and SGB interest must be treated as positive cash inflows on the exact date they were credited in order for XIRR to reflect total return. Most XIRR tools miss them because dividends are paid directly into your bank account — bypassing the broker ledger entirely — so the broker's fund statement never records them. For a diversified large-cap portfolio, this omission understates real XIRR by 1–2% annually. XIRR Ledger handles this by letting you upload your Zerodha dividend report separately; each payment is added as an inflow on its exact date and merged with your ledger cash flows before the calculation runs.

Why Dividends Are Missing From Most XIRR Calculations

When a company declares a dividend, the money lands directly in your bank account — not your broker account. Your broker's fund statement (the ledger that most XIRR tools read) only tracks money moving in and out of your broker account.

Dividends bypass the broker entirely. So most calculators — including Zerodha's own XIRR figure — never count them.

This isn't a minor rounding error. If you hold a diversified portfolio of large-cap stocks, dividends can add 1–2% annually to your real returns. Over 5–10 years, that gap between "XIRR including dividends" and "XIRR excluding dividends" compounds into a meaningful difference.

What Dividends Actually Are in XIRR Terms

XIRR treats every cash flow as either an outflow or an inflow:

Outflow — money you put in (negative). Every deposit, every SIP, every transfer to your broker.
Inflow — money you get back (positive). Withdrawals, and your current portfolio value as the final inflow.

Dividends received in your bank are inflows — money your investments generated and paid back to you. For your XIRR to reflect true portfolio performance, each dividend payment needs to be recorded as a positive cash flow on the date it was received.

Without them, your XIRR is calculated as if that income never existed. You did better than the number shows.

A Concrete Example

Say you hold 500 shares of a stock paying ₹8/share annually.

What your broker ledger captures:

Nothing. ₹4,000 went straight to your bank.

What a correct XIRR calculation should include:

[Dividend received]  18-Jul-2024  +₹4,000  (inflow)
[Dividend received]  22-Jul-2025  +₹4,000  (inflow)

Without these entries, your XIRR treats these years as if your money sat idle earning nothing — even though it paid you ₹8,000 over two years.

How xirrledger Handles This

xirrledger reads your Zerodha fund statement to calculate your base XIRR. But it also lets you upload your Zerodha dividend report — the separate statement Zerodha provides listing every dividend you've received, with amounts and dates.

When you upload it:

Each dividend entry is read as a positive inflow on the exact date it was paid.
These inflows are merged with your fund statement cash flows.
Your XIRR is recalculated on the complete picture — deposits, withdrawals, current value, and dividend income.

The result is a more accurate XIRR that reflects what your investments actually returned, not just what moved through your broker account.

How to Get Your Dividend Report From Zerodha

Log in to console.zerodha.com
Go to Reports → Downloads
Select Dividend statement, choose the financial year, and click Download
Upload this .xlsx file alongside your fund statement in the xirrledger calculator — one file per financial year if you want multiple years

The dividends are automatically matched to your Zerodha account by client ID and included as inflows in your XIRR.

Why This Matters More Than You Think

Most investors mentally separate "portfolio performance" (price returns) from "dividend income" (cash in bank). But in reality, both come from the same invested capital. XIRR is designed to measure total return — and total return means everything your capital generated, including dividends.

If your goal is to know whether you're beating an index like Nifty 50, you need to compare like-for-like. Nifty 50 Total Return Index (TRI) includes dividends reinvested. If your XIRR doesn't include dividends, you're comparing an incomplete number to a complete benchmark — and you'll always look worse than you actually are.

Upload your Zerodha dividend report and see your real XIRR. Calculate Now →