How to Track Mutual Fund Portfolio Performance Across AMCs
Five AMC apps and one spreadsheet is not a system. Here is how to consolidate mutual fund holdings and measure what matters.
Why mutual fund tracking gets messy fast
Indian investors often hold funds across HDFC, ICICI, SBI, Nippon, and platform feeders like Groww or Coin — each with separate logins, folio numbers, and statement formats. SIPs run on multiple dates. ELSS lock-ins overlap with open-ended debt funds. Without consolidation, you never see true allocation or performance.
AMC apps show their funds well but not your full picture. A flexi-cap fund here and a small-cap fund there may both be equity bets — duplicating risk you thought you diversified away.
Learning how to track mutual fund portfolio performance centrally is the first step toward rebalancing, tax planning, and honest return measurement across your entire mutual fund book.
What to track beyond current NAV
Current value is table stakes. Serious tracking includes: total invested versus market value (absolute gain), XIRR for SIP books, category allocation (equity large cap, mid cap, debt, hybrid), expense ratio drag across funds, and SIP continuity status.
Track corporate actions: mergers of schemes, name changes, and IDCW (dividend) payouts affect cost basis. Ignoring IDCW taken as cash understates withdrawals in return math.
Goal linkage matters. Tag each folio to a goal — retirement, home, education — so performance conversations stay anchored to time horizon, not weekly NAV noise.
Methods to consolidate mutual fund holdings
Method 1 — CAS (Consolidated Account Statement) from MFCentral or CAMS/KFintech: download periodic statements listing across registrars. Good for verification; manual import still required for live tracking.
Method 2 — Platform aggregators (Groww, Kuvera, etc.): convenient if all investments flow through one platform; incomplete if you hold direct AMC folios from older accounts.
Method 3 — Portfolio tracker with import: Capitallytics accepts CSV/Excel exports and broker PDFs, normalizes holdings, and refreshes values alongside stocks, gold, and crypto — one dashboard for total net worth.
Method 4 — Spreadsheets: fine for 2–3 funds; error-prone beyond that. NAV lookups, multiple SIP dates, and registrar splits make maintenance costly.
Step-by-step: set up unified mutual fund tracking
Step 1 — Gather latest statements from each AMC or registrar. Note folio numbers, ISIN, units, and average cost if shown.
Step 2 — Export or download transaction history for active SIPs — start dates matter for return calculations and ELSS lock-in clocks.
Step 3 — Import into Capitallytics via CSV/Excel or statement upload. Review parsed rows before confirming — scheme names vary between sources.
Step 4 — Categorize each fund (equity, debt, hybrid, international feeder) for allocation charts. Capitallytics asset typing supports mutual funds alongside direct equity.
Step 5 — Schedule monthly review: NAV change, SIP debit success, drift versus equity/debt targets, and upcoming ELSS unlock dates.
Tracking SIPs vs lump-sum purchases
SIPs produce staggered cost basis — average purchase NAV evolves monthly. Displaying only current NAV gain on the first installment misleads; use XIRR or platform-calculated annualized returns for SIP books.
Lump-sum tranches should be logged with separate purchase dates. Bonus-driven January investments perform differently from Diwali bonus entries in October — dating matters.
Capitallytics SIP calculator helps project future corpus for planning; live portfolio tracking shows actual NAV performance against those projections. Compare quarterly to adjust contributions thoughtfully.
Key metrics table for mutual fund investors
Metric | Why it matters — Current value & units: baseline visibility | detect stale or missing folios. Total invested: anchor for gain calculations | reconcile with bank debits. Absolute gain / loss: goal progress | emotional reality check. XIRR: fair performance for SIPs | compare funds and advisors. Category allocation: true diversification | avoid duplicate equity exposure. Expense ratio: long-term drag | prefer consistent net performance.
Review metrics monthly; act on allocation or SIP changes quarterly unless life events intervene.
ELSS, debt, and international feeders
ELSS funds carry three-year lock-in per installment. Tracking unlock dates prevents surprise liquidity crunches. Tag ELSS lots separately from open-ended debt allocations.
Debt funds behave differently from equity — lower volatility, taxation nuances, and sensitivity to interest rate cycles. Bucketing them as "safe" without checking credit risk and duration is a common mistake.
International feeder funds add currency and timezone lag. Confirm whether you track INR report card or underlying global index — both are valid if labeled consistently.
Common mutual fund tracking mistakes
Mistake 1 — Trusting a single AMC app for total allocation. You see their pie chart, not your household pie chart.
Mistake 2 — Ignoring idle cash in savings while celebrating fund NAV highs. Opportunity cost is part of portfolio truth.
Mistake 3 — Chasing last year's top performer and tracking 12 overlapping equity schemes. Consolidation reduces clutter and cost.
Mistake 4 — Not recording SWP or redemption transactions — XIRR and allocation both break silently.
Mistake 5 — Reviewing NAV daily but never reviewing category mix quarterly. Behavior follows what you measure.
Integrating mutual funds with stocks and other assets
Most wealth-building households hold mutual funds plus direct stocks, PPF, gold, and increasingly US equities. Siloed tracking obscures equity exposure — 40% in large-cap funds plus 30% in Nifty ETFs is 70% large-cap risk.
Capitallytics net worth tracker mindset applies: mutual funds are one sleeve in a total allocation policy. Rebalancing decisions happen at total portfolio level, not per app.
Use the investment dashboard to see cross-asset performance and the AI portfolio tracker tier for deeper analytics when books grow complex.
Tax and compliance awareness (India)
Tracking supports tax reporting — capital gains statements from registrars at year-end should match your transaction log. Discrepancies trigger avoidable notice risk.
IDCW versus growth plans affect cash flow tracking. Switching plans mid-holding creates reconciliation work — document switches with dates.
Consult a qualified tax professional for personal liability. Educational tracking is not tax advice; accuracy of records is still your responsibility.
Authoritative external sources: AMFI India investor guides, MFCentral FAQ, and SEBI investor education pages for regulatory context.
How often to review mutual fund portfolio
Monthly: confirm SIP debits, update any new purchases, scan allocation drift.
Quarterly: compare fund XIRR to category benchmarks, check for duplicate mandates, rebalance using new flows where possible.
Annually: deeper review — fund mandate changes, manager updates, expense ratio shifts, and whether each fund still matches its goal slot.
Avoid daily reaction to NAV. Mutual funds are long-horizon vehicles; measurement frequency should not exceed decision frequency.
When to replace a fund — tracking signals
Persistent underperformance versus category benchmark over 3+ years after fees may warrant replacement — not one bad quarter.
Strategy drift: a fund increasing small-cap exposure beyond its stated mandate changes your risk without consent.
Operational issues: frequent mandate changes, mergers, or extreme AUM swings deserve scrutiny.
Document why you switch — future you will want rationale if the replacement also struggles.
Actionable tips for cleaner mutual fund visibility
Consolidate all folios into one tracker within a weekend — Capitallytics import cuts setup time.
Align SIP dates where possible to simplify bank reconciliation.
Cap equity scheme count — many investors need fewer, not more, funds.
Pair mutual fund tracking with SIP calculator projections for forward planning.
Archive annual CAS PDFs; verify against tracker each March.
Conclusion
Knowing how to track mutual fund portfolio performance across AMCs is foundational for disciplined investing. Consolidation, correct return metrics, and category-level allocation views turn scattered folios into a strategy you can maintain for decades.
Capitallytics gives Indian and global investors one place to track mutual funds alongside stocks, crypto, and gold — with import tools, live NAV-based values, and analytics that scale as your book grows. Set up free tracking this week and retire the fifth spreadsheet tab.
Explore Capitallytics' free portfolio tracker and investment analytics — the practical way to monitor SIPs, NAV returns, and total allocation without juggling multiple AMC logins.
Track your portfolio like a pro
Free portfolio tracker with live NSE/BSE prices, analytics, and AI market briefs.