Use the Standard Manager Investment Activity Import Template to record investment activity by individual managers in each period. The template allows a bulk upload of manager activity instead of keying in entries one manager at a time. For instructions on how to load the file in Fundriver, view the “How do I Upload the Investment Manager Template?” article.
Populate the template as shown below. Manager GLID and Ending Market Value are required fields for every manager, regardless if activity occurred within the period.
Please Note: All numerical data must be hard coded in cells, no formulas.
Below are common scenarios that clients encounter. An excel file can be found at the bottom of this article that contains the examples below.
Below is an example of a completed file ready for import:
Once you have successfully imported your investment activity template, it is helpful to view the Manager Reconciliation Report 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 managers and pool activity. To view the Manager Reconciliation Report, go to REPORT > PORTFOLIO LEVEL REPORTS > MANAGER RECONCILIATION REPORT. Enter the dates for your current open period and click RUN REPORT.