SOC2

Extract Investment Statement Extractor Data in Seconds — Automatically

Finance teams spend 4+ hours weekly on manual document processing. That's $15,000/year in labor costs for a 10-person team — plus errors that cost $62 each to fix.

90
Fields Extracted
360s
Max Processing
Try Free — No Credit CardView API Docs

What This Template Does

AI-powered extraction using gemini-2.5-flash. Part of 113 production-ready templates.

Capabilities

  • Financial Extraction
  • Investment Analysis
  • Holdings Extraction
  • Investment
  • Brokerage

Output Schema

{
  "type": "object",
  "required": [
    "document_type",
    "statement_type",
    "statement_date",
    "account_info",
    "account_summary",
    "holdings",
    "validation"
  ],
  "properties": {
    "document_type": {
      "type": "string",
      "const": "investment_statement",
      "description": "Document type"
    },
    "statement_type": {
      "type": "string",
      "enum": [
        "brokerage",
        "ira",
        "401k",
        "529",
        "trust"
      ],
      "descr
...

Quick Start

$ pip install doclayer
$ doclayer process document.pdf --agent finance.investment-statement

See It In Action

Real extraction example showing input document and structured output.

Input Document
================================================================================
                         CHARLES SCHWAB & CO., INC.
                      INVESTMENT ACCOUNT STATEMENT
================================================================================

Account Holder: JAMES R. ANDERSON
Account Number: ****-5678
Account Type: Individual Brokerage Account
Statement Period: November 1, 2024 - November 30, 2024
Statement Date: December 1, 2024

Tax ID: XXX-XX-4523
Investment Advisor: Sa
Extracted Data
{
  "document_type": "investment_statement",
  "statement_type": "brokerage",
  "statement_date": "2024-12-01",
  "statement_period": {
    "start_date": "2024-11-01",
    "end_date": "2024-11-30"
  },
  "account_info": {
    "institution_name": "Charles Schwab & Co., Inc.",
    "account_number": "XXXX-5678",
    "account_type": "Individual",
    "account_holder": "James R. Anderson",
    "tax_id": "XXX-XX-4523",
    "advisor": "Sarah M. Williams (License #CRD-789456)"
  },
  "account_summary": {
    "beginning_value": "$487,234.56",
    "ending_value": "$512,891.23",
    "net_change": "$25,656.67",
    "net_change_percent": "+5.27%",
    "cash_balance": "$18,456.78",
    "margin_balance": "$0.00",
    "margin_equity": "N/A"
  },
  "activity_summary": {
    "deposits": "$5,000.00",
    "withdrawals": "$0.00",
    "transfers_in": "$0.00",
    "transfers_out": "$0.00",
    "dividends": "$1,234.56",
    "interest": "$45.23",
    "capital_gains": "$2,890.45",
    "fees": "$12.50"
  },
  "holdings": [
    {
      "symbol": "AAPL",
      "cusip": "037833100",
      "security_name": "Apple Inc.",
      "security_type": "Stock",
      "quantity": "250",
      "price": "$189.45",
      "market_value": "$47,362.50",
      "cost_basis": "$38,500.00",
      "unrealized_gain_loss": "+$8,862.50",
      "unrealized_gain_loss_percent": "+23.0%",
      "yield": "0.50%",
      "annual_income": "$240.00",
      "percent_of_portfolio": "9.2%"
    },
    {
      "symbol": "MSFT",
      "cusip": "594918104",
      "security_name": "Microsoft Corporation",
      "security_type": "Stock",
      "quantity": "180",
      "price": "$378.92",
      "market_value": "$68,205.60",
      "cost_basis": "$52,340.00",
      "unrealized_gain_loss": "+$15,865.60",
      "unrealized_gain_loss_percent": "+30.3%",
      "yield": "0.75%",
      "annual_income": "$511.54",
      "percent_of_portfolio": "13.3%"
    },
    {
      "symbol": "GOOGL",
      "cusip": "02079K305",
      "security_name": "Alphabet Inc. Class A",
      "security_type": "Stock",
      "quantity": "100",
      "price": "$141.23",
      "market_value": "$14,123.00",
      "cost_basis": "$12,450.00",
      "unrealized_gain_loss": "+$1,673.00",
      "unrealized_gain_loss_percent": "+13.4%",
      "yield": "0.00%",
      "annual_income": "$0.00",
      "percent_of_portfolio": "2.8%"
    },
    {
      "symbol": "AMZN",
      "cusip": "023135106",
      "security_name": "Amazon.com Inc.",
      "security_type": "Stock",
      "quantity": "125",
      "price": "$186.54",
      "market_value": "$23,317.50",
      "cost_basis": "$18,750.00",
      "unrealized_gain_loss": "+$4,567.50",
      "unrealized_gain_loss_percent": "+24.4%",
      "yield": "0.00%",
      "annual_income": "$0.00",
      "percent_of_portfolio": "4.5%"
    },
    {
      "symbol": "NVDA",
      "cusip": "67066G104",
      "security_name": "NVIDIA Corporation",
      "security_type": "Stock",
      "quantity": "85",
      "price": "$498.56",
      "market_value": "$42,377.60",
      "cost_basis": "$28,900.00",
      "unrealized_gain_loss": "+$13,477.60",
      "unrealized_gain_loss_percent": "+46.6%",
      "yield": "0.03%",
      "annual_income": "$13.60",
      "percent_of_portfolio": "8.3%"
    },
    {
      "symbol": "JPM",
      "cusip": "46625H100",
      "security_name": "JPMorgan Chase & Co.",
      "security_type": "Stock",
      "quantity": "200",
      "price": "$198.34",
      "market_value": "$39,668.00",
      "cost_basis": "$35,200.00",
      "unrealized_gain_loss": "+$4,468.00",
      "unrealized_gain_loss_percent": "+12.7%",
      "yield": "2.20%",
      "annual_income": "$872.70",
      "percent_of_portfolio": "7.7%"
    },
    {
      "symbol": "BND",
      "cusip": "921937835",
      "security_name": "Vanguard Total Bond Market ETF",
      "security_type": "ETF",
      "quantity": "450",
      "price": "$72.45",
      "market_value": "$32,602.50",
      "cost_basis": "$34,650.00",
      "unrealized_gain_loss": "-$2,047.50",
      "unrealized_gain_loss_percent": "-5.9%",
      "yield": "3.45%",
      "annual_income": "$1,124.79",
      "percent_of_portfolio": "6.4%"
    },
    {
      "symbol": "VCIT",
      "cusip": "92206C870",
      "security_name": "Vanguard Intermediate-Term Corporate Bond ETF",
      "security_type": "ETF",
      "quantity": "300",
      "price": "$79.23",
      "market_value": "$23,769.00",
      "cost_basis": "$25,200.00",
      "unrealized_gain_loss": "-$1,431.00",
      "unrealized_gain_loss_percent": "-5.7%",
      "yield": "4.12%",
      "annual_income": "$979.28",
      "percent_of_portfolio": "4.6%"
    },
    {
      "symbol": "TLT",
      "cusip": "464287440",
      "security_name": "iShares 20+ Year Treasury Bond ETF",
      "security_type": "ETF",
      "quantity": "150",
      "price": "$91.56",
      "market_value": "$13,734.00",
      "cost_basis": "$15,000.00",
      "unrealized_gain_loss": "-$1,266.00",
      "unrealized_gain_loss_percent": "-8.4%",
      "yield": "3.89%",
      "annual_income": "$534.25",
      "percent_of_portfolio": "2.7%"
    },
    {
      "symbol": "VFIAX",
      "cusip": "922908710",
      "security_name": "Vanguard 500 Index Fund Admiral Shares",
      "security_type": "Mutual Fund",
      "quantity": "325.45",
      "price": "$478.92",
      "market_value": "$155,878.55",
      "cost_basis": "$125,000.00",
      "unrealized_gain_loss": "+$30,878.55",
      "unrealized_gain_loss_percent": "+24.7%",
      "yield": "1.35%",
      "annual_income": "$2,104.36",
      "percent_of_portfolio": "30.4%"
    },
    {
      "symbol": "VBTLX",
      "cusip": "921937720",
      "security_name": "Vanguard Total Bond Market Index Fund Admiral Shares",
      "security_type": "Mutual Fund",
      "quantity": "456.78",
      "price": "$9.87",
      "market_value": "$4,508.42",
      "cost_basis": "$4,800.00",
      "unrealized_gain_loss": "-$291.58",
      "unrealized_gain_loss_percent": "-6.1%",
      "yield": "3.25%",
      "annual_income": "$146.52",
      "percent_of_portfolio": "0.9%"
    },
    {
      "symbol": "SWVXX",
      "cusip": "808509871",
      "security_name": "Schwab Value Advantage Money Fund",
      "security_type": "Money Market",
      "quantity": "18,456.78",
      "price": "$1.00",
      "market_value": "$18,456.78",
      "cost_basis": "$18,456.78",
      "unrealized_gain_loss": "$0.00",
      "unrealized_gain_loss_percent": "0.0%",
      "yield": "4.85%",
      "annual_income": "$895.15",
      "percent_of_portfolio": "3.6%"
    }
  ],
  "asset_allocation": {
    "stocks": {
      "value": "$235,054.20",
      "percentage": "45.8%"
    },
    "bonds": {
      "value": "$74,614.92",
      "percentage": "14.6%"
    },
    "cash": {
      "value": "$47,343.56",
      "percentage": "9.2%"
    },
    "alternatives": {
      "value": "$0.00",
      "percentage": "0.0%"
    }
  },
  "transactions": [
    {
      "date": "2024-11-05",
      "settlement_date": "2024-11-07",
      "type": "Buy",
      "symbol": "NVDA",
      "description": "NVIDIA Corporation",
      "quantity": "25",
      "price": "$472.30",
      "amount": "-$11,807.50",
      "fees_commissions": "$4.95"
    },
    {
      "date": "2024-11-08",
      "settlement_date": "2024-11-12",
      "type": "Sell",
      "symbol": "XOM",
      "description": "Exxon Mobil Corp",
      "quantity": "100",
      "price": "$118.45",
      "amount": "+$11,845.00",
      "fees_commissions": "$4.95"
    },
    {
      "date": "2024-11-12",
      "settlement_date": "2024-11-14",
      "type": "Buy",
      "symbol": "AAPL",
      "description": "Apple Inc.",
      "quantity": "50",
      "price": "$185.20",
      "amount": "-$9,260.00",
      "fees_commissions": "$0.00"
    },
    {
      "date": "2024-11-15",
      "settlement_date": "2024-11-15",
      "type": "Dividend",
      "symbol": "MSFT",
      "description": "Microsoft Corporation",
      "quantity": "-",
      "price": "-",
      "amount": "+$356.40",
      "fees_commissions": "$0.00"
    },
    {
      "date": "2024-11-18",
      "settlement_date": "2024-11-18",
      "type": "Dividend",
      "symbol": "AAPL",
      "description": "Apple Inc.",
      "quantity": "-",
      "price": "-",
      "amount": "+$60.00",
      "fees_commissions": "$0.00"
    },
    {
      "date": "2024-11-20",
      "settlement_date": "2024-11-20",
      "type": "Interest",
      "symbol": "SWVXX",
      "description": "MM Interest",
      "quantity": "-",
      "price": "-",
      "amount": "+$45.23",
      "fees_commissions": "$0.00"
    },
    {
      "date": "2024-11-22",
      "settlement_date": "2024-11-26",
      "type": "Buy",
      "symbol": "BND",
      "description": "Vanguard Total Bond ETF",
      "quantity": "100",
      "price": "$72.15",
      "amount": "-$7,215.00",
      "fees_commissions": "$0.00"
    },
    {
      "date": "2024-11-25",
      "settlement_date": "2024-11-25",
      "type": "Dividend",
      "symbol": "JPM",
      "description": "JPMorgan Chase & Co.",
      "quantity": "-",
      "price": "-",
      "amount": "+$260.00",
      "fees_commissions": "$0.00"
    },
    {
      "date": "2024-11-28",
      "settlement_date": "2024-11-28",
      "type": "Dividend",
      "symbol": "VFIAX",
      "description": "Vanguard 500 Index",
      "quantity": "-",
      "price": "-",
      "amount": "+$558.16",
      "fees_commissions": "$0.00"
    },
    {
      "date": "2024-11-29",
      "settlement_date": "2024-11-29",
      "type": "Transfer",
      "symbol": "-",
      "description": "ACH Deposit",
      "quantity": "-",
      "price": "-",
      "amount": "+$5,000.00",
      "fees_commissions": "$0.00"
    }
  ],
  "dividends_interest": [
    {
      "date": "2024-11-15",
      "symbol": "MSFT",
      "description": "Microsoft Corporation",
      "type": "Qualified",
      "amount": "$356.40",
      "reinvested": false
    },
    {
      "date": "2024-11-18",
      "symbol": "AAPL",
      "description": "Apple Inc.",
      "type": "Qualified",
      "amount": "$60.00",
      "reinvested": false
    },
    {
      "date": "2024-11-20",
      "symbol": "SWVXX",
      "description": "Money Market Interest",
      "type": "Interest",
      "amount": "$45.23",
      "reinvested": false
    },
    {
      "date": "2024-11-25",
      "symbol": "JPM",
      "description": "JPMorgan Chase & Co.",
      "type": "Qualified",
      "amount": "$260.00",
      "reinvested": false
    },
    {
      "date": "2024-11-28",
      "symbol": "VFIAX",
      "description": "Vanguard 500 Index Admiral",
      "type": "Qualified",
      "amount": "$558.16",
      "reinvested": true
    }
  ],
  "fees_charges": [
    {
      "date": "2024-11-05",
      "description": "Commission - NVDA Buy",
      "amount": "$4.95"
    },
    {
      "date": "2024-11-08",
      "description": "Commission - XOM Sell",
      "amount": "$4.95"
    },
    {
      "date": "2024-11-30",
      "description": "Account Maintenance Fee",
      "amount": "$2.60"
    }
  ],
  "retirement_specific": {
    "account_type": "N/A - Not a retirement account",
    "contributions_ytd": "N/A",
    "employer_match_ytd": "N/A",
    "contribution_limit": "N/A",
    "remaining_contribution_room": "N/A",
    "rmd_required": false,
    "rmd_amount": "N/A"
  },
  "tax_information": {
    "taxable_dividends": "$10,180.23",
    "qualified_dividends": "$8,945.67",
    "tax_exempt_interest": "$0.00",
    "short_term_gains": "$1,245.67",
    "long_term_gains": "$5,890.34",
    "foreign_taxes_paid": "$123.45"
  },
  "important_notices": [
    "Your account has been opted into dividend reinvestment for VFIAX",
    "Market data as of market close November 29, 2024",
    "Cost basis shown reflects average cost method",
    "Contact your tax advisor for personalized tax advice"
  ],
  "validation": {
    "holdings_sum_to_total": true,
    "transactions_reconcile": true,
    "account_info_complete": true
  }
}

Individual brokerage account statement with holdings, positions, and account balances. Demonstrates extraction of portfolio composition, security details, and account summary information.

Related Templates

Audit Report Extractor

Extract data from audit reports, auditor opinions, and assurance reports. Captures opinion type, key audit matters, findings, and auditor details.

Bank Reconciliation Extractor

Extract data from bank reconciliation statements. Captures book balance, bank balance, outstanding items, and reconciling differences.

Cap Table Checker

Cap Table Checker: Validate cap table CSV and flag rounding / option pool issues.

View all finance templates

Frequently Asked Questions

What documents can Investment Statement Extractor process?

The Investment Statement Extractor template processes finance documents including various formats and layouts. See the instructions for specific document types supported.

How accurate is the Investment Statement Extractor extraction?

The Investment Statement Extractor template uses Gemini 2.5 Flash for high-accuracy extraction. Results include confidence scores for each field.

Can I customize the Investment Statement Extractor template?

Yes, you can modify the extraction schema, add custom fields, or adjust the instructions to match your specific requirements.

Start Extracting Data Today

Process your first document in under 5 minutes. No credit card required.

Get Started FreeView Pricing