Extract CAMS Consolidated Account Statement (CAS) PDF to Excel
Export mutual fund holdings, folio balances, and NAV transaction tables from CAMS CAS PDFs into Excel for portfolio tracking and capital gains audit.
Drop your files here
or click to browse — up to 1 file
🔒 Your files never leave your device — processing happens in your browser.
Why use GoluPDFs for this?
- 1Predefined mapping for CAMS/Karvy Consolidated Account Statements
- 2Accurately maps schemes, folios, purchase/redemption transactions, and units
- 3Completely private local processing keeps your mutual fund investments confidential
- 4Compiles multiple folios into separate sheets or a unified ledger
What you get inside Table Extractor
- Visual Table Grid Editor: Select, edit cells, delete rows/columns manually
- OCR Table Recovery Mode: Simulated parser interface to digitize scanned documents
- Merged Cells & Multi-Page Joining: Clean row grouping across pages
- Smart Column Mapper: Dropdown categorizer (Date, Description, Debit, Credit, etc.)
- Financial Template Presets: Invoice, Bank Statement, and Income Statement parser options
- Multi-Sheet Excel Export: Compile multiple parsed tables into separate sheet tabs natively
Technical Guide: Extracting CAMS Mutual Fund CAS Logs
A Consolidated Account Statement (CAS) issued by CAMS (Computer Age Management Services) or Karvy (KFintech) compiles your entire mutual fund holdings across different asset management companies (AMCs) and folios. These statements are vital for portfolio consolidation, tax audit reporting, and wealth planning.
However, CAS PDFs are multi-column, densely formatted, and typically spread across dozens of pages. Direct copying results in broken rows, mixed folios, and misaligned transaction numbers.
CAS Holdings Mapping Schema
Our WebAssembly utility extracts both transaction histories and asset summary valuations, structuring them into clean columns:
- Folio Number & AMC: Groups transactions by specific AMC and account folios.
- Scheme Name: Identifies Direct vs Regular plans and debt vs equity schemes.
- Transaction Type: Categorizes purchase, SIP installments, redemptions, switches, and dividend payouts.
- NAV & Units: Isolates transaction pricing (Net Asset Value), units allocated, and transaction totals.
Absolute Confidentiality for Portfolio Data
Your CAMS Consolidated Account Statement contains your full portfolio valuation, PAN, email, residential address, and folio balances. Uploading this to standard cloud converters exposes your sensitive financial assets to third-party databases.
🔒 GoluPDF processes CAS decryption and grid building locally on your device. No financial records ever touch our web servers.
Mutual Fund Tax Auditing & Capital Gains Reconciliation
Auditing Long-Term Capital Gains (LTCG) and Short-Term Capital Gains (STCG) for tax returns is simple with Excel:
SIP Compounding Audit
Reconcile each SIP transaction date and rate against bank auto-debits to identify payment delay charges or missed portfolio logs.
Weighted Cost of Acquisition
Calculate the average cost of acquisition for equity units easily using Excel formulas on the extracted tabular columns.
Grandfathered NAV Tracking
Isolate units purchased before January 31, 2018, and apply grandfathering rules for Indian equity LTCG audits in your spreadsheet.
Disclaimer: GoluPDFs is a private, independent utility platform. It is not affiliated with, authorized, endorsed by, or in any way officially connected with the State Bank of India (SBI), HDFC Bank, ICICI Bank, Axis Bank, Kotak Mahindra Bank, Punjab National Bank (PNB), Bank of Baroda (BOB), Paytm, EPFO, CAMS, Karvy (KFintech), LIC, NPS, or any of their subsidiaries or affiliates. The official websites of these entities can be found at their respective domains. All product and service names, logos, brands, trademarks, and registered trademarks mentioned on this website are the property of their respective owners. Their use on GoluPDFs does not imply any affiliation with or endorsement by them.
🔒 Data Privacy: All document decryption, processing, and table extractions are conducted 100% client-side inside your browser sandbox using WebAssembly. No files or personal/financial data are uploaded, stored, or transmitted to our servers.
Frequently asked questions
Upload the CAS PDF (usually password-protected with your PAN/email), enter the PDF password if requested to decrypt locally, select the CAMS CAS preset mapping, and run. Your mutual fund holdings will extract to Excel instantly.