An AI buildout for the investment office
Endowments · Foundations · Family offices

Institutional AI, reimagined.

The investment function of an institution on one clean layer of data, with the tools that run on top of it. AI does the gathering, cleaning and drafting. People make the calls.

Live sample · asset allocation
dashboards / asset-allocation
Asset allocation dashboard with illustrative data
41/44
Reconciled overnight3 breaks routed with a root cause
!
Capital call due Mar 17caught from a portal notice
06:45
Rebuilt this morningfrom the custody file
20investment office functions mapped
12working tools, each with a live sample
1clean record underneath all of them
100%of decisions still made by people
What this is

Everything the office receives lands in one place. It becomes one record. Every tool reads from that record, and people decide what to do with it.

The problem
The problem

The data is everywhere.
None of it agrees.

Too many sources.

Custodian files, manager statements, portals, legal documents and an inbox full of notices. Each in its own format.

Systems that don't match.

The custodian, the general ledger and the portfolio system all describe the same holding differently.

Rebuilt by hand.

Every month someone exports, cleans and re‑keys the same spreadsheet, and hopes nothing changed.

The manual version
How it fits together

One layer underneath.
Every tool on top.

Inputs become one record. The record feeds every tool. The tools feed the decisions, and the decisions stay with people.

Inputs
Custodian filesPositions, transactions
Manager reportingNAV, K‑1s, notices
Legal documentsLPAs, side letters
Email & portalsCalls, distributions, fees
Notes & newsMeetings, summaries
PolicyIPS, spending, obligations
↓
The layer everything runs onThe Brain
IndexedTaggedSearchableAI‑connected

Ask once, answered from every document the office has ever read.

↓
The record
ABOR

Custodian and accounting. What the statements say.

NIB

Not‑in‑bank assets. Commitments, direct holdings, side pockets.

→
IBOR

Investment book of record. Both sources consolidated into one working view. What you actually hold today, and the layer portfolio management and risk run on.

→
Accounting

General ledger and reporting. The reconciled record the books, the audit and tax reporting run on.

↓
What runs on top of it
↓
Investment memos & IC reportsAssembled data, your inputs, your call
Dashboards & data aggregationOne refreshed view, off the same record
Performance reportsReturns, benchmarks, attribution
ALWAYSHuman judgement & decision making
Worked example
Worked example

From a raw custody file
to a committee‑ready dashboard.

Five steps. The dashboard is the easy part. The clean data underneath is what makes every tool after it fast.

01
Get the file in

A scheduled download or the email the custodian already sends. MCP where a vendor offers it.

/custody/daily/
02
Map and fix

Every field mapped to one master file. Formats cleaned, gaps flagged, every change versioned. Anything new waits for approval.

mapping v1.14
03
Cut it down

147 columns become the 12 people actually use.

147 → 12
04
Visualize

Rebuilt every morning. Allocation against policy, plus look‑through for equity, fixed income and alternatives.

06:45 daily
05
Build on top

Cash forecasts, reconciliation, fee forecasts, drift alerts. All reading the same clean data.

same data
MCPRare for custodians
Scheduled downloadMost common
EmailWorks fine
147FIELDS
Landing folder
/custody/daily/2026-10-06/
  • positions.csv✓
  • transactions.csv✓
  • cash_activity.csv✓
SEC_DESC_1LATTICE CORE 500 INDX ETF→Lattice Core 500 Index ETF
ASSET_TYP_CDEQ-ETF→Equity › US large cap
MV_BASE277265780.4→$277,265,780.40
PRICE_DT06OCT26→2026‑10‑06
MV_BASE(see stmt)→Flagged for review
Master mapping file
v1.14Oct 6Harlow Muni → Fixed income
v1.13Sep 29Sweep vehicle → Cash
v1.12Sep 18New account 88‑122
AccountSecurityAsset classSub‑classQuantityPricePrice dateMarket value% of totalCurrencySourceStatus
SecurityClassValue%
Lattice Core 500 Index ETFEquity$277,265,78023.5%
Camden Holdings Cl BEquity$98,364,8008.3%
Harlow Municipal Bond FundFixed income$22,450,8871.9%
Cedar Ridge Partners IVAlternatives$38,620,0003.3%
Meridian Govt Obligations MMFCash$8,904,5510.8%
312 holdings · ties to custodian ✓$1.18B
.../equity
.../fixed-income
.../alternatives
Cash forecastThe month it goes tight, before it does
Recon to accountingCustody vs. GL, only true breaks
Fund look‑throughWhat you actually own, by issuer
Drift alertsA ping when a policy band breaks
Fee forecastWhat you'll pay, by month
Committee packSame numbers, no re‑keying
DashboardStep 4
Clean data + master mappingSteps 2 and 3
Custody fileStep 1
The tools
The tools

Twelve working tools.
Open any one.

Each one was built with AI against a real workflow, then rebuilt here with invented data. Open a tool for screenshots or the live sample.

What's next
What's next

The rest of the office,
on the same record.

Mapped, not built yet. Each one runs on the same layer as the tools above.

Always

Human judgement
and decision making.

AI gathers, cleans, checks and drafts. It doesn't approve, commit or sign.

  • New mappings wait for a person.Nothing enters the master file without approval.
  • Every figure is traceable.Back to the document, the page and the file it came from.
  • Recommendations are drafts.The investment committee makes the call.