AI Won't Save Your Family Office. Clean Data Will.

Partner content by Dean Palmiter, Founder and CEO of Asseta.

I was at a family office conference last year and I lost count of how many times I heard the word "AI." AI was in every panel title. Every vendor booth. Every cocktail conversation. AI for portfolio analytics. AI for tax optimization. AI for document processing. AI for risk modeling. You couldn't walk ten feet without someone telling you that artificial intelligence was about to transform the way family offices operate.

And look, they're not wrong. AI is going to change this industry. It already is.

According to the latest data, family offices are three times more likely to use AI for operations today than they were just a year ago (Goldman Sachs GFO Report 2025). Over half of family offices globally have invested in generative AI in some form. The momentum is real.

But here's what nobody at that conference wanted to talk about: most family offices aren't ready for AI. Not because they lack the budget. Not because they lack interest. 

Because their data is a mess. AI built on messy data doesn't give you intelligence. 

It gives you confident-sounding nonsense at scale.

I've spent the better part of a decade working with family offices. I was first selling accounting software at Oracle NetSuite and later Sage Intacct, and now I’ve transitioned to building technology directly  for them. I’ve dedicated my time to doing this because  the single most consistent thing I've seen, across offices managing $200 million and offices managing $5 billion, is that the data layer is broken.

Not broken in some dramatic, catastrophic way. Broken in the quiet, slow way that nobody notices until they need to actually rely on it.​

​Here's what broken looks like in practice: A family office has entities in QuickBooks, entities in NetSuite, and a couple that are still tracked in Excel. Their custodian sends monthly statements in PDF. Their private equity fund administrators use three different reporting formats. Their real estate holdings are tracked in a shared drive somewhere, maybe in a workbook the controller built four years ago. Their banking data comes from five different institutions, each with its own portal and its own way of categorizing transactions.

None of these systems talk to each other. The chart of accounts is different across every platform. The entity naming conventions don't match. Transaction categories that mean one thing in QuickBooks mean something slightly different in the custodian report.

And sitting in the middle of all of it is a human being, usually one human being, manually pulling data from a dozen sources, reconciling it in a spreadsheet, and producing a consolidated view that everyone treats as gospel.

That process works. Sort of. Until you try to put AI on top of it.

This is the part of the conversation the AI vendors skip. They show you the demo. 

The demo is always beautiful. Clean dashboards, natural language queries, instant insights. "Ask your portfolio a question and get an answer in seconds." It looks like magic.

But the demo runs on clean data. Demo data. 

Perfectly structured, perfectly labeled, perfectly normalized data that somebody spent weeks preparing. It's the equivalent of test-driving a sports car on a freshly paved track and then taking it home to a dirt road full of potholes.

When you point that same AI at the actual data environment of a typical family office, what happens? 

It hallucinates. It double-counts. It misclassifies. It produces answers that look authoritative but are quietly wrong, because the inputs were inconsistent and the system has no way of knowing that.

I talked to a family office last year that had piloted an AI reporting tool. They were excited about it, and they fed it their data and asked it to produce a consolidated net worth statement. 

The number came back $40 million higher than their internal figure.  

After two weeks of digging, they traced the discrepancy to a handful of entities that were named differently across two systems. The AI treated them as separate holdings and counted them twice. Nobody caught it right away because the output looked polished and professional.

That's the danger. 

What would have happened if they reported that $40 million dollar number?

Bad data with no AI gives you slow, manual, frustrating work. Bad data with AI gives you fast, automated, wrong answers that look right. 

And in a family office context, where you're making decisions about estate planning, tax strategy, investment allocations, and generational wealth transfer, wrong answers that look right can be catastrophic.

I'm not the only one saying this. The PEX Report for 2025-2026 found that 52% of organizations cited data quality and availability as the single biggest barrier to AI adoption. Not cost. Not talent. Not regulatory concerns. 

Data quality. 

More than half of the people trying to use AI said the data itself was the problem.

