SOC2
Extract Portfolio Report 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.
83
Fields Extracted
480s
Max Processing
Common Pain Points
- Manual data entry errors cost $62 per error to fix
- Delayed processing strains vendor relationships
- Compliance violations from missed fields
- Audit trails incomplete without structured data
What This Template Does
AI-powered extraction using gemini-2.5-flash. Part of 113 production-ready templates.
Capabilities
- Financial Extraction
- Performance Analysis
- Risk Analytics
- Portfolio
- Performance
Output Schema
{
"type": "object",
"required": [
"document_type",
"report_type",
"report_date",
"portfolio_info",
"portfolio_value",
"performance_summary",
"validation"
],
"properties": {
"document_type": {
"type": "string",
"const": "portfolio_report",
"description": "Document type"
},
"report_type": {
"type": "string",
"description": "Report type"
},
"report_date": {
"type": "string",
"format": "date",
"de
...Quick Start
$ pip install doclayer
$ doclayer process document.pdf --agent finance.portfolio-report
See It In Action
Real extraction example showing input document and structured output.
Input Document
================================================================================
NORTHERN TRUST ASSET MANAGEMENT
QUARTERLY INVESTMENT PERFORMANCE REPORT
================================================================================
Client: MIDWEST STATE EMPLOYEES PENSION FUND
Portfolio: Balanced Growth Portfolio
Account ID: NT-PF-2024-8756
Report Date: January 15, 2025
Reporting Period: Q4 2024 (October 1 - December 31, 2024)
Investment Manager: Northern Trust Asset MaExtracted Data
{
"document_type": "portfolio_report",
"report_type": "quarterly_review",
"report_date": "2025-01-15",
"reporting_period": {
"start_date": "2024-10-01",
"end_date": "2024-12-31",
"period_type": "QTD"
},
"portfolio_info": {
"portfolio_name": "Balanced Growth Portfolio",
"portfolio_id": "NT-PF-2024-8756",
"manager_name": "Jennifer M. Richardson, CFA",
"investment_strategy": "Balanced Growth - 60/40 Equity/Fixed Income",
"inception_date": "2018-01-01",
"benchmark": "60% S&P 500 / 40% Bloomberg US Aggregate Bond Index",
"base_currency": "USD"
},
"portfolio_value": {
"beginning_value": "$485,670,000",
"contributions": "$12,500,000",
"withdrawals": "$8,750,000",
"income": "$4,125,000",
"market_change": "$28,955,000",
"ending_value": "$522,500,000",
"net_asset_value": "$142.87"
},
"performance_summary": {
"period_return": {
"gross_return": "+6.82%",
"net_return": "+6.70%",
"benchmark_return": "+6.15%",
"excess_return": "+0.55%"
},
"annualized_returns": {
"one_year": "+14.25%",
"three_year": "+10.85%",
"five_year": "+11.92%",
"ten_year": "N/A",
"since_inception": "+10.45%"
},
"calendar_year_returns": [
{
"year": "2024",
"portfolio_return": "+14.25%",
"benchmark_return": "+13.42%"
},
{
"year": "2023",
"portfolio_return": "+18.92%",
"benchmark_return": "+17.85%"
},
{
"year": "2022",
"portfolio_return": "-12.45%",
"benchmark_return": "-13.28%"
},
{
"year": "2021",
"portfolio_return": "+16.78%",
"benchmark_return": "+15.92%"
},
{
"year": "2020",
"portfolio_return": "+12.34%",
"benchmark_return": "+11.67%"
}
]
},
"risk_metrics": {
"volatility": {
"portfolio_std_dev": "12.45%",
"benchmark_std_dev": "13.12%",
"tracking_error": "2.15%"
},
"risk_adjusted_returns": {
"sharpe_ratio": "0.87",
"sortino_ratio": "1.12",
"information_ratio": "0.34",
"treynor_ratio": "0.092"
},
"downside_metrics": {
"max_drawdown": "-18.45%",
"max_drawdown_period": "Jan 2022 - Oct 2022",
"downside_deviation": "8.92%",
"beta": "0.94",
"var_95": "-4.25%",
"cvar": "-5.89%"
},
"correlation": {
"r_squared": "0.92",
"correlation_to_benchmark": "0.96"
}
},
"asset_allocation": {
"by_asset_class": [
{
"asset_class": "US Equities",
"market_value": "$219,450,000",
"percentage": "42.0%",
"target_allocation": "40.0%",
"deviation_from_target": "+2.0%"
},
{
"asset_class": "International Equity",
"market_value": "$94,050,000",
"percentage": "18.0%",
"target_allocation": "20.0%",
"deviation_from_target": "-2.0%"
},
{
"asset_class": "US Fixed Income",
"market_value": "$156,750,000",
"percentage": "30.0%",
"target_allocation": "30.0%",
"deviation_from_target": "0.0%"
},
{
"asset_class": "International Bonds",
"market_value": "$26,125,000",
"percentage": "5.0%",
"target_allocation": "5.0%",
"deviation_from_target": "0.0%"
},
{
"asset_class": "Cash & Equivalents",
"market_value": "$26,125,000",
"percentage": "5.0%",
"target_allocation": "5.0%",
"deviation_from_target": "0.0%"
}
],
"by_geography": [
{
"region": "United States",
"market_value": "$402,125,000",
"percentage": "77.0%"
},
{
"region": "Europe",
"market_value": "$52,250,000",
"percentage": "10.0%"
},
{
"region": "Asia Pacific",
"market_value": "$36,575,000",
"percentage": "7.0%"
},
{
"region": "Emerging Markets",
"market_value": "$26,125,000",
"percentage": "5.0%"
},
{
"region": "Other",
"market_value": "$5,425,000",
"percentage": "1.0%"
}
],
"by_sector": [
{
"sector": "Information Technology",
"market_value": "$75,264,000",
"percentage": "24.0%",
"benchmark_weight": "28.5%"
},
{
"sector": "Healthcare",
"market_value": "$47,055,000",
"percentage": "15.0%",
"benchmark_weight": "13.2%"
},
{
"sector": "Financials",
"market_value": "$43,984,500",
"percentage": "14.0%",
"benchmark_weight": "12.8%"
},
{
"sector": "Consumer Discretionary",
"market_value": "$34,441,500",
"percentage": "11.0%",
"benchmark_weight": "10.5%"
},
{
"sector": "Industrials",
"market_value": "$31,350,000",
"percentage": "10.0%",
"benchmark_weight": "8.5%"
},
{
"sector": "Communication Services",
"market_value": "$25,102,500",
"percentage": "8.0%",
"benchmark_weight": "8.8%"
},
{
"sector": "Consumer Staples",
"market_value": "$18,819,000",
"percentage": "6.0%",
"benchmark_weight": "6.2%"
},
{
"sector": "Energy",
"market_value": "$15,727,500",
"percentage": "5.0%",
"benchmark_weight": "4.5%"
},
{
"sector": "Utilities",
"market_value": "$9,409,500",
"percentage": "3.0%",
"benchmark_weight": "2.8%"
},
{
"sector": "Materials",
"market_value": "$6,273,000",
"percentage": "2.0%",
"benchmark_weight": "2.5%"
},
{
"sector": "Real Estate",
"market_value": "$6,273,000",
"percentage": "2.0%",
"benchmark_weight": "2.7%"
}
],
"by_market_cap": [
{
"category": "Large Cap",
"percentage": "72.5%"
},
{
"category": "Mid Cap",
"percentage": "18.5%"
},
{
"category": "Small Cap",
"percentage": "9.0%"
}
]
},
"holdings": {
"top_holdings": [
{
"rank": "1",
"security_name": "Apple Inc.",
"ticker": "AAPL",
"asset_class": "Equity",
"market_value": "$18,787,500",
"percentage": "3.60%",
"quantity": "N/A",
"cost_basis": "$12,450,000",
"unrealized_gain_loss": "+$6,337,500"
},
{
"rank": "2",
"security_name": "Microsoft Corporation",
"ticker": "MSFT",
"asset_class": "Equity",
"market_value": "$17,742,000",
"percentage": "3.40%",
"quantity": "N/A",
"cost_basis": "$11,890,000",
"unrealized_gain_loss": "+$5,852,000"
},
{
"rank": "3",
"security_name": "NVIDIA Corporation",
"ticker": "NVDA",
"asset_class": "Equity",
"market_value": "$15,675,000",
"percentage": "3.00%",
"quantity": "N/A",
"cost_basis": "$8,950,000",
"unrealized_gain_loss": "+$6,725,000"
},
{
"rank": "4",
"security_name": "Amazon.com Inc.",
"ticker": "AMZN",
"asset_class": "Equity",
"market_value": "$13,062,500",
"percentage": "2.50%",
"quantity": "N/A",
"cost_basis": "$9,750,000",
"unrealized_gain_loss": "+$3,312,500"
},
{
"rank": "5",
"security_name": "Alphabet Inc. Class A",
"ticker": "GOOGL",
"asset_class": "Equity",
"market_value": "$11,495,000",
"percentage": "2.20%",
"quantity": "N/A",
"cost_basis": "$8,560,000",
"unrealized_gain_loss": "+$2,935,000"
},
{
"rank": "6",
"security_name": "US Treasury Note 4.25% 2029",
"ticker": "N/A",
"asset_class": "Fixed Income",
"market_value": "$15,675,000",
"percentage": "3.00%",
"quantity": "N/A",
"cost_basis": "N/A",
"unrealized_gain_loss": "N/A"
},
{
"rank": "7",
"security_name": "US Treasury Bond 4.50% 2034",
"ticker": "N/A",
"asset_class": "Fixed Income",
"market_value": "$12,540,000",
"percentage": "2.40%",
"quantity": "N/A",
"cost_basis": "N/A",
"unrealized_gain_loss": "N/A"
}
],
"new_positions": [
{
"security_name": "Eli Lilly and Company",
"date_acquired": "2024-10-15",
"rationale": "Strong pipeline in obesity/diabetes drugs"
},
{
"security_name": "ServiceNow Inc.",
"date_acquired": "2024-11-01",
"rationale": "AI-driven enterprise software growth"
},
{
"security_name": "Broadcom Inc.",
"date_acquired": "2024-11-20",
"rationale": "Data center/AI chip demand expansion"
}
],
"closed_positions": [
{
"security_name": "Intel Corporation",
"date_sold": "2024-10-08",
"realized_gain_loss": "-$1,245,000"
},
{
"security_name": "Walgreens Boots Alliance",
"date_sold": "2024-11-15",
"realized_gain_loss": "-$890,000"
},
{
"security_name": "3M Company",
"date_sold": "2024-12-10",
"realized_gain_loss": "+$567,000"
}
]
},
"fixed_income_details": {
"duration": "5.8 years",
"modified_duration": "5.5 years",
"convexity": "0.45",
"yield_to_maturity": "4.85%",
"current_yield": "4.25%",
"average_credit_quality": "A+",
"credit_distribution": [
{
"rating": "AAA/Aaa",
"percentage": "35.0%"
},
{
"rating": "AA/Aa",
"percentage": "25.0%"
},
{
"rating": "A",
"percentage": "22.0%"
},
{
"rating": "BBB/Baa",
"percentage": "15.0%"
},
{
"rating": "Below Investment Grade",
"percentage": "3.0%"
}
],
"maturity_distribution": [
{
"bucket": "0-1 years",
"percentage": "8.0%"
},
{
"bucket": "1-3 years",
"percentage": "20.0%"
},
{
"bucket": "3-5 years",
"percentage": "28.0%"
},
{
"bucket": "5-10 years",
"percentage": "32.0%"
},
{
"bucket": "10+ years",
"percentage": "12.0%"
}
]
},
"attribution_analysis": {
"total_excess_return": "+0.67%",
"allocation_effect": "+0.28%",
"selection_effect": "+0.35%",
"interaction_effect": "+0.04%",
"by_sector": [
{
"sector": "Information Technology",
"allocation_effect": "-0.12%",
"selection_effect": "+0.25%",
"total_effect": "+0.13%"
},
{
"sector": "Healthcare",
"allocation_effect": "+0.08%",
"selection_effect": "+0.15%",
"total_effect": "+0.23%"
},
{
"sector": "Financials",
"allocation_effect": "+0.06%",
"selection_effect": "+0.12%",
"total_effect": "+0.18%"
},
{
"sector": "Industrials",
"allocation_effect": "+0.05%",
"selection_effect": "+0.08%",
"total_effect": "+0.13%"
},
{
"sector": "Energy",
"allocation_effect": "+0.03%",
"selection_effect": "-0.05%",
"total_effect": "-0.02%"
}
],
"top_contributors": [
{
"security": "NVIDIA Corporation",
"contribution": "+0.18%"
},
{
"security": "Eli Lilly and Company",
"contribution": "+0.12%"
},
{
"security": "Meta Platforms Inc.",
"contribution": "+0.09%"
},
{
"security": "Broadcom Inc.",
"contribution": "+0.07%"
},
{
"security": "ServiceNow Inc.",
"contribution": "+0.05%"
}
],
"top_detractors": [
{
"security": "Intel Corporation (sold)",
"contribution": "-0.08%"
},
{
"security": "Walgreens Boots (sold)",
"contribution": "-0.05%"
},
{
"security": "Boeing Company",
"contribution": "-0.04%"
},
{
"security": "Nike Inc.",
"contribution": "-0.03%"
},
{
"security": "Disney Company",
"contribution": "-0.02%"
}
]
},
"fees_expenses": {
"management_fee": "0.45%",
"performance_fee": "None",
"total_expense_ratio": "0.52%",
"trading_costs": "$125,000",
"other_expenses": "$63,500"
},
"manager_commentary": {
"market_outlook": "We maintain a constructive outlook for 2025 despite elevated valuations in certain market segments. The Federal Reserve's pivot toward rate cuts, combined with resilient corporate earnings, supports continued equity market strength. However, we remain vigilant about geopolitical risks and potential inflation resurgence.",
"portfolio_positioning": "The portfolio is positioned with a slight overweight to US equities, reflecting our conviction in domestic growth. Within equities, we favor quality companies with strong balance sheets and pricing power. Fixed income allocation emphasizes intermediate duration to balance yield and interest rate sensitivity.",
"key_changes": "During Q4, we initiated positions in healthcare (Eli Lilly) and technology (ServiceNow, Broadcom) to capture AI-driven growth opportunities. We exited Intel due to continued competitive pressures and Walgreens given structural challenges in retail pharmacy.",
"risk_assessment": "Key risks include: (1) Valuations in mega-cap tech remain stretched, (2) Geopolitical tensions could impact global trade, (3) Sticky inflation may delay Fed rate cuts. We maintain diversification and quality bias to manage these risks."
},
"compliance_metrics": {
"guideline_status": "In compliance",
"exceptions": []
},
"esg_metrics": {
"esg_score": "72/100",
"environmental_score": "68/100",
"social_score": "75/100",
"governance_score": "74/100",
"carbon_footprint": "125 tons CO2e / $1M invested",
"exclusions_applied": [
"Controversial weapons manufacturers",
"Tobacco producers (>5% revenue)",
"Thermal coal producers (>25% revenue)",
"Companies with severe ESG controversies"
]
},
"validation": {
"performance_calculated": true,
"allocations_sum_to_100": true,
"benchmark_comparison_present": true,
"risk_metrics_complete": true
}
}Quarterly investment performance report for balanced growth portfolio. Demonstrates extraction of benchmark comparison, asset allocation, performance metrics, and manager commentary on portfolio activity.
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.
Frequently Asked Questions
What documents can Portfolio Report Extractor process?
The Portfolio Report Extractor template processes finance documents including various formats and layouts. See the instructions for specific document types supported.
How accurate is the Portfolio Report Extractor extraction?
The Portfolio Report Extractor template uses Gemini 2.5 Flash for high-accuracy extraction. Results include confidence scores for each field.
Can I customize the Portfolio Report 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.