Your Broker Has a Document That Reveals Your Real Returns. It's Not the P&L.

You've seen the number. Zerodha console, Holdings page: Unrealised P&L: +₹1,23,000. It feels like the full picture.

It isn't. That number only knows about stocks you currently hold. It doesn't know that ₹80,000 sat in your account for 4 months earning nothing before you deployed it. It doesn't know about the ₹12,000 you paid in STT and exchange charges this year. It doesn't know when money actually left your bank.

Your broker has a document that knows all of this. It's called the ledger. Most investors have never downloaded it.

What the Ledger Actually Is

Think of it as a bank passbook — but for your broker account.

Every time money moves in or out, it gets recorded as a line item with a date, a description, and a debit or credit amount:

• Fund transfers in — every time you added money from your bank
• Fund transfers out — every time you withdrew
• Trade settlements — cash moves out when you buy, in when you sell
• Brokerage and STT charges — deducted on every trade, silently
• Dividend credits — when a company pays, it lands here first
• Interest credits — some brokers pay interest on idle funds above a threshold

Every rupee. Accounted for. In order.

What the P&L Hides That the Ledger Reveals

The P&L statement tells you: You bought Infosys at ₹1,400, sold at ₹1,800, made ₹400 per share — 28% gain. Feels complete.

It isn't. The P&L only tracks the stocks you traded. It has no idea:

• That you transferred ₹2L to your broker in January and only deployed ₹1.2L by March
• That ₹80,000 sat in your account earning zero for 60 days
• That you paid ₹4,200 in STT and brokerage this year
• That ₹3,100 in dividends arrived and were never reinvested

The ledger knows all of this. The P&L knows none of it.

A Real Example: What the Ledger Actually Shows

You transferred ₹5,00,000 to Zerodha on 1 April 2024. Markets looked uncertain — you invested ₹3,00,000 immediately and left ₹2,00,000 sitting in the account. Four months later, in August, you deployed the rest.

By March 2025, your portfolio is worth ₹5,70,000. You've paid ₹8,400 in charges over the year.

What your P&L shows:

Invested ₹5,00,000 → Current value ₹5,70,000 → Return: 14%

What your ledger-based XIRR shows:

₹5,00,000 transferred on 1 April. ₹2,00,000 sat idle for 120 days. ₹8,400 in charges reduced your net gain. True annualised return: 9.8%

That 4.2 percentage point gap is real. It only appears when you look at the ledger.

Five Things Only Your Ledger Tells You

1. The True Start Date of Your Investment

Your investment didn't start when you clicked Buy. It started the moment you transferred money from your bank. From that day, you gave up 3–4% bank interest in exchange for the opportunity to earn more in the market.

The ledger records that transfer date. No other document does.

2. Every Rupee You've Paid in Charges

Brokerage, STT, exchange charges, GST, SEBI fees — deducted silently on every trade. A moderately active investor can pay ₹15,000–₹40,000 a year without noticing. The ledger lists every deduction. Your P&L shows them as a footnote, or not at all.

3. How Long Your Money Sat Idle

Idle cash in a broker account earns nothing. Every day ₹1,00,000 sits in Zerodha instead of your savings account costs roughly ₹11 in lost interest (at 4% p.a.). Over a year of intermittent investing, this quietly costs 1–2% of total returns. The ledger is the only place you can see and measure it.

4. All Your Dividends — Reinvested or Forgotten

When a company pays you a dividend, it lands in your broker account. If you don't withdraw it or reinvest it, it sits as idle cash. The ledger shows every dividend credit with the date — you can see exactly how many times income arrived and was never put to work.

5. The Complete Picture Across Years

Every other broker document resets annually or shows a snapshot. Your ledger is cumulative — it shows the full history of every rupee since you opened the account. That's the only way to calculate an honest long-term XIRR.

Why the Ledger Is the Only Input That Gives You True XIRR

XIRR needs two things for each cash flow: the exact amount and the exact date.

• Transferring ₹1,00,000 to your broker = real cash outflow, specific date
• Withdrawing ₹50,000 = real cash inflow, specific date
• Your portfolio's current value = the final inflow (hypothetical liquidation today)

The ledger contains every one of these cash flows — exact amounts, exact dates. No other document does. Not the P&L. Not the portfolio summary. Not your contract notes.

This is why XIRR Ledger uses your broker's ledger file rather than asking you to enter trade history manually. The ledger is the ground truth. Everything else is a summary.

How to Download Your Ledger

Zerodha

Console → Funds → Statement → All Segments → set date range from your first investment → Download XLSX. If the Opening Balance shows 0, your date range is correct.

Groww

App → Profile → Reports → Groww Balance Statement → set date range → Download PDF. Password is your PAN (e.g. ABCDE1234F).

Fyers

Fyers One → Reports → Ledger → select financial year → Generate → Download CSV. Repeat for each year if needed.

The Most Important Way to Think About It

Every other document your broker provides — P&L, portfolio summary, holdings report — is their interpretation of your trades. The ledger is their receipt to you. The raw, unfiltered record of what happened to your money.

Ignoring your ledger is like running a business and never looking at your bank statement. You might feel profitable. You might be wrong.

The ledger doesn't lie. It just shows numbers most investors find uncomfortable — idle cash they forgot, charges they didn't track, returns that are lower than the number they've been telling themselves.

And that discomfort, when you act on it, is what separates a serious investor from one who just thinks they are.

---

See what your ledger reveals about your real returns. Calculate your true XIRR →

Want to see a sample report before uploading? Download Sample Report →