Mutual Fund Holdings Lite

View all your mutual fund holdings in one place and on-demand refresh NAV to see latest valuation

Import Mutual Fund Central XLSX

Backup / Restore:
Holdings: 0
Transactions: 0
Mapped Codes: 0
NAV Snapshots: 0

Scheme Code Manager

Review and manually correct the MFAPI scheme code mapped to each holding. After updating, click Fetch NAV Snapshots on the Import tab to refresh valuations.

AMC Name Scheme Name (CAS) Scheme Code API Scheme Name Match Score Action

Reports

AMC Name Scheme Name Scheme Code Invested Value Units Latest NAV Current Value 1 Day NAV 1 Month NAV 1 Jan NAV 1 Year NAV vs 1D % vs 1M % vs 1 Jan % vs 1Y %

AMC Level Summary

AMC Name Invested Value Current Value Returns Returns % Schemes

AMC Distribution

Uses AMC filters from AMC Summary tab (text, gain/loss, top N).

Invested Value Distribution

Current Value Distribution

Return % Distribution

XIRR Report

XIRR from the first purchase in the CAS transaction sheet through today's market value (latest NAV × units). Dividend payouts are excluded. Run Import → Map Scheme Codes → Fetch NAV Snapshots first.

AMC Name Scheme Name Scheme Code First Purchase Last Tx Date Tx Count Invested (Flows) Redeemed (Flows) Current Value XIRR % Status

XLS vs Calculated Current Value

Compares the current value recorded in the imported CAS file against the value calculated from the latest NAV (MFAPI) × units. Run Import → Map Scheme Codes → Fetch NAV Snapshots first.

AMC Name Scheme Name Scheme Code Invested Value Units Current Value (XLS) Current Value (Calc) Difference Diff %

How to Use — MF Holdings App

Follow these steps to load your mutual fund portfolio and review current valuations.

  1. Download Transaction Details from Mutual Fund Central

    Log in to mfcentral.com and download your Consolidated Account Statement (CAS) as an XLSX file.

    • Go to Reports → Consolidated Account Statement
    • Select the date range and choose Detailed format
    • Download and save the .xlsx file to your computer
  2. Upload the File in the Import Tab

    Switch to the Import tab and upload the downloaded XLSX file.

    • Click Choose File next to CAS File and select your downloaded XLSX
    • Click Load Holdings to IndexedDB
    • You should see a confirmation like "Loaded 69 holding(s) into IndexedDB"
    • The Holdings counter at the bottom will update

    💡 Holdings are stored locally in your browser's IndexedDB — nothing is sent to any server.

  3. Map Scheme Codes

    Scheme names in your CAS file need to be matched to official MFAPI scheme codes to enable NAV lookups.

    • Click Map Scheme Codes on the Import tab
    • The app fetches all schemes from api.mfapi.in and matches each holding by name
    • Most schemes match automatically. Any Unmatched schemes will be shown in the error area
    • The Mapped Codes counter updates when complete

    ⚠️ If scheme codes look wrong (e.g., "Large Cap" matched to "Large & Mid Cap"), go to the Scheme Codes tab to fix them manually.

  4. Fetch NAV Snapshots

    Download the latest NAV history for each mapped scheme to compute current valuations and return percentages.

    • Click Fetch NAV Snapshots on the Import tab
    • The app fetches NAV history for each scheme from MFAPI (this may take 30–60 seconds for large portfolios)
    • For each scheme it captures: latest NAV, 1-day, 1-month, 1-Jan, and 1-year reference NAVs
    • The NAV Snapshots counter updates when complete

    💡 You can re-run Fetch NAV Snapshots any time to refresh prices with the latest available NAV.

  5. View Reports

    Switch to the Reports tab to explore your portfolio. Three report views are available:

    • Scheme Report — Per-scheme breakdown showing invested value, units, latest NAV, current value, and percentage changes vs 1 day / 1 month / 1 Jan / 1 year. Sortable and filterable columns.
    • AMC Summary — Aggregated view by fund house (AMC) with a bar chart. Filter by AMC name, gainers/losers, and top N.
    • AMC Distribution — Pie charts showing portfolio split by invested value, current value, and return % per AMC.
    • XLS vs Calc Comparison — Side-by-side comparison of the current value from your CAS file versus the value calculated from latest NAV × units. Useful for spotting valuation discrepancies.

    Each report shows a totals summary at the top with total invested value, total current value, total returns (₹ and %).

🔍 If Current Values Don't Match Between XLS and App

The XLS vs Calc Comparison report compares:

  • Current Value (XLS) — the value recorded in your downloaded CAS file at the time of export
  • Current Value (Calc) — recalculated as latest NAV × units using MFAPI data fetched today

A difference is expected and normal if NAV has moved between the CAS export date and today. However, a large mismatch (e.g., 50–300%) usually means the scheme code was mapped incorrectly.

How to Fix Wrong Scheme Code Mappings

  1. Go to the Scheme Codes tab
  2. Find the scheme with the mismatch
  3. Look up the correct scheme code on api.mfapi.in/mf — search for the scheme name and note the schemeCode
  4. Enter the correct code in the Scheme Code input for that row
  5. Click Apply — the system validates the code against MFAPI and saves it
  6. Go back to the Import tab and click Fetch NAV Snapshots to refresh the values
  7. Open the XLS vs Calc Comparison report and click Refresh Comparison to verify the delta is now close to zero

Common Mapping Mistakes

Problem Example Fix
Large Cap matched to Large & Mid Cap ABSL Large Cap Fund → ABSL Large & Mid Cap Fund Find the correct "Large Cap" code on MFAPI and apply it
Regular Plan matched to Direct Plan Nippon India Pharma Growth → Nippon Direct Bonus Look for the "Regular Plan – Growth Option" variant and apply it
Short Term fund matched to long-term Kotak Bond Short Term → Kotak Bond Fund Search "Kotak Bond Short Term" on MFAPI and apply the Growth code
Unclaimed IDCW / placeholder accounts ABSL Unclaimed IDCW (After 3 years) These are placeholder rows — no live NAV exists. Delta is expected

💾 Backup and Restore

Use the Export / Import IndexedDB Dump buttons on the Import tab to backup and restore all your data (holdings, scheme codes, NAV snapshots).

  • Export saves a .json file you can store locally as a backup
  • Import restores from that file — useful when switching browsers or devices
  • You don't need to re-run all import steps after restoring from a backup