Family Offices

Data enrichment: Helping family offices make informed decisions

Data-enrichment_transparent

Ultra-high-net-worth (UHNW) families typically have a plethora of accounts, portfolios, trusts and managers. Yet not having a complete picture of their holdings can cause them frustration. In light of this, they are increasingly turning to their family offices to deliver the consolidated reporting that will provide the visibility they desire.

Enrichment is an important element of the consolidated reporting process. This is because it adds colour and granularity to the raw data that the family office sources from its custodians and stores in its database. It does this by appending to the raw data descriptive metadata from secondary sources.

So, what should your family office know about enrichment?

1. Enrichment is a very broad term

Some custodians offer nothing more than basic data on assets and liabilities, their valuations, and any transactions that have occurred. Others may include a few additional data points – such as names, some descriptions, a country or currency – but granularity is limited.

Where custodians do provide a degree of colour around the raw data, in many cases it will be subject to fair usage policies that prohibit users from programmatically extracting data fields from the files. So, while the custodian file may feature information such as sectors and ratings, users are only allowed to look at it, not process it automatically.

Nevertheless, enrichment can be used to bring in prices, volumes, volume-weighted average prices, market capitalisations and sector information, along with some more sophisticated datasets.

2. It is usually expensive

Enriching data is costly. Some relatively open-source providers exist, but their datasets are limited. Using the big-data vendors with strong market and instrument coverage is expensive, with the most basic licensing packages starting at around $50,000 to $60,000 a year.

3. Licence terms and conditions can be prohibitive

Understanding what users are permitted to do with the data can get complicated. The licence terms and conditions typically prohibit any programmatic transformations and external reporting of the data. That means a family office will be prevented from incorporating the vendor’s data in any reports it wants to make available to its families or third parties. Furthermore, the family office is not allowed to store that data – or any calculations derived from it – in its database, creating a massive problem for producing downstream consolidated reporting.

Pricing is a case in point. If a data user calculates regressions and beta coefficients for some of its stocks using the data vendor’s prices, that is classified as derived data. The data licensee will not be allowed to report that information to anyone outside the organisation, or store the prices themselves, or the calculations based on those prices, in their database programmatically. Backdated licensing surcharges can be significant, with some running into the hundreds of thousands of dollars.

4. API endpoints must be integrated with the database

Along with their data licensing costs, different data vendor solutions have their own API endpoints. Firms will need to hire software developers with subject matter expertise to integrate those endpoints. More complex data –such as indices, ratings, and environmental, social and governance (ESG) enrichments – increase the difficulty of integrating the vendor solution and transforming the data into the database ecosystem of the family office. The enriched information will then need to feed back into the database and link with the objects already created in there so that the data can be used downstream.

Delivering consolidated reporting

Family offices increasingly aspire to deliver accurate, comprehensive and timely consolidated reporting to families. And families will increasingly come to expect it.

But to provide that high-quality consolidated reporting, family offices first need to tackle a host of complex challenges relating to the sourcing, transforming, storing and enriching of data. All these processes require sophisticated IT engineering and financial data expertise – skillsets that are in high demand and do not come cheap. Hefty data licence fees add to the cost.

Family offices have a choice. They can opt to hire an internal team of IT engineers and financial quants to develop and manage the necessary infrastructure. Or they can use a software-as-a-service capability to handle the end-to-end data management processes for them. What they can no longer afford to do, however, is ignore the growing calls from families for a consolidated reporting service.

To find out more about how family offices can overcome data management challenges, read our whitepaper below.

New call-to-action

Related Content

how_your_family_office_should_be_sourcing_wealth_data
21 Sep 2023 | Family Offices

How your family office should be sourcing wealth data

As today’s UHNW become more geographically dispersed and family officesbecome more sophisticated in their investment functions and allocation strategies,portfoliosnowconsist of multiple asset classes, custodians and currencies, and investments may...

5_ways_to_improve_productivity_in_your_family_office
25 Jul 2023 | Family Offices

5 ways to improve productivity in your family office

As family offices attempt to modernise, many are facing productivity challenges due to out-of-date, disparate internal systems andheavily manual processes. Naturally, there are inherent risks associated with such inefficiencies, including missed ...

the_top_5_alternative_investment_reporting_challenges_for_family_offices
25 May 2023 | Family Offices

The Top 5 Alternative Investment Reporting Challenges for Family Offices

Related content

 

19 Oct 2023 | Webinar

From Alternatives to the Mainstream: Reporting on Private Assets
Alternative investments, once considered peripheral in asset owners' portfolios, recently accounted for as much as half of some family offices' holdings. This diversity in investment led to reporting processes plagued by errors and inefficiencies, due to varied data formats and spreadsheets. Landytech's Benjamin Mouté, along with Joseph Larizza of Mirador, Inc. and Robert Barwise-Carr from Mazars, discussed how family offices could tackle the challenges associated with private asset reporting.
Watch now arrow-read-more
 

12 Oct 2023 | Case Study

How a London-based multi-family office saved days each month on reporting with Landytech
Discover how a London-based multi-family office upgraded from an Excel-based ledger system to Sesame, saving days each month on data consolidation and reporting that could be reallocated to business growth initiatives.
Read case study arrow-read-more
 

21 Sep 2023 | Blog

How your family office should be sourcing wealth data

Family offices now manage complex, multi-asset-class portfolios, with fragmented data sources that comprise disparate, non-standardised data sets. How can these data sourcing challenges be overcome?

Read blog arrow-read-more

Discover the power of Sesame