In family offices specifically, the challenge is even more acute. These are organizations where 45 to 50 percent of the portfolio is now in private markets, which means the data is inherently harder to aggregate. There are no standardized feeds from private equity GPs the way there are from public custodians. Every fund admin reports differently. Every GP has their own format for capital call notices, distribution statements, and K-1s. And most family offices are working with more than a dozen external data sources, each with its own structure and cadence.

Layer on top of that the entity complexity. A typical family office might have twenty, thirty, sometimes fifty or more entities: LLCs, trusts, holding companies, foundations, personal accounts. Each one has its own books. Each one may be on a different system. And the relationships between them, the intercompany transactions, the ownership chains, the consolidation logic, often exist only in someone's head or in a spreadsheet that hasn't been audited in years.

if this is the data environment that AI is supposed to transform, good luck.

The current narrative in family office technology goes something like this: adopt AI, and it will solve your operational problems. Better reporting, faster workflows, real-time portfolio visibility. The pitch is seductive, and I understand why people are buying it.

But the narrative has it exactly backwards.

You can't automate reporting if the underlying data is inconsistent. You can't streamline workflows if every entity lives on a different system with a different chart of accounts. You can't get real-time portfolio insight if half your positions are tracked in spreadsheets that get updated quarterly, when someone remembers.

AI is not the starting point, it's the capstone. It's the thing you earn the right to use after you've done the hard, unglamorous work of getting your data house in order.

And that work is not exciting: nobody goes to a conference to hear someone talk about chart of accounts harmonization or multi-entity data normalization. There's no keynote about the importance of consistent entity naming conventions. It's boring. It's tedious. It's the financial equivalent of cleaning your garage before you install a home theater system.

But it's the only thing that makes the home theater system actually work.

When I say "clean data,"what I mean is a single, unified data layer where every entity, every account, every transaction lives in one place with consistent structure. A general ledger that can handle multi-entity consolidation natively, not through manual workarounds. A system where the chart of accounts is standardized, where entity relationships are documented and maintained, where intercompany transactions are tracked automatically, and where the consolidation logic isn't dependent on one person's memory.​

​Clean data means that when someone asks "what is the family's net worth," the answer comes from a system, not from a three-week exercise in spreadsheet archaeology. It means that when the next generation takes over, they inherit a structured, documented, auditable financial picture, not a jigsaw puzzle with missing pieces.

And yes, clean data means that when you do deploy AI, it actually works. Because the inputs are reliable. Because the structure is consistent. Because the AI has something real to learn from.

Here's what I'd say to any family office that's evaluating AI tools right now: before you spend another dollar on AI, ask yourself one question. If I pulled up my consolidated financial picture today, right now, how confident am I that every number is correct?

Not roughly correct. Not directionally correct. Actually correct.

If you hesitate, that's your answer. And no AI tool in the world is going to fix that hesitation. Only your data layer can.

I know this isn't what people want to hear. AI is exciting. Clean data is not. AI sounds like the future. Clean data sounds like homework. But every family office that has successfully deployed AI, and I've talked to enough of them to know that they will tell you the same thing: the AI part was easy. Getting the data ready was the real project.

I'll be honest about my bias here. I started a company, Asseta, with my co-founder Daniel Kennedy because we believed that the data and intelligence infrastructure layer for family offices was fundamentally broken and that nobody was building the right solution for it. We spent years watching family offices struggle with fragmented systems, and we decided to build a purpose-built platform to fix it.

But my bias doesn't change the underlying reality. Whether you use our product or someone else's or you figure it out internally, the math is the same. AI on top of bad data produces bad results. AI on top of clean data produces something genuinely useful.

The family offices that figure this out first, the ones willing to do the boring foundational work before chasing the shiny new thing, will be the ones that actually get value from AI. The rest will spend a lot of money on tools that produce beautiful dashboards full of numbers they can't trust.

The family offices that get the most out of AI will be the ones that invested in clean data before they invested in AI. You can't run a race car on an unpaved road - no matter how good the engine is.

-

Dean Palmiter is the CEO and Founder of Asseta AI, a purpose-built accounting and data platform for family offices. Before founding Asseta, he spent nearly a decade selling enterprise software to single-family offices at Oracle NetSuite and Sage Intacct. He lives in New York.