Use the standard Investment Manager Activity import template to record investment activity by individual managers in each period (i.e. monthly, quarter). The template allows a bulk upload of manager activity instead of keying in entries one manager at a time. This feature is only available to those clients that subscribe to the Investment Portfolio Module and enter investment activity by manager vs. by investment pool.

Follow the steps below to use the Investment Manager Activity Import.

To import the file into Balance, navigate to IMPORT/EXPORT and click the +Create new import button.

Select an Import Type of Investment Manager Activity and click the Continue button.

Download the Investment Manager Activity import template by clicking on the button highlighted below.

Populate the template based on your individual investment statements.  Please note the following:

• Manager GLID and Ending Market Value are required fields for every manager, regardless if activity occurred within the period.  
• All numerical data must be hard coded in cells, no formulas.
• If a new manager needs to be set up, follow these instructions to add the manager prior to loading the import file How Do I Add a New Investment Manager to a Pool?

Below is an example of a completed file ready to import.  The details that make up the amounts on this import example can be found in the attachment to this article.  See the Examples tab for the details.

When you have completed populating the Investment Manager Activity import template, click Browse to grab the saved file from your computer. Then, upload the file.

Approve the uploaded file after reviewing the 'Review  & Approve' screen.

Reconciling 

Once you have successfully imported your investment activity template, we recommend running the Manager Reconciliation Report (found under Reports > Portfolio Level Reports) to check the accuracy of the activity imported. 

This report will show any variances in ending balance by investment manager and will also help reconcile the net cash flow activity between investment managers and fund activity. Net Cash flow by Managers (Capital Calls + Returned Capital + Net Cash Flow) and cash flow by funds  (Gifts + Distributions + Transfers + Expenses) must net to zero in order to reconcile.