How to Use a CAS File to Import Your MFD Client Data

The Consolidated Account Statement, or CAS, is one of the most trusted sources of mutual fund data for MFDs. It contains all folio details, scheme holdings, transaction history, and investor information for a given PAN. Using a CAS file to import client data into a new MFD platform is fast, accurate, and reliable. Here is how to do it.

What Is a CAS File?

A CAS file is a standardized report provided by RTAs such as CAMS, KFintech, and FT. It shows all mutual fund holdings and transactions linked to a PAN across AMCs. For MFDs, the CAS is useful because it is a single, verified source of truth for client data. It reduces the risk of manual entry errors and missing records.

How to Obtain a CAS File

You can request a CAS from the RTA portal using the PAN and your ARN. Some platforms also allow clients to download their own CAS. Save the file in the standard format, usually PDF or a structured file. Make sure the statement covers the period you need and includes all folios.

Importing the CAS into Your MFD Platform

A modern MFD platform can read a CAS file and extract folio numbers, scheme names, units, transaction dates, and investor details. Upload the file, map the fields, and let the platform normalize the data. It matches client records and creates a complete client view. You can then review the imported data before going live.

Validating the Import

After importing, compare the platform's client count, AUM, and folio count with the original CAS. Check a few sample client records for accuracy. Look for missing transactions, incorrect scheme names, or duplicate folios. Fix any issues before you start using the platform for client service.

Conclusion

Using a CAS file for MFD client data import is a smart way to ensure accuracy. It saves time, reduces errors, and gives you confidence that your client book is correctly transferred to the new platform.