Sextant - Multi-Custodian Portfolio Reporting with Advisor-Reviewed AI Commentary
Portfolio Reporting Platform for a US Investment Adviser
Designed and built a clickable portfolio reporting platform for a Denver investment adviser with client assets at three custodians: daily reconciliation against custodian files, household views with performance gross and net of fees, and quarterly AI commentary that may only cite engine numbers and needs advisor and compliance sign-off.
Most of our work is under NDA. Per agreement, we can share the work but not the company details - all names and identifying information shown here have been changed.
Impact
Dashboard, reconciliation, households, household detail with 7 tabs and the commentary editor. Each of the 24 demo households opens its own detail page, and 12 commentary drafts open in the editor.
The advisor submits and compliance approves or requests changes with a comment. Submit stays disabled while a blocking guardrail flag is open or the draft is outside 150 to 350 words.
12 position, 4 cash, 3 transaction and 3 cost basis breaks, each with Sextant's value, the custodian's value, the likely cause and a suggested fix. Price differences under the 0.5% client tolerance stay off the list.
24 households at Schwab, Fidelity and Pershing plus held-away accounts, 18 securities including two private funds, 4 benchmarks, 12 commentary drafts and 11 staff users across 7 roles.
The Problem
Whitlock Ridge's operations team stitched three custodian downloads together in spreadsheets every morning, and household totals were wrong whenever a transfer between custodians was in flight. Quarterly reports took four people about three weeks, including 640 market commentaries written by hand. Compliance reviewed a sample at the end with no record of which numbers the commentary was based on, and fees were billed from a separate spreadsheet.
Our Solution
Sextant loads each custodian's daily files, reconciles positions, cash, transactions and cost basis, and groups accounts into households with time-weighted and money-weighted returns, gross and net of fees, against a policy benchmark. AI drafts each household's quarterly commentary from a fixed set of facts, the advisor edits it against firm guardrails, and compliance approves it before release.
The Challenge: One Set of Numbers for Clients, Fees and Compliance
Whitlock Ridge is an SEC-registered investment adviser managing about $2.4 billion for roughly 640 households, with assets at three qualified custodians plus private funds that no custodian reports on. Every number a client sees has to agree with the custodian, the fee bill and the record compliance keeps.
Three Custodians, One Household
Schwab, Fidelity and Pershing each send their own daily files on their own schedule. A transfer in flight, a late trade or a pending corporate action makes the two sides disagree, and performance cannot be trusted until those breaks are cleared.
Gross and Net Shown Fairly
Under the SEC Marketing Rule, any advertisement that shows gross performance must show net with equal prominence. A client's own report is generally not an advertisement, but the same numbers reused in a pitch book are, so every output has to be marked for client communication or marketing use.
AI Drafts Held to Adviser Standards
The SEC expects communications to be fair and balanced whoever drafts them. An AI commentary cannot predict returns, promise results, quote a gross return without net or slip in a number the performance engine never produced.
Records That Prove Every Number
Advisers generally keep required records for five years, including what supports any performance shown. Each issued report, its data snapshot, every commentary version and each approval has to be kept, and the custody rule calls for a legend asking clients to compare reports with custodian statements.
Our Approach: From Adviser Rules to a Clickable Platform
Spec and Rules Research
Mapped 8 roles from operations analyst to chief compliance officer and the client, 45 screens (38 for staff and 7 in a mobile-first client portal) and the data model for custodian files, accounts, households, securities, performance results, report runs, commentary versions and fee schedules. Wrote down the rules the design follows: the Investment Advisers Act of 1940, the Marketing Rule, the custody rule, Form ADV, the books and records rule, Regulation S-P and GIPS-style return methods.
Clickable Demo on a Production UI Kit
Built 5 key screens on a production dashboard kit: the dashboard with KPIs, a feed status strip per custodian and AUM over 24 months, reconciliation with filters, bulk assign and a break panel, households with a quick view, household detail with allocation drift, performance, holdings look-through and billing, and the commentary editor with fact-linked numbers, guardrail flags, version history and a diff. All actions run on local state.
What a Production Build Adds
Custodian data feeds from Schwab, Fidelity and Pershing, held-away aggregation (such as Morningstar ByAllAccounts or Plaid), a security master and licensed benchmark returns, private fund document extraction, a hosted language model for drafting, Okta or Auth0 sign-in with MFA, DocuSign, and email delivery with communications archiving. Role-based access, an audit trail of data views and exports, and the remaining screens: feeds, securities, alternatives, analytics, templates, report runs, billing, compliance and the client portal.
Why It Works: Every Number Traces to a Source
Commentary Cites Only Facts
The editor puts the facts the draft may use on the left, each with its source such as the engine run or data snapshot. Numbers in the draft are linked to those facts, and a number typed by hand that matches none is underlined red and blocks submit.
Guardrail Flags Explain Themselves
Each flag names the rule, such as a prediction or unbalanced language, and offers suggested wording. The advisor applies it or writes an explanation, and blocking flags have to be cleared before the draft can go to compliance.
Data Health Before Performance
Every page shows the latest fully reconciled date, the dashboard shows each custodian's file time and rejected records, and breaks older than 3 business days rise to Needs attention. The firm composite is labelled internal and not for marketing use.
Fees From the Same Values
The billing tab calculates the tiered fee on the household's reported value with accounts combined for breakpoints. The Alvarez Family's $6,842,300 on the Standard schedule comes to $36,869 a year or $9,217 a quarter, with the effective rate and how each quarter was collected.
Related case studies
View all: Wealth & investing
Waymark - Advisor Portal with Suitability Reports Built From the Case
Designed and built a clickable advisor portal for a UK wealth firm's financial planners: a daily home with reviews due and alerts, a segmented client book, a Client 360 for every household, an advice case board and a suitability report builder that will not issue a report until the checks and approvals are in place.
Kinfold - Family Office Platform with Look-Through Net Worth Across Trusts and Companies
Designed and built a clickable family office platform for a Hong Kong single family office serving a three-generation family: one look-through net worth in HKD across trusts, holding companies and banks in six jurisdictions, an ownership map, an asset register with valuation ages, and a capital call calendar with four-eyes payment approval.
Enterprise Software Engineering - Human + AI
Contact Us
© 2026 - Copyright. All Rights reserved Oceanlab
Location
Global Headquarters
21 Merchant Road, 3rd Floor, Singapore 058267
Main corporate office and leadership operations
North America Office
548 Market Street, PMB 12345, San Francisco, CA 94104
Client operations and business development
India Office
402 Shivalik Shilp II, SG Highway, Ahmedabad 380015
Engineering and delivery center
Enterprise Software Engineering - Human + AI
Contact Us
Locations
Global Headquarters
21 Merchant Road, 3rd Floor, Singapore 058267
Main corporate office and leadership operations
North America Office
548 Market Street, PMB 12345, San Francisco, CA 94104
Client operations and business development
India Office
402 Shivalik Shilp II, SG Highway, Ahmedabad 380015
Engineering and delivery center
© 2026 - Copyright. All Rights reserved Oceanlab