Family Office Technology Hub

Owning the Truth: How Family Offices Turn Data into Power

Jan 25, 2026
Vivecca Hartman, Principal and Controller at a multi-generational family office, CPA with deep accounting and tax control experience. Matthew Espinosa, Senior operations manager who centralized data on Salesforce and automated workflows. They discuss keeping the right systems while owning your data. They cover standardising private investment entries, using APIs, Power BI and data warehouses, and why centralising data beats buying more apps.
Ask episode
AI Snips
Chapters
Transcript
Episode notes
ADVICE

Standardize Private Investment Transactions

  • Do standardize private investment transaction entry with templates to remove variability between accountants and the complexity of APX.
  • Fayez Sarofim built a transaction template and review points so entries are uniform and partly automated, reducing errors.
INSIGHT

Power BI Reveals Investment Lifecycle

  • Power BI turned disparate APX reports and scattered Excel schedules into a single place for lifecycle visibility of investments.
  • With structured inputs in APX, Power BI enabled drilldown to security-level activity and weekly validation outside period-end reconciliations.
ANECDOTE

Centralizing Spreadsheets Into Salesforce

  • Matthew reused an existing Salesforce instance as a centralized database to replace fragmented spreadsheets across teams.
  • He related assets, families, houses, investments, and LLCs so every object could be cross-referenced and shared firmwide.
Get the Snipd Podcast app to discover more snips from this episode
Get the app