The Seventy-Five Percent Problem
In the family offices that steward the world's greatest fortunes, three-quarters of every working hour is spent not on thinking, but on typing.
Somewhere right now, at a single family office managing north of a billion dollars in diversified assets, a financial analyst is doing something that would strike an outside observer as deeply strange. She is not modeling a co-investment opportunity. She is not stress-testing the portfolio's exposure to rising tariffs. She is not reviewing the due diligence package for a Series B in an AI infrastructure company. She is logging into a custodian portal, downloading a CSV, opening Excel, and copying numbers into a spreadsheet she built three years ago that nobody else fully understands.
She will do this five more times today — once for each banking relationship — and by the time the data is consolidated, reconciled, and formatted into something her principal can read, two full working days will have passed. The numbers will already be stale. And on Monday, she will begin again.
This is not a failure of talent. It is a failure of architecture. And according to research from APQC, published by CFO.com, it is disturbingly normal: the average financial planning and analysis professional spends 75 percent of their time gathering data and administering processes, leaving just 25 percent for the value-added analysis that actually drives decisions. That ratio, remarkably, has barely moved in a decade. Between 2010 and 2019, the split shifted from roughly 77/23 to 75/25 — a two-percentage-point improvement in nine years.
For family offices, where teams are small, mandates are complex, and every hour of analytical bandwidth has outsized consequences, the implications of that ratio are not merely inefficient. They are strategic.
The most expensive spreadsheet in finance
To understand why this matters, you need to understand how a family office actually operates day to day — not the investment committee meeting or the quarterly review, but the grinding, invisible labor that precedes them.
A typical single family office manages assets across multiple custodians, private banks, fund administrators, and direct investment vehicles. Campden Wealth surveys have found that 40 percent of family offices express concern about their excessive reliance on spreadsheets, while 38 percent continue to aggregate financial data manually. The routine looks the same almost everywhere: log into portal, download statement, normalize format, paste into master workbook, cross-reference against the previous period, flag discrepancies, chase down explanations, update formulas, generate report. Repeat for every account, every entity, every trust structure.
The average family office, according to UBS research, maintains relationships with more than five financial institutions. Each speaks a different data language. Some deliver monthly PDFs. Others offer downloadable CSVs with idiosyncratic column headers. A few have APIs, though rarely ones that talk to each other. Stitching these into a coherent picture of the family's total wealth is a task that falls somewhere between data engineering and detective work, and in most offices, it falls on one or two people who have built a bespoke spreadsheet architecture that lives in their heads.
The risks here are both mundane and existential. Research on spreadsheet error rates — most prominently the work of Professor Raymond Panko at the University of Hawaii, widely cited in auditing and finance literature — has found that approximately 88 percent of spreadsheets contain at least one error. In a corporate context, a formula mistake might cause an embarrassing restatement. In a family office managing complex, illiquid, multi-jurisdictional holdings, a spreadsheet error can misstate net worth, miscalculate a capital call, misrepresent tax exposure, or obscure a concentration risk that only becomes visible when it's too late to unwind.
The compounding cost of lost time
There is a useful thought experiment for any family office principal willing to perform it honestly. Take the total number of hours your investment and operations team works in a given quarter. Apply the APQC ratio: three-quarters of that time goes to gathering, reconciling, formatting, and administering data. Now calculate what that time costs — not in salary alone, but in opportunity.
What decisions were not made because the analyst was reconciling custodian statements? What co-investment was not evaluated because the due diligence team was building a quarterly report from scratch? What risk was not identified because the CIO's attention was consumed by a data discrepancy rather than a portfolio question?
A McKinsey survey of finance leaders found that 41 percent of CFOs report that 25 percent or less of their processes are currently digitized or automated. In family offices, where teams are leaner and technology budgets are often an afterthought, the figure is almost certainly worse. The J.P. Morgan 2026 Global Family Office Report — surveying 333 single family offices with an average net worth of $1.6 billion — found that technology platforms and cybersecurity have become top service needs. But desire and implementation are not the same thing. The gap between the two is where the compounding cost lives.
Consider one illustrative calculation. If a family office employs five investment and operations professionals, and the APQC ratio holds, the equivalent of 3.75 full-time employees are engaged in data administration at any given time. That is not a back-office problem. That is the majority of the institution's intellectual capacity being consumed by work that creates no insight, generates no return, and is functionally identical to what a properly configured technology platform could accomplish in minutes. The remaining 1.25-person equivalent is doing the actual thinking — the portfolio construction, the risk assessment, the strategic planning — that justifies the family office's existence.
Put differently: the family office is paying for five brains but using one and a quarter.
Why nothing changes (until it does)
The persistence of this problem is itself informative. Family offices are not lacking in intelligence, resources, or awareness. Many principals understand, at least in the abstract, that their operations are inefficient. So why does the spreadsheet endure?
Three forces conspire to maintain the status quo.
The first is familiarity compounded by customization. Every family office's spreadsheet architecture is, by definition, bespoke. It has been built over years to reflect the specific structures, entities, reporting preferences, and idiosyncrasies of that particular family. Replacing it means not just adopting new software, but reverse-engineering institutional knowledge that often exists only in one person's head. The switching cost feels enormous — even when the ongoing cost of not switching is demonstrably larger.
The second is the invisibility of the loss. Operational drag does not appear on any statement. There is no line item for "hours spent copying numbers between systems" or "decisions deferred because the data wasn't ready." The cost is real but diffuse, spread across every quarter in the form of slightly slower decision-making, slightly less rigorous risk oversight, and slightly fewer opportunities evaluated. It compounds the way all invisible costs do: quietly, until the cumulative deficit becomes obvious only in retrospect.
The third is a cultural assumption that the back office is a cost center to be minimized rather than an engine to be optimized. In many family offices, the technology conversation begins and ends with "what's the cheapest way to keep the lights on?" This framing ensures that operational infrastructure never receives the same strategic attention as, say, a co-investment opportunity or a new fund allocation — even though the infrastructure determines how effectively those investments are managed once they're made.
The next generation won't wait
There is a force, however, that is more powerful than any of these: generational change.
The great wealth transfer — the largest intergenerational movement of capital in human history — is accelerating. RBC and Campden Wealth's 2025 report found that 60 percent of family offices anticipate the transition of wealth from one generation to the next within the coming decade. The next-generation leaders inheriting these institutions have, by and large, grown up with technology that works. They manage personal finances on mobile apps that update in real time. They consume information through dashboards, not documents. They expect the same fluency from their family office that they get from their brokerage app.
This is not merely a preference. It is a standard. And it is already reshaping the industry. RBC and Campden Wealth found that three times more family offices are leveraging AI to improve operations in 2025 compared to the prior year. Next-generation members are driving demand for greater transparency, real-time reporting, and technology infrastructure that can match the growing complexity of the portfolio.
The offices that cannot meet this standard face a problem that goes beyond inefficiency. They face irrelevance. A next-generation principal who inherits a billion-dollar portfolio and discovers that the "reporting system" is a collection of spreadsheets maintained by a single employee who is planning to retire will not invest in upgrading that system. They will replace it entirely — along with, in many cases, the advisors who tolerated it.
What reclaiming the seventy-five percent looks like
The corrective is not a single technology purchase. It is a reorientation of how a family office thinks about the relationship between its people and its processes.
The goal is not to eliminate human judgment. It is to redirect it. If the APQC ratio can be inverted — if even half the time currently consumed by data administration can be reclaimed for analysis — the effect on a lean family office team is transformative. Two and a half additional person-equivalents of analytical capacity, without hiring a single new employee.
This begins with automated data aggregation: platforms that connect directly to custodians, banks, and fund administrators, normalizing data as it arrives and presenting it in a unified view. The technology is mature. It has been deployed at scale by institutional investors, endowments, and the larger multi-family offices for years. The barrier for single family offices has historically been cost and complexity, but both have dropped substantially as the market for family office technology has matured.
It extends to reporting automation: replacing the quarterly PDF assembly line with configurable dashboards that update continuously and can be sliced by entity, asset class, geography, or any other dimension the principal or investment committee requires. The shift from static reports to dynamic visibility is not cosmetic. It changes the cadence of decision-making from periodic to continuous — from "what happened last quarter" to "what is happening now."
And it culminates in what might be called analytical liberation: freeing the people who were hired for their investment acumen, their risk instinct, their strategic vision, to actually do the work they were hired to do. Not more people. The same people, doing better work, because the machinery around them is finally adequate to the task.
The real asset
There is an irony at the heart of the seventy-five percent problem that deserves to be named. Family offices exist to preserve and grow wealth across generations — a mandate measured in decades, not quarters. Their competitive advantage over every other form of institutional capital is patience, flexibility, and the ability to think long-term. And yet the majority of their daily bandwidth is consumed by the shortest-term, most repetitive, least strategic work imaginable.
The family offices that recognize this — and act on it — will not merely become more efficient. They will become fundamentally different institutions: faster in their analysis, broader in their opportunity evaluation, more rigorous in their risk management, and more resilient across the generational transitions that will define the next two decades of private wealth.
The ones that don't will continue to pay the seventy-five percent tax. They will pay it in hours that could have been spent on strategy. In decisions that were made too slowly, or not at all. In talent that left for institutions where the tools matched the ambition. And in the quiet, compounding erosion of an edge that was never lost in the market, but surrendered, one spreadsheet at a time, to the back office.
This is the second installment of The Prominent Blog, a biweekly series on the convergence of capital strategy and operational technology in the family office sector.
Sources and verification notes:
All statistics cited in this article are drawn from identified, published sources:
APQC research via CFO.com: FP&A professionals spend 75% of time on data gathering (confirmed in APQC's Planning and Management Accounting Performance Assessment; published CFO.com, October 2021; ratio tracked from 77% in 2010 to 75% in 2019 per Vena Solutions)
Campden Wealth surveys: 40% of family offices concerned about spreadsheet reliance; 38% still manually aggregate financial data (cited in multiple Campden Wealth annual reports; confirmed by Eleven Systems and Copia Wealth Studios)
UBS Global Family Office Report 2025: average family office works with more than five financial institutions (cited by Landytech, sourced from UBS 2025 GFO Report)
Professor Raymond Panko, University of Hawaii: ~88% of spreadsheets contain errors (peer-reviewed research widely cited in auditing and finance literature)
McKinsey 2024: 41% of CFOs report 25% or less of processes digitized/automated (cited in Cube Software's FP&A statistics compilation, sourced to McKinsey)
J.P. Morgan Private Bank 2026 Global Family Office Report: 333 SFOs, average net worth $1.6B, technology and cybersecurity as top service needs
RBC and Campden Wealth, North America Family Office Report 2025: 3x increase in AI adoption for operations year-over-year; 60% anticipate generational wealth transfer within the decade
