Mutual Fund CAS Analyzer (India): XIRR, Capital Gains, Allocation

About the Mutual Fund CAS Analyzer (India): XIRR, Capital Gains, Allocation

The Consolidated Account Statement (CAS) from CAMS or KFintech lists every purchase, SIP, switch and redemption in your mutual fund folios — but not your return, your capital gains or what a regular plan costs you. This tool reads the statement PDF in your browser (its password is typed here and used only to open the file) and works them out.

You get your holdings with the cost of the units still held, the XIRR of each scheme and of the whole portfolio, first-in, first-out capital gains for FY 2025-26 and Tax Year 2026-27 split the way the tax return asks — with the 31 January 2018 grandfathering for equity funds — the allocation by tax category, fund house and plan, and the yearly cost of regular plans against their direct plans.

Without a pass, the free preview shows the XIRR of your whole portfolio in full, with the first rows of each table; a Premium pass unlocks every figure and the allocation, and lets you download everything as an Excel workbook, or the gains lot by lot as CSV.

What the statement must be

Use the detailed CAS that CAMS or KFintech emails you as a PDF: it has every transaction. A summary statement has only holdings, so it gives no XIRR or gains. Ask for the period from your first investment: a statement that starts with units already held has no record of what they cost, and that scheme’s gains and XIRR cannot be worked out. The statement is protected with the password you chose when you requested it (KFintech, CAMS). A demat statement from NSDL or CDSL lists holdings only and is not read here; units held in a demat account are not in the registrars’ statement either.

How the capital gains are worked out

Units are matched first in, first out, folio by folio and scheme by scheme (section 67(7) of the Income-tax Act, 2025; section 45(2A) of the 1961 Act), with the lot engine of the FIFO capital gains calculator:

• Equity-oriented funds — 65% or more in Indian shares, aggressive hybrid funds included; a fund of funds only when it keeps 90% or more in an ETF that keeps 90% or more in Indian shares (section 198(8); section 112A of the 1961 Act): long-term after 12 months; short-term gains at 20% (section 196) and long-term gains at 12.5% on the year’s total above ₹1,25,000 (section 198). Units bought before 1 February 2018 take as cost the higher of what they cost and the lower of the NAV on 31 January 2018 and the sale value (section 90(7); section 55(2)(ac) of the 1961 Act).
• Debt funds (more than 65% in debt and money-market instruments, conservative hybrid funds included) bought on or after 1 April 2023: always short-term, at your slab rates (section 76; section 50AA). Bought before 1 April 2023: long-term after 24 months, at 12.5% without indexation (section 197).
• Other funds — gold, international, other funds of funds, hybrids that are neither: long-term after 24 months, at 12.5% (section 197).

Stamp duty on a purchase is part of its cost. The redemption amount on the statement is the sale value (an exit load is already taken off). STT is not deductible. A purchase the registrar reversed is taken out with its reversal, and units that move in a scheme merger keep their dates and cost: a merger is not a sale.

XIRR

XIRR is the yearly return of money that goes in and out on different dates — Excel’s XIRR, as in the XIRR calculator. Each purchase counts as money you put in (with its stamp duty), each redemption (after STT) and each IDCW payout as money you got back, and the value of the units on the statement’s date closes the account. A reinvested IDCW is not new money. Switches between your schemes count for each scheme but cancel out in the portfolio’s XIRR.

Regular and direct plans

Every scheme has a direct plan and a regular plan with the same portfolio; the regular plan’s higher total expense ratio pays the distributor whose ARN appears on your statement. Enter the expense ratio of your plan and of the direct plan (AMFI publishes them) to see the extra cost a year at today’s value and, with a return you assume, the difference over the years you choose. This is arithmetic on the figures you enter, not a recommendation to switch: a switch is a redemption, which may be taxed and may carry an exit load.

Limitations

• For residents. Units held in demat accounts, NPS, PMS and shares are not part of the registrars’ statement.
• The NAV on 31 January 2018, the expense ratios and the tax category are what you enter or confirm; the tool does not look them up.
• Sales before FY 2025-26 are matched (so later sales use the right units) and totalled by year, but not split by category: the holding periods and rates were different then.
• Segregated portfolios, gifts and transmissions are listed but their cost is not apportioned; check those schemes with the registrar’s capital gains statement.
• A scanned or printed copy of the statement has no text to read; download the emailed PDF.
• No buy, sell or switch suggestions: the figures are for your own records and your tax return.

Privacy

The statement is opened and read in your browser; its password is used only to open it here. Nothing is uploaded, and nothing is kept after you close the page.