How to Calculate XIRR Free and in a Few Seconds
Stop wrestling with Excel formulas. Here's the fastest way to calculate your accurate XIRR for free — just upload your broker ledger and get the result in seconds.
Most investors either skip calculating XIRR entirely, or spend an hour in Excel and still get a number that's off. Neither is good.
There's a faster way — and it's free.
XIRR Ledger calculates your true investment return from your actual broker ledger in seconds. No Excel, no formulas, no manual data entry. Just upload and go.
Here's exactly how to do it.
Quick Answer: Go to xirrledger.com/calculator, sign in, upload your broker ledger (Zerodha, Groww, or Fyers), and your accurate XIRR is calculated instantly — including all charges, idle cash, and a Nifty 50 benchmark. It's free and takes under a minute.
Why "Free in Seconds" Is Actually Possible
The calculation itself — the XIRR formula — is not complex. The hard part is getting the right data into it.
Most people try to track individual stock trades. That approach misses every rupee you paid in STT, brokerage, exchange charges, SEBI fees, stamp duty, and GST. The result looks right but runs 0.5–1.5% higher than your actual return.
The correct input is your broker's fund statement — the ledger that records every actual cash flow in and out of your account, with all charges already reflected.
XIRR Ledger reads that file directly. You don't build a spreadsheet. You just upload the file you already have.
Step 1: Download Your Broker Ledger
This is the only thing you need to gather. Takes 2–3 minutes.
Zerodha
- Log in to console.zerodha.com
- Go to Reports → Fund Statement
- Set segment to All Segments, pick your date range (start from when you first deposited funds)
- Click Download CSV
Groww
- Log in to groww.in
- Go to Profile → Reports → Transactions
- Select all time, choose Download
- Use the P&L / ledger statement (PDF or CSV depending on account type)
Fyers
- Log in to fyers.in
- Go to My Account → Reports → Ledger
- Set date range from your first deposit to today
- Download as CSV
If you have multiple broker accounts, download a ledger from each. XIRR Ledger handles all of them together — you don't need to merge anything yourself.
Step 2: Go to the Calculator
Open xirrledger.com/calculator.
No app download. No installation. It works in your browser.
Step 3: Sign In
Sign in with Google (one click) or with your email address.
If you use email, you'll receive a 6-digit OTP to verify — takes about 15 seconds.
Your files are processed securely. Your ledger data is never stored permanently or shared.
Step 4: Upload Your Ledger
Once signed in, you'll see the upload screen.
- Drag and drop your downloaded ledger file, or click to browse
- If you have multiple accounts, upload all the files — one per broker
- Supported formats: CSV (Zerodha, Fyers) and PDF (Groww)
XIRR Ledger automatically identifies which broker the file is from and parses it accordingly.
Step 5: Get Your Accurate XIRR
That's it. Within a few seconds, you'll see:
- Your XIRR — your annualised return, net of all charges, across all uploaded accounts
- Nifty 50 XIRR — what you would have earned if you had invested the same amounts on the same dates into the index
- The gap — whether you beat the market or underperformed it, on a true apples-to-apples basis
- A PDF report — emailed to you, ready to save or share
The Nifty 50 comparison accounts for when your money entered the market. If you invested ₹50,000 in January and another ₹2L in November, the benchmark uses those exact dates and amounts. It's not a simple annual return comparison — it's a fair one.
What Makes This More Accurate Than Other Methods
| What gets included | Excel (stock trades) | Excel (ledger) | XIRR Ledger |
|---|---|---|---|
| STT, brokerage, GST, charges | ❌ Missed | ✅ Included | ✅ Included |
| Idle cash periods | ❌ Ignored | ✅ Included | ✅ Included |
| Multiple broker accounts | ❌ Manual merge | ⚠️ Painful | ✅ Automatic |
| Nifty 50 benchmark | ❌ Not included | ❌ Not included | ✅ Cash-flow matched |
| Time to calculate | 60–90 min | 30–45 min | Under 1 minute |
The key difference: XIRR Ledger uses your fund statement, not your trade history. Your fund statement already has all charges deducted — so the XIRR it produces reflects your real, net return without any extra work from you.
Common Questions
Is it really free?
Yes. No credit card, no trial period, no hidden plan. Upload your ledger and get your XIRR.
What if I have both Zerodha and Groww?
Upload both ledgers in the same session. XIRR Ledger merges the cash flows and gives you one combined XIRR across both accounts.
What if I have mutual funds and stocks in the same account?
That's fine — it's all in your broker ledger. XIRR Ledger reads the full statement as-is.
How long does the calculation take?
Usually 5–15 seconds after upload, depending on how many years of data your ledger contains.
Which brokers are supported?
Currently Zerodha, Groww, and Fyers. More brokers are being added.
Try It Now
If you've been putting off calculating your XIRR because it seemed complicated — this is your sign that it isn't.
Download your ledger, upload it, and see your real returns in under a minute.
Disclaimer: This article is for informational purposes only and does not constitute financial, investment, tax, or legal advice. Past returns do not indicate future performance. Please consult a qualified financial advisor before making investment decisions.
Ready to Calculate Your True XIRR?
Upload your ledger and get accurate returns in minutes