How to Read a Mutual Fund CAS: Transactions, Returns and Missing Folios

Your investment app shows one portfolio value, your emailed statement shows another, and a fund you bought through a bank seems to be missing. Before deciding that the investment has disappeared or the app is wrong, bring the records to the same date and check what each document includes. A consolidated account statement, or CAS, is the starting point for that reconciliation.

This guide focuses on Indian mutual fund statements. The examples are invented for explanation and contain no customer information. A CAS is a record of investments; it does not, by itself, establish whether a fund suits your goals or whether every displayed gain is taxable.

What is a CAS, and which statement do you have?

CAS stands for Consolidated Account Statement. It brings investment records together, but its scope depends on the issuer and the service you requested. Start by identifying whether you have a mutual fund statement from the registrars or a depository statement covering demat holdings.

CAMS describes its consolidated service as covering funds serviced by CAMS and KFintech, with summary and detailed choices. It also cautions that demat information may be incomplete and directs investors to their depository participant. A missing line in one document is therefore a reason to investigate coverage, rather than proof that ownership has vanished.

NSDL's investor brochure explains its consolidated view of demat accounts and mutual fund holdings in statement-of-account form, aggregated using the first holder's PAN. Check the actual investor and account details rather than expecting a personal statement to function as a complete family balance sheet.

How to download the right CAS for your task

Use the links on AMFI's official CAS download page to reach CAMS, KFintech or MFCentral. AMFI lists these routes and describes summary and detailed statement options. The period choices can differ between services, so inspect the start and end dates in the delivered file.

1. For a holdings check, request a statement with an explicit valuation date and compare it with your apps on that same date.
2. For a missing transaction, request the detailed version covering dates before and after the expected allotment or redemption.
3. For a lifetime return calculation, obtain the full transaction history, including fully exited investments where relevant. A recent financial-year statement may be insufficient.
4. Include zero-balance folios when investigating an old investment. A folio that was fully redeemed can still explain earlier cash flows.
5. Save the original file and note the request date. Keep any spreadsheet corrections separate so you can return to the source record.

Do not assume every service offers an unrestricted since-inception download. If you need several date ranges, reconcile the opening and closing balances at each boundary and remove duplicate transactions from overlapping periods. Joining two PDFs is not enough to produce a reliable investment history.

Read these fields before looking at the profit figure

Read the complete scheme name. Growth and IDCW are different distribution options; Direct and Regular are different plans. Similar fund names do not make their NAV histories interchangeable. An ISIN, when shown, helps identify the precise security, but the scheme description and transaction record still need to agree.

The cost of your remaining units and your lifetime contributions answer different questions. After a partial redemption, some original capital has already left the investment. After a switch, money may have moved between schemes without leaving your overall portfolio. Neither situation can be explained safely by subtracting one loosely labelled dashboard number from another.

A worked CAS example: reconcile units before returns

Assume a hypothetical Growth-option holding opens the period with 1,000 units. The amounts below are simplified net transaction amounts, with no stamp duty, exit load, tax or other deductions. They are not a reproduction of any fund's statement.

The unit check is 1,000 + 200 + 200 − 100 = 1,300. The valuation check is 1,300 × ₹28 = ₹36,400. These are two independent checks: the first verifies the quantity, while the second verifies the value assigned to that quantity. Allow for the statement's displayed decimal precision when comparing a rounded calculation.

You cannot calculate lifetime profit as ₹36,400 minus the ₹10,200 purchased during this period. The opening 1,000 units already had a cost and an investment date, and ₹2,700 has left the account. You need that earlier history for lifetime performance. For performance over only this statement period, you instead need the opening market value and the subsequent dated cash flows.

How to interpret switches, IDCW and reinvestment entries

A switch usually creates an outgoing transaction in one scheme or option and an incoming transaction in another. For an individual scheme's performance, those are relevant cash flows. For the combined portfolio, the amount transferred internally should not be counted as fresh household savings or money spent outside the portfolio.

Suppose ₹40,000 moves from Fund A to Fund B. Calling the purchase in B a new contribution while ignoring the redemption from A overstates how much you invested. When consolidating, retain both sides and reconcile amounts, dates and any deductions. If the money is between schemes at a valuation boundary, account for the unsettled amount rather than silently treating it as a loss.

