Common Uses for the Aumni Plugin for Excel

Skip ahead to:

1. What is the Aumni Plugin for Excel? 
2. Building an Investment Memo in Excel with Aumni Data 
3. Building an LP Report in Excel
4. Creating an SOI or Transaction Ledger 

 

What is the Aumni Plugin for Excel?

The Aumni Plugin for Excel lets you instantly create and refresh Excel-based reports, models, templates, and more with your Aumni Portfolio data. Get started even faster with our ready-made Excel templates for LP and investment reporting, built by subject matter experts. Templates are pre-filled with Aumni formulas so all you need to do is update a cell reference or reload a dataset to dynamically refresh data across a workbook. Templates are provided to all Plugin users. 

In this article, you'll learn how to leverage Aumni templates, Plugin data, and Excel functionality to seamlessly complete three key portfolio monitoring and reporting workflows. 

Building an Investment Memo in Excel with Aumni Data 

Situation: I report my investment activity and performance to my firm's stakeholders. I'd like to leverage Aumni data to create an investment memo, or valuation memo, that highlights investment details, including underlying transaction information, co-investors, and company performance metrics. 

This template combines data from your Portfolio Companies, Transaction Ledger, and Co-Investors' datasets and is organized by:

1. 1. Company data
   2. Investment data and investment history
   3. Financial summary by quarter and year

To update investment information throughout a workbook, update the highlighted reference cell in A3 with a different portfolio company ID.

Portfolio company IDs are stated in paratheses within the Identifier section of the Plugin, or in the URL of the Aumni platform. 

 

Each section references a different dataset, outlined below.   

Section	Formula Library	ID
Company Data	Portfolio Companies	Portfolio Company ID (poc83)
Investment Data	Portfolio Companies	Portfolio Company ID (poc83)
Investment History	Transaction Ledger	Transaction ID (psp1)
Key Investor Ownership	Co-Investors	Co-Investment ID (poc83_fnd1)

 

For transaction ledger and co-investor formulas, cells A14 and A22 look up the corresponding identifiers in the Transaction Ledger and Co-Investor Report via cell A3.

You'll notice that the financial summary section is blank. These are editable fields that you can use to add portfolio company KPI data and performance metrics from your other sources. 

 

Building an LP Report in Excel 

Situation: I consistently report to my LPs on my investment activity. I'd like to use Aumni data to highlight my top-performing portfolio companies and give my investors an overview of my fund's performance. 

This template combines data from your Portfolio Companies and Co-Investors' datasets and is divided into three sections to help you showcase your performance to your LPs:

1. 1. Fund overview
   2. Top five portfolio companies by investment amount
   3. Portfolio company information, to highlight the companies’ current valuation compared to your entry

The fund name entered in cell C3 will determine the portfolio companies that appear in the top positions table. You must enter the fund name as it appears in Aumni.

Cells E7:L7 are customizable text fields that you can then edit; you can also update the text in the merge cells beneath the overview. 

Once C3 is updated, hit Return on your keyboard. Your top five portfolio companies for that fund, ranked by Total Cost, will populate.  

Change the reference range in cell A19 if you wish to narrow down or expand your list of top positions. For example, simply edit the reference range within the formula to ROW(1:10) to report on your top 10 positions. Make sure you adjust the number of rows to ensure that the returned results do not override existing data.

The template is configured to reference the Portfolio company IDs for the two top positions in cells A26 and A47. To add more positions:

1. 1. Insert more rows to allow for details of the additional companies you are reporting on.
   2. Copy the rows with the data and formulas and paste them into the newly inserted rows.
   3. Adjust the reference ID in column A to update the details for the third company position.

 

Creating an SOI or Transaction Ledger 

Situation: I keep a record of my investments and transactions by fund in a Transaction Ledger or Schedule of Investments (SOI). I'd like to use Aumni data and Plugin functionality to automate this process to save me time.  

With Aumni, you can use the Securities Held dataset to streamline SOI creation and maintenance. From your workbook template, open a new sheet. 

From the Datasets tab, select Securities Held.

Once data has loaded, select one of your Funds listed in Column T that you'd like to build the SOI template for. Copy the fund name.

In the SOI - Securities Held tab, paste the Fund Name into cell C8. Hit Return on your keyboard to refresh your data. 

Column A will automatically update with the underlying data identifiers for each security, along with the portfolio company name, security type, cost, share count, and more, providing a comprehensive account of a fund's positions.