A guide to importing CAMS/CAS statements into a portfolio tracker

If you invest in mutual funds in India across various AMC platforms or brokers like Groww and Coin, the easiest way to see your entire transaction history is through a Consolidated Account Statement (CAS).

What is a CAS Statement?

A CAS (Consolidated Account Statement) is a single document that consolidates financial transactions across all your mutual funds and demat accounts based on your PAN number. It is securely issued by depository participants like CAMS or KFintech.

Step 1: Generate your CAS File

1. Visit the official CAMS Online portal (camsonline.com) or use their MFCentral app.
2. Navigate to the "CAS / Statement" generation section.
3. Select "Detailed" or "Summary" statement type (for a portfolio tracker, you usually need a 'Detailed' statement spanning 'Since Inception').
4. Enter your registered email address and PAN.
5. Set a secure password for the PDF file. You will receive an email shortly with your encrypted PDF.

Step 2: Import into Your Tracker

Once you have your PDF, importing it into a tracker like Arthavi is simple.

1. Log in to your dashboard.
2. Click on "Upload Investments" or "Sync Mutual Funds".
3. Provide the encrypted PDF and occasionally the password you set (we handle parsing locally so your data remains strictly private).
4. Watch as the tracker instantly reconstructs your historical buy/sell events and builds your real-time XIRR.

Troubleshooting CAS Import Issues

Sometimes, investors face issues when generating or uploading their CAS files. Here are common reasons why:

• Incorrect Password: The most common error is typing the wrong password when unlocking the PDF. Always double-check your email or PAN-based password logic.
• 'Summary' instead of 'Detailed': Ensure you request a 'Detailed' transaction statement. Summary statements lack the specific transaction dates required to calculate an accurate XIRR.
• Demat Holdings Missing: CAMS only tracks mutual funds held in regular folios. If you buy mutual funds in Demat form (like on Zerodha Coin), you must generate a CAS from NSDL or CDSL instead.

How Often Should You Import CAS?

Unlike stocks which fluctuate wildly, mutual fund NAVs update only once a day. For most passive long-term investors, importing a new CAS statement once a month (after your SIPs trigger) is more than enough to keep their dashboard perfectly synced.

Ditch the confusion of multiple accounts. Start organizing your investments securely. Explore the best portfolio tracker in India to upload your first CAS statement today.