Investing through SIP is not a set-it-and-forget-it-forever strategy. While the monthly investment itself should be automated and untouched, your portfolio deserves a thorough annual review to ensure it is still on track to meet your financial goals. Year-end is the ideal time for this audit — it gives you a full calendar year of data to analyse and enough time to make adjustments before the new financial year. Here is a step-by-step framework for conducting your annual mutual fund portfolio review.
Step 1: Get Your Consolidated Account Statement (CAS)
Your first step is obtaining a CAS from CAMS or KFintech. This single document contains every mutual fund investment across all AMCs linked to your PAN. Visit camsonline.com or kfintech.com and request a CAS by entering your email. You can also get it from MFCentral. The CAS shows every SIP transaction, switches, redemptions, current holdings, and the folio numbers. This is your single source of truth for the entire review process.
Request a Detailed CAS (not summary) that includes transaction history. This is essential for accurate XIRR calculation. You can also request CAS for a specific date range, such as January to December, to align with the calendar year review.
Step 2: Calculate Your XIRR (True Returns)
XIRR (Extended Internal Rate of Return) is the only accurate way to measure SIP returns because it accounts for the timing and amount of every cash flow — each monthly SIP, additional lump sums, and withdrawals. Simple return calculations or CAGR are misleading for SIP portfolios because they do not account for irregular cash flows. Most portfolio tracking apps like Kuvera, Value Research, and Groww calculate XIRR automatically. You can also compute it in Excel or Google Sheets using the XIRR function.
How to Interpret Your XIRR
| XIRR Range | Assessment | Action |
|---|---|---|
| Above 15% | Excellent — outperforming most benchmarks | Continue as is, review fund overlap |
| 12-15% | Good — in line with long-term equity averages | Monitor, no changes needed |
| 8-12% | Below average — underperforming equity benchmarks | Deep dive into individual fund performance |
| Below 8% | Poor — significant underperformance | Consider fund switches or allocation changes |
Step 3: Benchmark Comparison
Every mutual fund has a benchmark index that it aims to outperform. Large-cap funds benchmark against Nifty 50 or BSE 100. Mid-cap funds against Nifty Midcap 150. Flexi-cap funds against BSE 500 or Nifty 500. Compare each of your funds' 1-year, 3-year, and 5-year returns against their respective benchmarks. A fund that consistently underperforms its benchmark over 3+ years is a candidate for replacement. However, avoid knee-jerk reactions based on a single bad year.
- Compare rolling 3-year returns rather than point-to-point returns for more reliable assessment
- Check if the fund is in the top 2 quartiles of its category — bottom quartile for 3 consecutive years is a red flag
- For index funds, check tracking error — it should be below 0.5 percent annually
- Factor in expense ratio differences when comparing returns with the benchmark
- Remember that benchmark comparison is relevant only for actively managed funds, not index funds
Step 4: Fund Overlap Analysis
If you hold multiple equity funds, there is a high probability of portfolio overlap — the same stocks appearing in multiple funds. Holding three large-cap funds often means 60-70 percent of the same stocks repeated across all three, giving you the illusion of diversification without the actual benefit. Use free tools like Value Research Portfolio Overlap or Primeinvestor to check the overlap percentage between your funds.
| Overlap Percentage | Assessment | Action |
|---|---|---|
| Below 30% | Low overlap — genuine diversification | No action needed |
| 30-50% | Moderate overlap — some redundancy | Review if both funds are necessary |
| 50-70% | High overlap — significant redundancy | Consider consolidating into fewer funds |
| Above 70% | Very high — virtually the same portfolio | Exit one fund and redirect SIP to the other |
Step 5: Rebalancing Triggers
Rebalancing means bringing your portfolio back to its target asset allocation. If your target is 70 percent equity and 30 percent debt, a strong equity rally may push your actual allocation to 80:20. Conversely, a market crash may take it to 60:40. Rebalancing forces you to sell high (trimming the overweight asset) and buy low (adding to the underweight asset). It is the only systematic way to lock in gains and manage risk.
- Rebalance if your actual allocation deviates more than 5 percentage points from target in either direction
- Use new SIP flows or lump sums to rebalance rather than redeeming (to avoid tax events)
- Consider the tax implications before rebalancing — redeeming equity before 1 year triggers 20% STCG tax
- Rebalance annually at a fixed date (year-end works well) rather than trying to time it
- For multi-goal portfolios, rebalance each goal bucket independently
Step 6: When to Exit a Fund
Exiting a fund is a significant decision that should be based on objective criteria, not emotional reactions to short-term underperformance. Valid reasons to exit include consistent underperformance versus benchmark and category peers for 3+ years, a change in fund manager with no track record of the new manager, a fundamental change in the fund's investment strategy or style, the fund's category no longer aligns with your goal (for example, you no longer need aggressive growth), and merger or scheme changes that alter the fund's character.
Do NOT exit a fund simply because it had a bad quarter or even a bad year. Equity fund performance is cyclical — value funds underperform during growth rallies, mid-caps lag in risk-off periods, and even the best fund managers have off years. Check the 3-year and 5-year rolling return consistency before making any exit decisions.
Portfolio Health Indicators: Your Annual Checklist
| Health Indicator | Healthy Range | Your Status | Action If Unhealthy |
|---|---|---|---|
| Number of Funds | 4-7 funds | Check your portfolio | Consolidate if more than 8 |
| Portfolio XIRR (3+ year) | Above 12% | Calculate from CAS | Review underperformers |
| Equity:Debt Ratio | Within 5% of target | Compare to your plan | Rebalance via SIP allocation |
| Fund Overlap | Below 40% | Use overlap tool | Merge similar category funds |
| Expense Ratio (Weighted) | Below 1% | Check fund factsheets | Switch to direct plans if in regular |
| SIP Step-Up Done | Yes, annually | Did you increase this year? | Increase SIP by 10% minimum |
An annual portfolio review is like a health check-up for your wealth. You may feel fine without it, but regular monitoring catches problems early when they are easy to fix. Spend 2-3 hours once a year on this review — it can add lakhs to your final corpus over your investment lifetime.
Year-end review action items: (1) Download CAS from CAMS. (2) Calculate XIRR for each fund and overall portfolio. (3) Compare against benchmarks. (4) Run overlap analysis. (5) Check if asset allocation needs rebalancing. (6) Set up SIP step-up for the new year. (7) Verify nominee details are updated in all folios. Complete these seven steps and you are set for the new year.