A book of record replaces the spreadsheet pack

The client is a family investment office in the Gulf. Its capital sits across public equities and fixed income held at custodian banks in several jurisdictions, stakes in private equity and venture funds, direct company holdings, and real estate. For years the operations team ran everything on spreadsheets. Analysts downloaded custodian statements, rekeyed positions into workbooks, and assembled a reporting pack for the principals and the investment committee every month.

The model broke as the portfolio grew more private. Fund commitments multiplied, each with its own administrator, statement format, and capital call schedule. Custodian data arrived in incompatible formats, corrections landed weeks after month end, and formulas drifted every time a workbook was copied forward. Close stretched later into the month, capital call deadlines were tracked in inboxes, and when the investment committee asked an exposure question, the answer depended on who had built the spreadsheet.

Kentro was engaged to build a portfolio operations platform: a consolidated book of record across every custodian and asset class, automated reconciliation, exposure and performance views, structured capital call and distribution workflows, and investor reporting generated from the ledger instead of assembled by hand.

The operating model that had worked for a simpler portfolio was failing quietly, in ways that only surfaced at month end.

• Fragmented custody data.: Each custodian delivered holdings and cash in its own format, on its own schedule, with its own identifiers. Nothing consolidated without a person in the middle.
• A handmade reporting pack.: The monthly pack was assembled by copying workbooks forward. Formulas drifted, versions forked, and no record existed of who changed what.
• Private markets in inboxes.: Capital call notices, distribution advices, and commitment terms lived in email threads and shared folders. Unfunded exposure was only truly known when administrators sent quarterly statements.
• No answer the whole team trusted.: Exposure and performance questions took days to answer, and the answer changed depending on which spreadsheet produced it.

Kentro built the platform around an investment book of record, the pattern institutional asset managers run on. Every custodian feed, administrator statement, and manual entry lands in a normalization layer and posts to an event-sourced ledger. Everything the team sees, from exposure dashboards to investor reports, is a projection of that ledger.

• Custodian and administrator ingestion.: Scheduled pipelines pull SWIFT MT535 and MT536 securities statements, ISO 20022 camt cash messages, and CSV extracts over SFTP from each custodian. Administrator statements that arrive as PDFs pass through document extraction with human review before posting.
• A canonical security master.: Every instrument resolves to a canonical record keyed on ISIN and FIGI identifiers, with fund stakes, direct holdings, and real assets modeled alongside listed securities. FX rates from a market data feed consolidate multi-currency positions into a base-currency view.
• An event-sourced, bitemporal ledger.: Transactions post to a double-entry book of record that stores both when an event happened and when the office learned of it. Late custodian corrections restate as-of views without overwriting history, which is what makes audits and performance restatements safe.
• Automated reconciliation.: The engine matches positions and cash against custodian records on every statement cycle, applies configurable tolerances, and routes unmatched items to a break queue with ownership and ageing. Analysts work exceptions instead of comparing spreadsheets line by line.
• Private markets workflows and reporting.: Commitments, capital calls, and distributions run through structured capture with maker-checker approval, deadline tracking, and unfunded commitments shown against available liquidity. Time-weighted and money-weighted performance, look-through exposure views, and investor reports generate directly from the ledger, behind OIDC single sign-on with role-based entitlements and full audit logging.

The office now runs portfolio operations from the ledger, not from workbooks.

• The spreadsheet pack retired.: Investor and committee reports generate from the book of record on a schedule. Analysts spend month end reviewing reconciliation breaks instead of rekeying statements.
• Exposure questions answered the day they are asked.: Look-through views by asset class, currency, and geography come from the platform, and everyone reads the same figures.
• Capital calls under control.: Calls and distributions move through an approval workflow with visible deadlines, and unfunded commitments sit next to available liquidity instead of in a folder of notices.
• Audit-ready by construction.: Every reported figure traces back to source transactions, and every correction is preserved with its history. Review conversations moved from data provenance to the investment decisions themselves.