An IDCW payout is cash distributed to you. Reinvestment uses the distribution to buy additional units. These need different treatment in a cash-flow calculation: an amount reinvested within the investment is not an additional payment from your salary. For the mechanics and NAV adjustment, see Growth versus IDCW.

This is also why a statement can show activity without a matching bank debit. Reinvestment, switches and certain adjustments alter the investment record without representing a fresh instruction to transfer money from your bank. Read the transaction description before assigning a cash-flow sign.

Why a mutual fund folio may be missing from your CAS

Work from the simplest explanation toward the more serious ones. The checklist below is a practical investigation sequence, not a claim that every missing folio has the same cause.

1. Check the requested period and folio filter. A zero-balance investment may have been excluded intentionally.
2. Check the email registered against the missing folio. CAMS asks for the email used across the relevant fund records; an older address can require correction or a separate statement request.
3. Check the PAN, first holder and holding pattern against the original investment record. Do not combine relatives' holdings merely because you manage them together.
4. Establish whether the units are in demat form. Obtain the relevant DP record when the RTA statement's demat coverage is incomplete.
5. Compare with a fresh statement issued directly for that AMC folio. If it exists there, ask the registrar why it is absent from the consolidated view.
6. For a recent bank debit, establish whether allotment actually happened. A payment acknowledgement and a confirmed unit allocation are different records.

If the issue began with a SIP debit, follow the separate SIP deducted but units not allotted checklist. If you see an unrecognised redemption or a bank-detail change you did not request, contact the AMC or DP promptly through its official channel rather than waiting for the next monthly statement.

Why CAS value, app returns and XIRR can disagree

A value difference is not necessarily a performance difference. One screen may use yesterday's NAV and another an earlier month-end figure. One may include exited schemes or IDCW payouts and another only current holdings. A third may display absolute gain while the others show an annualised return.

For your own cash-flow return, XIRR uses dated amounts paid in, cash received back and the final valuation. The CAGR versus XIRR guide explains the distinction. If you only have this year's transactions, labelling the result as your lifetime XIRR would be misleading even if the spreadsheet formula itself is correct.

An opening unit balance is not automatically an opening cash investment at that period's NAV. Use that market value only when deliberately measuring performance from the period's start. Record this choice so that a later comparison is between two calculations answering the same question.

For tax work, obtain the relevant realised-gains statement rather than treating a CAS unrealised gain as income to report. CAMS provides a separate capital gain and loss statement with redemption and FIFO gain details. Confirm that every registrar and holding mode is covered before using any consolidated tax figure.

Use the CAS Analyzer after checking the source data

Our CAS Analyzer reads supported CAMS/KFintech statement formats in your browser. It can help inspect holdings, cash flows and concentration. It is currently under development: verify its totals and transaction classifications against the original statement, especially when a PDF layout or transaction description is unusual.

A summary statement can support a holdings review, but dated transactions are needed for XIRR. NSDL/CDSL demat CAS files are not supported by the current parser. Sector and allocation estimates depend on matching schemes to disclosed portfolios; incomplete matching should be treated as incomplete coverage, not as proof that the unmatched money has no exposure.

The tool does not authenticate ownership, correct registrar records or establish your final tax liability. Keep those tasks with the relevant official records and professional review where needed. A useful output is a short list of differences you can explain, rather than a number you accept because it looks precise.

A repeatable portfolio review using your statement

1. Reconcile holdings and recent transactions; resolve unexplained differences first.
2. Group the verified holdings by purpose: emergency reserve, education, retirement and other goals.
3. Measure concentration by actual rupee value. Three small funds do not offset one dominant holding merely because there are more names.
4. Use the portfolio overlap checker to investigate duplicated equity exposure, keeping its disclosed holdings date in view.
5. Compare the portfolio with your risk assessment and the time remaining to each goal.
6. Write down any proposed change and check exit load, tax and settlement before acting. A statement review does not require a trade.

When asking for help, provide the statement period, scheme, masked folio reference, the transaction in question and the difference you calculated. Share sensitive documents only through a verified private channel. If you want help understanding the review, contact Mahesh Jain MFD; account corrections still need to be processed by the authorised entity.