Client Statement and Portfolio Extraction

• Head of Wealth Operations
• Relationship Manager
• SEBI-Registered Investment Adviser
• Family Office Operations Lead

A new wealth client rarely arrives with one tidy statement. They bring a depository CAS, mutual fund statements from the registrars, a PMS quarterly report, an AIF capital account statement, bank deposit receipts and perhaps an overseas brokerage statement, and the RM's team rebuilds the portfolio by hand before any review can begin.

We build a statement pipeline that accepts client statements by secure upload, email or, where your setup supports it, Account Aggregator data. It opens password-protected files in memory using the password the client provides, identifies the statement type and extracts holdings, transactions, valuations and statement dates. Each security is mapped to its ISIN or scheme code against your security master, and holdings that appear in more than one statement are de-duplicated. The pipeline reconciles extracted totals to each statement's own summary and sends unmapped securities or breaks to an operations analyst. The result is a consolidated portfolio in your wealth platform, ready for the adviser's review.

• Classifies statement types: depository CAS, registrar statements, broker holdings, PMS, AIF, deposits and overseas brokerage
• Extracts holdings, transactions, units, NAV or price, valuation date and cost where shown
• Maps securities to ISINs and scheme codes, including plan and option variants
• De-duplicates holdings that appear in more than one statement
• Reconciles extracted totals to each statement's own summary and flags breaks
• Exports a consolidated portfolio by client, family member and asset class to your wealth platform

1. 01Collect statements with consentClients share statements through a secure upload, email or Account Aggregator consent, and the consent is recorded.
2. 02Open and classifyPassword-protected files are opened in memory, and each statement is classified by type and source.
3. 03Extract holdings and transactionsHoldings, transactions and valuations are extracted with page references.
4. 04Map and de-duplicateSecurities are mapped to ISINs or scheme codes, and duplicate holdings across statements are merged.
5. 05Reconcile and reviewTotals are reconciled to statement summaries; breaks and unmapped items go to an operations analyst.
6. 06Publish the portfolioThe consolidated portfolio is pushed to the wealth platform for the adviser's review.

1. Collection and consent
   • Secure client upload portal
   • Email intake
   • Account Aggregator data feed where available
   • Consent log
2. Document understanding
   • In-memory password handling
   • Statement type classifier
   • Table and text extractor for holdings and transactions
3. Reference mapping
   • Security master with ISINs and scheme codes
   • Fuzzy name matching for schemes and bonds
   • Cross-statement de-duplication
4. Reconciliation and review
   • Statement total reconciliation
   • Exception queue for operations
5. Delivery
   • Wealth platform adapter
   • Excel export
   • Audit trail

Operations analysts resolve every unmapped security and reconciliation break before a portfolio is published. Advisers review the consolidated portfolio before any client discussion, and the system never suggests what to buy, sell or switch.

• Wealth management or portfolio management platform
• CRM
• Account Aggregator ecosystem, where you are onboarded as a financial information user
• Security master data provider
• Secure client upload portal and email

• Statement passwords used in memory only and never stored
• PAN and account numbers masked in logs
• Reconciliation to statement totals required before publishing
• Every holding linked to its source page
• No recommendations or advice generated from the data

• Client consent is recorded before statements are processed, supporting DPDP Act 2023 requirements on consent and purpose.
• Outputs are analytical inputs for SEBI-registered advisers or distributors; the system does not generate investment advice.

• Capital Markets & Wealth Management

  KYC and Onboarding Document Verification for Brokers

  Check account opening packets for brokers and depository participants: cross-match KYC fields, apply segment and entity checklists, and prepare a discrepancy list for the checker.

• Capital Markets & Wealth Management

  RM Meeting Notes and CRM Update Agent

  Turn RM client meetings and voice notes in English or Hindi into structured notes, CRM updates and follow-up drafts, with compliance mentions flagged and the RM approving everything.

• Capital Markets & Wealth Management

  Private Markets Fund Document Extraction

  Read capital calls, distribution notices, capital account statements and LPAs from many GPs into structured records, with roll-forward checks and wire-instruction change alerts.

• NBFCs & Lending

  Bank Statement Analysis for Underwriting

  Analyse bank statements from PDFs, scans and Account Aggregator data to surface income, obligations, bounces and red flags, with every figure traceable to transactions.