Investor Portal
Private Equity & Syndicate LP Management Platform
An internal operations platform engineered for private equity funds and syndicates to share financial updates, track capital calls, and distribute confidential tax documents without insecure email attachments.
Private Equity & Syndicate
4 Weeks (Sprint to Prod)
Product Design & Dev
Next.js, Supabase, Tailwind
The Problem: Insecure Document Delivery & Repetitive Inquiries
Private equity operations teams manage sensitive tax documents, capital calls, and financial statements. Before building this internal tool, managing LP communication over email created significant compliance and operational burdens:
Before the Internal Portal
- •Unsecured Tax Delivery: Schedule K-1s, quarterly financials, and bank wiring instructions were emailed as unencrypted attachments.
- •Repetitive LP Requests: Investors constantly emailed associates asking for historical statements, wire confirmations, and unfunded balances.
- •Manual Quarter-End Distribution: Administrators spent days manually splitting, naming, and emailing individualized PDF files.
With the Internal Portal
- •Encrypted Document Vault: Secure, watermarked storage for tax filings and quarterly reports with investor-specific permissions.
- •Self-Service Capital Accounts: LPs log in anytime to inspect committed capital, funded totals, unfunded amounts, and cash distributions.
- •Automated Routing: Fund administrators upload batch files once, and Supabase automatically routes documents to verified investor accounts.
Operations & Investor Requirements
Built to balance the operational velocity of fund administrators with the confidentiality demanded by institutional LPs:
Batch Document Routing
Upload hundreds of individualized investor statements in seconds with automated entity matching.
Multi-Entity Visibility
Inspect holdings across multiple family trusts, corporate entities, and retirement vehicles in one clean dashboard.
Audit Trail Integrity
Maintain tamper-evident logs of document views and downloads to verify tax and reporting compliance.
Valuation Maintenance
Update quarterly carrying values and valuation multiples across portfolio assets with instant performance recalculation.
Internal Tool Architecture & Sprint Process
A focused 4-week sprint from compliance and entity mapping to a secure production portal:
Audit & Requirements
Mapped compliance workflows, tax document distribution rules, and multi-entity investor structures.
Supabase Architecture
Built relational Postgres tables with row-level security to isolate LP entities and document access.
Internal Tool UX
Created the encrypted document vault, capital account tracking, and investment valuation tables.
Security Audit & Launch
Validated short-lived pre-signed storage tokens, watermarking, and audit access logs before deployment.
Fund Overview
High-level summary of committed capital, funded amounts, distributions to date, and portfolio asset allocation.
Key Architectural Decisions
Practical engineering decisions made to enforce bank-grade security and multi-entity accounting:
Multi-Entity Row-Level Security in Supabase
Investors frequently invest through separate family trusts, LLCs, and retirement accounts needing isolated statements under one login.
Engineered a many-to-many membership model in Supabase with RLS policies restricting queries to verified entity memberships.
Pre-Signed Storage Tokens for Tax Vault Files
Public or long-lived file links to confidential tax returns (Schedule K-1s) and quarterly letters risked data leaks.
Implemented short-lived pre-signed Supabase Storage URLs that expire in 15 minutes and log every download event.
Exact Numeric Storage for Capital Accounts
Standard floating-point numbers in browser JavaScript caused small penny rounding errors in capital call balances.
Stored all financial figures as high-precision numeric types in PostgreSQL and formatted values with fixed-point arithmetic.
Tamper-Evident Document Access Logging
Fund administrators required verified proof of document receipt to satisfy institutional LP compliance mandates.
Embedded dynamic viewer watermarks with timestamps and logged user ID, timestamp, and document ID on every view.
Tech Stack
A secure, modern architecture designed for multi-entity permissions and protected financial data:
Database & Security
Multi-entity row-level security and encrypted storage for tax filings.
Server Architecture
Generates short-lived file tokens and executes audited mutations.
Authentication & Vault
Two-factor login and pre-signed access tokens for document downloads.
User Interface
Clean, accessible financial tables with responsive desktop and tablet layouts.
Results & Impact
The internal tool streamlined operations, satisfied institutional compliance, and elevated investor confidence:
100% Secure Distribution
Eliminated unencrypted email attachments for all tax documents and quarterly reports.
80% Fewer Admin Inquiries
Self-service access to historical statements, unfunded balances, and wire details stopped repetitive emails.
Fast Quarter-End Delivery
Automated batch matching reduced document distribution from 3 days to under 30 minutes.
Auditable Compliance Trails
Complete records of investor document views and downloads satisfying institutional audit mandates.
Portfolio Investments
Comprehensive table of portfolio company investments with entry valuations, current carrying values, and MOIC.
Performance Summary
Historical performance metrics tracking net TVPI, DPI, RVPI, and annualized net IRR across fund vintages.
Cashflow Schedule
Audit trail of capital calls, distribution notices, funded wire verifications, and upcoming payment deadlines.
Ongoing Maintenance & Usability
Providing continuous security updates, multi-entity policy testing, query optimization, and quarterly statement support.
Planning Automated Capital Calls
Planning automated PDF notice generation and wiring schedule notifications triggered through Supabase database webhooks.
Gallery
All operational investor portal views developed for the platform. Click any view to inspect full size: