A college endowment replaced its Investment Book of Record (IBOR) and took that opportunity to revisit its data entry process as well as the investment committee reporting out of the new system.

The college endowment wanted to reduce the time spent on manual entry of transactions and valuations in its IBOR.

In addition, since the college endowment was already planning to rebuild its investment committee reporting due to the new IBOR implementation, the CIO and COO wanted to also invest in enhancing the form and content of the reports.

Data Extraction and Integration
Union Park implemented a data extraction tool for valuations and transactions and set up a daily feed from the data extraction tool to the IBOR.

First, Union Park worked directly with the data extraction vendor to produce valuation and transaction scheduled exports as well as map transaction types between the two systems.

Next, Union Park collaborated with the IBOR vendor to build an sFTP integration to feed approved valuations and transactions daily. This included establishing customized feed logic for different fund types and developing email alerts to assist with better oversight of the integration.

Finally, Union Park created reconciliation templates and provided training to the operations team to ensure the daily feed remained error-free.

Investment Committee Reporting
Union Park worked with the college endowment to determine the list of reports to include in its investment committee reporting.

To facilitate a more efficient and consistent reporting process, Union Park set up the college endowment with a single extract that downloaded all required data in bulk from its IBOR.

Union Park built excel-based reporting templates using dynamic formulas to pull underlying data from the system exports. Union Park iterated on the format and content with the client throughout the process.

Some examples of report templates that Union Park created include:

• Asset class performance summary
• Geographic and sector exposure summary
• Top contributors and detractors
• Trailing asset class attribution

Union Park created a reporting checklist and procedures to support the endowment’s ongoing report generation process.