PSI SQUARE • case study • ai agents & custom software

AI-Powered Fund Manager SaaS Dashboard

A Next.js SaaS platform built for a fund manager — live portfolio data feeds, AI-generated performance summaries, and investor reporting automation. Monthly reporting time cut from 8 hours to 20 minutes. Built and delivered to production within 6 weeks.

Next.jsSupabaseOpenAI APITypeScriptVercelSaaS
THE CHALLENGE

The challenge

A fund manager overseeing multiple portfolios was spending 8+ hours every month manually compiling performance data from disparate sources into investor reports. Positions were tracked in spreadsheets, data feeds were pulled manually from broker APIs, and summary narratives were written from scratch each reporting cycle. The process was slow, error-prone, and not scalable as the number of investor accounts grew.

Key Project Constraints & Requirements

Multi-Source Data Ingestion

Unified live portfolio and P&L data from multiple broker APIs and data feeds into a single view

Natural AI Performance Narrative

AI-generated executive summary that reads naturally with bespoke fund tone, avoiding generic templates

One-Click Report Export

Investor-ready PDF generation rendered on-demand complete with charts, metrics, and narrative commentary

Role-Based Multi-Tenancy

Multi-user access separating full manager admin privileges from secure, read-only investor portals

Self-Sustaining Operations

Fully hosted and automated infrastructure that runs reliably without daily developer involvement

THE SOLUTION

The solution

PSI Square built a multi-tenant Next.js SaaS platform with three integrated layers: live data ingestion, AI narrative generation, and investor-ready report export.

Data Pipeline

Data Ingestion & Normalisation Layer

Server-side data pipeline pulling live position and P&L data from broker APIs into Supabase on a configurable refresh interval. Normalised across multiple account types and base currencies into a single unified portfolio view.

OpenAI GPT-4o

AI Narrative & Reporting Layer

OpenAI API integration: each reporting cycle, the platform compiles portfolio metrics into a structured prompt and generates a natural-language performance summary tailored to the fund's reporting tone. Manager reviews and edits the AI draft in an inline editor before publishing — AI handles the first draft, human approves the final.

Client Experience

Investor Portal & Export Engine

Role-based access: fund manager sees full admin view; investors see only their own portfolio slice and published reports. Features one-click PDF export of the full report including interactive charts, AI narrative, and period performance tables.

THE ARCHITECTURE

Technical architecture

System architecture specifications encompassing Next.js server components, OpenAI model routing, and workspace isolation.

Framework
Next.js (App Router, server components)
Database
Supabase (Postgres + real-time subscriptions)
AI Layer
OpenAI API — GPT-4o for narrative generation
Auth
Supabase Auth with role-based access control (RBAC)
Data Ingestion
Server-side broker API polling — configurable interval
Report Export
PDF generation via server-side rendering pipeline
Hosting
Vercel Edge Network
Multi-Tenancy
Workspace-per-fund isolation model
VERIFIED OUTCOME

Verified outcome

Measurable productivity improvements and operational efficiency verified across multiple fund reporting cycles.

8 hrs → 20 min
Monthly reporting time
96% reduction in compilation overhead
6 weeks
Scoping to production deployment
Full platform build, API integration & QA
Zero manual entry
Fully automated data pipeline
Real-time broker synchronization

Operational Automation & Workflow Acceleration

Monthly reporting time dropped from over 8 hours to under 20 minutes per cycle. The AI draft handles the narrative, the automated pipeline handles the data, and the manager's time is now spent reviewing and approving rather than compiling. The platform has since been expanded to cover additional fund accounts without any structural changes to the codebase.

GET IN TOUCH

Ready to build your platform?

Whether you need an AI-powered SaaS or a custom internal tool — tell us what you're building. We'll scope it, design it and deliver it to production standard. Most projects start within 5 business days.

Or email info@psi-square.net · Phone +44 (0) 20 3872 7195 · We reply within 24 hours · NDA available on request