How a London-based family office saved days each month on reporting with Landytech

Discover how a London-based family office replaced an Excel-based ledger system with Landytech’s Sesame One, a consolidated investment reporting platform designed for family offices, saving days each month on data consolidation and reporting.

With the previous system, staff were manually updating transactions and valuations across hundreds of accounts. This left little time for strategic initiatives and the intensive workload meant reporting only covered net worth and not profit and loss.

Now, the family office receives an automated feed of consolidated data from all associated banks and custodians, refreshed daily. Stakeholder reports can be produced at the click of a button and tailored on the fly, meaning the team can now focus more time on strategic oversight, governance and long-term planning.

At a glance (TL;DR)

• Organisation: London-based family office
• Challenge: Too much time spent on manual Excel consolidation across many accounts and asset classes
• Solution: Landytech's Sesame One platform
• Landytech chosen for: Streamlined reporting through automated data consolidation
• Result: Saved days each month, daily refreshed consolidated data, faster tailored reporting

About the family office

A London-based family office, managing wealth with a minimum of £50 million in investable assets, was looking to expedite its business growth. Historically, it was reliant on an Excel-based ledger system to record positions across multiple asset classes and ownership structures.

This meant staff were spending days each month on manual data consolidation and producing investment reports. To support its growth ambitions, the firm wanted to automate the data consolidation and reporting process. 

The challenge

Too much time in spreadsheets, not enough time for the business

The Excel-based ledger system the family office had been using to book positions and generate reports was labour-intensive and highly susceptible to manual error. 

Staff had to manually enter all the account valuations and cashflows across hundreds of accounts. Whenever a transaction occurred, analysts needed to book both the transaction and the updated valuation resulting from it. This operational bottleneck restricted the update of custodied investment portfolio valuations to a monthly cadence.  

The system also struggled to provide the granularity of reporting that the family had come to expect. Stakeholders wanted a clear picture of their drivers and detractors of performance, but valuations were limited to the investment account level, rather than for positions within the investment account. Consequently, the family office could only report net worth, not profit and loss. 

The manual processes meant staff were spending days each month on data consolidation and reporting, leaving less time for the high-touch interactions with decision makers and business development initiatives that were needed for them to grow.

Staff were spending days each month on data consolidation and reporting.

The solution

Streamlined reporting through automated data consolidation

Landytech’s investment reporting and data consolidation platform, Sesame One, supports both public and private assets. The family office used Sesame to:

• Consolidate positions across all asset classes to give a clear view of overall wealth

• Provide granular monitoring of fees, costs, income and liabilities

• Generate accurate, independent performance calculations

• Deliver automated, fully customisable stakeholder reports

Sesame is designed for single family offices and private offices that require consolidated, multi-asset reporting across custodians. 

Leveraging Landytech’s extensive network of custodian connections, rapid data pipelines were established with all associated banks and wealth managers, enabling automated daily feeds of the latest positions and transactions across accounts.

The family office also adopted Sesame’s portfolio management system for non-custodied assets. The system allows bulk input of transactions and valuation updates for any private or alternative assets, significantly reducing manual input time. 

With data feed automation and a dedicated tool for managing private and real assets, the family office has gone from spending days a month on producing reports to having them ready at the click of a button and scheduled automatically. Where changes to reports used to involve painstakingly reworking an Excel spreadsheet manually, the team can now make bulk alterations on the fly.   

Reports now go into the level of granularity required by key stakeholders and include:

• Exposure analysis by country, sector or market cap

• Performance analysis (including in different reference currencies)

• GIPS-compliant performance reporting and performance contribution and attribution by different categories

• Stress tests and scenario analysis

• Exposure to risk factors

• Liquidity analysis

The family office has gone from spending days a month on producing reports to having them ready at the click of a button.

The impact 

Days each month reclaimed for strategic growth initiatives

Transitioning from manual to automated processes has not only transformed the family office’s reporting process but also fostered a more scalable operating environment. Eliminating manual tasks has left staff less stretched in addition to delivering more timely and tailored reporting to stakeholders, with greater confidence in the accuracy of data.

With manual tasks significantly reduced, the family office can now allocate more time to strengthening relationships and enhancing governance and investment oversight.

Frequently Asked Questions

Is Sesame One designed for single family offices?
Yes. Sesame One is designed for single family offices with multi-asset portfolios to resolve critical data aggregation, analytical and reporting challenges to inform investment decision making and achieve operational efficiency.

Can Sesame consolidate data from multiple banks and custodians?
Yes. Sesame connects to a wide network of custodians and wealth managers, providing automated daily data feeds and consolidated reporting.

Does Sesame support private and alternative assets?
Yes. Sesame includes tools for managing non-custodied assets, private equity and real assets alongside public market investments.

How much does Sesame cost?
Our pricing model for family offices is dependent on several factors including the number of managed feeds, legal entities, portfolios, assets and users. In order for us to give you a more accurate estimate we'll need a few more details from you. You can leave your details by filling in our contact us form, and one of our team will get back to you.