How to Track Your Mutual Fund Portfolio in India (Without Giving Broker Access)
If you have been investing in Indian mutual funds for a few years, your portfolio probably looks like a jigsaw puzzle.
You might have started a tax-saving ELSS fund on one platform, moved to a discount broker for direct plans later, and perhaps have older investments done through a bank distributor. The result? You have three different logins, three different apps, and no single place that tells you exactly how much wealth you actually have.
The problem isn't just inconvenience; it's a lack of clarity. When you can't see your entire mutual fund portfolio in one view, you struggle to understand your true asset allocation or whether your returns are actually beating inflation.
Most investors try to solve this by installing yet another app that asks for their email password to "automatically sync" everything. This is a privacy nightmare.
There is a better way. This guide explains how to track your investments effectively, accurately, and privately.
Why the Old Methods Are Failing You
Before fixing the problem, let’s look at why standard tracking methods often fall short for serious retail investors.
1. Broker Apps
Your broker app is excellent for executing trades, but it often makes for a terrible portfolio tracker. Why? Because they only show you what you bought through them. If you hold units in a different folio or changed brokers, that data is invisible. They want you to move everything to them, but switching brokers purely for a dashboard view is often unnecessary work and tax-inefficient.
2. Spreadsheets (Excel / Google Sheets)
The DIY investor loves a good spreadsheet. It offers infinite flexibility and total privacy. However, it requires immense discipline. You must manually update NAVs, record every SIP installment, and adjust for dividends or stock splits. One missed entry can skew your returns for years. Over time, maintaining a spreadsheet becomes a chore, and your data becomes stale.
3. Manual Notes
Some investors simply check their email statements and write down the final value. This gives you a "current value" but tells you nothing about performance. Knowing you have ₹10 Lakhs is good; knowing whether that ₹10 Lakhs grew at 6% or 16% is what actually matters for your financial goals.
The Verification Gold Standard: CAS Statements
Ideally, you want a source of truth that is independent of any broker. In India, this exists in the form of the Consolidated Account Statement (CAS).
The CAS is a single document that lists every mutual fund unit held against your PAN, regardless of which broker or AMC you used. It is issued by the Registrar and Transfer Agents (RTAs) like CAMS and KFintech.
Why is CAS reliable?
- It is comprehensive: It covers all equity and debt schemes across all AMCs.
- It is official: The data comes directly from the backend systems that manage mutual fund records.
- It is standardized: The format is widely recognized, making it perfect for parsing.
By using your CAS, you bypass the need to log into five different portals. You simply have one file that contains your entire financial history.
Understanding Returns: Why XIRR Matters More Than CAGR
Once you have your data, the next challenge is calculating returns. A common mistake is using CAGR (Compound Annual Growth Rate) for SIPs.
CAGR works well for a fixed deposit or a one-time lump sum investment. You invest once, wait five years, and calculate the growth. However, SIPs involve multiple cash flows at different times. Your money from last month hasn't had the same time to grow as your money from five years ago.
This is where XIRR (Extended Internal Rate of Return) comes in. XIRR calculates the annual return identifying the exact date of every single cash inflow and outflow. It is the only accurate way to measure SIP performance.
Example: If you verify your returns on a simple calculator, you might think you made 12%. But an XIRR calculator for mutual funds might show 10.5% because a bulk of your money was invested recently and hasn't compounded yet. Tracking XIRR prevents you from having a false sense of security.
The Privacy Trap: Read-Only vs. Broker Access
Many "free" portfolio tracking apps solve the data aggregation problem by asking for your broker login credentials or permission to read your emails. They scrape your data to build your dashboard.
You should be skeptical of this model. Giving an app write-access (the ability to execute trades) or full email access is a significant security risk. Furthermore, if the product is free, your aggregate financial data is likely the product being sold to lenders or insurance companies.
The Safe Alternative: Read-Only Parsing
The safest way to use a third-party tracker is through read-only data ingestion. This usually involves uploading your CAS PDF. The application reads the file, extracts the numbers, and deletes the file. It never touches your broker account, never asks for your email password, and cannot move your money.
A Modern Approach to Tracking
This need for privacy and accuracy is exactly why we built Arthavi. We realized that smart investors wanted analytics without the privacy trade-offs.
Arthavi works on a simple premise:
- You download your CAS from CAMS/KFintech (we don't even ask you to login).
- You upload the PDF to Arthavi.
- We parse the file securely to construct your portfolio transaction history.
- You get an institutional-grade dashboard with XIRR, asset allocation, and goal tracking.
Because we use the CAS file, we don't need your broker password. We are a read-only platform, which aligns with robust security practices for personal finance.
Common Tracking Mistakes to Avoid
Even with the right tools, keep these nuances in mind:
- Ignoring Dividends: If you are in a dividend payout plan, that cash hitting your bank account is part of your return. ignoring it makes your fund look like it's underperforming.
- Mixing Goals: Don't track your retirement corpus and your car-purchase fund in the same bucket. Returns should be weighed against the specific time horizon of the goal.
- Obsessing Over Daily NAV: Mutual funds are long-term vehicles. Checking your portfolio tracker daily is a recipe for anxiety, not wealth. Monthly reviews are sufficient.
Conclusion
Tracking your mutual fund portfolio shouldn't require compromising your privacy or juggling multiple apps. By centering your tracking around the Consolidated Account Statement (CAS) and focusing on XIRR rather than simple absolute returns, you gain a truthful picture of your financial health.
Your next step is simple: Download your latest CAS, verify your holdings, and ensure you have a single, unified view of your net worth that you—and only you—control.