Family Offices

We are experts in creating data warehouse solutions for the family office market, and currently work with some of the largest family offices in the country. We can provide a package of solutions that include:

  • Pre-built and custom ETL processes
  • Data Warehouse with a customized data model
  • Reporting package for your clients
  • Cash Flow Forecasting module
  • Seamless integration with other reporting and analytic applications

PivotData has developed a set of reports focused on family offices covering multi-generational, as well as complex family structures and entity ownerships. All reports can be generated at the family level, the individual level, or the entity level.

Financial reports provide family members with a consolidated picture of their wealth holdings, allowing them to make fully informed decisions about their future. Studies show that on average a manager of a family office spends over 30% of their time creating the quarterly and annual reports for the various family members. Most of the time this work involves the extraction of data from various databases and applications, and then using another set of applications, along with Excel spreadsheets, to cobble together the necessary reports.

Our Family office reporting package works seamlessly with our data warehouse to allow you to create the required reporting at any level, at any time for your clients. These reports can be delivered via paper or online, depending on your clients’ needs.

Family Office - Cash Flow Forecasting Module

PivotData’s Cash Flow Forecasting module provides family offices with the ability to manage and predict cash flows for all types of investments, including alternative investments such as private equity and real estate transactions. Our cash flow module will enable you to model current and future investments, taking into account different events such as changes in distributions, or a change in a fund manager’s liquidity requirements, allowing you to optimize the use of your cash and capital.

PivotData’s Cash Flow Forecasting Module allows family offices to automate waterfall calculation processes and scenario forecasting capabilities using multiple hurdle rate scenarios. Coupled with our data warehouse solution, our Cash Flow Forecasting Module will allow you to report cash flow forecast for any entity or ownership structure.

Benefits of PivotData’s Cash Flow Forecasting Module

  • Integrated into our Data Warehouse with intuitive input allowing users to input and update waterfall scenarios.
  • Ability to track and report waterfall calculations at the GP or investment levels.
  • Built in functions allow for reforecasting of cash flows based on projected IRR or EBITDA.
  • Includes cash flow forecasting report for any entity, or group of entities.

Family Entity Reporting

PivotData has developed a report package with functionality based on recommendations from the Family Office Exchange, focused on providing family office managers and family members with a comprehensive reporting package. The reporting capabilities cover multi-generational, as well as complex family structures and entity ownerships. All reports can be generated at the family level, the individual level, or the entity level.

Financial reports provide family members with a consolidated picture of their wealth holdings, allowing them to make fully informed decisions about their future. Studies show that on average a manager of a family office spends over 30% of their time creating the quarterly and annual reports for the various family members. Most of the time this work involves the extraction of data from various databases and applications, and then using another set of applications, along with Excel spreadsheets, to cobble together the necessary reports.

Our Family office reporting package works seamlessly with our data warehouse to allow you to create the required reporting at any level, at any time for your clients. These reports can be delivered via paper or online depending on your clients’ needs.

PivotData’s standard Family Office reporting package includes the following reports, by entity:

Quarterly Reports
  • Statement of Net Worth
  • Net Worth Projections
  • Balance Sheet
  • Income and Expenses
  • Income and Expense Projections
  • Cash Flow
  • Cash Flow Projections
  • Put the following image here
Market/Investment Overview
  • Asset Allocation
  • Holdings
  • Investment Performance
  • Liability Management
  • Net Worth Trends
  • Summary of Capital Calls
  • Summary of Charitable Contributions
  • Tax Analysis and Projections

ILPA Reporting

ILPA’s Capital Call and Distribution Reporting

PivotData has integrated ILPA’s capital call and distribution recommendations into our ETL and data warehouse process to facilitate the collection and processing of capital call information between the LP and GP. Our incorporation of the ILPA reporting guidelines will serve several purposes, including, but not limited to:

  • Enabling the LP to interpret and account for a transaction accurately
  • Reducing LP and GP processing times, and ultimately reducing monitoring costs
  • Improving LP-GP communications in regards to an investment’s status

The Capital Call and Distribution Notice data is automatically uploaded to the data warehouse, and updates the relevant financial data and cash flow forecast as required.

>Next Article: Markets - LP’s and Allocators